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

Question

Question

New to using tables in new forms designer

asked on September 20, 2024 Show version history

I would like to use the Field "table" to put in my form.  I have selected the 2 column variables that I would like. In advanced, selected fixed number of rows as 3, and typed in my 3 row labels. My form displays the 1 row when editing, but previewing shows all 3 rows (the first row label). Is this expected behavior?

I am not able to adjust the column width between the rows label and the first column.

My form user will be populating the 6 boxes manually with currency.

If a table is not the proper way to do this, can someone suggest how I should go about doing it? I thought the table would look nicer than me creating 6 different single line text fields.

0 0

Answer

SELECTED ANSWER
replied on September 20, 2024

For the row labels, enter a number into the column size field.  This sets the size for the row labels as a percentage of the row.

0 0

Replies

replied on September 20, 2024

Have you previewed the form (click the eye ball in the upper right)?  This should show your three rows.  The Flow Designer only shows the one row while doing the design, it shows the rows you want in the preview.

You will also need to add fields (columns) to the table to have it start looking like a table.  

0 0
replied on September 20, 2024

That was definitely my problem! Thank you!

Is there a way to use any type of slider to adjust the column width between the first column (row labels) and the first column? I can adjust all column widths, just not that one.

1 0
SELECTED ANSWER
replied on September 20, 2024

For the row labels, enter a number into the column size field.  This sets the size for the row labels as a percentage of the row.

0 0
replied on September 20, 2024

I swear I was looking for that very wording and didn't see it! Thank you!!!

1 0
replied on September 23, 2024

@████████, since you've been so helpful on tables, can I push this issue one step further? I am also happy to start a new topic for this. Is it possible for me to add an advanced calculation just on the 2nd row of my table? 2 of those cells just need to do (* 12) in whatever figure it input in the row above in it's respective column. Since I can't see or access those 2nd 2 rows in the forms layout designer, I'm thinking this is not possible. See screenshot:

0 0
replied on September 23, 2024

How about switching your rows for columns?  Make the Current Compensation  and Compensation Effective Date your rows and then put the Monthly, Annual and the Annualized as the data fields.  This way you will see the data fields and then be able to do a calculation on those fields.

0 0
replied on September 23, 2024

@████████ I will see if that will work for them, easy enough fix :)

0 0
replied on September 23, 2024

@████████ it doesn't look like that is going to work unfortunately. As I tried to move it to the first line, then wanted to build an advanced formula, and I still don't know the name of the variable or target on the other cells that are hidden. I may go ahead and post this question to the masses so as not to get to sideways in my original ask :)

0 0
replied on September 24, 2024

@████████ Have you looked at this page for information on formulas within Laserfiche Forms:  https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/FieldCalculations.htm for more info on Tables, go here

0 0
replied on September 24, 2024

@████████ I have not! Thank you so much for that resource!!!

 

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

Sign in to reply to this post.