Auto regenerate structure

AppSheet AppSheet Q&A
,
1

Hello,

I created an app sheet for my google sheet. I have an apps script that would automatically generate a new column every month. For example in the image below the apps script generated Aug’23 column and will generate a Sep’23 column next month. However I have to manually regenerate the structure in the app sheet after a new column is generated in the google spreadsheet. Is there a way I can automate the regeneration of the structure in the app sheet?

akash54321_0-1690909078626.png
akash54321_0-1690909078626.png659×170 3.89 KB

Thanks

2

Unfortunately there is no way to do that. Why don’t you add two columns for the month & year so this would not be needed?

3

Thanks for the reply. I was thinking if there was someway to do this before I try another solution.

4

You’re welcome