November 3, 200916 yr 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.
November 3, 200916 yr 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/
November 3, 200916 yr 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.
Create an account or sign in to comment