Problems with Show if - Page 2

Denis2 · 04-17-2019 01:25 AM

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?

Denis2

Great I hadn’t spotted that. Maybe my last question - I can’t get the About page as my start page.

Many thanks again

Kirk_Masden

Perhaps I can help with this one.

In the image I’m attaching, I think you can see “Start with About” just below the view I have chosen to start my app, which is “Welcome.” On my app, “Start with About” is off, but I think all you need to do is click on the toggle to turn it to “on.”

Denis2

Hi Kirk and thanks,

Unfortunately, it doesn’t seem to work. See my screenshot attached…

Kind regards,

Denis

Josh_Axmacher

Denis, start with about really means the first time you open the app on a device. If your thinking it will happen when you sync in the app editor, it won’t…unless maybe you reload the AppSheet editor. If you have selected that switch, it will definitely work. An easy way to test is to open your app on another mobile device while your editing.