Forum Discussion
ChayceDuncan2
6 years agoQrew Cadet
Instead of using a form rule from your screenshot - you can use an automation to populate it for each modification to the record where that specific field was changed. In the automation - you would write the value of 'Last Modified By' - the person who last updated the record - and copy that into the 'Anticipated Purchase Entered By'
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
- ShaneSelasky6 years agoQrew CadetWhere can i find more information about automation?
- ChayceDuncan26 years agoQrew CadetHere is the Quick Base documentation from the site.
https://help.quickbase.com/user-assistance/about_quick_base_automations.html
In your specific situation - you'll want an automation something like this:
1) Automation occurs when data changes in the table where you date field exists
2) Trigger is Based on Add/Modifications - and where that exact field is the field changing
3) Your action is to modify the specific record that was just changed (this would be in the filter condition) - and the actual change would be to copy the value of Last Modified By into your user field
Hopefully that helps get you started.
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base - ShaneSelasky6 years agoQrew Cadetnevermind. i found it. thanks. i will have to check how this works.