Hi Darren,
Thank you, I’ve added a sequence construct and a new field to store that sequence number and also added that table to Glide selecting that field as the unique row id. I now have a number of SQL tables listed in Glide. Then I added an extra field to the users table which will allow me to relate the users table to my own expenses table (so that only records for the logged in user will be displayed). Next I added extra columns to my main expenses table to specify the relationship to other tables (jobs, expense_type, users). Now I want to start with a screen that actually shows a summary of expenses based on their status which I would normally use an aggregate query for. My issues so far are this:
-
Writing a bespoke SQL query to get the aggregate values is no problem but how can I include criteria to limit the results to those for the logged-in user? Can I refer to a current record in the users table? I’ve added a field called employee_login to Glide’s user table which matches a field employee_login in my expenses table and I’ve edited the users table row which has my details and added the employee login value which just happens to be “MARTIN”. Right now I’ve hard coded my employee_login value in the SQL.
-
I have created this first screen using a data grid and this looks fine but I can’t see how to allow the user to select a row which would lead to another screen passing the unique row value which would then display expenses with the specific status? Strangely at the bottom of this first screen it has “+ users” at the bottom right and the name of the current page at the bottom left. I have turned off editing/deleting since an aggregate of course. In addition, how it is possible to format a value as a number with decimal places (but not with any currency symbol) and right align? Could a total row be added?
Thanks,