Once again seeking help from this fine forum.

I have defined a link (see below) on one of my web site pages. The link confirms previously selected event record(s) and places each record selected on the

You can use Global fields for this. Assign the values to them with the URL.

Good Luck.

Garry

Hi Garry, many thanks! I have added 2 global fields to the URL below, does this appear to be correct?

Link:

<a href="FMPro?-db=Web_TA_Pre_Reg_DB.fp5&-lay=Registration Evaluation Form-2 &-format=finish.htm&-error=error_page_confirm.htm

&-token=[FMP-CurrentToken]&-token.1=[FMP-CurrentToken: 1]

&-token.2=[FMP-CurrentToken: 2]&-token.3=[FMP-CurrentToken: 3]

&-token.4=[FMP-Field: Event ID]&Participant IDQ=[FMP-CurrentToken: 3]

&Participant IDQ=GlobalFieldParticipant IDQ

&token.3=GlobalFieldtoken3

&-script=confirmC&-sortfield=Event Date&-find">Confirm

Does Filemaker place these global fields in memory/disk so that they can be accessed by any file.

They are set and accessed by the file they are defined in. They can then be accessed by a Script to perform a search.

All the best.

Garry

Many thanks Garry, I won't be able to test this until Tuesday but wanted to ask if the following URL additions would most likely work:

&Participant IDQ=GlobalFieldParticipant IDQ

&token.3=GlobalFieldtoken3

Where GlobalFieldParticipant IDQ and GlobalFieldtoken3 were global fields defined in the appropriate file........

They should work. If I get a chance, I will try a similar test today.

All the best.

Garry

re: &-script=confirmC and "I want to place a

Ray,

You will need to do an "-edit" to be able to assign value to Global fields, eg:

http://localhost/FMPro?-db=combotest.fp5&-format=-fmp_xml&-recid=16&g_Countries=Aus&-edit

The "-recid" can be that of any record.

As Keith says this will not work if more than one user accesses the Globals and Script at the same time (or very close to it).

Good Luck.

Garry

Hi Keith and Garry, many thanks for your comments, they are much appreciated. I tried to update the global field from my (-find) action tag URL without any success. As the saying goes "there is more than one way to skin a cat", I was able to resolve the issue by revising the script file ....confirmC.

I would like to avoid using this script file in the (-find) URL but not sure if this is possible. I must differentiate the "found" records from others in the file by placing a "C" in the confirmed record. Can this be done in the (-find) URL?? My command of the Javascript discipline is quite lacking but I can see as time passes that it can be quite an asset in resolving these kinds of issues.

If the bottom line is that I have to use the script I will take the advise from both of you and test the script thoroughly and simultaneously from multiple workstations. Fortunately, this is a relatively low access application but there can be instances when we may have simultaneous access.

Again, thanks for your much appreciated assistance............

re: "I must differentiate the "found" records from others in the file by placing a "C" in the confirmed record."

It would seem to follow logically that when the client has completed her activity, it will be necessary to remove the "C", which means a second edit.

Needless to say, with CDML -find will be inappropriate to perform an edit as that requires the -edit tag.

Why must you "differentiate the "found" records"? Can they be differentiated through CDML, as in a found set and a -link tag? (This is rhetorical.)

It looks from here that you are opening a can of worms. I would suggest you carefully rethink your solution design.

Keith, this is a fairly straight forward application, the user selects an event or multiple events from a list (similar to a shopping cart) and then confirms their selections. I place a "C" in the record at the time they confirm. If the user bails out prior to confirmation but has selected event(s), they will not have a "C" confirming the selection and will be purged from the transaction file. I'm sure there are many other approaches to this solution and would be grateful to read your thoughts............ Many Thanks,

If you have PHP scripting available to you it is good for handling multiple edits.

You may also be able to present the events from a Portal. This is another method for performing multiple edits.

Good Luck.

Garry

Morning Gary, thanks for the suggestion regarding PHP scripting, this is yet another area I will be looking into. Since I have set a deadline to cut this application over this week I will have to go with the Filemaker scripting solution. Your assistance over the past weeks is much appreciated......