AnsweredAssumed Answered

Entering default value on new record creation?

Question asked by retired on Feb 10, 2009
Latest reply on Feb 10, 2009 by retired


Entering default value on new record creation?


When entering a new record I need set a default value to three different fields. Two of these I have accomplished with short scripts but the third has me stumped.  I need to add "Active" to a field named 'status'  I have tried the Insert Text script but must be doing something wrong as it does not work.  Using FMP 10 - it writes the script as

Insert Text [Select; members::member_status["Active"]]

The Script Reference pdf shows the syntax as

Insert Text [Select; members::member_status; "Active"]

 If I try to enter per the reference I get error saying the [ is expected.

When I run the script as FMP creates it nothing happens.

I have also tried the Set Field but that does not work either - I assume since there is no calculation involved.

It's been almost 30 years since I've done any programming so I will appreciate all help.