Hi, I’m new to Appsheet.
I have built a prototype app to help clients record gas and electricity meter readings. There are three tables, Sites, Electricity Readings and Gas Readings. The two reading tables reference the Sites table and are each set to be “part of” that table. Broadly speaking, the app works but I want to refine it and am having problems with “show if” logic.
There is a column is Sites called Utility and for each row it contains "Electricity" or "Gas". There are rows in Sites for each site/utility combination and I have concatenated in Excel Site name and utility and set that as the key.
There is also column in Sites named Profile of type Text.
I have created form view for each reading table and set them as inline so if you click on a site it takes you to the inline views for electricity and for gas. However, if the site I click on is for electricity only, I want to show only the electricity inline form and vice versa. I am trying to use show if logic and have tried = and contains(). Each is accepted as correct but neither works.
For electricity if the profile is "04", I want to ask for a Day reading and a Night reading else Day only.
Can someone help, please?