Is there a way I can add blank rows to a data grid?

Hi Guys,

I am using a data grid in my app, Is there a way I can add blank rows to my data grid?

I would need to copy paste values to it later once blank rows are added

Question1: Can I do it using Add button?
Question 2 : Can I do it if there is relation which is configured to add button
Question 3: Can I give an input saying 20 rows and click add such that it creates 20 rows?

thank you in advance

Regards,
Dilip

Can I make use of java script to make this work?

Regards,
Dilip

Hi guys,

Let me know if there is a solution for this flow

When I click on add —> pop up appears where I give number of blank rows I need

It should create those many extra rows

Would this be possible with javascript

Scenario 1 : if add is based on relation
Scenario 2: add is to add data to table

What would be the javascript I can use ?

Thank you in advance

Regards,
Dilip

Why do you need blank rows?

Thank you for responding @ThinhDinh

Basically I have a List of creators I send to my client as a part of my pre campaign prep

Meaning I have a list of table which has more than 1000 creators I work with.

Every client I work with will have a pipeline created in my system

Each pipeline will have a thing called community List where our team will add values into.

Having a form approach is not a good experience because most of the times there will be more than 100 creators that have to be added (Even search and add wouldn’t be preferred)

They prefer copying names in build and and pasting it

**My team will use the main creators sheet → Copy all the names that are relevant and want to paste it in the pipeline (Space where I want to show this blank data grid I create) **

Meaning In pipeline lets say I want to add 100 Creators → I want an option to be able to create 100 rows → using JS → then My team can copy all relevant 100 names and paste it in this blank rows created just now

PS: The blank rows would need to be created on a relation as pipeline and creators to be added to pipeline are in separate table and linked via relationship column in pipeline table.

Sounds complicated but solves lot of issues for my team is what they are saying.

Can this be done? or is there a better approach?

Regards,
Dilip

I would rather creating a flow to upload a CSV and then using Make to add those to your table with Glide API.

Thank you for replying @ThinhDinh

Want to remove dependency on excel and keep everything in one system

Are you suggesting a flow where they list all creators of interest in glide and then download it as CSV —> then upload it via Zapier?

Can I filter elements and download only filtered elements as CSV ?

What happens if I need to add more elements ? Can I still keep the existing ones ? and add on top of this?

Also I can make use of Zapier too for this right ?

Regards,
Dilip

@ThinhDinh I tried doing it via Zapier and uploaded a file and then used web hook to Write names into different rows

Observation

The rows are sent in some random order they are not sent in the order that is there in CSV,

Any particular reason os is there a way I can streamline it?

Regards,
Dilip

It is a known behaviour, it’s not guaranteed at all to be in the same order.

Ah ok.

@ThinhDinh thank you for your reply.

I am now confused as to what to do.

Btw can I still create empty rows using JS by specifying a number?

Regards,
Dilip

Is ordering critical to your app?

yeah in a way it matters.

that’s why I was thinking if there was a way I can create the number of Rows using JS

I can ask them to copy paste the names from their source.

Avoids lot of complications designing a flow?

Regards,
Dilip

@ThinhDinh

Zapier and web hook combo just eats up your updates like in a jiffy LOL!

They are quite fast in eating up quota :joy:

If I have too many rows then it might become an issue right ?

Regards,
Dilip

Yeah, because for every row you add, that counts as an update.