Problem with ref rows

AppSheet AppSheet Q&A
1

Hi, this is an example of muy problem :

I have 2 tables

Table Persons : with fields id_person, name, profession

Table Photos: with fields id_photo, id_person, PHOTO. In this case for id_person I used the REF type and reference to Persons table.

My problem is that I have an ADD PHOTO button , but I only need that this button is active only if the person has the “photographer” profession. It means an architect or a doctor are not allowed to take any photos with the application.

I tried a lot of expression in the Add button behaviour but nothing works well.

Thanks.

2

Sorry for my bad english. I need the ADD photo button only in the case that the person is a “photographer”.

3

I found the solution.

for this problem, I need the “ADD botton action” asigned to the Persons table. For this action I used the behaviour [proffesion]=“photographer”. And finally the action calls the view “Photos_FORM” . Target= LINKTOFORM(“photos_FORM”,“id_person”,[_THISROW])

Thanks

1 Like