You are viewing limited content. For full access, please sign in.

Question

Question

Forms Row as value to parse in Workflow

Forms Workflow
Updated July 9, 2017
asked on July 6, 2017 • Show version history

I want to use a Forms table row labels as values to help parse my data.

I would like to call the table in workflow and for each row use the values from the row labels.

Is there any way to achieve this?

0 0

Replies

replied on July 7, 2017

Tables are available in the Retrieve Business Process Content activity just like all other fields. If you choose to retrieve the table and its fields, then its fields are available for iteration in For Each Row.

0 0
View 2 previous replies
replied on July 7, 2017

I have it called in just like that,  but there is no variable given for the row label itself.  Only the data in the field of the table.

I am only given the field values,  the row labels are not given as values to use for iterations.

0 0
replied on July 7, 2017

Oh, sorry, I read it wrong, the row labels have no meaning in Workflow (or SQL data sources), they're just for display in Forms.

The row data is retrieved in order, what would the labels bring that's different?

0 0
replied on July 7, 2017

database storage.  for example:

ROW        FIELD

C1             90

C2             65

 

etc.

If I was able to retrieve the row data, I would have been able to pull the row value and store the field data in the database column I wanted.  

I will need to find another way to do this.  I know the ordering will be correct, so I can use workflow to store with tons of mini queries knowing C1 is first, C2 is second etc.  But it will make for a very ugly workflow.

Need a simpler design.

0 0
replied on July 8, 2017

Sorry, I'm not sure I understand what you're trying to do. For each row would get the value from "FIELD" so you can use it in your query. Why is knowing it's "C1" in row 1 relevant?

0 0
replied on July 9, 2017 • Show version history

Here's the Database setup:

Site   |   Tank   |   Date   |   Feed   |   Feed_Value

WC        C1        7-7-17     Carp      90

 

I want to add rows for a specific site in the database but the tank value also needs to be recorded.  The Form row is a clean way to display the tank value while also getting the correct correlated feed value associated with it on a certain day.

In order to store it like this using the Tank value is needed.  The table is clean so depending on the Site chosen, I can hide other sites and their tanks.

I can accomplish the same thing with single fields in a Section, But I felt it was cleaner on the back end not having to hide or show so many fields per Site.

Here is a capture of each table I would have shown based on the location and the Feed type.  I would hide the other tables.  Then the user could fill out the tank feed values and all of them would be added to their database for reporting later.

Can I accomplish the same thing without a table by using a Section and hide the section based on the same rules and have fields for each Tank?  I believe that can handle what I am needing be getting the tank value when storing the values.

Tables are just more dynamic if there is a way I can still use them.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...