work makAll play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All
HBAM2016AUG95
Pro 3.0
All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a goodCopyright 1984-1997 Claris Corporation
and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy.
HBAM3016AUG95@
Days, 15 Hours, 32 Minutes and 33 Seconds until the Year 2000.
Timeouts
YO/<CNFG?<
_&HUO
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
10/23/98
Helvetica
Geneva
Pro 3.0 - 4.0F!
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
CARRIAGE RETURN
CURRENT LAYOUT NUMBER
DUMMY
FIELD1
FIELD2
FIELD3
FIELD4
FIELD5
FILENAME
NEXT LAYOUT NUMBER
PREVIOUS LAYOUT NUMBER
TAB CHARACTER
Next layout numberB
Previous layout numberB
Current layout numberB
DummyB
FileNameB
TAB characterB
|("Widgt-Ascii_Char"
Widgt-Ascii_Char
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
}}Y/(
__e_e
Y}S(.
3 33- X3X
^33X X 3X
::X^^
kF@Fj
kk1jjk
jk?k8dj
9jkj?22jk
V8kj2
jkjd?djkj
kjkj?
9kj81jkj
22jkj
kjjd?2
d828j
kkj8jk9
kkjkj
]j?2k
29??2
djkkjj
^44::
1jkjkj1
|RX|RR
jkjkj?8
jkj@dj@1
9dj9jkd
||SXY
jkjjk
djj9kj?kj
kjj]?jj
jkkj9
jkjk1
jj9kj
jjkk]
2kjk9
_eeFF
kjkjkj
@kk1jkjk
8dkjj
jkjjkjk
jkkj?8
1dj@]
2djjk
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3
3#f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
3#f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
3!f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
3!f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3
Widget 1.6 for FileMaker Pro V4 (Macintosh Version - Windows version to follow)
The Amsys Widget plug-in for FileMaker Pro 4 gives FileMaker several new functions. These are Widgt-Find_Replace, Widgt-Char_Ascii, Widgt-Ascii_Char, Widgt-Y2K, Widgt-Set_File, Widgt-Set_Path, Widgt-Write_File and Widgt-Append_File.
Installation
To install Amsys Widget quit FileMaker Pro 4 and drag Amsys Widget to the FileMaker Extensions folder. Then relaunch FileMaker. To check that Amsys Widget has been
enabled select Preferences-Application from the Edit menu. This will bring up the Application Preferences dialog box. Click on General and a pop menu will appear where you can select Plug-Ins. Make sure that the check box by Amsys Widget is checked.
Navigating this READ ME file
Use the arrow icons in the bottom right hand corner of each screen to move to the next or previous screen.
Widget
Page Y
Registered charity no 213890
t Apple Authorised Service Provider
in the UK and is a FileMaker Solutions Alliance member.
Please note that the red text above is a "hot link" to send an email or to connect to a Web site. You must have an Internet connection and Claris Emailer, Qualcomm Eudora Light, or Eudora Pro installed to send email with FileMaker Pro. You also must have the Internet Config tool (version 1.1 or higher) installed and configured to process the mailto protocol for sending email and to
process the httpC# protocol for accessing a Web site.
}JyJ}kyk}kyJ~R
}Jyk}kyJ}kyk}kyJ~1
Z}JyJ}kyJ}kyk}kyJ}
}kyJ}kyk}kyJ~
yJ}kyJ}kyk}J~
Widget
Widgt-Write_File
Widgt-Write_File is used to write text to a file. If a file of the name specified exists already it will be overwritten.
If a file of the name specified does not exist then it will create a new one.
The format of the Widgt-Write_File function is as follows.
External ("Widgt-Write_File"; parameter)
Here is an example of how to use the Widgt_Write File function and the Widgt-Ascii_Char function together.
Create a calculated field called "TAB character" where the calcul
X is External("Widgt-Ascii_Char"; 9)
Create a calculated field called "Carriage Return" where the calculation is External("Widgt-Ascii_Char"; 13)
Create a script with the following step:-
External("Widgt-Write_File"; Field1 & TAB character & Field2 & TAB character & Field3 & TAB character
& Field4 & TAB character & Field5 & Carriage Return)
o{o{^
o{o{^
o{o{
}kyJ}kyk}kyJ~
yJ}kyJ}kyk}J~
Widget
Widgt-Y2K
Widgt-Y2K returns the number of days, hours, minutes and seconds until the Year 2000.
Try it by clicking on the button below.
The format of the Widgt-Y2K function is as follows.
External("Widgt-Y2K"; parameter)
In the example demonstrated by the button above we have a script which sets a field called Y2K (the red field above)
to External("Widgt-Y2K"; "") & " until the Year 2000."
Page S
How long until the year 2000?
u can set whether the find is case sensitive.
Page
Set FileName
|("Widgt-Set_File"
Widgt-Set_File
Output Single Record
|("Widgt-Write_File"
Widgt-Write_File
A%Set FileName and Output Single Record
Widget
Widgt-Set_File
Widgt-Set_File is used in conjunction with the Widgt-Write_File and the Widgt-Append_File commands which
are described on the following pages.
Widgt-Set_File specifies the file name to be used when exporting text. Unless you use the Widgt-Set_Path command
described on the following page the default location of the exported file will be the folder where the FileMaker
Pro 4 program is located.
In this sample database the file is called out.txt (you can change the filename b
nelow if you want to).
The format of the Widgt-Set_File function is as follows.
External ("Widgt-Set_File"; parameter)
An easy way to use this is to have a temporary global text field called "DUMMY" and a global text field
called "FILENAME". Then use the following script step to set the file name:-
Set Field ["DUMMY"; "External("Widgt-Set_File"; FILENAME)"]
Page U
FileName
Widget
Widgt-Set_Path
Widgt-Set_Path can be used instead of Widgt-Set_File in conjunction with the Widgt-Write_File and the
Widgt-Append_File commands.
Widgt-Set_Path specifies the complete path name, including the filename, to be used when exporting text.
An example would be Macintosh HD:System Folder:output.txt
The format of the Widgt-Set_Path function is as follows.
External ("Widgt-Set_Path"; parameter)
An easy way to use this command is to have a temporary global text field called "DUMB
MY" and a global text field
called "PATH". Then use the following script step to set the path name:-
Set Field ["DUMMY"; "External("Widgt-Set_Path"; PATH)"]
.txt (you can change the filename below if you want to).
Widgt-Set_Path
Widgt-Set_Pa
Page
intosh HD:System Folder:output.txt
The format of the Widgt-Set_Path function is as follows.
External ("Widgt-Set_Path"; parameter) - an easy way to use this is to have a temporary global text field called "DUMMY"
and a global text field called "CyPATH". Then use the following script step to set the path name:-
Set Field ["DUMMY"; "External("Widgt-Set_Path"; PATH)"]
Page
Page W
Create a text file.year 2000?an be used instead of Widgt-Set_File in conjunction with the Widgt-Write_File and the
Widgt-Append_File commands.
Widgt-Set_Path specifies the complete path name, including the filename, to be used when exporting text.
An example would be Macintosh HD:System Folder:output.txt
The format of the Widgt-Set_Path function is as follows.
External ("Widgt-Set_Path"; parameter)
An easy way to use this is to have a temporary global text field called "DUMMY" and B
a global text field
called "PATH". Then use the following script step to set the path name:-
Set Field ["DUMMY"; "External("Widgt-Set_Path"; PATH)"]
Page
Widget
Widget
Widgt-Append_File
Widgt-Append_File is used to append text to the file that has been written to using the Widgt-Write_File
command. If a file of the name specified does not exist then it will create a new one. The Widgt-Append_File
command can be used in a loop to export all of the records in a database to a single file.
The format of the Widgt-Append_File function is as follows.
External ("Widgt-Append_File"; parameter)
This command is used in exactly the same way as the Widgt-Write_FB4ile command which is described on
the previous page.
Page
Set Field ["DUMMY"; "External("Widgt-Set_Path"; PATH)"]
Page
Carriage ReturnB
|("Widgt-Ascii_Char"
Widgt-Ascii_Char
Field1B
Field2B
Field3B
Field4B
Field5B
out.txtK
ation is External("Widgt-Ascii_Char"; 9)
Create a calculated field called "Carriage Return" where the calculation is External("Widgt-Ascii_Char"; 13)
Create a script with the following step:-
Set Field ["DUMMY"; "External("Widgt-Write_File"; Field1 & TAB character & Field2 & TAB character
& Field3 & TAB character & Field4 & TAB character & Field5 & Carriage Return)"]
When this script is executed it will export a file that looks like this
This assumes that you have 5 fields called FielC
d1 through Field5. is a TAB and is a carriage return.
If you click on the button below a sample file called out.txt will be created for you to look at.
a single character or a string of characters. This is the text that the plug-in will search for.
Replace_String: This can be a single character or a string of characters. This is the text it will replace the found text with.
Text: Is the text which will be manipulated.
Find_Replace Example
External("Widgt-Find_Replace"; "A" & "," & "B" & "," & myField) - This example will replace
all occurrences of "A" with "B" in the text from the field
myField
You can either use Widgt-Find_ReC;place in a calculation or with FileMaker
s Replace command.
xt with.
Text: Is the text which will be manipulated.
ld run Script 1 in the database called myDatabase if the value of aField is
otherwise it would run Script 2.
Page
Page
Page Q
Minutes: Range 0 to 59 inclusive.
Seconds: Range 0 to 59 inclusive.
Script Name: The name of the Script to be executed
Database name: The name of the Database that has the Script.
Page will execute a script once only at a given time.
will execute a script every day at a given time.
will execute a script at regular intervals.
will execute a script after a period of time has elapsed. Only one of these options can be used per schedule.
Function enabled: This takes two options
will enable the schedule,
N: will disable the schedule.
Hours: Range 0 to 23 i
ript to be executed
Database name: The name of the Database that has the Script.
Page
Page
sys.co.uk>
Web:- <http://www.amsys.co.uk/>
sys.co.uk/>
tton.
or no overhead.
o{o{
Schedule-it listserver ON
widget-on@listserver.amsys.co.uko.uk
Opening Script
"out.txt"
out.txt
Previous layout
- "1"
+ "1"
+ "1"
+ "1"
Helvetica
Geneva
Times
o{o{V
Helvetica
Geneva
Times
Page ge
0*https://securetrading.net/savethechildren/.html
11FB434 Days, 15 Hours, 29 Minutes and 42 Seconds until the Year 2000.I
Opening Script
Go to www.amsys.co.uk
Next Layout
Previous layout
Schedule-it listserver ON
Schedule-it listserver OFF
Email Dick Williams
Email support@amsys.co.uk
$Go to listserver.amsys.co.uk/widget/
0Go to https://securetrading.net/savethechildren/
4Go to http://www.oneworld.org/scf/support/index.html
"Go to http://www.oneworld.org/scf/
Set Y2K
Set FileName
Output Single Record
%Set FileName and Output Single Record
Widget
Widgt-Char_Ascii
This function takes a single character and returns its ASCII value (in decimal format).
Widgt-Char_Ascii Example
External("Widgt-Char_Ascii"; myField) - This example takes the first character from the field 'myField' and returns its ASCII value.
External("Widgt-Char_Ascii"; "A") - This example returns the ASCII value for the character 'A'.
Widgt-Ascii_Char
This function takes a decimal number (range 0 - 255) and returns its character.
Widgt-Ascii_Char Example
ernal("Widgt-Ascii_Char"; myField) - This example takes the value of the field 'myField' and returns its ASCII character.
External("Widgt-Ascii_Char"; "12") - This example returns the ASCII character for the number '12'.
A4Go to http://www.oneworld.org/scf/support/index.html
Widgt-Find_Replace has 2 preference options which can be accessed when you configure the plug-in.
Because Widgt-Find_Replace uses a comma as its delimiter by default this means that you cannot find and replace commas. To overcome this you can set the delimiter you wish to use in the above preference box.
Additionally you can set whether the find is case sensitive.
Schedule Numbe
Schedule-it
Widget
How do I pay for Amsys Widget?
Amsys Widget is shareware - please feel free to give copies of the software, complete with this READ ME file, to anybody.
If you find that Amsys Widget is useful please make a donation to Save the Children.
You can make donations online by credit card at <https://securetrading.net/savethechildren/>
Details on how to make other donations (cheques etc) are at <http://www.oneworld.org/scf/support/index.html#donation>
About Amsys plc
Amsys plc is the larges
Widget
Widget
Using Amsys Widget
Amsys Widget is accessed from FileMaker
s External Function feature. There are eight commands which can be used.
Widgt-Find_Replace
This function allows you to find a specific character or string of characters and replace them with different text.
The format of the function is as follows.
External("Widgt-Find_Replace"; parameter)
Widgt-Find_Replace has one parameter which is broken down as follows.
Find_String , Replace_String , Text
Find_String: This can be
a string of characters. This is the text that the plug-in will search for.
Replace_String: This can either be a single character or a string of characters. This is the text it will replace the found text with.
Text: Is the text which will be manipulated.
Email support@amsys.co.uk
<mailto:support@amsys.co.uk>
A$Go to listserver.amsys.co.uk/widget/
0%http://listserver.amsys.co.uk/widget/AD_ME.html
A0Go to https://securetrading.net/savethechildren/
Helvetica
Geneva
Times
Email Dick Williams
<mailto:dickw@amsys.co.uk>
Schedule-it listserver OFF
!widget-off@listserver.amsys.co.uko.uk
A Schedule-it listserver DIGEST ON
(scheduleit-digest@listserver.amsys.co.uk
cRRcRRcRR
1!!1!!1!!
Page
Page
Widget
Information about the latest version of Amsys Widget can be found on the Web at <http://listserver.amsys.co.uk/widget.html>
We would welcome any feedback that you may have via email to <mailto:support@amsys.co.uk> - but we are unable to give technical support for Widget via this email address.
Amsys plc
Byron House
Lower Road
Kenley
Surrey CR8 5NA
England
Telephone:- (+44) 181 660 9999
Fax:- (+44) 181 763 9332
Email:- <mailto:support@amsys.co.uk>
Web:- <http://www.amsys.co.uk/>
Please
note that the red text above is a "hot link" to send an email or to connect to a Web site. You must have an Internet connection and Claris Emailer, Qualcomm Eudora Light, or Eudora Pro installed to send email with FileMaker Pro. You also must have the Internet Config tool (version 1.1 or higher) installed and configured to process the mailto protocol for sending email and to
process the http protocol for accessing a Web site.
co.uk>
Web:- <http://www.amsys.co.uk/>
- "1"
+ "1"
- "1"
+ "1"
ening Script
Previous layout
Helvetica
Geneva
Times
Go to www.amsys.co.uk
http://www.amsys.co.uk/schedule-it_READ_ME.html
Next Layout
Layout
Helvetica
Geneva
Times
Widget
Amsys Widget listserver
The Amsys Widget ListServer is an unmoderated low volume list which discusses ways of using the Amsys Widget plug-in. Technical support for Amsys Widget is only available through the Amsys Widget ListServer.
SUBSCRIBING
Send an email to <mailto:widget-on@listserver.amsys.co.uk>
UNSUBSCRIBING
Send an email to <mailto:widget-off@listserver.amsys.co.uk>
If you have problems using these commands, you can contact the list server
administrator by sending an email m
essage to Dick Williams at <mailto:dickw@amsys.co.uk>
Please note that the red text above is a "hot link" to send an email. You must have an Internet connection and Claris Emailer, Qualcomm Eudora Light, or Eudora Pro installed to send email with FileMaker Pro. You also must have the Internet Config tool (version 1.1 or higher) installed and configured
to process the mailto protocol.
Page
Page
Page U
gfdgR
Page nt layout number
1!!sk
RRcRR
kB!!Js
!!1!!
cRRcR
1!!1!
RRcRR
!!1!!
cRRcRR
1!!1!!
RRcRR
RRcRR
!!1!!
!!1!!
RRcRRc
!!1!!1
RRcRR
RRcRR
!!1!!Z
!!1!!Z
RRcRR
!!1!!
RRcRR
RRcRR
!!1!!
!!1!!
Bss1!B
BZZ1!Z
RRcRR
!!1!!
sJ!!Z
cRRcRRcRR
1!!1!!1!!
Widget
Widget
})y)|
~1xBt
xcxcx
9}kxc
xBx!t
~Rykx
}kyk}
yJx!t
}Jxcx
})y)x
})y)})x
~1x!t
x!xc}J~
~s~s}
9~s~s~
~s~s}
~s~s}
9~s~s~
|c|!|
|c|c|
})})}J
~s~s~
~s~s~
9~s~s~
9~s~s
9~s~s
o{o{V
}JyJ}kyk}kyJ~R
}Jyk}kyJ}kyk}kyJ~1
Z}JyJ}kyJ}kyk}kyJ}
}kyJ}kyk}kyJ~
yJ}kyJ}kyk}J~
Page idgt-Char_Ascii
This function takes a single character and returns its Ascii value (in decimal format).
Widgt-Char_Ascii Example
External("Widgt-Char_Ascii"; myField) - This example takes the first character from the field
myField
and returns its Ascii value.
External("Widgt-Char_Ascii";
) - This example returns the Ascii value for the character
Widgt-Ascii_Char
This function takes a decimal number (range 0 - 255) and returns its character.
Widgt-Ascii_Char Example
ternal("Widgt-Char_Ascii"; myField) - This example takes the first character from the field
myField
and returns its Ascii Value.
External("Widgt-Char_Ascii";
) - This example returns the Ascii value for the character
Page
IMPORTANT NOTE
In the United States, commas act as list separators in formulas you use in functions and calculation fields. In other countries, semicolons might be used as separators. The delimiter or separator required to separate the function depends on the system the application is running on, but it can also depend on where the file was created and whether or not "Use system formats" is on or off.
These examples for Widget may use a combination of commas and semicolons (just to confu
se the innocent user - or possibly because we missed the odd comma or semicolon when we were writing the documentation). If a Widget function does not appear to be working properly this is one of the first things that you should check before contacting us for help.