Hi @Darren_Murphy , Isn’t the miracle method bit of an issue in terms of feasibility ? I might be getting in new row added every minute. how do we handle it then? This way whatever blank row I create will run off very soon right ? Regards, Dilip

[image] Dilip_Adiga: Isn’t the miracle method bit of an issue in terms of feasibility ? I might be getting in new row added every minute. how do we handle it then? This way whatever blank row I create will run off very soon right ? I don’t really know what you mean. There may be situations…

Hi @Darren_Murphy Thank you for replying. Scenario We are making an API call, There maybe N number of elements in the array right ? We may never really know how many rows should be there in helper table. As and when the API keeps getting called new rows have to be created without knowing which mi…

I’ve split this into a separate topic. Why can’t you just add more rows than you are likely to need? There is no reason why you can’t add 1000 rows (or more) to a helper table.

Thank you @Darren_Murphy for creating a seperate thread, Was just about to ask you. [image] Darren_Murphy: Why can’t you just add more rows than you are likely to need? There is no reason why you can’t add 1000 rows (or more) to a helper table. I can add rows, But what if I am getting like …

I think I need to understand your use case better before I can make any further comment. What are you actually doing with this data?

My use case is as follows. I have a 3rd party which does reporting for me, it gives me campaign stats, Sentimental analysis (It reads comments on my posts and gives me sentimental analysis) I have a list of campaigns, I am calling an API every day morning to fetch the JSON in which there will be a…

[image] Dilip_Adiga: But Using the miracle method I can write each item of array into a seperate row right ? But for that I would have to keep adding extra rows in the table so that they keep getting written to inidivudal rows rather than everything in single cell The idea with a Helper Tabl…

Hi @Darren_Murphy , Thank you for your reply. Are you proposing to do something like this ? [🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)] Where I store responses of all campaigns in mutations and then make use of it and write in separate rows? ill give it a try …

Yes. The idea is to have a fixed number of rows in your helper table, and you use the same rows over and over again as a staging area for adding rows to some other table.

Hi @Darren_Murphy , Correct me if I am wrong In following these steps I have list of campaigns → Against each campaign column I have the response that comes from the API it will have the JSON What I should do Create the joined List of all the response of call campaigns separated by comma Put it…

Dynamic row count in Helper Table for Miracle method

Ask for Help

Darren_Murphy November 1, 2024, 1:28am 16

Yes, perhaps. Or you could use something outside of Glide such as Make or Apps Script.

I can’t think of a way off the top of my head.

Topic		Replies	Views
Add Row - Capture Data from Multiple Rows Ask for Help	23	3073	January 17, 2024
API Calls as a solution to the Filter/Search problem of Big Tables? - Price Issue Ask for Help	25	780	September 6, 2024
How to make loops of rows and repeat them dynamic number of times Community Resources tutorial	26	3177	July 14, 2023
Creation of multiple rows dynamically Ask for Help	31	3816	January 18, 2022
Add Row from ChatGPT Table Ask for Help	12	834	March 19, 2024

Dynamic row count in Helper Table for Miracle method

Related topics