Forum Discussion
- QuickBaseCoachDQrew CaptainThere seem to be some extra characters in the middle. The \n does not belong and you were missing an &
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_208=1"
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) - ShontaySmithQrew Assistant CaptainDo I need the apptoken?
Below is what I have and I am receiving an error message:
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4" & [Record ID#] &"& _fid_208=1"&"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) - QuickBaseCoachDQrew CaptainI suggest that you go into Settings and then Application Properties and uncheck the box which requires application tokens.
Then i suggest that you review the formula which I posted and use it instead of your formula. You formula is missing the &rid= part which tells the formula which record ID to update. - ShontaySmithQrew Assistant CaptainThe App token have to be required, so would I apply that right after the EditRecord& apptoken =???"
- QuickBaseCoachDQrew CaptainIt would look like this with an app token
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4"
& "&_fid_208=1"
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) - ShontaySmithQrew Assistant Captainthanks I got it to work
- QuickBaseCoachDQrew Captainthx for letting me know. now, btw, after the button is pushed, then if it is pushed again, the email will not fire as the trigger field is already set to 1 (true). If you want it to fire every time and you tell me what the name is of your trigger field that field ID 208, then I can help you with that.
- ShontaySmithQrew Assistant Captainthanks you read my mind the field name is Send_Notification
- QuickBaseCoachDQrew Captainvar text NewToggle = IF([Send_Notification] = true, "0","1") // this will make the toggle be the opposite of its current value, but in text format.
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4"
& "&_fid_208=" & $NewToggle
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) - ShontaySmithQrew Assistant CaptainPerfect you rock, thanks alot