Calculated field on Selection of another field. | Community
Skip to main content
N
NishaPatel
Level 3
July 13, 2023
Solved

Calculated field on Selection of another field.

  • July 13, 2023
  • 2 replies
  • 1320 views

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.
Best answer by NishaPatel

Thanks, this is working for me 🙂 

2 replies

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
July 13, 2023

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.

Kundanism
Kundanism
Level 10
July 14, 2023

Possible to get the code for the same?

🙂

N
NishaPatelAuthor
Level 3
July 14, 2023

Yes Please.

K
Adobe Employee
Karlton_HarrisonAdobe Employee
Adobe Employee
July 19, 2023

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"))))

    N
    NishaPatelAuthorAccepted solution
    Level 3
    July 19, 2023

    Thanks, this is working for me 🙂 

    Terms & ConditionsAccessibility statement

    Loading footer...