Pupiweb

Hi Larry You can't import accounts and privilege sets But why do you want to do that ? A Filemaker 7 file can be opened by FM 8-8.5 so you'll find whatever you've done before untouched ... Ciao G. Pupita

Hello Check this tip file by Mikhail Edoshin http://edoshin.skeletonkey.com/2006/06/linked_fields.html#more Ciao G. Pupita

Hello Peter I would not follow the path you're taking It seems easy at first but then it might force you to many workarounds; also should a fourth language be needed you'd have to restart everything again You might instead 1. create a Language table, one record per language, one field per label you want to use in your layouts In your tables you'll have a global field gLanguage in which you'll write the language in use and hence the labels to be used Load appropriate labels in global fields so that they'll also be visible in find mode 2. Create a value list table, one record for each combination of value list item and language. Assign a code to each value. In the main db relate to these records using the gLanguage field in order to display the same code but the proper translated value Searches can be performed on the codes rather than on the translated values (by doing this company and empresa will bith be found in a search sionce they'll have the same code) 3. Use the Troi Dialog plugin for dialogs, unless you can live with the fact that you can't translate the "standard" FM buttons In general prepare for A LOT of work ;-) Ciao G. Pupita

Solution / Action Tabs Description: Hello -- Have you ever wanted to run a script clicking on a tab (I guess you did) ? With a little trickery now you can: http://www.buliga.it/TipFiles/ActionTabs.zip ... and you've plenty of room for other magics -) Working Under: 8 Advanced Solution Status: Finished Pre-requisites: FileMaker 8 or better Author(s): Pupiweb Date: 07/16/06 Credits: Instructions / Other Info: Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify. ActionTabs.zip

You already received excellent advice on the two issues - one email address per email: can be done, using a looping script Loop Send Mail Go to record next (exit after last) End Loop You might alternative use the mailto protocol coupled with an Open URL () step Whatever the method you'll end up having the messages created in your default email client BUT NOT SENT If you want to fully automatize the procedure use a plugin; I'd suggest SMTPit by CNS - messages personalization can be achieved creating a calc joining the message and the other relevant fields; if you want to make dynamic create a global text field in which you write the message and put some placeholders like [Contact]; use a calc substituing all placeholders with record data for the message body

Take a look at Navigator by Nico Kuilmann ftp://ftp.fmfiles.com/download/open/Navigator.sit ftp://ftp.fmfiles.com/download/open/Navigator.zip or at Smart Tabs by mikhail Edoshin http://www.onegasoft.com

I'm not sure it can be considered a bug ... Given that one button "accepts" the data and one "refuses" them the third button could have been given either function, and IMO setting it to refuse data was a conservative choice (IOW accept data only when the user explicitly says so) that I agree with. BTW I've almost never used it since I usually use a Dialog.fp5 file to do this kind of operations, a much more powerful and flexible option

Add the sort tags in the Inline [... ,-sortfield=TheFieldYouWantToSortOn,-find]

Hi Anna try with If (RadioField ="Yes") Go to Layout [Other] Else Show Message (You haven't chosen Yes ...) End If You might also add an If () at the beginning to check for an empty RadioField, should this imply a different action

Sure You can memorize the Import parameters using the Restore option of the Import step Run an import using the desired parameters, create a script with the Import step, check the "Restore Import order" option and the import criteria will be memorized in the script

If you make the portal field clickable and attach to it a step like Go to related record (Portal relationship) you'll actually land in the related file on the clicked record

Try with an Inline <Select name="FieldName"> <option value=""> Select a value [FMP-InlineAction:-db=Items.fp5,-lay=cgi,Item={field:ItemID},-max=all,-find] [FMP-Record] <option value="[FMP-Field:Size]"> [FMP-Field:Size]</option> [/FMP-Record] [/FMP-InlineAction] This will produce a list of the sizes related to an item; with a similar mechanis you can also get radio buttons, checkboxes etc ...

Try writing me privately (gpupita@sestante.net) and I'll send you the files

Point 1 isn't very clear to me but it *should* be enough to put it after the <option ""> tag Point2: the problem is a syntax error Instead of user1_user2=[fmp-field:username] use {field:username} HTH

See if the attached files help; they're very "basic" but should be a decent starter Archive.zip

Field content size is NOT a problem Make fields as big as the largest field you might choose and set them to shrink on printing Preferably use merge fields as Peter suggests

This doesn't make much sense, and makes me think/guess that you've only define a CustomerID field in Orders by which yo see the related Customer record in Customers; however you haven't probably defined a CustomerName field in Orders and hence you cannot lookup this info in OderDetails, in which you must have passed the customerID using a lookup from Orders So you can either Create customer fields in Orders and lookup data in OrderDetails from Orders or - probably better - lookup up customer data in OrderDetails directly from Customers HTH

Nothing triggers the Inline; obviously you've to be calling FileMaker somehow, either with a -view, -find, -findany etc ... tag.When the page is loaded the Inline performs the action specified in it like -find ... Details: -db=Dates.fp5 is the file in which the Inline performs the search; doesn't need to be related to the current file -lay=cgi is the layout to be used in the Dates.fp5 file; it's named cgi but you can name it as you like it best Student={field:Student} tells FM to look for Students (in Dates.fp5) who have the same value of field Student of the current record in the current file

Create 3 global fields, format them with a custom value list listing the possible break fields for the report Then make 3 calc fields like: Case ( global1 = "Name", Name, global1 = "Surname", Surname, Etc ... Sort on the 3 calc fields, and memorize the sort order Send your users to a layout with the global fields, make them choose the sort fields and then run the sort script and send them to a report layout with 3 subsummary sections, one for each calc field Caveats: 1. calc fields will be unstored hence things will be slower than normal 2. calc fields will have a specific result type (i.e. text or number) so you might have problems when trying to sort on different field types Improvements: Using the Get field function the system can be made much more flexible since the calcs will become like Get Field (global1) and you'll have just to format the global fields with a value list made of field names Same caveats will apply though

Make a global text field gRooms Make a calc Case (PatternCount (gRooms, Area)>0, RoomNumber) This calc will return the room number only when the area chosen in the global field matches with the area in whioch the room is located A nice addition might be to format gRooms as a checkbox field so that you might choose multiple areas and highlight relative rooms (Hope I understood properly)

Make a calc field State & City and use them on both sides of the relationship

Relational value lists do not work in FM Web Try with an Inline <Select name="FieldName"> <option value=""> Select a value [FMP-InlineAction:-db=Dates.fp5,-lay=cgi,Student={field:Student},-max=all,-find] [FMP-Record] <option value="[FMP-Field:Date]"> [FMP-Field:Date]</option> [/FMP-Record] [/FMP-InlineAction] This will produce a list of dates related to a student

Try with <Select name="FieldName"> <option value=""> Select a value [FMP-InlineAction:-db==web_users.fp5,-lay=WebMain,User={field:user},-max=all,-find] [FMP-Record] <option value="[FMP-Field:System Name]"> [FMP-Field:System Name]</option> [/FMP-Record] [/FMP-InlineAction] This will produce a list of all systems related to a user Add a sort tag to the Inline if you want to sort the list items

Sounds doable Format the ID as a link <A HREF="FMPro?-db=RelatedFile.fp5&-format=cgi&ID= [fmp-field:PortalRelationship::ID]&-find"></A> IOW it will run a search in the related file for the record having the ID of the portal row

The way I do it is to use the same login procedure that users would use at startup (see a tip file named The Gateway at http://www.fmfiles.com) When enetering the solution a login script is performed, bringing the user to a layout in which they have to enter username and password; in this layout you've 2 buttons, Enter and Cancel; the Cancel button would close all files. So just create a Re-Login script that calls the same login routine; if a new user logs in s/he'll find already opened files, otherwise all files will close