I believe I have asked this before but now that the script triggers were added to FM 10 I was able to lock a record after it was Marked Done so that it cannot be edited again.

I was wondering is there already is a better way then the one I used and I wanted to check if there are any big drawbacks with the method I used as far as it breaking depending on user actions.

If anyone can take a look at the file and comment I would appreciate it.

Thank you Kindly.,

T.009.zip

1) Go in Table View

2) Add to the table the hidden fields

3) Set them to Empty

4) Write "In Progress" into Text3

5) Drag & Drop from Text3 to Done

Thanks., Hm, I tried but I got the pop-up upon exiting the hidden field and it would not take the drag and drop text.

I might have done something wrong when following your instructions, not sure.

This would not be an issue though is only Form view was available, I believe.

It is more then likely it can be broken if one puts an effort but would regular users be able to break it via regular use?

Isn't this simpler ?

T.009MOD.zip

It looks simple but I do not want to relogin users. If they click on ToggleLog when they are done, they will be relogined as Limited. They cannot then go about their business as other things depend on login account.

Unless I am missing something...

Maybe there could be another way with this.

I am thinking along the lines of your ToggleLog button, which would set a Control field to 1 and another script which would trigger on RecordLoad and automatically relogined useres who visit a record that has 1 in control field and then relogin them back to their account when they leave the record or something similar.

It looks simple but I do not want to relogin users.

They haven't to relogin...

They just open the file with a limited account and stay so forever.

( the ToggleLog button was made only for you )

Hm, I do not want them to stay limited forever. That applies to the whole file, if my understanding is not wrong, I want it to apply to the record that was marked as Done only.

If they stay limited account forever, there will be issues with Auto enter creation account name, modification account name (for records that are allowed to be edited...), the records cannot be exported and such.

( the ToggleLog button was made only for you )

Yeh, got that after I posted a reply. :

Anuviel

I think that you have to go and look better at privileges.

The user has ALWAYS a limited account but, depending from your needs, he can export and such.

He just can't modify or delete a record marked Done.

Touche - just realized that.

Done ≠ "Yes" - just saw that there...

Thanks for the help and instruction.