Add an item/radio button on the screen without adding corresponding data column in DB

[Evendo]

Hi!

I already had an input screen with corresponding table in DB. Now for an improvising purpose, I want to add a radio button that used to filter out value of another existing input item (an enum list), by that user could choose one value (from radio button group) then its value will affect other item.

I could do it easily by adding a new column in corresponding table for the new item, however, as I don't want this radio button return/save any data into DB, I think I should find another way. I wonder is there a way to do it without adding new data column?

I know that any item used for calculating or displaying purpose only could be achieved by adding virtual column, but I still don't know what is the correct formula or setting for the item I need.

I'm still any newbie so any help and guide is really appreciated. Thanks...

[AleksiAlkio · Accepted solution]

Unfortunately AppSheet doesn't have that functionality to fill a virtual value without saving it somewhere. One workaround is to add an additional table with one row and modify that with an action button. Another way is to use Usersettings but it will need to be synced.. and you probably don't want to wait it.