Just viewing the record should not trigger a modification...
What version of Filemaker are you using? (12 was released just today...)
Are there any script triggers on this layout? (See layout setup | Script triggers...)
I don't have any script triggers. I currently have the FileMaker Pro 11 Advanced version.
When the record is first created, these fields will auto-enter the account name and date.
I created a sample file with a text and date field with the above auto-enter modification settings.
I reset my system clock to yesterday's date and created several records
I used mange security to create a second full access account.
I then reset my system clock to the correct date, closed and reopened the file with the second account.
I can click through the records while in form view or view them all in table view and viewing the records does not modify the date nor the account name.
Not sure what the problem is on my end. Everytime i click on a Script Trigger next record key which moves to the next record it records it as modified, do you know how to deal with this kind of problem, I currently have a navigation that run by click on a container which triggers a script, is that the cause of the problem?
How do i deal with that?
I'd need to see that script and I thought you said that you didn't have any script triggers? What trigger is this? Is the container field set up as a button or are you using a script trigger such as OnObjectEnter?
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here.
- If You have FileMaker advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format. (Use the HTML option on the database tab panel and paste the text into the forum's HTML editor.)
I'm using the script trigger OnObjectEnter feature for all my containers to act like buttons.
Here is a screenshot of the script that i run for the next_Record, i use the same procedure to run the previous records and so on.
If the layout is based on Product, then the set field steps in this script (which I can fully read due to the lack of resolution), are modifying your record and this triggers the fields with Modify auto-enter settings to update.
While it's not a solution for the issue here, you can use button set up on the container fields to turn them into buttons instead of using OnObjectEnter.
If you can post the script again so that it's readable, I can suggest changes for going to next, previous, first, last records so that they do not modify records in your table.
Here is a pdf version of the script, hopefully this is better quality.
Sorry, here is the jpg version of the pdf.
How do you use The Product::Find Option and Product::Find fields?
What does the _update_record_count script do? (It might be modifying the record as well.)
Do you have Filemaker 11?
I can't be sure, but these look like fields that could be set up with global storage and defined in a separate table instead of in this table. If so, this change will keep the script from modifying the record and causing the modify fields to update.
Yes, it is modifying the record using the _update_record_count script, which is shown in this image. How do i deal with modifying fields that shouldn't count towards the actual user modification?
As I mentioned in my last post, put the fields modififed by your scripts in a different table. Depending on how you use these fields, you may be able to use fields with global storage. (Fields in global storage can be accessed and modified from any record in any layout in your file.) You may also be able to use global variables in place of fields.
I will definitely do the conersion and let you know how it goes.
Thanks for your help.
I'm not sure what you mean by adding the fields that are modified by the script in a different table. Do you have an example on how to do that?