Create bulk multiple rows from the csv file

Ask for Help
1

Hello, for an event management app, how can l set up the functionality where a user upload a excel document of events using file picker and have the multiple events displayed on the event table?

2

I don’t think that’s possible. It’s been a feature request for a while.

If you want to upload a CSV file of events, it would have to be done by you or an editor of the app directly in the data editor.

3
2 Likes
4

I didn’t have that on my radar. Bookmarked.

5

We first developed techniques for doing this about 2-3 years ago :wink:

6

Oh gosh. I tend to ignore setups that are not native features and what I’d consider hacky or convoluted. My tolerance level for “hacky” is low :sweat_smile:

I just watched Bob’s video. I almost feel I little dizzy. I suppose it’s possible for users to import a CSV from inside the app, but it’s complicated to set up. Most people cannot set this up without a manual or Bob’s video.

The setup is impressive though, I hope I force myself to try it one day just for the thrill of it.

1 Like
7

“When does it make sense to set up an automation to allow users to upload a CSV file inside the app and when does it make more sense to do it manually?”

I’ve been thinking about this question this morning. I think it boils down to answering the following questions:

  1. How often does the CSV upload need to happen? (task frequency)
  2. Is the CSV upload time-sensitive? (does it need to happen in that moment or can it wait to be done manually)
  3. To what extent is cost a factor? Would an automation be set up even if it cost more in time and money than doing things manually, due to point 2 about for instance?
  4. Uploading a CSV is good for bulk uploads. How do you define “bulk” in your situation? When is it acceptable to simply fill out a form one event at a time?

@Teejay_Oyeniran

1 Like
8

I’ve never had a real world need for this. I originally created a concept App that does this back in 2023 because I enjoy the challenge, and I wanted to prove to myself that it could be done. I haven’t watched Bob’s video, but I imagine his technique is probably similar to the one I used, except that I was using the V1 API back then. I also used Make because we didn’t have the Call API action.

Here is a video I made at the time to describe it:

https://www.loom.com/share/aa950af4901b4b3b8b9ccdda8aa591e0

Note: I wouldn’t recommend using my technique now, as we have better methods available.

3 Likes
9

I watched your video. Very nice.

10

Nice, Thank you for your input.