Skip to main content

How can I copy a field when a criteria is filled on another field

  • November 6, 2019
  • 2 replies
  • 17 views
A

Hi, can you please help me? I hope I can explain it well.

Field 1 Single Select (SGL,DBL,TPL)
Field 2 Price for SGL
Field 3 Price for DBL
Field 4 Price for TPL
Field 5- I want to pull the information from either field 2,3 or 4 depending on what was selected on Field 1. If I chose SGL, I want to pull the price for SGL.

Angel

2 replies

Justin_Barrett
Forum|alt.badge.img+21

Here’s one option for the {Field 5} formula:

 SWITCH({Field 1}, "SGL", {Field 2}, "DBL", {Field 3}, "TPL", {Field 4})
A
  • Angel_Ortiz
  • Author
  • New Participant
  • November 23, 2019

Thank you very much Justin, I will try it and let you know.

Terms & ConditionsAccessibility statement