I use an Action to download the CSV. The CSV is seperated by comma. But I need it to be seperated by semicolon.
And I need to give it a name: Booking.csv
Is this possible?
Background: I’m working on a Timesheet App. I want to export the CSV and import it into the Software my client is using.
It needs to be named as Booking.csv and to be seperated by semicolon.
Hi,
CSV stands for comma separated values. You can create a quick program in R, Python, or some other language to swap these out for you and then push them into the other software.
CSV can also stand for character-separated-value.
Is your data stored in Google Sheets or in a SQL server?
Either way, this is certainly something you could achieve in the backend either with google scripts or a scheduled report in sql server. Unsure if you could do this directly in appsheet, I have never tried.
Thank you for that hint. Yes it’s a MySQL Database.