I am trying to build an admin screen that lets the user set variables that are stored in multiple tables. The only way I can see to do this is set up a tab for each table then create action buttons that update the table that the tab is built from.
Surely there is a simpler way to do this. For example I have a “Cars” table that the user selects from for each order. a boolean column in the table is used to filter out car numbers that have been selected so the same number can’t be assigned twice.
The app needs to reset these values all to false each weekend when the process starts. Ideally I’d like a way to reference multiple tables from a single admin screen. the cars reset is one table, I also have an orders table that needs to be reset each week. There is also an admin settings table i use to establish values that determine how many items are available each week for the food bank.
so at this point i have 3 tables and would like to provide access to all 3 tables from a single tab.
I get that but my challenge is there is no matching data to build a relation on. e.g. my cars table is just rows 1-n of the car number. The admin tabel i am using just stores variables used for filtering lists, etc. The data is disconnected in other words so i don’t get how to build single relations.
I will check out whole row column - that’s new to me. If there is an existing thread on this let me know.
But What I would love to see Glide offer is a simpler way to access multiple tables from a single tab. I’m sure there’s a good reason for limiting a tab to a single table but it makes things difficult.
It’s pretty straight forward, and the result is essentially the same as a Single Relation.
Because the Single Value column allows you to target N from start, you can point it directly at any row in any table. I generally have a whole series of them in my User Profile table - one for every helper table - and this allows me to set values and navigate to my helper table screens from anywhere in my App.
It’s because screens and tabs are bound to tables, so by default the only columns available are the ones in the bound table. But there are plenty of ways to get at other tables.
Thanks for the info Darren. Watched Robert’s vid - looks straightforward.
One of the “admin” functions I need to offer is a way to reset the boolean values in my cars table. Each week the the car rows get selected as a client is selected and i just flag that row as used.
I need to offer the admin a way to reset all the booleans in the 25 ish car rows to false.
I found Advanced Multiple Row Reset Concept and this seems like exactly what I need o do. my bonehead question is how can i view the tables of the sample apps that gliders link to? i am only able to run it…
Yeah, those Apps are very old and can’t be copied.
Although the technique is an old one, it’s still extremely useful today, and I use variations of it in almost every App that I build. One of these days I’ll make a new template to demonstrate it - but not now
In the meantime, for your use case it would work something like this:
Add two user specific text columns to your Cars table. Lets call one parentID, and the other one parentIDSet
Add a Single Value column that takes parentID and applies it to every row
Add an if-then-else column:
– If Single Value ParentID is parentIDSet, then true
Your if-then-else column will replace your current boolean column, and it will be what you will show on the screen.
When you want to select a car, use a Set Column Values action to change the value in parentIDSet to match the value in Single Value parentID
And when you want to reset the whole table, use a Set Column Values action to change the value in parentID to a Unique Identifier.
If you are asking me - I followed Darren’s guidance and made my columns user specific although I think I need to change that as there will be several users selecting cars and I need the selected cars to be removed for all the users.
oh yes, if multiple users need to see the status then you should not use User Specific columns.
What Thinh was getting at is that if your plan supports scheduled workflows, then that could be another option for resetting the column.
Yet another option could be to use the Glide API. Here is a video I made a long time ago that shows how to do that.
PS. In that video I use templates and a joined list to prepare the JSON payload. I’ve sinced learned better and I wouldn’t do that now. The correct way to do it is with a combination of JSON Object, Query, Lookup & JSON Template columns
