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

Question

Question

Use Current Row Values in Table for Labels

Forms
Updated March 5, 2019
asked on February 4, 2019

In Forms 10.2, I have a table that has a bunch of columns.  I am looking to use the values selected in one column as part of a label for another column in the same row.  We have the ability to use variables in "Field Label", "Text Above Field", and "Text Below Field" but I cannot seem to find how to pull the value only from the current row.  I've tried the calculation method "INDEX(table.column,ROW())" but that puts the values from all rows in the table. Is this even possible (even with newer versions of Forms) or do I need to do this through Javescript?

  •  
0 0

Replies

replied on February 4, 2019

Can you show the table and what values you are trying to grab to put in the later columns? Are you trying to grab values from row 1 of the table to fill in the later column headers? 

0 0
replied on February 7, 2019

It is not really with the headers as it is with the text above/below the text box.  This form is essentially a time sheet in that it allows you on a row to pick a vendor from a drop-down and then pick the vendors project you worked on from another drop-down.  If the project you worked on is not in the drop-down there is a link in the "Text Below Field" that links to another form where they can create the project. 

Right now that link is static and thus they have to choose the vendor again in the other form before creating the new project.  I am wanting to pass vendor name they selected in this form via the URL in that link, so that the vendor is already selected in the new project form.

 

0 0
replied on March 5, 2019

The text below field input doesn't accept calculations and cannot use variables unless they were submitted on previous forms. One thing you could try is adding a hidden column to the table that could build the URL for Add New Project. The hidden column could build a URL using Index(table.column,row()) which would auto-populate your next form. You'd have to use JS to grab that dynamic URL and put it under the Add New Project hyperlink. 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...