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.