Change referenced table through select list

I wanted to be able to change what my reference to a table is based on an option from a select list.
Example:

@Pedro_Miguel_Rocha_Silveira

Something like this?

Kinda, but the problem is that if I add a new option to the select list (let’s say D, and a table D) I’ll have to add that to the formula, or can I add that that part of the formula with a button, perhaps?

@Pedro_Miguel_Rocha_Silveira

I don’t think we yet have the ability to programmatically access tables or columns, or at least I don’t know how to do it.

Oh, that’s sad, it would have been so useful if that function worked, I guess I’ll just use the switch if solution as a place holder, maybe that is possible using the API

1 Like

Hi Pedro, unfortunately you can’t dynamically set the reference to a table hover you can still achieve the scenario by putting all the values in a single table and filtering the results based on the value of the select list. Here’s an example:

1 Like