Button to copy field into another table
So I need a button to do the following: In child table: 1) When a [status field] = "Work finished" --> button to appear on the form. 2) When button is clicked --> Copy [field w] and [field x] (in...
Forum Discussion
You will want to use the API_EditRecord call from the child record.
Your formula URL field will be set up similar to this.
Where the '9' will change to the FID of field 'y' and the '25' will change to the FID of field 'z'
Your formula URL field will be set up similar to this.
URLRoot() & "db/" & [_DBID_PROJECT] & "?a=API_EditRecord&rid="&[Related Project]&"&apptoken=xxxxxxxxxxxxx&_fid_9="&URLEncode([Field w])&"&_fid_25="&URLEncode([Field x])
Where the '9' will change to the FID of field 'y' and the '25' will change to the FID of field 'z'