I have a table linked to itselfA Lookup field type still works fineBut a Count field type always returns the value 1 when in some cases it should be more than 1
I have designed a webform from which I want to populate 2 tables - Families and Individuals. The webform could potentially capture up to 15 individuals. My Automation looks like this:
I don’t want the second conditional action to be “otherwise” - I ...
I have 2 tables - Families and Individuals, and I want to create a one to many relationship between these.
So I’ve marked fields in the 2 tables as linked.
I then want to create a webform so that external users can create records which give details o...
SeferianneThanks for your reply. So I have a "Members" table where we can have several members in the same family. I have identified a "Lead Member" in the family and have linked the other members to the ID of the "Lead Member" (so the linkage is fro...
Yes, I used to have a Families table, but I felt that made the whole thing clumsy and it also meant that you couldn't just have a single form.So I'll live with it as it is at this stage
AdamThanks for the quick replyHopefully you can see the above screenshot. So there are 6 records linked to the ID 66, and when you look up the first name of the "master" record, it returns it OK. But the Count field only shows 1 when it should show 6
kuovonne - I think I see it. When I tell it how to set a field value when I create a record, one of the options is to use the “Airtable Record ID” - that should work?
Thanks
Bob
