Execute a block of code in an IF Statement

Question

I hope this is a simple question with an simple answer.
Is it possible to execute a block of code rather than a single action inside an IF statement?Ex:IF(condition, {&nbsp; &nbsp; &nbsp;command 1,&nbsp; &nbsp; &nbsp;command 2,&nbsp; &nbsp; &nbsp;....}------------------------------Paul Peterson------------------------------

donlarson · Answer

Paul,

Build the parameters you need to use in the formula
Build a number of URL statements as variables with the parameters you need
Build a logic layer,&nbsp;that will determine which URL the user can execute.&nbsp;&nbsp;
Create the User Interface for them to execute

// Parameters

var&nbsp;text&nbsp;Token&nbsp;="abcdefghijklmnopqrstuv";

var&nbsp;text&nbsp;IMGButton&nbsp; =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"&lt;img&nbsp;src=https://images.quickbase.com/si/48/045-lock.png&gt;";&nbsp;

// URLs

var&nbsp;text&nbsp;URLOne=&nbsp;
&nbsp;&nbsp;URLRoot()&nbsp;&amp;&nbsp;"db/"&nbsp;&amp;&nbsp;Dbid()&nbsp;&amp;&nbsp;"?a=API_AddRecord&amp;AppToken="&nbsp;&amp;&nbsp;&nbsp;&nbsp;$Token&nbsp;&amp;&nbsp;&nbsp;"&amp;_fid_XX="&nbsp;&amp;&nbsp;URLEncode&nbsp;([Record&nbsp;ID#]);var text URLTwo =

var&nbsp;text&nbsp;URLAPIAdd&nbsp;=
&nbsp;&nbsp;URLRoot()&nbsp;&amp;&nbsp;"db/"&nbsp;&amp;&nbsp;Dbid()&nbsp;&amp;&nbsp;"?a=API_AddRecord&amp;AppToken="&nbsp;&amp;&nbsp;&nbsp;&nbsp;$Token&nbsp;&amp;&nbsp;&nbsp;&nbsp;"&amp;_fid_XX="&nbsp;&amp;&nbsp;URLEncode&nbsp;([Record&nbsp;ID#]) &amp;&nbsp;&nbsp;&nbsp;"&amp;_fid_XY="&nbsp;&amp;&nbsp;URLEncode&nbsp;([XY])&amp;&nbsp;&nbsp;&nbsp;"&amp;_fid_XZ="&nbsp;&amp;&nbsp;URLEncode&nbsp;([XZ]);and so on// Logicvar text URLRun = If (&nbsp; &nbsp; &nbsp; &nbsp; [Rule One]= True, $URLOne,&nbsp; &nbsp; &nbsp; &nbsp; [Rule Two]= True, $URLTwo,&nbsp; &nbsp; &nbsp; and so on&nbsp; )// UI

&lt;a&nbsp;href=\"javascript:"&nbsp;&amp;&nbsp;"$.get('"&nbsp;&amp;&nbsp;$URLRun&nbsp;&nbsp;&amp;&nbsp;"',&nbsp;function(){"&nbsp;&amp;&nbsp;"location.reload();"&nbsp;&amp;&nbsp;"});"&nbsp;&amp;&nbsp;"void(0);\"&gt;"&nbsp;&amp;&nbsp;$IMGButton&nbsp;&amp;&nbsp;"&lt;/a&gt;"

------------------------------Don LarsonPaasporterWestlake OH------------------------------

markshnier__you · Answer

Can you explain what you mean by "a block of code".. if you mean run successive API calls, then yes its possible. Or is this javascript? and is the trigger to push a button?

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

paulpeterson1 · Answer

I'm trying to update multiple fields inside of an If statement.------------------------------Paul Peterson------------------------------

markshnier__you · Answer

Can you say in words an example of the logic and I can suggest the code syntax for a URL formula button.

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

paulpeterson1 · Answer

One of the situations I am working with involves changing the text in a status field and adding a date in a related field when a condition in another field is met.------------------------------Paul Peterson------------------------------

Forum Discussion

Execute a block of code in an IF Statement

Related Content

Dynamic Rule - Or statement?

Jinja If statement equals field value

formula help "if statement"

IF Statement based on a file being attached

IF statement changing numeric to text