Deleted ref dropdown after added to child form

AppSheet AppSheet Q&A
,
1

Hai,

i want to automatic deleted ref drop down after selected the Asset Number
1.deleted choosen selected number

3X_9_6_9657e949208a04d11f9b7a4054b7b0a3862a95f1.png
3X_9_6_9657e949208a04d11f9b7a4054b7b0a3862a95f1.png260Ă—456 7.92 KB

sorry im the newbie user so i just can upload the image one post, i will explain it later

thank you

1 Like
2

Hello @adityo_reksoprawiro

No worries about the details; you’ll find many of the people that answer questions like this will already know what you’re looking for.

I’m assuming you’re using either a Ref or a Valid if formula to populate that list - yes?

Then the thing you need to do is remove the already used items from that list. Thankfully, AppSheet has made List math super easy; literally treat things like you’re dealing with numbers (in a sense).

What you’ll need to make this work is a list of the items that have already been selected; you can achieve this with a slice pretty simply.

If I go with the assumptions:

  • that this dropdown is populated from a Valid If formula that’s pulling it’s data from another table
  • that the form from your screenshot is a different table than where the data is coming from

Then you could do the following:

  • Create a slice of the table where people are submitting data
  • Inside the Valid If formula for your dropdown, use list subtraction to remove the items that have been selected

    • If your valid if formula was this:
      Table_Of_Options[Option_Number]

    • Then your new formula would look something like this:
      Table_Of_Options[Option_Number] - Slice[Selected_Option]

3 Likes
3

@MultiTech_Visions after i tried many times it works
thank you so much

2 Likes