I want to put a "submit" button on my form that allows for:1. A checkbox field to be checked [Invoice Submitted]2. The record to be saved3. It must work whether or not it's a new record or one that has been saved before.4. I was using a formula-text but formula-URL is fine that that's what I should be doing.I was trying to get it to update the field and save the record, but the code doesn't work, I believe because it has to be saved firstvar text Update=URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#]) & "&_fid_20=1"& "&apptoken= *********"; "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit Invoice</a>"

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.

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

21 Replies

QuickBaseCoachD
Qrew Captain
8 years ago
This is the only school there is for the type of questions you are asking. There are a bunch of tricks to learn. Once you learn them, you just keep re-using them.
- StephenStephen
  Qrew Assistant Captain
  8 years ago
  Well you'd think I could at least have realized that I declared a variable and then never called it. :(
QuickBaseCoachD
Qrew Captain
8 years ago
Be sure to give the button a pretty color.
QuickBaseCoachD
Qrew Captain
8 years ago
formula URL
- StephenStephen
  Qrew Assistant Captain
  8 years ago
  I did add to my report as well, and presto, like magic.
StephenStephen
Qrew Assistant Captain
8 years ago
This is excellent. Thanks. I had to remove what appeared to be a stray "=" in the first assignment so it now looks like this. And yes, a green button was mandatory for this one :)

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);
QuickBaseCoachD
Qrew Captain
8 years ago
It even works if it was a button on an embedded report of records on a record. ie on a child table on a report on a record.
QuickBaseCoachD
Qrew Captain
8 years ago
btw, what is your "day job" in real life? What kind of business are you running?
- StephenStephen
  Qrew Assistant Captain
  8 years ago
  own/run a niche toy company: www.weebelievers.com

Forum Discussion

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

21 Replies

Related Content

API Button Help

Formula Url Buttons

Delete Formula Button Error

Previous and Next Record Buttons

+New Button