I have several columns Category 1, Category 2, Category 3… and Glide automatically creates a concatenating column that brings all the Categories together in one cell. This is very useful, as I can create relation columns based on this automatic column. The problem is this column doesn’t update…
For example:
Category 1 Category 2 Category 3 --> Concatenating automatic column
Music [empty] Art Music // Art
If I change the values:
Category 1 Category 2 Category 3 --> Concatenating automatic column doesn’t update
[empty] Economy Art Music // Art
Another example in the images attached: I changed the values in the columns and the values in the concatenating column haven’t updated.
Could it have something to do with Category 6 and Category 7 have “&” in them or spaces or the '. See if you change that temporarily to see if it makes a difference.
I’ve just added values in 3 more rows and they don’t show up in the concatenating column… it just sticks to the values that where there when it was first created.
I think it’s because the columns Category 1, Category 2… have a formula. If they are normal fields where I write the Categories, the concatenating column updates.
Does this mean automatic concatenating columns don’t work if the reference columns have formulas?
I must be the one who is missing something. How are you creating the relationship now. What I was proposing was to do the exact thing you were using the Glide Template feature to do, but do it in the spreadsheet. Were you using the Glide Template feature to concatenate those columns?
Oh wait, now I get it. I have never used that feature for anything other than images. I didn’t know you could then use it for a relationship. I assume under the covers it is creating an array. Humm, I guess I need more information as to what you are trying to accomplish.
Yes, I would like to use it as the reference for a relation column. It works fine, but only when the values are manually inserted, and not by means of a formula. It’s a great feature, if only it worked with formulas…
So, here’s what I need:
I have a sheet “New products”, where I list the new books that arrived to the bookshop. There’s a column “Categories”, where I classify each book (up to 5 themes, separated by commas). Then, I split this column into 5 columns (Category 1 / Category 2…) - Glide automatically creates a concatenated Categories column.
Sheet “Users preferences” is where users choose their favorite categories - I’m using a checkbox field for this, and the columns names are the categories - “Anthropology” / “Architecture”… Then, I have columns “Category 1” / “Category 2”…, with the formula if(E2=TRUE,$E$1,""), that pulls the columns’ titles if they’re checked. Glide automatically creates a concatenated Categories column, and I was using it to link this sheet to the first sheet, “New products”. But since this concatenated column doesn’t update if the reference fields are formulas, I can no longer establish the relation…
So, what I’m trying is to make a link between the users preferences (the favorite categories) and the newly arrived books.
@George_B, I closed the google sheets and the glide tabs in the browser and reopened them and everything is working as it’s supposed to after all - the automatic column takes formulas and all the relations are there. I guess we just have to reload everything for it to update!
Interesting. I hope it continues to work. I’m actually surprised that it is working at all but then again I learn something everyday about Glide and Google sheets.
Hmm, if u need to give your users the new arrivals based on their preference here’s how I would do it.
Give your users their own “new arrivals reference column”, based on every category.
NAFiction=Newarrivals:Category:Multiple
NABiography=Newarrivals:Category:Multiple
And so forth.
So if u have 10 categories you will need 10 new arrival reference columns.
For each column you will need to run an array formula that searches their current preference and if it’s a match, “category”, if no match then " nomatch"
2 create a sheet called “Newarrivals” that runs a query against your booklist called new arrivals, you can add filter in your query to pull only books less than 30 day added or whatever you prefer. Based on a column that calculated how long the books have been added.
For your just arrived tab use your users sheet.
Switch layout to detail view and filter by user email.
5.add the inline or reference link for each “new arrival column”
Hide all other details about user so only the references are shown
What will happen is any books that are in your new arrival sheet that matches the user preference will automatically be seen otherwise it will be hidden.
You could additionally put a link for all arrivals so you don’t limit them too much.
Hope this helps
@Lighted_Candle, thank you! The problem is: in the New Products sheet, each book has a Category column where up to 5 categories per book can show up, separated by commas. There’s then 5 columns - Category 1-5 - with a formula to split those categories.
So, each category relation column in the Users Preferences sheet would have to relate to each of the 5 Category column in New Products. I can’t understand how to do this…
