Using Domo Workflow, is there a way to store data in a dataset when a user fills out a form?

Jithin212

Hi ,

In Domo Workflow, I have created a conditional statement for one of the fields so that data entries require manager approval before being submitted, based on the tutorial from Domo University. It's working well, but now I need to store the values being input in the form.

In a normal form, you can see a dataset, but not in this case. Is there a way to perform this?

lesienebrecount

Hi there!

Yes there is a way to do this.
If I recall correctly, it is easiest if you set up the a webform as the dataset you intend to add data to, to map out your field names. Once that exists, you should be able to add a step in your workflow that uses an APPEND TO DATASET tool from the DOMO Datasets Code Function Package. (first image)

A super key thing to keep in mind here is that the text from the form can sometimes work against the log. For example if I said "We had a great day, no support issues" the comma is going to be treated as a comma separated list instead of punctuation.

In order to avoid this, you will want to use a Text Substitutions tool from the Code Function Package DOMO Text Utilities or do a dynamic replace for commas to blanks for any field that may contain them as punctuation rather than a list. (You will want to separate tool for each of those fields). (second image)

Hope this helps!

lesienebrecount

Hi there!

Yes there is a way to do this.
If I recall correctly, it is easiest if you set up the a webform as the dataset you intend to add data to, to map out your field names. Once that exists, you should be able to add a step in your workflow that uses an APPEND TO DATASET tool from the DOMO Datasets Code Function Package. (first image)

A super key thing to keep in mind here is that the text from the form can sometimes work against the log. For example if I said "We had a great day, no support issues" the comma is going to be treated as a comma separated list instead of punctuation.

In order to avoid this, you will want to use a Text Substitutions tool from the Code Function Package DOMO Text Utilities or do a dynamic replace for commas to blanks for any field that may contain them as punctuation rather than a list. (You will want to separate tool for each of those fields). (second image)

Hope this helps!