Is It Possible to write while or for loop in formula field? If possible ple explain with example.Thanks

No, at least not with native Quick Base. It is more like Excel in that regard where there are formulas in fields However, if you know JavaScript, then you can write code pages which can have programs.

Thanks , I know JavaScript,How to call this code pages?

You can use IOL technique to implement this on the form.Thanks,Gaurav

A link or further clarification would be helpful. Googling your answer leads to a certain type of eye surgery.

You can't write a loop in the formula language. While you can write all sorts of loops and recursive procedures in JavaScript I have to ask what are you trying to accomplish?

Is It Possible to write while or for loop in formula field?

13 Replies

QuickBaseCoachD
Qrew Captain
6 years ago
No, at least not with native Quick Base. It is more like Excel in that regard where there are formulas in fields

However, if you know JavaScript, then you can write code pages which can have programs.
AnvikaReddy
Qrew Trainee
6 years ago
Thanks ,
I know JavaScript,How to call this code pages?
- GauravSharma3
  Qrew Commander
  6 years ago
  You can use IOL technique to implement this on the form.
  
  Thanks,
  Gaurav
- LanePemberton
  Qrew Cadet
  6 years ago
  A link or further clarification would be helpful. Googling your answer leads to a certain type of eye surgery.
- ScottMarks
  Qrew Member
  6 years ago
  Original post by Dandiebolt: https://community.quickbase.com/quickbase/topics/how-do-i-setup-the-image-onload-technique-iol
_anomDiebolt_
Qrew Elite
6 years ago
You can't write a loop in the formula language. While you can write all sorts of loops and recursive procedures in JavaScript I have to ask what are you trying to accomplish?
_anomDiebolt_
Qrew Elite
6 years ago
>Is it Possible to call JavaScript With out using IOL technique?

All other techniques are largely just going to be variants of the IOL technique. Why not just use the accepted method which is adequately documented and for which there are 100s of public solutions available in the Pastie Database? I somehow sense that you are reluctant to try the IOL technique - just take the plunge and you will be pleased with the result.
EOMDevelepors
Qrew Captain
6 years ago
How do I loop to lookup the next record that exists with one lower number of the record I am currently on.

I have a key field call ID but sometimes it can skip a number since the table is being imported from a SQL server.

I want to lookup the last call ID before the current one and it should subtract 1 until it finds a record with that Call ID.
- ZalmenFreund
  Qrew Member
  6 months ago
  Going back to this thread. Is there a way to loop or for each in a formula column?
  
  I'm looking to add in a Rich Text formula column, hyperlinks for each value in a multi select column or for each record in the child table.
  
  ------------------------------
  QuickBase 96
  ------------------------------
  - MarkShnier__You
    Qrew Champion
    6 months ago
    No problem
    
    just make your perfect hyperlink on the child table as a rich formula field, and then roll it up to the parent as a combined tech summary field.
    
    then on the parent, make a formula Rich Text field which will convert the Combined Text summary to text and replace the semi colon delimiters with a <br> character to give a nice vertical list
    
    not tested but try
    
    SearchAndReplace(
    
    ToText([My combined text hyperlinks]),
    " ; ", "<br>")
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------