How to show a dropdown, in a form view, depending on two or mores values existing in another table?

[silvanosc]

Hi everybody,

I need a support on building a formula for a “show_if”. Scenario is below:

A) Database: GoogleSheet
Here, there are three sheets (among others) and some columns and values:

---

Sheet 1: PowerCompany

Name
Cemig
Cpfl
Elektro

---

Sheet 2: Service Order

PowerCompanyName*

• is REF to “powercompany” sheet

---

Sheet 3: Parameters

Group	Variable	Value*
cGeneral	iAppType	1
Purchasing	lAllowVendorCreation	N
Sales	lAllowDiscounts	S

• where cValue may vary:

1 - photovoltaic panels
2 - industrial equipment maintenance

B) in Appsheet, I made a form view for the “Service Order” sheet and designated a dropdown menu format to the “PowerCompanyName” field:

c) What do I need?

• show or not this dropwdown depending on the combination of the three values obtained from “parameters” sheet. For example, this dropdown should be shown (show_if) only if:

Group = “General” AND Variable = “iAppType” AND Value = “1”

i.e. “General, iApptype, 1”

• Thus, if one or more of these three values are FALSE, the dropdown shouldn’t be shown.

I’m struggling with formulas and not understanding which function to use or how to build them

---

---

Thanks in advance,

Silvano (Brazil)

[Arni_Kli]

@silvanosc

Group = “General” AND Variable = “iAppType” AND Value = “1” i.e. “General, iApptype, 1” - Thus, if one or more of these three values are FALSE, the dropdown shouldn’t be shown.

@silvanosc , you did not show how table 3 (Parameters) is connected to table 2 (Service Order) - through which link and which column.

You cann’t use this formula of Parameters table columns in Service Order table without any link between this tables. This won’t work in Service Order table. Need some link, e.g. REF or REF-base or REF_ROWS like as you linked table 1 with table 2.

AND(
  [Link].[Group] = "General",
  [Link].[Variable] = "iAppType",
  [Link].[Value] = 1
)

[silvanosc]

Hey @Arni_Kli ,

thank you for your guidance.

I agree.

However, It’s exactly what I’m trying to prevent: a link, a “ref”.

The medium-term goal is that the visualization of many components also depends on these parameter without I must to create a column “iAppType” in each table whose field I intend to show / hide

That’s why the parameter has the “General” value in the “group” column.

Silvano