I’ve been trying to create an invite system that allows people to see private/secret items in the shop and order them but only if they’ve been invited. The flow should be: Private item is created. It does not show up for anyone in the “things” list. Creator of the item shares invites with people …

This didn’t work: I tried to implement it by adding an “invisible” boolean column to each item that is user specific. I’ve been trying to make it so when a user types in an invite code to a separate form they toggle that boolean. The list of things doesn’t show any item that has boolean set to true…

There could be several different ways to do this. Here is one way that should be fairly straight forward to implement: Ensure that you have a text column in your Items table to hold the “secret code” for that Item In your User Profiles table, create a text column to hold a list of entered “secret …

[image] Darren_Murphy: In your User Profiles table, create a text column to hold a list of entered “secret codes” for each user See I tried this initially but I wasn’t able to figure out how to do a list in which every user keeps adding codes. Just giving them a big text field in which I say…

[image] Prospero: I couldn’t find a way to just append a list or a text blob in glide. You can do it like this: Present a text input component that prompts for the code, and target that at a User Specific column Create a template column that takes the current value of the “Secret Code” list…

by a code stored in the apposite table. you must create a relation from the screen field (user column field) to that table and set the ITEM visible if the field and the relation are not empty (that means as soon the code will be correctly introduced, the items will be visible to the visitor only). …

[image] Darren_Murphy: You can do it like this: Present a text input component that prompts for the code, and target that at a User Specific column Create a template column that takes the current value of the “Secret Code” list, appends a comma to it, and the value of the User Specific column C…

[image] Prospero: IFTHENELSE columns are userspecific by default? I don’t see the option to make them but they seem to work that way. I remember computed columns are calculated in the frontend but I thought that wasn’t the same thing as being user specific. Not by default, but as soon as they…

[image] Darren_Murphy: Not by default, but as soon as they reference a user specific column then they become user specific. The same applies to all computed columns. It’s impressive that it propagates all the way from the single invite code input column. That’s the only user specific column …

[image] Prospero: I’m probably going to have to flush the invite list every once in a while but it’s not a huge concern. Any idea what the character limit is on a simple text column? I’ve seen it mentioned, but I can’t quote it off the top of my head. But it’s ridiculously high - maybe millio…

[image] Chat and Comments using the Trebuchet Method Project Showcase According to @Jason you can store 1 million characters in a glide table cell. Google sheets limited to 50,000 characters per cell

Invites to show private items to order (like secret menu)

Ask for Help

ThinhDinh November 2, 2021, 12:12am 11

Topic		Replies	Views
Session-based invite codes for users without sign-in Ask for Help	17	155	November 5, 2024
Hide specific items from specif users Ask for Help	4	259	September 22, 2022
Conditional Component Visibility for User Specific Columns Ask for Help	7	909	July 10, 2021
User Specific Columns + User Profiles Demo Community Resources tutorial	89	5240	May 31, 2020
"IF" and "Lookup" in glide Ask for Help	11	1411	June 9, 2021

Invites to show private items to order (like secret menu)

Related topics