Five Suggestions / Enhancement Requests

Support
1

I have a couple of suggestions:

1:
When a form’s table is updated, the form should be refereshed immediately, the way a data view with a live query is. My Reports form has the list sorted by Seq number field. It’s working, but when I pull up a record and change the Seq value (in order to re-order the list), I have to leave the form and then come back to it to see the changes. This is workable, but not intuitive. This is the very reason I had to create my own form page based on a Data View, because I added action buttons to “choose all” and “choose none”. The Join page just looked funny when I tap the “choose all” button and nothing seems to happen. Same when I re-sequence the list.

2:
Did you ever decide to implement MySQL’s innate ability to have a calculated field? This has been available since version 5.x and works very well. Five requires a bunch of code and functions in order to update fields which are part of the data needed for a calculated field. Example: Address is calculated by concatenating Street, City State and Zip, plus some punctuation. This is fine if maintaining the table via form, but not so good when updating the table via SQL.

1 Like
2

Hi Ron, thanks for the suggestions! We will discuss these with our product and R&D team to see how they can be added to our roadmap!

3

Another enhancement request:

It seems like alternating row background shading is a basic reporting feature. I would like to see it incorporated as a feature of report design. Vin gave me a reasonable work-around, which involves the report query generating sequence numbers for each detail record, then having a style which uses the sequence mod 2 to decide if I’m on an even row or not, then applying a background style on the even rows. This works somewhat, but causes first row of a continuation page to be shaded depending on how many records fit on a page.

Ideally, it should start fresh on each page, so first record has white background and alternating from there. It seems like a feature in template design for shading alternate records would be best.