Valores de tabla en función de parámetros seleccionables de un formulario

AppSheet AppSheet Q&A
1

Good morning everyone!

I have a database with values ​​and I need to generate a list, but that list must depend on some parameters that the user selects in a previous form, for example:

The table is a list of items with prices for materials, labor, tools and VAT.

I need that if a user selects without VAT, for example, the list with prices does not consider VAT. I need the choice to be generated in a separate form and that, in the table of said form (from google sheet), infinite records are not generated for each time the form is modified, but rather it is a single record that is modified each time I know that it is edited, so indefinite records will not be generated, only a valid choice.

At first I created a database with YES/NO columns and this allows me to make the election form.

In another table create virtual columns on which values ​​are calculated based on the choices in the other table. But this seems to be impossible since the IF function doesn’t support lists. There is probably another way to update those values.

Is there a way to update the values ​​of a table based on a parameter form that allows some adjustments to be made?

Greetings

2

I think what you are describing is perfectly possible. It sounds like you want a user to be able to store their preferences (this would be in a table which one row per user) and then a filter or similar expression in another view should reference those preferences. Perhaps you could start by showing us the structure of the two tables you have and the expression you tried which doesn’t work? IF() can support Lists by the way, but remember comparisons have to between objects of the same type. So you can’t ask does my list equal this text value? but you can ask does the first item in my list equal this text value?

Edit to show an example of the way I use if to see if the current role is a match for the value of role associated with the current user. Note the use of Index to pull the first row, even though there is only one row associated with the current user. This allows me to compare a text value with a value from a list.

If(
  [Role ID] = Index(Current_User[Role ID], 1)
)
2 Likes
3

Hola Graham, no se porqué no vi esto antes. Muchas gracias por tu respuesta. Corroboro y comento nuevamente.

1 Like