I have aProject tablewith a field called Building Name. This field is a dropdown, the choices are pulled from the Building table.
I would like the user to be able to select the Building Name and have the next column over (Building Address field, also from the building table) auto- populate.
We do have option to auto-populate next dropdown based on values chosen in previous one with "Powerful filter" Add-on but it doesn't work with foreign key relations at this moment. We are working hard to integrate all core options with Add-ons so please stay tuned for updates.
I have a Project table with a field called Building Name. This field is a dropdown, the choices are pulled from the Building table.
I would like the user to be able to select the Building Name and have the next column over (Building Address field, also from the building table) auto- populate.
Is there a way to do this?
Hi Sue,
Thank you for your purchase.
We do have option to auto-populate next dropdown based on values chosen in previous one with "Powerful filter" Add-on but it doesn't work with foreign key relations at this moment. We are working hard to integrate all core options with Add-ons so please stay tuned for updates.