I have a system whereby I have a popup menu when right-clicking a data grid. In the menu, I can enter the name of a database table to link the data grid to, and another for afterward dropping a label / field combination as a group onto the card which itself is then linked to a column in that table. This makes creating forms based on database columns MUCH easier. In my data grid library selectionChanged goes through each of these linked fields and populates them with the selected data. The groups, labels and fields are automatically named according to the table column at the time of creation.
So to your point, thoughtful design and preparation on the front end reaps a harvest of time on the back end. Bob S On Mar 23, 2021, at 8:04 AM, Andre Garzia via use-livecode <use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com>> wrote: You advice to look for areas of friction in your workflow really relates to an experience I had recently. For a new project I had to make lots of fields with lots of labels and changing the text of a label takes way longer than it should. Finally, after years of grumbling to myself that this should be easier I created a handler that I added as a behaviour to a template label field. Basically it allows you to set the text of a label by double clicking with the browse tool on a text label field and then entering the text in an answer dialog. I could then option drag the label field template and then change its text with a simple double click. As a bonus I could set it to align left by holding the option + double clicking the label field. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode