use Webform to perform data capture to an existing data set

gomezican

i would like to construct a data set that has referential data, in this case project ID, then have the ability to perform additional data capture via the web form.

 

in a simplified example,  i construct a list of projects using workbench/data flows.

 

i can then allow users the ability to capture data about that project on a monthly basis by adding content to a couple of predefined columns (for example month, project notes for the month)

 

i have 5 or 6 cases where this situation could apply to our current program.  

 

benefits to DOMO

- more user licenses

- more dependence on the platform

- easier adoption

GIriarte

This idea is great and its connect with the following: 

 

 https://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/Dynamic-Goal-setting-Manual-setting-by-user-Applicable-to/idi-p/7403

 

Check the +3 line.

product_John

Thank you for this idea.  I'm assigning to our product manager @alexpeay for review.

product_John

alexpeay

@gomezican I don't think I am following your request. Are you saying you would like to send the data initially through Workbench then be able to switch that DataSet over to be updated manually through a webform?

alexpeay

gomezican

@alexpeay Hey Alex.  Yes.  i'd like to be able to load a DataSet with Key Information, in this case Project ID from our ERP.  This would be done via the workbench.  Users would then be able to update non-ID columns via DOMO.

alexpeay

@gomezican thanks for clarifying! This is very intersting concept. I'll dig into the details of how we might be able to provide this type of functionality.

alexpeay

user08458

Hey Domo masters,

 

Any update on this feature - adding a manual input/entry functionality for data sources?

DataMaven

I use recursive MySQL queries which create, and subsequently overwrite Webforms.  It's a bit cumbersome to set up, requires some intervention from Domo staff, and you have to be careful with your design...but it works.  

 

I use it for my mapping tables, where I need to be able to categorize data attributes, and new values appearing in datasets need to be appended.  

 

It's honestly more complicated than it needs to be.  If we could have a webform as an output dataset option in Magic ETL, this would be solved.  ?