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

Question

Question

Posting table information to approval form

Forms
Updated April 17, 2014
asked on April 16, 2014

I am currently working on a form that is for an expense report and I am inputting the value in each row. The issue that I am having is that when it is posted to the approval form. I am setting the default value of the previous form column variable and when this happens the it does pull the data from each row but it post all the data from each row in the box separated by a comma. Do I have to post the data via JavaScript by pulling the information from the previous table? The screen capture shows my current situation.

 

 

 

Capture.PNG
Capture.PNG (8.66 KB)
Download
0 0

Answer

SELECTED ANSWER
replied on April 17, 2014 • Show version history

Hi Cristobal,

 

To access the variables from previous forms in your process you'll want to go about it in a slightly different way. Instead of creating a new table and assigning it the variables from your previous table, you can actually drag the whole table from the previous form over, along with its contents. To do this, switch from the 'Fields' tab to the 'Variables' tab in the Forms Designer.

 

 

 

Then find the variable you want (in your case it's called Miles3) and drag it onto the form. This will keep the same table structure as you had in the previous form and will populate it with the information inputted earlier in the process.

0 0

Replies

replied on April 17, 2014

Does the table on the approval form contain different information than the one from the original expense report form?

 

Would it be possible to use the table from the expense report as a field variable on your approval form?

 

As you've discovered, the variable for a table column stores the values for each column in a comma separated list. Using the entire table as a variable on your approval form, if possible, is a nice way to avoid having to parse the contents of the comma separated list of values and then append those to the correct field in the table.

0 0
replied on April 17, 2014

The table on the approval form is supposed to contain exactly the same content as the table in the previous form. 

 

In the approval table the column was assigned the variable Miles4 when in the previous form it was assigned Miles3. It attempted to create a new column and inputting the variable name and I was denied because it stated the variable was already in use. 

 

I will probably recreate this form so that they have similar variables. Unless there is another way to get around this without having to recreate the form entirely.

0 0
SELECTED ANSWER
replied on April 17, 2014 • Show version history

Hi Cristobal,

 

To access the variables from previous forms in your process you'll want to go about it in a slightly different way. Instead of creating a new table and assigning it the variables from your previous table, you can actually drag the whole table from the previous form over, along with its contents. To do this, switch from the 'Fields' tab to the 'Variables' tab in the Forms Designer.

 

 

 

Then find the variable you want (in your case it's called Miles3) and drag it onto the form. This will keep the same table structure as you had in the previous form and will populate it with the information inputted earlier in the process.

0 0
replied on April 17, 2014

What I ended up doing was deleting the table on the approval form and then dragging and dropping in the table to were it previously was from the variables tab. I also removed the extra columns using the cog wheel under that variable. Thanks for the help.

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

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...