Hi, I have an app that has different categories. Each category is launched from the same page, but would have different data. The title and images display unique, but whenever I change the content on one page (inline list) it updates all of the pages with the same information (which may or may not be relevant). How do I get each page to show information related to them without affecting the other pages?
If they are pointing to the same sheet that is the normal behavior. What you need to do is create sheets that essentially clone the data from the other “main” data sheet. Something as simple as this would work:
={Sheet1!A:Z}
Or you can do more complex copying of the information with a QUERY() or many other functions.
This is a common question. Check out my response to the thread below. One thing I always mention is that layouts are tied to sheets so if you are making layout changes to one item in a list, it will affect all items in that list because they are all part of the same sheet.
Thank you. I will try creating sheets for each category. Do you know how I would take a field with multiple responses (ie. what is your role, someone puts, designer, developer, founder). I would like their concatenated responses to display on their profile, but if I go to any of those categories I would like to see them listed there. Is it ok to have them multi-select on a form or should I be doing this another way? I currently had them doing a type form, but need to move them to another solution. Currently I can’t figure out how to do multi-select values in a native glide form. Thanks!
Thank you. I think this is my problem. I was using one big sheet and trying to manipulate that data in different views. Now that you mention it, the only ones that work properly are the ones that have separate sheets (like states). I will first try creating sheets for each category. Do you know how I would take a field with multiple responses (ie. what is your role, someone puts, designer, developer, founder). I would like their concatenated responses to display on their profile, but if I go to any of those categories I would like to see them listed there. Is it ok to have them multi-select on a form or should I be doing this another way? I currently had them doing a type form, but need to move them to another solution. Currently I can’t figure out how to do multi-select values in a native glide form. Thanks!
Glide currently does not allow you to multi-select in a choice dropdown. However even if they did the data most likely would be saved to a single cell, with some separator, and you would have another problem to deal with in how you display and/or filter the data. Somewhat based on what are you going to need or do with the information gathered you need to decide on where and how that data will be stored. Another factor that could affect the design of the sheet would be whether there are a lot of choices, the expectation of whether they would normally select only one or two, or whether in some cases they would select all 10 options. Based on the little knowledge I have in this case I would most likely advise you to maybe have 3 columns, call primary role; secondary role; tertiary role. If you can live with this, then you would have the roles in a settings table somewhere and 3 choice components that point to this list. The answers would obviously go to one of those 3 columns. That is just one way to structure it.
1 Like
Hi George, I’m trying to understand this one. Does that go on a particular field or somewhere else? Sorry for the late reply.
The formula is usually placed in cell A1 of a new sheet.
However, a lot has changed since February and you now have the option to independently design each item detail from a list.
