Question

Can't submit form with a Read-only table field with Formulas

Forms Laserfiche

Updated August 31, 2023

asked on August 30, 2023

We have a timesheet form with rows for entering each days time punches. The fields fill/default how we'd like and the formulas work, but if the 'Hrs. Worked' field at the end that's adding the differences in time fields together is changed to read only we then receive errors when trying to submit said form.

0 0

Replies

replied on August 31, 2023

Figured it out; for some reason making the field read only required the formulas to be changed.

=SUM(
ROUND(((VALUE(INDEX(Pay_Period.time_out_lunch,ROW())))-VALUE(INDEX(Pay_Period.time_in_work,ROW())))*24,2)

,ROUND(((VALUE(INDEX(Pay_Period.time_out_extra,ROW())))-VALUE(INDEX(Pay_Period.time_in_extra,ROW())))*24,2)

,ROUND(((VALUE(INDEX(Pay_Period.time_out_extra,ROW())))-VALUE(INDEX(Pay_Period.time_in_extra,ROW())))*24,2)

)

That seemed to be working prior to setting the field to read only, but the VALUE'S needed to be TIMEVALUE's afterward.

1 0

replied on August 30, 2023

What version of Forms are you using?

0 0

replied on August 31, 2023

11.0.2212.30987

0 0

You are not allowed to follow up in this post.

Question

Question

Can't submit form with a Read-only table field with Formulas

Replies

Sign in to reply to this post.