Mass Data Upload on the user side

[Olivier]

Hi,

I am trying to build an accounting app using Appsheet. To do this, my end users will have to input accounting entries into the application.

Each accounting entry has several fields (date, comment, amount) … and I would like to know if there is a functionnality in appsheet for uploading data from csv / xls from the end-user side ? If yes, I could ask my users to upload directly their bank statement in a proper csv/xls format.

Help, anyone ?

Thanks in advance !

[LeventK · Accepted solution]

Yes it’s possible with CSV. Please read this:

Import data from CSV Tips & Tricks 💡

I conducted quick testing for New Action of “Import CSV file” as it seems to be functional right now. [image] I save the CSV file (made out of Excel) and saved to local. This CSV have first row with exactly same names of column against the target table This is observation so far. Add new row It works. Make sure to add “unique value explicitly” on the csv file otherwise this action wont add new rows (for rows missing the key value) Even we have initial value set and leaving the value in…

[Olivier]

Thanks !! I believe that it answers the question. A l’attaque !