I'm writing a formula to change a bunch of fields when a button is clicked. Some of the fields are meant to track the previous value of another field. I need to update a field with the value in another field and then clear out the original value of that field.
[Date field A] = 10/12/16
some change requires [Date field A] to be cancelled and rescheduled, but we don't know the new date yet.
i want to update [Date field B] with the date that is in QB right now (10/12/16) and then delete the data in [Date field A] so that it is now blank.
my current formula is:
URLRoot() & "db/" & Dbid()
& "?act=API_EDITRecord&rid=" & [Record ID#]
& "&_fid_1302=_fid_24&_fid_1380="&" "