I am really confused. I enrolled with Appster Pro in order to try to have more success than with Grok or GPT, which seemed to work. I am really at a loss at the moment though, trying to limit someone from accessing my app if I change their status to Former. If I do that, it removes their lines from the admin filter, which I don’t want. I just don’t want someone labeled former able to access the data any more. Appster told me to expand the filter to include roles, including Admin. When I do that, it crashes the app. I have done everything I can think of, on my own and with Appster, but to no avail. If I remove the role out of the formula, it works fine. If I just put the role in, it crashes. I am using a Current_User slice like appster had me do. The filter for roles works fine on any slice and view filter, just not security. This is the formula that breaks security: INDEX(Current_User[Role], 1) = “Admin”. it doesn’t work with any other role or making it <> instead of =. Can anyone please help? From what I can see on my end, it looks like this should work. Thanks!!!
Update: I added a new table completely and the security filter works perfectly for it, but still crashes my Profile table if I try to use it there. The full filter in question is OR(
INDEX(Current_User[Role], 1) = “Admin”,
[Status] <> “Former”
)
Additional Update: I could not get this to work at all. I have deleted everything and am starting over again. Thanks but please disregard if you got to this as nothing is there any more LOL.
hmmm definitely weird, most likely with something else really causing the issue.
- Did you ever figure it out?
Nope. I never could get it figured out no matter what i did. i kept deleting one view and slice at a time from the most recently created to the oldest thinking i would eventually find the one that had the issue. I deleted, then added the filter back in. It crashed so I deleted the next and added the filter back in. I got all the way back to the beginning so I figured I had something messed up royally somewhere so I started over again. I want to get the app going so badly and want to move forward, but also know I have to do it right. I keep looking at starting over as just my schooling since I totally taught myself how to use this starting about a week ago. It’s frustrating but each new restart allows me to figure out more and find better ways to do things, so though frustrating, it has been helpful. I just wish I could get someone to talk through it with me for an hour or two as I feel it would be so much faster than AI teaching. Appster is great, but still AI and doesn’t always handle things and understand like a human would LOL.
Yeah. Just re-encountered the same problem again trying to add security filters to the profile table. Built exactly the way that Appster instructed but still cannot get it to work. Very disappointed and discouraged! I really was hoping that Appster would be what I needed to get the app to work.
Yeah sounds like a very organic software development journey, which AppSheet is well suited for.
The thing that you’re trying to do is fairly straightforward, and most likely it’s just that there is a fiddly bit not quite what it needs to be.
What you might try is to start over and create a very simple proof of concept:
- A user table
- A data table, with a few records inside it that have different user IDs
- A current user slice
- A security filter on the data table, limiting the data to only that for the current user
If you set up a simpler test like this, it’ll be more straightforward and you should be able to see how all the pieces are supposed to align. Then once you have this done, you can compare how this is different from what you have on your other one…and usually for me that’ll allow the differences to pop out, and I’ll be able to see that I did something differently and then put it right.
______________________________________________________
Apprentice Program
If you’re really interested in learning more, I have an apprenticeship program where we will meet once a month, you can schedule other meetings, we can email back and forth, and really start to get a grasp of how to be a power user with this platform.
You can learn more here: https://www.multitechvisions.com/apprenticeships
Wait….. are you trying to add a security filter to the user table? As in, only show me the record that matches the current user slice?
- If that’s what you’re trying to do, it’s never going to work
If you think about it:
- The current user slice is the user table
- You can’t use the table that you’re trying to filter as the filter for that table.
It’s like a cycle
If you are wanting to restrict that user table, or I think you called it the profile table, so that it only loads the one record that matches the current email…. You would essentially do the same formula that you have in your current user slice, but use that as the security filter instead.
- Keep in mind, this removes all of the other user records from the system, which might have unintended effects
- Or maybe that’s exactly what you want, and it’ll do exactly what you’re looking for.
Anyways, I just noticed that and thought I would point it out.
My brain is so jumbled right now I’m not sure if that is what I need to do or not anymore LOL. That’s kind of what I’m doing. I have everything in one user table named Profile. This stores their user and office details/profiles. I have the user slice set up to match user email against this table. I have roles and statuses there. Admin can see and edit anything, including their own records. The other roles can only see their own records. I have a delegate role that plays into this that lets someone grant someone else permission to access and add/edit their records, but not the profile table unless it is their own. A status of former should not have access to anything in the app regardless of role. I get the functionality working but can’t get the security settings working.
Can you show us what your security formula looks like?
Sorry. I just now saw this. I finally got it figured out. All the AI’s, including Appster kept telling me that I could use the Security Filter in order to block users. It does not block users. It only filters and I finally understand that now. I got it all figured out by playing with it some more and then doing some other experimenting. Once I got it figured out, Appster has been phenomenal in helping me. My problem now is that after I spent so much time figuring out the problems with the security filter, it used up all my month’s worth of tokens (or whatever they are called on here). I now have no more access for the rest of this month. I tried going back to Grok, but it is so frustrating. I spend more time correcting it and trying to teach it than I am getting help. Is there any way that I can pay another $10 now and get another month’s worth of work from Appster? I feel like I am to the point now where I can actually make some incredible progress if I can just continue where I left off.
@Bradiskey Are you saying that you can’t start a new thread in Appster chat?
- Looking at the logs:
- I can see you’re using Anthropic
- It looks like you’ve got a very long conversation (169+ message)
- I’m betting you’re reaching the anthropic API limit
- You can only send so much to the API before it just say, “No more!”
Try starting a new conversation about the same topic.
Start a new thread and explain the situation to the ai at the start; as long as you give it a good understanding of what’s happening, what you’re trying to do, what things look like, where you want to go… a new convo can usually help get this info out of the Ai faster.
- Usually this helps the Ai give you better answers because you can zero in on the topic you’re focusing on
- There is a concept called “Context Rot” that deals with an Ai’s ability to answer well when the context gets longer
- I’m currently writing a blog post about this, will post a link here when i’m finished.
It won’t let me start a new thread either. I get this message on one of my old threads or a new one. This is from a new one. It does say I exceeded my limit, that was why I was wondering if I could pay the monthly fee again now and get it reset?:
Error Details: Error: Error with UrlFetchApp:
Error: Error from OpenAI API: You exceeded your current quota, please check your plan and billing details. For more information on this error, read the docs: https://platform.openai.com/docs/guides/error-codes/api-errors.
at get_embeddings (embeddings:58:13)
at add_resource_context_to_prompt (Supporting Info:9:29)
at enhance_prompt (Scripts:194:18)
at GS_INTERNAL_top_function_call.gs:1:8
@Bradiskey try again now
It’s working again! Thank you so much!!!