Had some more thoughts about this.
I’m trying to find a way I can do this which avoids a custom table, but which lets my client manage the table of data.
I realised that I can use the repeater field to capture the data and then query it in a template that spits out JSON. My templates can then query that JSON. So that’s awesome.
What would make this great however would be a select field that can be automatically populated with the unique key of the repeater field data, say Suburb.
That then creates the link between the lookup table (my repeater field) and the place where that lookup table is needed (say a page template for listing office locations for example).
The concept of a select field being able to be populated by an external source seems to have fairly broad application too.
What do you think?
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
📣 “ACF Chat Fridays”— Advanced Custom Fields (@wp_acf) January 31, 2023
The ACF team holds their first open office hours this Friday! Come and talk ACF, and ask questions about building sites with the plugin.
We’d love to see you there!
📆 Friday 3rd Feb - 3pm UTC
👉 Register here - https://t.co/3UtvQbE4CU pic.twitter.com/oTwW9K1XQ0
© 2023 Advanced Custom Fields.