Thanks for the question. The ACF framework is not built to save multiple values to the DB for each field, only one.
The repeater field can handle multiple values because it adds an extra level of logic. This is why it is a premium add-on.
I would advise that you think about using a custom DB table to save all the data to. That way, you have full controll over the SQL.
Your field file has a function called update_value. This is where you can do custom SQL.
Also, the load_value function will allow you to read in the data through custom SQL.
Hope that helps.
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!
The ACF site is currently experiencing some issues.— Advanced Custom Fields (@wp_acf) September 21, 2022
We apologize for the inconvenience and we are working hard to get it back up and running as soon as possible.
© 2022 Advanced Custom Fields.