Auto field filling

[timsonefelt]

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

[Techphan]

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.

[timsonefelt]

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!

[AHunter3]

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.

[Techphan]

... 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.