Conditionally check a checkbox

Question

I've put in too many hours this week and am making stupid mistakes.&nbsp;&nbsp;I need a button that will check a checkbox if a corresponding checkbox is checked.&nbsp; There are several services and not all are subscribed on each order.&nbsp; Rather than checking a submit button for all services that have not been submitted I want to add a button that will check the submit button for any services that have not been submitted.This is my first real attempt at a button and I am a bit blind.&nbsp;&nbsp;I am currently using:var text URLRemoteServices = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord &amp; rid=" &amp; [Record ID#] &amp; "&amp;_fid_3008=1" &amp; Rurl();If([Remote Services] and [Remote Services] != [Remote Services - Submit], $URLRemoteServices)and getting the following error
&lt;qdbapi&gt;

&lt;action&gt;API_EditRecord&nbsp;&lt;/action&gt;

&lt;errcode&gt;5&lt;/errcode&gt;

&lt;errtext&gt;No Such Operation&lt;/errtext&gt;

&lt;errdetail&gt;
This operation does not exist. Please check the URL.
&lt;/errdetail&gt;

&lt;/qdbapi&gt;I only have the first service in the list added at the moment.&nbsp; I will use the approach I saw in&nbsp;this&nbsp;post.I hope one of you can point me in the right direction.------------------------------Paul Peterson------------------------------

markshnier__you · Answer

.... _fid_3008! man o man, that's a lot of fields.

But I digress,

Like Tom Hanks says "there is no crying in baseball"

similarly, "There is no spaces in URLs"

?act=API_EditRecord & rid // take out the spaces before and after the &

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

paulpeterson1 · Answer

Thank you Mark,I removed the spaces and now getting this error:
&lt;qdbapi&gt;

&lt;action&gt;API_EditRecord&lt;/action&gt;

&lt;errcode&gt;0&lt;/errcode&gt;

&lt;errtext&gt;No error&lt;/errtext&gt;

&lt;rid&gt;200480&lt;/rid&gt;

&lt;num_fields_changed&gt;0&lt;/num_fields_changed&gt;

&lt;update_id&gt;1586982586971&lt;/update_id&gt;

&lt;/qdbapi&gt;------------------------------Paul Peterson------------------------------

adamkeever1 · Answer

You have to redirect if you don't want to land on the API response page. This isn't an error, but it did not change the checkbox to checked.

What are the conditions you are trying to evaluate? I don't follow your conditional statement:

"If([Remote Services] and [Remote Services] != [Remote Services - Submit], $URLRemoteServices)"

Your first [Remote Services] call does not evaluate anything. I would expect something more along the lines of:

If([Remote Services] = true and [Remote Services] != [Remote Services - Submit], $URLRemoteServices)

------------------------------
Adam Keever
------------------------------

markshnier__you · Answer

Adam, In fact with a Boolean (checkbox) field, you do not need to check if it is true.&nbsp; It is inherently true or false.In fact all of these expressions will yield identical resultsIF([My checkbox field]=true, true, false)IF([My checkbox field]=true, true)[My checkbox field]=true[My checkbox field]Mark------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

I'm getting a little closer.&nbsp;&nbsp;I changed the URL to&nbsp;URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord&amp;apptoken=ghhrwtcy2ca93dvtmnvidb9gm5a&amp;rid=" &amp; [Record ID#] &amp; "&amp;_fid_3008=1" &amp;"&amp;rdr=" &amp; Rurl();It is updating the checkbox, but now getting&nbsp; a prompt to save the form and the following error:&lt;qdbapi&gt;&lt;action&gt;API_EditRecord&lt;/action&gt;&lt;errcode&gt;0&lt;/errcode&gt;&lt;errtext&gt;No error&lt;/errtext&gt;&lt;rid&gt;200480&lt;/rid&gt;&lt;num_fields_changed&gt;1&lt;/num_fields_changed&gt;&lt;update_id&gt;1587049487774&lt;/update_id&gt;&lt;/qdbapi&gt;------------------------------Paul Peterson------------------------------

Forum Discussion

Conditionally check a checkbox

Related Content

Add Numeric Fields together if a checkbox is checked

Autofill user field when a checkbox is checked

Using Pipelines to Archive Records Based on Checkbox

Formula checkbox using manual checkbox and lookup formula

Converting delimited text into checkboxes