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

Question

Question

Fill specific cell in Forms table with variable

Forms Version 10
Updated November 28, 2022
asked on March 28, 2019

This should be simple, but I can't find any posts related.  I'm trying to take a variable from a text field in one form and fill a specific cell in a fixed-size table in a later form.  The columns and rows are all set in the table, so it will always be the same size.

Any ideas?

0 0

Replies

replied on March 31, 2019

Hi Paul,

If you want to avoid javascript you could use a formula in the field options for the table column where the cell you want to populate resides and enter:

=IF(ROW()=2,Single_Line,"")

In this case the second cell in the column would be populated with the Single_Line field from the first form.

0 0
replied on December 17, 2021

Ian,

If I wanted to do the opposite, get the value from a table and input it into another separate field, what would that look like?

Thanks

0 0
replied on December 20, 2021

Hi Dillan,

It depends exactly what you need but you can use the INDEX function to pull data out of a table.  In the example here the formula in the single line cell is =INDEX(Table1.Column1, 2) which pulls the second row from Column1 in Table1.

(where Table1 and Column1 are variables for the table and column)

 

0 0
replied on November 28, 2022 
For example, if I wanted to enable and disable an entire row based on a cell, how would it be without using javascript?
1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...