Is it possible to show a date in a field based on another field's selection?

  • Profile Image
    ChinaAdvocates
    Asked on April 27, 2017 at 07:18 PM

    i.e. relational information.

     

    Field #1   Organization

    Field #2   Date

     

    When I choose Organization from a drop down in Field #1 it looks up the date for that organization and populates Field #2 with the corresponding date that is linked to that Organization somewhere!

    I have a feeling that is not possible with this.

    Please advise.

     

    kate@china-advocates.com

     

     

  • Profile Image
    Mike_G
    Answered on April 28, 2017 at 12:00 AM

    In order for you to accomplish your requirements, you first need to set calculation values for the options (organizations) in Field #1. The calculation value of each option in the drop-down field would be the option's corresponding dates.

    How-to-Assign-Calculation-Value

    Field #2 would be a textbox field that will have the calculation value of the selected option in Field #1. This would be possible with the help of conditional logic.

    Conditional-Logic-Inserts-Text-Calculation-Into-A-Field

    Result:

    I hope this helps. If you have any further questions regarding this, please feel free to contact us again anytime.

    Thank you.