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.
This topic is locked and no more replies can be posted.
