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

Jithin212
Jithin212 Member
edited January 7 in APIs & Domo Developer

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?

Tagged:

Best Answer

  • lesienebrecount
    lesienebrecount Contributor
    Answer ✓

    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!

    image.png

    image.png

Answers

  • lesienebrecount
    lesienebrecount Contributor
    Answer ✓

    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!

    image.png

    image.png

Categories