QBuserQBuser
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Lock values once form is marked complete
I have a form that I would like to lock all values once the form is marked finalized. If formulas or values in linked tables change I do not want the values to change if the form is marked finalized. What is the best way to do this? Do the values need to be copied to another table when the form is marked finalized?Re: Automatically create child record when parent record saved
Thanks for the info on the app token. The number of children varies depending on the selection, but a minimum of 5. The current button I am working on adds 5 records. Is there something I can add to the URL formula to save the parent record first and then create the children? Here is my current formula: var text SetFocus = URLRoot()&"db/"&[_DBID_FOCUS_TASKS] & "?act=API_EditRecord&rid=1" & "&_fid_6=" &[Record ID#]; var text RunImport= URLRoot()& "db/"&[_DBID_TREATMENT_BATCHES]& "?a=API_RunImport&ID=10"; var text RefreshRecord= URLRoot()&"db/"&Dbid()&"?a=dr&rid="& ToText([Record ID#]); $SetFocus &"&rdr="& URLEncode($RunImport) &URLEncode("&rdr="& URLEncode($RefreshRecord))Re: Automatically create child record when parent record saved
I am following the article link above and it is working well except for the following 2 items. 1. I had to disable my app tokens to get this to work. What code would I need to add to get the app token to work again? 2. I have to save the project before clicking on the button for it to work. What do I need to add to the button formula to save the project first and then create the child records?
