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

Question

Question

Why does having a calculation defined on a forms field, automatically make that field required?

asked on December 12, 2022 Show version history

Even if I do not check the required box, if I add a calculation that might populate the field with a value, depending on if another field has a value, suddenly that field becomes required to have a value and the user can not submit without entering something into the field.

Why is this? It should only be required if the required checkbox is checked.

 

Here I am being taken back to the EDMonth field on the first page. Yet you can see the configuration for that field is not required and there is no red star.

0 0

Answer

SELECTED ANSWER
replied on December 12, 2022 Show version history

I believe the problem is that the formula fails if the DiscDateExt field is blank.  Try to calculate the value only if DiscDateExt is not bot blank like this:

=IF(TEXT(DiscDateExt)<>"",IF(MONTH(DiscDateExt)>9,MONTH(DiscDateExt),CONCATENATE("0",MONTH(DiscDateExt))),"")

Fixed formula

3 0
replied on December 13, 2022

Ah I see, so if using Calculations you must always insert either a value or null, indicated by "", otherwise it will prompt the user to enter something.

I tested this and it worked. Thank you for the full example!

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.