# Adding Data via Temp Table **URL:** \ **Category:** Ask for Help\ **Created:** [April 17, 2024, 3:04pm UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656 "2024-04-17T15:04:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Hunter\_Thompson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hunter_thompson/32/73746_2.png) [@Hunter\_Thompson](https://community.glideapps.com/u/Hunter_Thompson)\ **Post date:** [April 17, 2024, 3:04pm UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656/1 "2024-04-17T15:04:48Z")
Hi everyone, Fairly new to Glide, I’m interested in recreating a system I’m using in [Coda.io](http://Coda.io). Any help or advice would be appreciated. In [Coda.io](http://Coda.io) I have teachers selecting a few values, such as ‘Course Name’, ‘Date’, and ‘Crew Name’ then pressing a ‘populate’ button. The populate button adds rows to a temporary table, and sets the values marked by the teacher. Additionally, the ‘Crew Name’ is pulling all the students from a separate database who have a matching ‘Crew Name’ and creating a row for each of them. This temporary table is used by teachers to update information like ‘Attendance’ about each student and the ‘Submit’ button publishes the information into a main database. After submission, the temporary table values are deleted. I’ve attached a few screenshots from Coda, thoughts? **Before Populate** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/1227a833cdf68a2beab0059714309428689965ba.png) **After Populate** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/404087b715e1de88ccf6c6c4a1415ce8bacaba1b.png) ---
**Author:** ![Hunter\_Thompson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hunter_thompson/32/73746_2.png) [@Hunter\_Thompson](https://community.glideapps.com/u/Hunter_Thompson)\ **Post date:** [April 17, 2024, 3:06pm UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656/2 "2024-04-17T15:06:25Z")
Here are examples of the code I’m using in each button with [Coda.io](http://Coda.io) **[Coda.io](http://Coda.io) ‘Populate’ Button Code** `StudentCrewX.Filter(CrewName=[CrewSelect 3]).FormulaMap(AddRow(TonyStudentDailyScoresX,TonyStudentDailyScoresX.StudentName,[Student Name],TonyStudentDailyScoresX.Crew,[CrewSelect 3],TonyStudentDailyScoresX.[Class Name],[ClassSelect 3],TonyStudentDailyScoresX.[Instructor Name],[InstructorSelect 4],TonyStudentDailyScoresX.Term,TonyTermSelect,TonyStudentDailyScoresX.Date,[date 2]))` ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 17, 2024, 3:43pm UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656/3 "2024-04-17T15:43:19Z")
Two questions: - is the number of rows to be added fixed, or variable? - which team plan do you have? ---
**Author:** ![Hunter\_Thompson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hunter_thompson/32/73746_2.png) [@Hunter\_Thompson](https://community.glideapps.com/u/Hunter_Thompson)\ **Post date:** [April 19, 2024, 1:53am UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656/4 "2024-04-19T01:53:19Z")
Hey Darren, thanks for the response. Number of rows would be dependent on the number of students with an assigned ‘Crew Name’, this number should be fixed, but may change over the course of a semester. I’m on the Maker Plan currently, open to changing plans if necessary. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 19, 2024, 3:15am UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656/5 "2024-04-19T03:15:16Z")
Okay. So unless the number of rows to be added is fixed in the sense that it can be “hard coded”, then the only (current) way to add several rows at once is via the Glide API. So you would need either a Team, Business or Enterprise Plan. The general approach is to use a multiple row Helper Table to prepare the data, then send a webhook to a tool such a Make or Zapier with a data payload, then insert the rows into Glide via the API. It’s a little convoluted, but until such time as Glide give us the ability to perform iterative actions, it’s the best option available. ---
**Author:** ![Hunter\_Thompson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hunter_thompson/32/73746_2.png) [@Hunter\_Thompson](https://community.glideapps.com/u/Hunter_Thompson)\ **Post date:** [April 22, 2024, 12:08am UTC](https://community.glideapps.com/t/adding-data-via-temp-table/72656/6 "2024-04-22T00:08:53Z")
Hi Darren, Thanks for your answer! If I’m understanding you correctly – I’ll have to use a fixed number of rows pulled into a Helper Table using a button, then to submit the information, I’ll use a Make button trigger to add the data via the API. Can you point me in a direction on how to configure the initial helper table button to call the fixed row data?