Doesn't write on my Google Sheet

Hi,
I created an app → https://fsx7o.glideapp.io and I am asking any user to add something via the + button.
I runed several tests : I can add things and it edit the data on Glide but it edits nothing on the Sheet?
Why is that ?
Here is a link to the sheet → https://docs.google.com/spreadsheets/d/1fwbCX3QdAJScoWrzMm1AWPD4eJL3KpELynkXUPh2HD0/edit?usp=sharing
Thanks,
Dan

Scroll down to the bottom of the sheet. The record is there.

You populated all of your rows with formulas. New records from Glide will not touch these existing rows. You need to switch your formulas to Arrayformulas and then delete any empty rows. Then everything will work.

Thank you @Jeff_Hager… but how to “switch your formulas to Arrayformulas and then delete any empty rows” ? Can you show me how to do this ?

1 Like

All clear ! I made it work thanks to the community.
Thanks a lot,
Dan

1 Like