Just wondering how others would handle my situation. I have a form that I need to add a dynamic field to, then allow that field to be sorted ASC and DESC. My Form is set to “Multiple Records” so it looks a lot like a grid.
I understand why I just can’t add the field and have it do a lookup in the Event onLoadRecord then sort on it.
I can write an SQL query that dynamically creates the column needed… but since its a form I can’t edit the MySQL that it uses to select the columns.
Anyone else have a creative way of doing this other than on a grid?
Thanks!