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

Question

Question

LFF1018 Error When Submitting Form with Calculation

asked on July 22, 2020

We have created a Form for a client where we are performing some calculations to procure a Gross Amount based on a set of fields being selected. The calculation includes fields that can be hidden based on a set of radio buttons. When we try and submit the Form, we get the below error:

Laserfiche Forms has encountered a problem.

 

Errors encountered during forms submission:
Field Name: Total Allocated Invoice Amount, Position: 58, Error: An unexpected error has occurred. [LFF502-UnexpectedError] [LFF1018-ErrorOccuredDuringFormulaCalculation]

 

Your form data has been saved. Please click the "Recover form" button to go back to your form to fix any errors and try to submit again. You will be sent to a sign-in page first if your session was disconnected.

 

The calculation is below:

=IF(AND(Coding_Type.PO,Additional_GL_Coding_PO_Checkbox.Additional_GL_Coding),SUM(Total_PO_Amount,Total_GL_Amount),IF(AND(Coding_Type="AFE Multi-line",Additional_GL_Coding_AFE_Checkbox.Additional_GL_Coding),SUM(Total_M_AFE_Amount,Total_GL_Amount),IF(AND(Coding_Type.PO),SUM(Total_PO_Amount),IF(AND(Coding_Type.AFE),SUM(Total_S_AFE_Amount),IF(AND(Coding_Type.GL),SUM(Total_GL_Amount),IF(AND(Coding_Type="AFE Multi-line"),SUM(Total_M_AFE_Amount),""))))))

 

The help files do not include any information about Error 1018.

Any help would be greatly appreciated!

 

Thank you!
Molly

0 0

Replies

replied on July 22, 2020

The error is unexpected, please check what error it recorded in the event log when end user see this error. Please open a support case with the download process , a video to illustrate the issue and the event log that contains the detailed error. We will investigate what data cause this. 

0 0
replied on January 5, 2021

Hi Molly,

 

A Radio Button value should be referred as [RadioButtonVariable]="[Value]" in Calculation for read-only field.

For example: IF(Radio_Button="Yes",1,2) , where Radio_Button is a radio button.

The formula [variable].[choice] for radio buttons should be function well in Forms 11.

 

Regards.

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

Sign in to reply to this post.