Field keeps re-auto populating with default

[fitnessfm]

Hi,

 

I've been troubleshooting an issue with a database that I made and am hoping to get some help. I'm self-taught and am putting together this database at work because there's no one else do it.

 

I have a field that was originally set to auto-populate the word "Active." The user interacts with the field through a drop-down menu with the options: Active, Cancelled, and Complete. After some activity, the user selects "Complete."

 

The field will show "Complete" for a short period of time and then change back to "Active," usually the following day. The day that the record shows as last modified also changes without anyone manually making any changes.

 

Any ideas as to what might be going on or where I should look? I've tried removing the auto-enter data option from the field, but that doesn't seem to have worked.

 

Screenshot of table fields enclosed. I'm using Filemaker Pro 13, but started the dataabase in 12.

 

Thanks.

[Wim Decorte]

The "modifier" field should tell you who modified the record... since the modification timestamp also changes, there is someone or something (a script?) that modifies the field on that record.

[Rick Whitelaw]

When you go to Define Fields make sure, when you set up auto-enter, to allow the user to change the value. The checkbox.

[LaRetta]

If you are talking about the Status field, you have removed the auto-enter.  If on the auto-enter set to 'Active' you had unchecked 'Do not replace existing value' that will cause it to re-evaluate and change back to active (depending upon what you used for the calculation).

 

As Wim indicates, if it is still changing (and upon viewing the field definition there is NO auto-enter on Status), it indicates there is a script or script trigger changing it again.

 

To handle the situation, after you find the script or trigger which is still causing it to change, do this:

 

Set the Status field to auto-enter DATA of "Active".  That will insert 'active' when the record is created but will NEVER re-evaluate it and change it back after someone changes it to Complete.

[Rick Whitelaw]

Ah, LaRetta. You got the language right. I didn't remember the exact wording of the checkbox. I guess I haven't been there in a while . . .

[fitnessfm]

Thanks everyone for your suggestions! I combed through my scripts and found a suspect one that changes the status to "Active," so I removed that line and set the Status field to auto-enter DATA "Active." Worked like a charm.