We are using a web based version of FMP 16 for 20 users. Is there any way anyone of them can see the last record they were working on before they closed when the open the program?
Set a field for last modified by and last modified timestamp, have them filled automatically. Then when they log back in, perform a find against those fields for the account and for the max timestamp value (Max ( Modified On).
Out of habit, I almost always place a created by (Auto-enter Account Name), created on (Auto-enter Timestamp), modified by (Auto-enter Account Name), modified on (Auto-enter Timestamp), and pkID (primary key number or UUID) fields on every table. It just makes a lot of things easier, especially to find changes in a date range, etc.
It sounds good, I will try it. I did not even know that could be done...
Good luck, and do holler if you get stuck. That's one of the great things about this community; chances are someone has already done it and can save you time and frustration.
Yes, I could not agree more.
It is working, except for one thing. Instead of coming with the user name, It appears the Institution name in the field: Last Modified by. I guess I will need to contact IT from the institution, unless, someone here has another idea.
BTW, THANK YOU!
You'll want something that looks like this:
You're very welcome.
To clarify, every user should have their own account and password, that will help keep things unique and be able to create the functionality that you're after. Now, this works only if someone else doesn't modify the record, as then it will be that users record. If you need to adapt for that, then along with a Users (or Account) table, add a field to store the pkID of the record they are working on when they close the last window on their session. This will require a closing script for the file to capture and record that ID for them.
Every user has their own account and password and IT set the system so everyone can use the same credentials that we use to log in to the PC every morning. Except for me since I am the administrator maybe that is why I see the Institution name instead of my user's name.
Any record can be modified for any user since each of them has a piece of the information...
This is a learning process for me, so thank you for the help.
No worries. If you log in as yourself, not administrator, you should be fine. You may want to just change your privilege set in the database so you can log in as you, but have administrative control.
I will see what happens tomorrow when other team members start pulling data...
It used to be that way, but IT decided to change it for some reason that is unknown for me... They have the control on that, so I will try to see what can be done about that.
Again, thank you very much!
Retrieving data ...