I am building an application based on Employee Onboarding. I have mostly dropdown menu's on this form. I will just focus on two for this question: (1) Job Titles and (2) Laptop Needed. When HR fills this form and selects "Manager" from the first drop down, I want the second dropdown to auto-populate "Yes".
Is this possible? If so . . .
1 - Where would the formula be placed, drop down 1 or drop down 2?
2 - What property would be best based on this situation, OnUpdate, Items, OnChange?
3 - How many drop down's can be updated based on the selection from drop down 1?
4 - Would the change be made on the DataCard or the DataCardValue?
Solved! Go to Solution.
Hey PowerAddict,
I have the solution, the fix is in . . .
Thanks for your assistance with this case. We have the solution.
Hey PowerAddict,
Thank you for the formula . . .What do you mean by, "Value might need to be replaced...?"
When I begin my IF statement, the name of the data card populates automatically. Once I begin to type ".selected.value", the query seems to stop, no auto-populated names appear. To target "selected.value", do I need to apply further configuration settings on the first drop down menu card?
For better reference, I will provide images of my situation. The Job Title card (screenshot) shows the card details, 15Five card (sreenshot) is where the "Yes/No" lives. The Job title card has all the titles.
Job Title Card (Screenshot)
15Five Card Screenshot
Here is a demo screenshot of the job title and the field that needs to change . . . When Accounts Payable Specialist is selected, I need the 15Five card to populate Yes (yes/no options).
When I entered the formula, and select the job title (after a republish of app), nothing happens when selected.
Here's my formula: If('Job Title_DataCard1' = "Accounts Payable Specialist", "Yes"). I also tried the ".selected.value" and nothing happens.
Can you let me know where I'm going wrong @PowerAddict ?
Job Title Items (1st dropdown)
15Five dropdown
I skipped ahead (thinking I have a better understanding), when I updated my formula, in the 15Five Default property, and republish, still no bueno . . . The value appeared automatically after I corrected the reference to Job Title card.
Hey PowerAddict,
I have the solution, the fix is in . . .
Thanks for your assistance with this case. We have the solution.
User | Count |
---|---|
213 | |
95 | |
88 | |
49 | |
38 |
User | Count |
---|---|
271 | |
104 | |
103 | |
60 | |
59 |