-
Looping through an array and add to a record with an array field
I have a table called "Sales documents", which has an array of "Sales document lines" ids. On the frontend, I am able to get the sales line items and then create a variable called "list-ids-only", which returns the following ids (dynamic depending on what the user entered): I then run a for loop to loop through the sales…
-
Getting the error; Please use a numerically indexed array.
I've created a 'for each' loop to change the format of my timestamp. However, when I run it, I receive the error message 'Please use a numerically indexed array.' Does anyone know what I'm doing wrong?
-
How to change fields in an object with for each loop and conditional if?
Hi, I want to loop through the fields in an object and set fields with a null value to contain the string "empty" instead. I'm trying to do it like this: But when I hit the stop and debug, all the null fields in the object are still null. What am I doing wrong here? Thanks in advance.
-
I'm looking to hire Xano expert who can help with Data manipulation using Arrays and Loops.
I'm working on building a database that would serve as a Corpus for my Arabic classes. It would be a relational database for which I create the structure myself in Airtable and then import it into Xano. The main things I need help with is Data manipulation using arrays and loops, since I need to generate new words from…
-
LOOM VIDEO: HELP! 3rd party API Loop Write to Database
Hi, I have a simple API request that uses a FOR LOOP to iterate through an array of inputs coming from another table named MATRIX 1) MATRIX table is what I am using as the basis for INPUTS into an API request at Apify.com a web scraping API. 2) COUNTS table where I want to write the results of the API query I am having…
-
For each loop not processing everything (bug?)
Hello, so I have a relatively simple task to reset the daily statistics for users, using a "task" to do it and it was working well, but now there is about 3.5K of rows to edit and the loop is not processing everything. Strangest part, and why I think it is a bug is that, it does not result in an error, but it does not…
-
Reference variable in a variable?
Hi, I'm using a loop to manipulate an object. I need each loop to use a succesive element in my JSON data. For example: Loop 0 —> user.preference.0 Loop 1 —> user.preference.1 Loop 2 —> user.preference.2 Initially I thought I could simply use the loop's "index" variable (which tracks the loop's current iteration number) in…
-
If loop B is inside of loop A, a "Break out of a loop" function in loop B will break out of loop A?
Hi, If loop B is inside of loop A, a "Break out of a loop" function in loop B will break out of loop A as well or only break out of loop B? Thanks!
-
Help! I've hit a brick wall with a bulk update function
Hi. I am completely new to xano and I'm struggling to understand it. I was using adalo for an MVP build but hit a wall because the database functionality in adalo didn't support bulk updates. So I'm hoping I can achieve what I want to do in Xano. My app is essentially a to-do list that will break down a big goal (or…
-
From a list of 1000 items, run a loop in batches of 100
Hello, I have a list of 1000 items and I have to run some functions for each one of them (on a loop) and finally upload all of them to an external database through an external api call. The problem is this external database only allows to upload 100 items per api call so I can't wait until the 1000 loops are done and them…