Forum Discussion

AshleyAshley1's avatar
AshleyAshley1
Qrew Trainee
8 years ago

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

Hi I'm trying to add a button which will open the same record in a different form but at the same time editing a field within that form. i have this so far which opens the record in the other fo...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
So you cannot actually populate a checkbox field when opening the record to edit.

The only option would be to actually have that checkbox set to checked under the covers and then display the record in Edit mode.

The subtle difference is that when the user clicks the button, that checkbox will be checked, regardless if they choose to back out of the edit process and not actually save the record.

The code would be in two steps like this, using formula variables for each step.

var Checkbox= URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxx"
& "&_fid_155=1;

var Edit = URLRoot() & "db/" & Dbid() & "?a=er&key="&[Record ID#]&"&dfid=11";

$Checkbox
& "&rdr=" & URlEncode($Edit)


If you have application tokens set to be required you will need to supply that line
& "&apptoken=xxxxxxx"

or else disable them on the Settings in App properties and then you don't need that line.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Re: "Curiously QuickBase does allow you to do this for new records:"

It must be because there is an API for API_GenAddRecordForm (which must be what happens when the short form of a=nwr is used),  but there is no API for "API_EditRecordForm" - ie that does not exist as an API.