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?
Comments
-
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.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
Another option would be to keep the file in a cloud service such as one drive, google drive, dropbox, etc. Domo has pre-built connectors to these services and you could schedule how often the dataset should look at the file for updates. Sharing this file with the user would allow them to edit the file accordingly and the changes update in Domo as well.
-----------------
Chris1 -
Hello,
There wouldn't be a way to update the File Upload dataset directly with the Webform Connector.
You would be able to do this by using a DataFlow and joining the Webform Data onto the File Upload Data. This would allow the data to update every time the customer added new data to the Webform.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive