Hi,

hoping this is a really simple problem, but it is driving me insane

Let me explain:

I am trying to modify a filemaker solution I paid to have developed. I now want to try and fix this myself. I have a little knowledge of filemaker so it would be good to know how to do this

I have 2 tables, costing and quotes. Both of these tables have a field that is set to Timestamp, and have the tick in the box 'modification - date and time'. I then have a dashboard layout with 2 portals that display this information.

My problem is this - if I log in using any user, the modification timestamp on one of the portals (the quotes portal) is changed to the current time and date. On the other portal (costings), it remains unchanged, unless I modify a record.

I have even deleted the timestamp field out of the costings table and pasted it into the quotes table, to ensure they are formatted the same, but the same issue arrises.

Is there somewhere I am not looking that influences how the timestamp works?

Any help appreciated.

Thanks

If I had to guess - and without seeing your file, it's no more than that - I'd say you have a script set to run upon opening the file, and this script modifies all quote records (though I am not sure why this would be needed).

HI,

thanks for your reply. Regarding the script that modifies fields at start up, wouldnt it modify all fields?

The problem I have is that one timestamp field is being updated on login, the other exact copy isnt??

Regarding the script that modifies fields at start up, wouldnt it modify all fields?

It only needs to modify one field in order to trigger the LastModified field.

one timestamp field is being updated on login, the other exact copy isnt??

What do you mean by "exact copy"? Do you have another LastModified field in the same table?

Hi,

I have checked the file, and there is a script run on 'open file'. I have disabled this and it has fixed the issue.

Just need to look and see now what the script was doing.

Thanks for the advise on where to look. Would have never thought of looking for a startup script :

thanks again