PrashantMaheshw
Qrew Assistant Captain
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Pipelines and appending / joining
We recently solved something like this when a.$prev didn't work for us. In our case Existing field was getting update via incoming webhook Step 1 , Receive webhook Step 2 , Receive the value of existing value (which is what I am detailing here) Step 3 , Join existing value and webhook value First do a query on https://api.quickbase.com/v1/records/query In my scenario it looked like below { "from": "{{a.body_params.parentid}}", --> tableid "select": ["{{a.body_params.fid}}"], --> fid of record you want "where": "{3.EX.{{a.body_params.recordid}}}" }. --> Query you This will allow you to 'get' the value of the existing field first. This was stored inside for me {b.json.data[0]} Then another query doing make request and append value. Hope this makes sense As for your actual join , you can trying using ~ to concat like {{ (a.firstname) ~ ' ' ~ (a.lastname) }}Re: Custom GPT: Quickbase Formula Builder - Version of ChatGPT Optimized for Writing QuickBase Formulas
I don't mind exploring this together if you have time to hop on to Zoom. Or maybe you can train it to avoid python function which it suggests a lot . For example I asked it to generate random number which is not a feature. To generate a random number between 1 and 100 in Quickbase, you can use the Rand() function, which generates a random decimal number between 0 and 1. To scale this to the desired range of 1 to 100, you multiply the result by 99 (the range of numbers you want, which is 100 - 1), then add 1 to shift the range from 0-99 to 1-100. Finally, you should use the Int() function to convert the resulting decimal number to an integer. ------------------------------ Prashant Maheshwari ------------------------------Re: Pipeline Looping Through an Array
OK , I understand some part now . So let's walk through high logic , my assumption is Array variable is supplied once Record id is supplied once If below works you can supply xyz = a.j_classification {% set xyz = '538;923;239;248;492;964;082;943' %} {% set values = xyz.split(';') %} --> We split your array {% for value in values %} -> For each value we now loop through them {% if value == a.id %} -> We check each value for record.id which I assume is in a.id but you can supply anything Do something {% endif %} {%endfor %} ------------------------------ Prashant Maheshwari ------------------------------Re: Pipeline Looping Through an Array
I am still confused by "Loop through the first half of a text field containing many numbers separated by ";" . In string already without the text component "538 923 239 248 492 964 082 943" ?? Should we assume we are doing a nested lookup? ------------------------------ Prashant Maheshwari ------------------------------Re: Pipeline Looping Through an Array
Can you post some sample data ? I visualize you've something like ABC123 , you want to split it down the middle into ABC and 123 and then compare 123 to the record id of the record ? it can ABCDE12345, will it always be half the length ? never ABC13245 , since [Record ID#] keeps growing ------------------------------ Prashant Maheshwari ------------------------------
