Open record in another form and change the value of a field

I create a simple application:

Edit Record With Field Override ~ Edit Record #1
https://haversineconsulting.quickbase.com/db/bm5ep5eb7?a=er&rid=1

You can tack on parameters to the URL that will set values for _fid_6 and/or _fid_7 immediately when the form opens.

?a=er&rid=1&_fid_6=Jane Doe&_fid_7=4/5/2018
?a=er&rid=1&_fid_6=John Doe&_fid_7=1/2/2019

I modified the pastie slightly to not change the field unless a value is supplied in the URL:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=600

The example hardcoded processing of only these two fids but it would not be difficult to modify the script to process any supplied fid.

FWIW, the reason QuickBase probably did not implement this feature on ?a=er (but they did on ?a=nwr) might be because you loose knowledge of what the old value of the field was so it is probably a safety thing.