I think that is the most straightforward solution. With a single button you can trigger all edit boxes to send their data and execute the script that handles the data. I would probably put every value in a homey variable. And let the button also trigger a flow that first waits a couple of seconds (to be sure the data is copied to the variables first) and then generates the new table based on these new values. You can create Homey scripts that handles multiple variables. Interesting topic about that:
Some remarks on this:
I have not optimised dashboard studio for keyboard use. Always intended the usage with touch screens or info screens. Couple of problems that might arise: tabbing to controls are based on creation time. So you need to create the edit boxes in sequence of tabbing. Also buttons / sliders are not keyboard friendly. You can not tab to a button and press to execute it.
Might add improvements for this later (option to set tabbing order, and keyboard controls for buttons menu’s, sliders etc). But for now, you are limited to mouse / touch control.
Do you do this all on your Homey? (is there a MySQL app / server?) or do you handle this externally to a nas / server or cloud like that “Powerapps”? (Just interested, you do not have to explain in detail)
