Can I do a count on a portal?
I have a voyage booking record with portal for contact booked on the voyage.
How can I count the lines in the portal?
Any help would be fab x
Count ( PortalTable::anyNonEmptyField )
which preferably is the primary key of that table, or the foreign key for the parent table, like
Count ( Booking::id_travel )
You can also create a summary field in the portal table with 'Count of' and place that as a related field on the layout with the portal (but outside of the portal, since you only want to see that value once).
Thank you so much, I will give it a go.
I have to perform the count based the amount of contacts booked on a booking ID
So I have a contact table with a contactID and a booking table with a bookingID. I have a join table to deal with this. as seen below. How would I write this count please?
Well, why not try the second approach?
In the join table, create a new field of type summary and define it as 'Count of': join_ID
Then put it under the portal from your first screenshot.
Thank you so much for your help, I have managed this with your help.
Retrieving data ...