Button to check a field and save the record (Submit button)

I guess an if(IsNull([Record ID#]),
would allow me to have two strings one for API_EditRecord and one for API_AddRecord but I don't understand how to get the AddRecord to work and then how to imbed the two options into the IF statement with correct Syntax. 


I would think Javascript would make sense but I know little about Javascript. 
 
Seems like Javascript would just check the box and hit the "save" button regardless of whether it was add to edit?



,

My suggestion is to just have the user save the record and then give them a button to "Submit", when in View mode.

That's feeling like the right answer at this point as this gets more and more complicated :(

I thought this code worked but now it won't. It saves but doesn't check the fid_20 to a true:

var text Update=URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_20=1"& "&apptoken= xxx";
"<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit Invoice</a>

You are just guessing at code.  Well, I suppose that we all do that sometimes.  

I don't know if there is a way to do what you ask without javascript, but that code certainly that won't work.

You are defining the formula variable called "Update".  But then the actual code does not even refer to that formula variable.

Ah. I switched it from Formula-Text with HTML Checked to Formula URL and that works in view mode. I am then hiding the submit button in edit/add mode.

var text URLONE = URLRoot() & "db/" & Dbid()& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_20=1"& "&apptoken= xxxxx";

var text URLTWO = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
  
$URLONE
& "&rdr=" & URLEncode($URLTWO)

If you just want to edit the record to check a checkbox, yes that is easy.  

Do you also have a need to check that checkbox from a report but no want to have different buttons?

this syntax works well as long as there are no redirects in your URL

var text URL = = URLRoot() & "db/" & Dbid()& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_20=1" & "&apptoken= xxxxx";


"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"


The magic is that after it does the edit it will refresh the"page" whether that is a record or a report.

It wouldn't hurt to have it work from a report, allowing a user to submit from there after editing say multiple invoices. Do I use a formula text or URL type?