your "input field should be a global field and not one used to store the project number for each Projects record. Then your script, when performed by either the OnObjectSave or OnObjectModify trigger (which one to use depends on the specific formatting options you select for this field) can perform a script that finds the specified Project record.
See this thread for examples of scripted finds that use criteria user entered/selected in global fields to find records: Scripted Find Examples
thanks a lot PhilModJunk, I used the first solution of that post to solve my issue.
I've just an additional question about this issue.
Currently I'm working with one user and then the project number in the global field is OK. But how should I use this global field when there are 2 or more users?
- User1 is working on project 1
- User 2 is working on project 2
Every action of the two users will result in a new value of the global field.
So what I am looking for is to store the project number as an user specific variable. And maybe in the future there will be other user specific variables to store.
Do I have to create a table (with global fields) per user? Or is there another option?
If you are talking about two or more users accessing the same database at the same time, a Global field is user specific. The value a user enters/selects in a global field will not be visible to other users as long as they are a client instead of the host of a hosted database.
thanks a lot, that was the information I was looking for.