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

Question

Question

Previous table data read-only with field calculation

asked on August 20, 2022

I'm trying to put an approval history table on a form that tracks date, user, decision, and comments. The decision itself is made via dropdown list, so I'm trying to use a field calculation to populate that column. However, changes made on later forms change not just the current line of the table, but all previous decision values. This is with the option to make previous data read-only. In the screenshot below, the first row's Decision should say "I Approve".

Is there a way to use a field calculation to populate just the current, editable row and not previous read-only rows? I'd prefer to use calculations rather than JavaScript if possible.

 

0 0

Replies

replied on August 22, 2022 Show version history

When you set the field it looks like you need to target the last row of data only. So something like this.

 

$('.yourTable .yourField input').last().val(theValue); 

EDIT: Sorry did not catch you wanting to use formulas. I can't think of a way off the top of my head a way to set only the last value in a table using formulas. 

0 0
replied on August 22, 2022

No problem, Genny. I appreciate the input and will probably have to go that way.

 

@████████ do you know if it's possible to make field calculations ignore rows from previous steps?

 

0 0
replied on August 22, 2022

My colleagues tell me you should be able to use ROW().

Check out SUM on this docs page for an example:

https://doc.laserfiche.com/laserfiche.documentation/en-us/Subsystems/ProcessAutomation/Content/Forms-Current/Formulas.htm

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

Sign in to reply to this post.