Newby - Using Excel on Google drive for user data Entry (large amounts of Purchase order PO data)

[tom_vouk]

Hi,

I’m new to Appsheet and been playing around with the app a while and also browsing help, forums and videos.

I’ve split out PO history sheets and have them “live” separately on Google drive (shared) - one is called Current year and the other one Previous year. The users would periodically update the content with the data from their ERP system and I’d like to have this synced to specific table in my App and display it there.

Is there a way for a user to paste data directly into the app somehow using pre-determined columns and cell formatting structure?

Ideally they could even edit specific fields in the App directly.

Whatever I do, I can’t seem to find a way to bring these 2 external sheets to the app and have them synced every time I change something either in the app fields or in the actual sheet on google drive.

Also, in the app view/edit mode for the user, can you actually display in the same way as in Excel, i.e. columns in the top row and below the actual data with their ability to filter and/or sort on specific columns?

What am I missing here? Thanks in advance for any pointers.

Regards,

Tom