Appending a Column to a Webform
I have the following requirements:
- Given a Domo Web Form where users add Data to a Dataset.
- I would like to pull the dataset, add an additional column and modify it based on the data.
- Replace the webform.
Is this possible via the API (or otherwise)?
Best Answer
-
What's your use case? Do you just want to make it easier for other users to update data and change columns easily for data that's used in Domo?
I think the API should be able to handle that.
On the other hand, the Excel plugin can do the same: export datasets to Excel, edit data and schemas, and reupload to Domo.
You could probably do the same with a Google doc spreadsheet using the Domo Google Sheets connector, as long as that's compliant with your corporate policy.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
Thanks for the reply.
We have a use-case where the user inputs their own customer segmentation; thus the customer segmentation would therefore need to be appended to the other datasets.
The solutions you proposed are interesting, particularly with the Excel plugin. We'll try them out.
Thanks
0 -
We have a few places in our instance where our sales and marketing department needs similar interaction. We gave them spreadsheets in a Windows folder that they're able to edit on their own, and we have Domo Workbench retrieving those files on a regular schedule.
In other cases, we have loaded spreadsheets using the Excel connector in Domo, and users just update and reload those whenever they need changes made.
We also have one or two Domo webforms that users can update whenever they need.
Now that I think about it, I should work on making that a more unified approach, but you can see that there are a variety of methods to accomplish what you're looking for.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 479 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 49 Visualize
- 202 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 37 Product Ideas
- 1.1K Ideas Exchange
- 2 Community Forums
- 15 Getting Started
- 2 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 579 日本支部