Skip to main content
Level 3
Jul 13, 2023 12:57 PM UTC
Solved

Calculated field on Selection of another field.

I want to set up a calculated field to have a pre-set value based on a selection of another field (radio button). So suppose one radio button have 4 options a,b,c and d, I want to have a calculated field that shows 1 for a, 2 for b, 3 for c and d.

Is it possible?

 

Thanks,

Nisha

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
NishaPatelAccepted solution
Level 3
Jul 19, 2023 6:04 AM UTC

Thanks, this is working for me 🙂 

7 replies

RandyRoberts
Community Advisor
Community Advisor
Jul 13, 2023 1:54 PM UTC

This is possible but the caveat is the form has to be refreshed before any calc takes place. This is usually done by selecting "Recalculate Expressions" from the elipsis menu on the Project.

Translate
Kundanism
Level 10
Jul 14, 2023 8:26 AM UTC

Possible to get the code for the same?

🙂

Translate
Level 3
Jul 14, 2023 8:39 AM UTC

Yes Please.

Translate
Adobe Employee
Jul 19, 2023 1:09 AM UTC

Fields:

Radio Type = A, B, C, D

Calculated field = 

IF({DE:Radio Type}="A","1",
IF({DE:Radio Type}="B","2",
IF({DE:Radio Type}="C","3",
IF({DE:Radio Type}="D","4"))))

Translate
NishaPatelAuthorAccepted solution
Level 3
Jul 19, 2023 6:04 AM UTC

Thanks, this is working for me 🙂 

Translate