I am trying to create a report which sorts the data by certain columns, I am happy to share my app with anyone who is willing to help but I have been working on this for days and am going a bit
It is an app to be used to collect information from real estate agents about their upcoming, current and future properties. I have set the app up so it is all in one table, the agent makes a new entry for each property and the type selected jumps them to the relevant questions. Would this be better set up in a different way?
With the report I want to group and sort the data first by agent, then property type (e.g. upcoming, current, sold, future).
I have been experimenting with the start and select expressions but just can’t figure it out!
Looking forward to getting some answers!