Auto enter

[johnwiliams]

Hi ,

i am creating a solution in which what i want is that when i press a button it would automatically create a new record along with that new id should also be generated via script not by auto enter options.

[Makah]

Can I ask why you don't want to use an auto enter option for the key?

The hard part about not using the auto enter is making sure every key is unique.

You could set the key field to:

Filter( Get ( CurrentTimeStamp ); "1234567890")

Assuming that your script will not be running by multiple users at the exact same time, this could work. But, it's not bullet proof. An auto enter is a much better option.

You could also add the account name to the key to make 100% sure it is unique:

get(accountname) & Filter( Get ( CurrentTimeStamp ); "1234567890")

But it will make your key longer. Hope this helps.

Makah Leal

Soliant Consulting

http://www.soliantconsulting.com/apps/filemaker/

[Vaughan]

Use field-level validation to ensure the key is not empty and unique. FMP won't let the record be committed (saved) unless the validation is satisfied.