button to create a record that is not a child
I've got a parent table (Cases) with two different child tables (Activities and Tasks). I figured out how to create a button in Tasks that creates a new Activity. (Go me!) What I can't figure ou...
Forum Discussion
Okay, here's a new challenge. :)
Now I want the button to "Mark Complete and Create Activity." Complete is a checkbox in the Tasks table, fid 9.
Here is where my formula stands now. What do I add to have it mark the task as complete?
URLRoot() & "db/" & [_DBID_ACTIVITY_SUMMARY] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Related Case #])&"&_fid_15=" & URLEncode ([Task])
Now I want the button to "Mark Complete and Create Activity." Complete is a checkbox in the Tasks table, fid 9.
Here is where my formula stands now. What do I add to have it mark the task as complete?
URLRoot() & "db/" & [_DBID_ACTIVITY_SUMMARY] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Related Case #])&"&_fid_15=" & URLEncode ([Task])
Thank you so much!
Form rules won't work because these buttons will be pressed from a report rather than a form.
Form rules won't work because these buttons will be pressed from a report rather than a form.