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

Question

Question

LFF1004-InvalidParameterValue

Forms Version 10
Updated April 30, 2020
asked on April 28, 2020

I have a form that is getting this error message when submitted. Based on another thread, I think the problem is one of the two formulas used in the form, but they both work in preview so I don't know which is the problem. Does anyone see a problem with either of these?

 

=IF(LEN(id)=1,CONCATENATE("CC20-0000",id),CONCATENATE("CC20-000",id))

This one turns the "id" field into a Medical Record Number. Both fields are Single Line fields.

 

=SUM(VALUE(Appointment_Time_Start),DIV(2,24))

This one sets an appointment end time to 2 hours after the appointment start time. Both are time fields.

 

Thank you!

Shawn

0 0

Answer

SELECTED ANSWER
replied on April 30, 2020

I found my own answer lol. For anyone else who has this issue, the problem was the the ID field is a number field and had to be converted to text. The correct formula is:

=IF(LEN(id)=1,CONCATENATE("CC20-0000",TEXT(id)),CONCATENATE("CC20-000",TEXT(id)))

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...