API Calls as a solution to the Filter/Search problem of Big Tables? - Price Issue

Hi @Darren_Murphy ,

One possible issue I can see is, My tables rows are not defined. it can keep increasing over period of time. So we cannot add it dynamically right?

I mean ill have to keep creating joined list as rows increase?

Please correct me if I am wrong?

Is there no way a JS can give me the combined array of all rows?

Regards,
Dilip

Why would you need to do that?
A Joined List is a computed column, it will operate on all rows that are present.

Hi @Darren_Murphy
I understanding creating a Joined List of all Row-ID.

I could do it where it gives me dynamically list of all Row-ID’s present in the table.

How can I get the Values inside them? Is there a way I can apply Java script on this Row-ID’s to get it?

I cannot do a joined List of my API mutation column which is a template column. Again it will lead me to warning saying only 100 rows can be used.

Trying to create a Joined List of my template column or JS out put column gives me this error

Screenshot 2024-09-06 at 11.11.29 AM

it says computed column not supported
Regards,
Dilip

@Darren_Murphy ,

I think I get what you are saying. Create a joined list for each of the values I need to send and combine them such that it comes well within 3 parameters to be sent to JS.

Is this an approach I can take? Wont it create latency ?

Main reason for using big table

Is to get filtered list of people to be sent via API.

Do you think I can instead keep two tables one Big table and one normal glide table.

?

Which approach would you suggest?

Regards,
Dilip

How can I do this @Darren_Murphy ?

Regards,
Dilip

Create multiple Joined List columns, and then combine them using a template column with a different separator. I usually use a double-pipe ||, as it’s pretty rare that you would have that in your data. You’ll then have a Joined List of Joined Lists, with the outer list separated by double-pipe, and the inner lists separated by commas.

1 Like