Doesn't write on my Google Sheet

[ledafyomi]

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

[Jeff_Hager]

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.

[ledafyomi]

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 ?

[Jeff_Hager]

Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet

I can’t take credit for this tip but I just found out about this trick/tip by reading a post here. So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l…

Issue With Google Sheets

My app’s URL: https://shalomorocco.glideapp.io I created an application with glide and did some testing yesterday and it worked well. Today, when I fill out my form via the application, the data is not synchronized on google sheets. I see them on the data menu of the application but not on Google Sheets Anyone can help me please ?

Form data not showing in Google Sheet

Thanks, yes, it is right at the bottom of the sheet (row 22545)

Glide app is not updating google sheets

My app’s URL: https://kbik2020.glideapp.io The app is private. But I noticed for the past several weeks, the glide app has not been syncing the data for a few sheets with Google sheets. If I add data to the sheet from Google sheets webpage, the app is updated just fine. But if I create a new record inside the glide app I created, the new record just stays inside of Glide instead of being sync with Google sheets. [app]

Date format

I would like choose date format from glide, because then I add a record in Google sheet change date format.

Arrayformula?

Good Morning could someone help me on an arrayformula to get the amount of product and its value and give the total to pay [array]

[ledafyomi]

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