Connecting a drop-down menu selection with an ID

  • xanu,

    What are your thoughts about saving an ID in the database that is recorded based on a selection that a user might make from a drop down menu? Is this something you’ve attempted before?

    So if someone signs up, and there is a drop down menu with:
    Option1
    Option2
    And, the user selects Option1.

    How can I save:
    OptionID1
    In the same record on a separate column?

    Is there a way to create this relationship somehow using hidden fields?

    Thanks for any input you have!

    –Dan

    https://www.ads-software.com/plugins/participants-database/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Something like this will typically require a little javascript to copy a value into a hidden field when the selector is changed by the user.

    The trickier part is defining your IDs…it is possible to set up a dropdown so the title (the visible string) and it’s corresponding value are different, but if I understand your question, you want to save two values in two fields: a string and an ID. That will require something more because the javascript needs to know somehow which value to store in the ID field.

    Thread Starter lastcall4dektol

    (@lastcall4dektol)

    Thanks for the input. After reading your comments, I’m thinking I’ll try to solve this by creating a drop down selection that contains a string that has both values. Then I’ll attempt to split the string and save two values in separate columns.

    As always — thank you sir.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Connecting a drop-down menu selection with an ID’ is closed to new replies.