Hey guys, I would like to ask for some assistance on a possible way to do a check for unique items based on a date. I would use this result to hide conditionally, a button.
So your data structure now contains a date column, an item name column and a quantity column.
The easier way is to use a query formula inside Sheets.
Inside Glide, I would make a relation from the date column to itself, then count the unique number of item names/IDs. Would that work?
One solution on top of my mind is this. I assume you’re having a user profiles sheet.
Create a template column joining the user’s email and the current day (you can generate this via a math column pointing to “now” and select date only).
In the sheet where you store the submisssions, create the same type of template, make sure the date formats match.
Create a relation between the two columns in the profiles sheet, then a joined list column to return all submitted types for that day.
The choice component in the form would be filtered by “choice option name is not included in user’s joined list of submitted items for that day”.
For hiding the button, assuming you will only ever have max 2 submissions each day, do a rollup on top of the relation in the user profiles sheet. Show the form as long as rollup is less than 2.
Is the “joined list column to return all submitted types for that day.” Supposed to be on the Users Table?
If so I think it should only be returning one as I only have one goal set for the current day so far.
So is it good to go now? Let me know if I can help more.
THANK-YOU so much for the help.