This topic is 1840 days old. Please don't post here. Open a new topic instead.
I have a date field which uses the Evaluate Function in the Auto-enter by calculation to update the date when a Signature is entered into a container field.
I just found out that the date is being updated with the SYNC date instead of keeping the original date that the signature was entered.
For Example: a new signature is entered in the offline file on 10/3/17, the "Date" field gets auto-entered with a date of 10/3/17. On 10/5/17 the offline file is sync'd with the host. Now the date on the host has been entered with 10/5/17 instead of 10/3/17.
How do I fix this so the original date gets entered and is not based on when the sync occurs? I need to do this at the field level or Sync layout level, and not through a script trigger because I have the date field (actually 4 date fields) on over 100 layouts.
By Matthew R White
I have a number field that I would like to auto enter either (2, 3, or 9) at random every time a new record is created.
I tried to do a sequenced auto enter but filemaker simply counts up from 1 and I can't specify the 3 numbers.