This topic is 2583 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.
I've been looking around to try to find this info:
When in the process does a field that is set to Auto Enter: Creation Timestamp actually enter the data? On creation? On commit?
Is it the same for all creation and modification auto entry?
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.
I have a database with 1000's of children's games. I have teachers in other parts of the world classifying the games into categories. When they log in, a find is performed to bring up a specific 100 games for that teacher to categorise based on topic. The teacher categorising the Games to teach the animals (100 games) has a readout telling the teacher that s/he is on E.g. Game 4 out of 100 which is a calcualtion I made.
Once they are done they check the 'Done' box in the Games::Done field.
The teachers have requested that there is a readout telling them how many games they have completed and I am struggling to create a formula to acheive this.
I imagine I need the count function to find not only the Games::Done that have been checked 'Done' but only those within the Games::Topic = Animals.
I have to admit, I am bit amiss as to how to create such a formula. Would it be a summary field or a count function?
Thanks so much for all your advice,