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)