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

7 Replies

Related Content

IF Statement based on a file being attached

Total Formula with 2 IF statements

Error - Invalid record data provided when executing form rules

Jinja If else statement syntax

If statement with multiple conditions

Recent Discussions

Save & Redirect in a Formula URL Using API_GenAddRecordForm

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API