Selective access list to generate a date when changed
I have a slective access list for approving a transaction, where certain people can approve a process or reject, challenge it.
When they choose 'approval status'.approved', i would like to add the date to a line item.
Adding a date to a line item is easy enough, HOWEVER the date field cannot be open, or people who do not have selective easily type a date in it.
i did think about using IF 'project approval' = 'approval status'.approved THEN timemodule.currentdate ELSE BLANK
But this would change the approval date every day,as i can't do an IF only when the field is changed can I?
You see my dilemna, how can i only allow a line item to be generated by people who have selctive access to the list, or only be updated when another line item is changed?
Thanks in advance