Add 60 multiple rows with dates (today + monthly additions)

Ask for Help
1

Hello Gliders. I’m watching this great video on multiple row adding with API:
:mortar_board: Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)https://youtu.be/b7_k3_brusQ?si=Q1m6cNPjbMURdCTR. Clear enough (for now) and I intend to do this.

But the rows I’m adding will have a date column. The first row can be today, and each row after should be +1 month. How to do?

Thank you as always

2

I think your best bet would be using Make, with their Repeater module to repeat 60 times.

Use the addDays function in tandem with the repeater index to add the correct amount of days for each time you add a row to Glide.

3

Thanks for this. I ended up using the API method to bulk add rows, and included an index number in the bulk-add as well as a date added, then in the destination table it was easy to use math column to add a month based on the index number. It’s not flexible (i.e. can only add set number of rows) but it is contained within glide at least and for my purpose users can easily delete rows in the data table collection so having extra from the bulk add is ok

1 Like
4

That’s also a great way to do it!

5

Hmm maybe not. Just noticed I’m stuck in the problem of adding days to get to the next month and Feb being too short. Here’s where I am:

  1. API template adds with start date (could be any month / year), also adds index 1-48 (total number rows)
  2. Destination then finds first day of month and then Math (firstdayofmonthcolumn+(30*index)
  3. Of course this skips Feb
  4. It would seem easier in my case to find the last day of the month and add 1 day. Is this possible?
    @Darren_Murphy I noticed your formula below, is there a way to adjust this so that I can use the index number to add x number of months?

((Now-DAY(Now)+15)+60)

DAY((Now-DAY(Now)+15)+60)

6

Adding months is a bit tricky. Check the below thread for a couple of options:

1 Like
7

Exactly what I needed - thanks for the rapid response and super helpful reference guide!!

1 Like
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.