Need Help with Form and show_if()

[ABBA]

Hi Friends

I have a a table and form from that table for input.

I have a ref table [Tank or Gauge Name] and I am using buttons to show them in the form. All the code is based on selection of the [Tank or Gauge Name]

When I click the selection a drop down of [Tank of Guage ID] drops

I dont want this to be dropdown but rather an auto SELECTTION process in the app, because each [Tank or Gauge Name] has a specific [Tank or Guage ID]

Also, since the code is based on [Tank or Gauge Name] or [_ThisRow], I have to have [Tank or Gauge Name] as selection, when the users prefer [Tank or Gauge ID]. 

is it possible to change something in the table where I dont have to change all the 25 to 30 formulas to [Tank or Gauge ID] but rather have users select [Tank or Gauge Name] and this action auto selects the corresponding [Tank or Gauge ID]?

I have a table [Tank Gauge List] that I am using as reference to get [Tank or Guage Name]-column Tank or Guage Name

ID	Facility	Tank or Gauge Name	Tank#	Type	Capacity	bbls/in
EARL Harlan-11978	EARL Harlan	11978	Production Tank	Oil	300	1.167
EAST Dome Ellis-25293	EAST Dome Ellis	25293	Production Tank	Oil	300	1.167
EAST Dome Ellis-66018	EAST Dome Ellis	66018	Sales Tank	Oil	300	1.167
MOSBY Dome Ellis-11955	MOSBY Dome Ellis	11955	Production Tank	Oil	300	1.167
MOSBY Dome Ellis-Sales Tank #1	MOSBY Dome Ellis	Sales Tank #1	Sales Tank	Oil	300	1.167
Unit#1-1230	Unit#1	1230	Production Tank	Oil	300	1.167
Unit#1-1231	Unit#1	1231	Production Tank	Oil	300	1.167
Unit#1-55769	Unit#1	55769	Production Tank	Oil	300	1.167
Unit#2-21469	Unit#2	21469	Production Tank	Oil	300	1.167

Also I have another table called [Tank Guage Capacity] from which I get [Tank or Guage Name] as Unique([Tank Guage Capacity].[Tank or Guage ID-Name])

I know the code is jumbled

I am trying to simpli

[VOLODYMYR_TYROL]

use next formula  "[Tank or Gauge Name].[Tank or Gauge ID]"

[ABBA]

Where would you use the formula @volodymyrt and what should be changed? Appreciate your input

[VOLODYMYR_TYROL]

i don't remember proper name for this, but when you have ref field you can use "." to get to some columns in it 

[VOLODYMYR_TYROL]

here

[ABBA · Accepted solution]

Hi Friend.

This solved the problem with auto selection. Now the user does not have to select from drop down. Its auto selected.

I did change to initial value as sugested

[Tank or Gauge Name].[ID]

[VOLODYMYR_TYROL]

if you wouldn't like that user will be able to change the Tank ID you shod use App formulas instead of Initial values, please read this article 

https://support.google.com/appsheet/answer/10106437?hl=en

[VOLODYMYR_TYROL]

App formulas and Initial values

Sometimes you want calculations to run in the app while the user is interacting with the data in a form. To help you achieve that goal, you can specify an App formula for specific columns. An App formula is an expression that AppSheet evaluates whenever a user changes a value in a form (while creating a new record or editing an existing record).

Each time such a change occurs in the form, the App Formula of every affected column in the record is evaluated and the column is assigned the result of the formula evaluation. For example, if a record has a Price column and a Tax column, the Tax column might have an App Formula [Price]*0.05 to compute a 5% tax automatically.

You can also specify an Initial value for every column. An Initial value expression assigns an initial or default values for a column in a new entry. If the expression is not a constant, it may be a formula that depends on other columns in the new entry. Its value will be recomputed as the new entry is filled in until the user explicitly sets the value of the column. At that point, a value has been assigned and the Initial value definition is no longer relevant for this entry.

In other words, an Initial value expression acts just like an App formula, but it has two differences: (a) the column is still editable by the user, and (b) once edited, the column is no longer automatically updated with continued re-computation of the expression.

https://support.google.com/appsheet/answer/10106437?hl=en