How to create an visibility for this

[Manikandan_R]

Hi,

Have created a form to fill data in business owners table has shop name,shop no and address and email.

Now i have data in business owners table.

I have a business owner tab showing the business owners table data for that business owner in the app and also floating button to to send advertisement datail ,so that the advertisement detail gets updated every month.

Now if the business owners email is there in the business owners table,it should show the tab and floating button.how ?

i need this tab visibility conditions to be create anfd how to create?

[Dilon_Perera]

Hi @Manikandan_R,

So you have a Users table/sheet and a Business Owner table/sheet and in the Business Owner table/sheet you have a email column to identify who created the record. And now you want to show the tab and the floating button if there’s a record that user ( business owner ) created on the Business owner table/sheet?

You can create a relation column on the Users table/sheet as email column to business owner table/sheet email column and make it as multiple ( enable the checkbox ).

And create a rollup column and connect the created relation column to get the count of that relation! Then for the floating button and for the tab you can add the visibility condition as User Profile > Rollup column > is greater than > 0 ( You can add the condtion as the relation column > is not empty but I like to do this with the count ). If it’s 0 that means there are no records in the business owner table/sheet for that user’s ( business owner ) email.

If it’s not 0 floating button and the tab will show which means there’s a one record or many records in the business owner table/sheet for that user’s ( business owner ) email!

And I think you don’t need to put the visibility condition on the floating button because after you put the condition for the tab then the full tab is hidden including the floating button. If the floating button is on another tab or screen then you need to put.

Thank you

[Manikandan_R]

Sorry,I’m not looking for this.i will send you a detailed one with screen shot in a new topic.

Thank you.

[Manikandan_R]

Posibility of doing this

Hi [a1.PNG] This is my front page,it has a form button “To Advertise…click here” ,it moves to getting shop name,shop no and address. [a2] Email gets filled by the logged in user email. The form button should created rows in business owners table such as shop name,shop no,shop address and email. [a3] If that email in business owners table its should show the business owner tab and also the floating button.other users shouldnt show the floating button and business owners tab. The floati…

Hi,

This is what I need.