I'm having trouble figuring out how to auto-update a second dropdown based on the option chosen in the first dropdown, which is populated from a MySQL database. Additionally, I'm trying to autofill some dynamic table columns and add them up based on the selected item in the dropdown. It seems like I need to convert the dropdown values into an array of objects that is accepted in a table format, but it's proving to be a challenging task.
Additionally, the selected item from the second dropdown will need to autofill some dynamic table columns and calculate their total. The table should also add a new row once a new item is added. To achieve this, the values in the second dropdown should be in the format accepted by a table, which is an array of objects.
One way to approach this is by using a sample app like Appsmith, which provides a similar concept that can be adapted to fit the specific requirements of the project.