Forums

Repeater Area, Mask and Save DB

rafaelscouto 01 Aug, 2019
Hi,

I decided to use Repeater Area and the Mask that was previously working, but stopped working what may have happened?

I saw that with the repeater it changes the name of the field.

As the field name changes, how do I write to the database?
healyhatman 04 Aug, 2019
You should call the repeater fields FOR EXAMPLE
education[{var:area_repeater#.key}][dateCompleted]
and
education[{var:area_repeater#.key}][nameOfCourse]
Then in your database you have two tables. One for the main data, and one for data that gets put into a repeater area.
Then in your database you would use a loop event to loop through {data:education} and save each row to its own data row, related to the first table using {var:save_data_action_for_first_table.id} as the foreign key.

Or you can use one data table, and use {data.jsonen:education} to save all of the repeater fields under one column as a json encoded array.
rafaelscouto 07 Aug, 2019
I do not understand how I can use this.

in the save event, how will it be because before I used it

{data: field_name}
This topic is locked and no more replies can be posted.