do we have for loop in native quickbase
Hi Is it possible to write for loop in formula text column? Thanks Pushpakumar ------------------------------ Pushpakumar Gnanadurai ------------------------------
Forum Discussion
Hi Pushpakumar,
What do you mean by putting a loop in a formula text field? What are you trying to accomplish and what kind of calculation are you trying to do?
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
What do you mean by putting a loop in a formula text field? What are you trying to accomplish and what kind of calculation are you trying to do?
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
- Hi Evan,
Basically , i have a string and i need to write to four variables
For example , String="N|LT|01|2021,02,25 ; N|NLT|01|2021,02,25 ; Y|LT|01|2021,02,25 ; Y|LT|02|2022,02,25 ; Y|LT|03|2023,02,25 ; Y|NLT|04|2019,02,23 ;"
N_LT = "N|LT|01|2021,02,25 ;"
N_NLT="N|NLT|01|2021,02,25 ;"
Y_LT="Y|LT|01|2021,02,25 ; Y|LT|02|2022,02,25 ; Y|LT|03|2023,02,25 ;"
Y_NLT="Y|NLT|04|2019,02,23 ;"
Basically i am looking for "for" loop which will traverse the string one by one based on delimiter and check the first and second parameter and put that in the respective string.
can you please provide me some suggestions.
Thanks
------------------------------
Pushpakumar Gnanadurai
------------------------------- Pushpakumar,
I am assuming you have a field of data that you want to become four new fields. If the user or some other source populates the first field, then individual formulas in four other fields can each evaluate the first field.
If your source is
[Source]="1,2,3,4"
Each individual field is defined:
[Field One]= Left([Source],1) Which would return "1"
[Field Two]= Left([Source],"'") Which would return "2"
[Field Three]= Left([Field Two],"'") Which would return "3"
[Field Four]= Right([Source],1) Which would return "4"
The way you are parse, trim and cut up your source depends on the source format. There is no way to natively write a single loop that will populate the four new fields.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------- thanks a lot for the reply. I will try and get back to you in case of any queries.
Thanks
------------------------------
Pushpakumar Gnanadurai
------------------------------
