Hi all… I need to pick the brains of the smart people out there please. I need to do something and I figure Glide can do it but I’m just after the best approach to how to do it, so I thought I’d ask before I head down the wrong track.
Firstly, this will be on the Glide Free plan.
Think animal database where each animal would have a foster carer assigned. This carer can change depending on stage of development or whatever. There is a field in the animal table for the current foster carer but I’m after starting to keep a history of each foster carer that is involved in an animals development. Initially I thought, oh well I’ll just create a table… but then I thought do I really need to do that? Is it possible to just have another field (or two if calculations needed) in the Animal table that would just keep appending a foster carer name then the “Foster Carer” field is changed. I hope that makes sense how I described it. I don’t imagine it would be many carers, likely 3-4 absolute maximum but generally two.
Just after advice on the best way to approach this please 
If ordering isn’t a concern, I would just have a field to store all carer’s rowIDs, then convert it to an array and do a relation to show carers in a collection.
If ordering is a concern (say you want to know who was assigned 1st, 2nd, 3rd and 4th), maybe you can have an action that would set the ID to the 1st column if 1st column is empty, 2nd column if 1st is not empty, 3rd column if 2nd is not empty, and 4th if 3rd is not empty).
Thanks for this. No, ordering isn’t a concern so I’ll have a go setting up your first suggestions.
1 Like
Apologies, can I please pick your brain a bit more as I’m having issues making this work.
I have a text column called “Current Foster Carer”. This gets updated by users as needs be from within the app.
I created a new array which got the value in the “Current Foster Carer” text field. I called this “FC Array”.
I then make an append array thinking I could say add “FC Array” and “Current Foster Carer” together, but whilst it does that, when I change the Current Foster Carer, it obviously then changes the “FC Array” with the new Carer so this array just ends up with the same person, not both people.
I’m not sure where I’m getting it wrong and how to fix. IF you’re able to please shed any light, I would really appreciate it.
I’m obviously missing it because every time I try I keep being told I can’t do it as I’m making a cyclical connection. I just want a history column that appends whatever is in the Current Foster Carer to it. So if Current FC says A, then History says A. If Current FC is updated to B, then History says A, B. If Current FC is updated to C, then History says A, B, C.
I’m sure once I get this I will slap myself and say of course, so simple, but right now it is doing my head in
You need 4 columns:
- A Multiple Texts column. This will store your history.
- A regular text column. This will store the ID of the current carer.
- A user specific text column. This will temporarily store the ID of the new carer.
- A Make Array column. Use this to create an array from your history plus your new carer (1 & 3 above).
When adding a new carer, start by writing their ID into the user specific column. Then use a Set Columns action to write the value of the Make Array column into the history column.
Thank you. I will try this but what is a multiple texts column? I see multiple files and multiple images but not multiple texts
oh, it might not have been officially released into production yet.
Never mind, you can use Multiple Files. It will work in the same way.