Is there a way to add rows to a dataset while in Domo where the dataset was a file upload?
I have a file I want to upload using the file upload connector. I will be turning the dataset over to one of the users and want to allow him to edit the dataset as a webform. He will have to add and delete rows and edit rows as necessary. I want to make it as simple as I can for him. Most of the time he will only have to update one cell or row at a time so I don't want to have him need to upload a file everytime to update the data. Is there a way to do this?
Re: Is there a way to add rows to a dataset while in Domo where the dataset was a file upload?
How large is the spreadsheet? Can you just copy and paste the rows from Excel straight into a new Domo Webform? I've done it for a limited amount of rows and it went "ok" but if you're making this post I'll assume it means you have an amount that makes that not feasible as the Chrome tab will hang and not really do anything.
This option might not work for you as it's more involved but you might be able to create the dataset in Domo as a Webform then create a Script in your programming language of choice to take the spreadsheet and update the webform. Definitely more work on your end.