# Is there a way I can add blank rows to a data grid? **URL:** \ **Category:** Ask for Help\ **Created:** [August 21, 2024, 12:40pm UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764 "2024-08-21T12:40:17Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 21, 2024, 12:40pm UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/1 "2024-08-21T12:40:17Z")
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 ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 21, 2024, 1:07pm UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/2 "2024-08-21T13:07:35Z")
Can I make use of java script to make this work? Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 21, 2024, 2:51pm UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/3 "2024-08-21T14:51:53Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 22, 2024, 12:49am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/4 "2024-08-22T00:49:24Z")
Why do you need blank rows? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 22, 2024, 1:01am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/5 "2024-08-22T01:01:10Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 22, 2024, 1:07am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/6 "2024-08-22T01:07:21Z")
I would rather creating a flow to upload a CSV and then using Make to add those to your table with Glide API. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 22, 2024, 1:09am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/7 "2024-08-22T01:09:56Z")
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 ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 22, 2024, 7:02am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/8 "2024-08-22T07:02:42Z")
@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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 22, 2024, 8:05am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/9 "2024-08-22T08:05:00Z")
> [@Dilip\_Adiga](#): > > 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? It is a known behaviour, it’s not guaranteed at all to be in the same order. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 22, 2024, 8:16am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/10 "2024-08-22T08:16:20Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 22, 2024, 8:20am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/11 "2024-08-22T08:20:29Z")
Is ordering critical to your app? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 22, 2024, 8:22am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/12 "2024-08-22T08:22:34Z")
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 ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 22, 2024, 9:58am UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/13 "2024-08-22T09:58:25Z")
@ThinhDinh Zapier and web hook combo just eats up your updates like in a jiffy LOL! They are quite fast in eating up quota 😂 If I have too many rows then it might become an issue right ? Regards, Dilip ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 22, 2024, 2:40pm UTC](https://community.glideapps.com/t/is-there-a-way-i-can-add-blank-rows-to-a-data-grid/75764/14 "2024-08-22T14:40:51Z")
Yeah, because for every row you add, that counts as an update.