Workflow with Form and Writeback
Hello,
My use case is as follows:
Create a workflow that allows a user to go through a list of items with "Undefined" as their value under the "Designation" column. For each undefined item, the user should be prompted with a form that allows them to see the identifier for the item and select either "Capitalization" or "Operations" as a value to replace "Undefined". When the form is complete, the value should be written back to the dataset.
I am trying to follow these videos to start working through the process:
These videos do not include any specifics on how to write the SQL query to query the dataset and I don't find any information in the documentation. Also, I was curious if I'm even on the right course for this use case. Has anyone done anything similar successfully?
Thanks,
Kyle L Smith
Answers
-
Kyle, sounds like a great use case!
As far as the SQL query goes, it follows the same syntax as beast mode. Encapsulate your columns in backticks, strings in single quotes, etc… I'm going to try and write a sample query below, but sometimes this platform does strange encoding things.
SELECTID
,First Name
asFirstName
from DATA whereID
< 100 andRegion
!= 'USA'0 -
The forum software eliminated the backticks, but I'm guessing you follow.
0 -
Yes, thank you. My issue has been with the table name, where you have "DATA" and I think it might be a bug because I've demonstrated the issue to support where some names work in that section and some don't. Still waiting on a resolution.
I've found under the test button that you put the dataset's name where you have "DATA", is that correct?
Assuming that I was able to get this to work, do you think workflows and a form would be a good solution for my use case?
0 -
Workflows and a form should work well, yes. How many of these is someone to process? And what do you do with the response?
It may be easier using a Brick, that allows people to change the value and syncing the AppDB data to a dataset that can be a dataflow input to overwrite old values. Multiple ways to skin the cat.
As far as the table name goes, I think you can use just about anything. I've used data, dataset, table, etc…0 -
Considering the source of the data and what to do with the response are important considerations.
0 -
The source of the data is a Domo datasource created through ETL. What we end up is a list of Projects by unique IDs and I need to have a human assign either "Caapitalization" or "Operations" into a field (column) named "Designation". So, my intention is as follows:
- A Domo datasource "Projects" is updated weekly using API connector to Jira
- "Projects" goes through ETL to prepare the data for our reports
- A human needs to interact to determine whether a project should have "Capitalization" or "Operations" in the "Designation" field
- Workflow makes a list of rows with "Designation" = "Unassigned" with a "Projects" as the source
- A form is assigned to a user that has the name of the project in question and a prompt to select "Capitalization" or "Operations"
- When the user selects the value and completes the form, the selected value is written back to replace the value of "Unassigned" in the "Designation" field.
- Workflow repeats for every row with a value of "Unassigned"
- Repeat this process every week
0 -
OK. How many of these are there roughly every week, and are these tasks to be performed by certain individuals or by anyone of a list of people? If by certain folks, are there attributes of the task that assign it to them?
As I mentioned…it could be done two ways that I can think of. What you outlined, or alternatively using a Brick. Volume and specificity of people would likely dictate which route I take.
Super high volume and no specificity of people, brick.
Lower volume or certain people assigned certain Projects, workflow.0 -
3-4 specific people, could easily defined by a group. The hope would be that any of them could make the designation.
Low volume per week (less than 20, probably around 10).
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive