How would be the best way to approach taking the results of a join to populate dynamically created fields, while also leaving open the ability to delete items/fields or add fields for more items?
For example:
Database 1
Bob
Database 2
1 Red birds
4 Green birds
2 Blue birds
In a form, the results of the database query would dynamically create and populate a field for each bird entry, as well as Bob. But we could add a fourth field dynamically and enter Grey Bird. Or we could delete the field and info for Blue bird, or change the quantities of each.
I figure it would involve a loop that counted the returned results - but translating that over to actual fields in CCv6 is where I'm a little stumped. Adding fields dynamically too - normally javascript, but does CCv6 have a mechanism by which I can do that?
I am getting some inspiration from the Dynamic Actions example, but want to make sure I'm interpreting it correctly and heading in the right direction.
For example:
Database 1
Bob
Database 2
1 Red birds
4 Green birds
2 Blue birds
In a form, the results of the database query would dynamically create and populate a field for each bird entry, as well as Bob. But we could add a fourth field dynamically and enter Grey Bird. Or we could delete the field and info for Blue bird, or change the quantities of each.
I figure it would involve a loop that counted the returned results - but translating that over to actual fields in CCv6 is where I'm a little stumped. Adding fields dynamically too - normally javascript, but does CCv6 have a mechanism by which I can do that?
I am getting some inspiration from the Dynamic Actions example, but want to make sure I'm interpreting it correctly and heading in the right direction.
