Webform refresh
Hello,
I have a dataset embedded into a webform. So, wanted to know in case we refresh the dataset, the webform will also be refreshed (in terms of new columns added to the dataset or new addition to the data)?
Thanks,
Bharti
Comments
-
Hi
Did you use the import functionality when creating the Webform and imported from another dataset?
If this is the case, when you change the dataset that you imported from the Webform won't change, the import functionality is just for help in initially populating the webform.
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
So, is there any other solution which can help in refreshing of data and having done a manual entry to a particular column, as possible in webform?
Thanks,
Bharti
0 -
You can use a google sheet with the data you want to update, and then use ETL to link it to your main DATA.
Google Sheet connector can be configured to fetch data from at predefined intervals and constituently fire the ETL that joins the DATA.
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Hi,
Can you give me a reference to read and understand more on datasheet being built on google sheet and how to apply an ETL there.
Thanks,
Bharti
0 -
So you can find some more information on google sheet conector here:
http://knowledge.domo.com?cid=googlesheets
As for ETL, here is some info:
http://knowledge.domo.com?cid=createmagic
If you can provide some more details i can try and help you.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Hi,
Let me explain the scenario..There is an output dataset (which refreshes regularly) to which we need to add two extra columns for which entries need to be done manually (corresponding to the refreshed data). Please let me know a feasible solution to this.
I tried creating a webform in which the dataset was embedded and then created two new columns within it and was able to do the manual entry too but the issue was that the dataset when refreshed , did not refresh the webform.
Please help, if this can be achieved through google sheets.
Thanks,
Bharti
0 -
It's a little complicated, but your friends at Domo can help.
Step 1: You will need a MySQL DataFlow, which is specially enabled to generate a Webform. This is not something you can do on your own.
Step 2: Use the dataset as the input in the above query to create the webform. It is important never to delete the resultant Webform or change the output of that query.
Step 3: If you are wanting to periodically change your input dataset which builds your webform, you simply have it uploaded normally, make it the input table in your MySQL query, and do a Select * statement to overwrite the table.
Note: You can also do more complicated things with it, but the more compicated you get, the less flexible the query becomes for input channges. If it will be more complicated, you may want to have a Magic ETL dataflow upstream so that your MySQL can be a simple Select *.
Good Luck!
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive