Struggling to write this script...

[JTSmith]

I have a vendors table and a quotes table. I have a portal on the quotes table that shows "Potential Vendors". The portal simply shows all vendors with in a 100 mile radius of the Quote's zip code. I want to put a button on the portal for each Vendor that will run a script "Check Availability". That way, I can click the button for each vendor that I want to check that is in the radius. Sometimes, I might want to check them all, sometimes only one or two.

The script would email the email address of the vendor, but it would pull some of the fields from the Quote record. The problem I'm running into, is the fact that there may be several different qoutes for numerous vendors, and it's not a simple relationship...

Any advice on how to do it? I can write an email script, i'm just not sure on how to write this one with the relationship challenge...

Any help would be much appreciated. Thanks!

[Vaughan]

Put the id of the quote into a global field in vendors, and use this global field as the basis for a relationship back to the quotes that the process started on. That way the dozens of vendors within the radius all "know" which quote they need to refer to.

[E.J. Sexton]

You could probably also pass the field values from the Quote record that you need as script parameters:

Perform Script ["Check Availability"; Parameter: Quote::field1 & "¶" & Quote::field2 & "¶" & Quote::field3]

And then retrieve those values in the "Check Availability" script:

Set Variable [$field1; Value:GetValue(Get(ScriptParameter);1)]

Set Variable [$field2; Value:GetValue(Get(ScriptParameter);2)]

Set Variable [$field3; Value:GetValue(Get(ScriptParameter);3)]