I have two tables: Project Activities and Activities Dates History. On a form of Project Activities table I have a button "Add a new date". Is it possible to fill the dates fields with the dates at the moment and change only those I need to change? Because now after clicking "Add new" I get redirected to the blank page, which might not be ideal for those people, who, for example, wants to keep the planned end date and to modify only actual end date.
So more or less I'm looking for something like "Update and Save as a new record".
Thank you in advance,
My conditions should be: copy the latest record where project activity is the same as on the current page.
So something like this, I guess, but this doesn't work, I get "Date not found" error.
URLRoot() & "db/" & [_DBID_ACTUAL_DATE_UPDATES] & "?a=GenCopyRecord&rid=[Maximum Status Evaluation Record ID#]"
where 6 is the FieldID of a "Related activity" field in Dates table.
URLRoot() & "db/" & [_DBID_of the child table] & "?act=API_GenAddRecordForm"
& "&apptoken= xxxxxxxxxxxxx" // only required if you have application tokens enabled. For simplicity you may want to turn that off in app properties
& "&_fid_xx=" & URLEncode([Record ID#]) // populate the field [Related PARENT] with the value of the Parent's Record ID#
& "&_fid_yy=" & URLEncode([some other field that needs to be populated])
& "&_fid_zz=" & URLEncode([yet some other field that needs to be populated])
So, you fill in the xx yy zz with the field ID number on the child record to be populated.