Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Auto field filling


timsonefelt
 Share

Recommended Posts

I have bill to and ship to addresses on my invoices. I'd like to be able to execute a script (have a button) for when the addresses are the same, that automatically fills in the values for the second set of address fields so I don't have to type everything twice.

 

Any help is appreciated

 

Thanks,

Tim Sonefelt

Link to comment
Share on other sites

I have bill to and ship to addresses on my invoices. I'd like to be able to execute a script (have a button) for when the addresses are the same, that automatically fills in the values for the second set of address fields so I don't have to type everything twice.

 

Any help is appreciated

 

Thanks,

Tim Sonefelt

 

Script

Set field (Client::ShippingAddress;Client::BillingAddress)

Set field (Client::ShippingCity;Client::BillingCity)

Set field (Client::ShippingState;Client::BillingState)

Set field (Client::ShippingZip;Client::BillingZip)

 

If you have FMP v10 then you can use a "script trigger" to fill in the shipping fields.

Link to comment
Share on other sites

OK, I tried to do this, but have some questions . . .

 

in the New Script area, I chose the 'Set Field' and it gave me [] instead of (). I assume that's the same thing. Then there are two script step options: specify target and calculated result. I can't get both

Client::ShippingAddress AND Client::BillingAddress in there. When I put the semicolon as you had above, it gives me a message that 'an operator is expected here.'

 

also I'm on FMP 9 for mac so I'm guessing the 'trigger' option you mentioned isn't available to me.

 

I look forward to getting this worked out - thanks for your help!

Link to comment
Share on other sites

Basic Tutorial on what folks on this forum (and other filemaker-centric venues) mean by Some Command [Table::Some Field; SomeTable::SomeOtherField] and so forth.
Link to comment
Share on other sites

... I chose the 'Set Field' and it gave me [] instead of ()...

 

It is something you do not have control over in FM since it is done for you.

 

Then there are two script step options: specify target and calculated result. I can't get both Client::ShippingAddress AND Client::BillingAddress in there. When I put the semicolon as you had above, it gives me a message that 'an operator is expected here.'

 

When you choose "Set field" as a script step, you have to choose the target field and what you want FM to put in the target field.

 

It looks like this: Set field [Target Field; Value to place in target field**]

 

1. You do NOT place the semi-colon (FM does it)

2. **The value in the target field can be the value of another field, a calc based upon another field, a local or global variable, or a calculated text, number, date, time, etc. It must be in correct FM syntax.

 

...also I'm on FMP 9 for mac so I'm guessing the 'trigger' option you mentioned isn't available to me

 

Script triggers were introduced in version 10. There are 3rd party options available for earlier versions.

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use