I dont see a 'Date modified box' on your layout, I see 'Created by' and 'Date Created'.
I think the problem is your typing into the record, then creating & commiting a new record.
You would need a field with timestamp modified.
Create the new record with a button, then type in data then commit.
those are just the manually enetered names, I just didn't change them yet. The Date box AUTO Fills when you first create the document, and it's set to change if you modify the Description box. the Created by Auto fills with the UserID of the person logged into Filemaker neither of these box's is editable by the user.
The problem occurs if you type in the description box, then click the button to create a new record, without using enter or tab first to move to the next field, it adds a blank record when you click the button (pressing enter or tab after changing the description box prevents this from happening but you cannot assume all users will do this). if I set the date box to only auto fill on creation it does not do this.
1 of 1 people found this helpful
Why don't you just add a Commit Record step at the start of your script? That way, if there is a record active but not finalised it will at least be committed so that autoupdate stuff gets done before the rest of the script proceeds to create the new record.
ok I have (sortof) fixed this. @keywords gave me the idea. although your suggestion didn't actually work. What I had to do was add a 1 second pause in the script, between creating the new record and adding the ticket number to the new record, this way the time stamp is NEWER that the previous record and so shows as the new record waiting to be added.
So my script now looks like
thankyou for helping me think this through