INPUT() function with dependent dropdowns

AppSheet AppSheet Q&A
, ,
1

I have a table with student records. I have an Action “Withdraw” that shows as a button. I got so far. Now, when the action is pressed / triggered, I ideally want to popup an input() window that shows a dropdown question of possible reasons why a student withdraws. When the first selection is made, a dependent dropdown should display for another selection. When the user finished the selections and confirms, a new record should be added to an other table “Withdraw requests” for further review by admins.

I have not yet figured out how to create the input window that shows a dropdown and a depending dropdown, as well as adding the record to a new table upon confirmation.

Any help is appreciated.

2

As far as I know, the INPUT function doesn’t work on the action that adds a row to another table. Instead make an action “go to another view within this app”, and use the value LINKTOFORM(
“Withdraw Request Form”,
“Student ID”, [Student ID]).

Use SHOW IF settings to conditionally display the rest of the fields only if the previous field is not blank.

2 Likes
3

Add the withdrawal row first, then use an action of type Data: set the values of some columns in this row and INPUT() to get your pop-up.

1 Like
4

Thanks guys. I’ll experiment with both approaches and see what’s the best UX and most robust. Much appreciated :+1: I’ll come back to report results.

1 Like