Making something like 2D array in a view

[tetkovsky]

Hello everyone, I would like to implement a certain function in my AppSheet application. The user is presented with a form similar to the photo below:

And depending on the user’s choice, the application receives information like: “Box two, Product two”. I think this somehow counts as a 2D array.

Is there any way I can implement a table like this in AppSheet view?

The only solution I have found at the moment is to create several “Enum” columns, enter specific “Values”, and select Input mode: Buttons. The result looks like this:

But this way still leaves me with column names and large spacing, plus the ability to select several options instead of one.

Thanks in advance for your response

[Suvrutt_Gurjar]

I

@tetkovsky

plus the ability to select several options instead of one.

If understanding of your requirement is correct, you could use suitable valid_if expressions on the three columns so that it allows only one value to be selected at a time among the three columns. The understanding is the user can select any one of those nine options.

Example below

When more than one option is selected in two different columns, it will not let the form save.

Here the valid_if for the [Product_1] column is

AND(ISBLANK([Product_2]), ISBLANK([Product_3]))

The valid_if for the [Product_2] column is

AND(ISBLANK([Product_1]), ISBLANK([Product_3]))

The valid_if for the [Product_3] column is

AND(ISBLANK([Product_1]), ISBLANK([Product_2]))