About Patrick_Paul

Patrick_Paul

I have a table that has a ref into it from a Google Calendar data source. That ref has the "is part of" attribute checked. When security filters are not on for the Calendar data source, everything works as expected. If a user deletes the "parent" rec...

Patrick_Paul

OK, so I've wasted over an hour trying to figure this out using Appsheet documentation. How on earth can I use images stored in Google Drive with Appsheet "show" columns? I have a form that I need to display images in as a visual aid for users comple...

Patrick_Paul

I wasted nearly 3 hours today to figure out that for some ungodly reason, if you put the text "Technical Preparedness Review" (which is what we call a certain time of report) in an automated email process subject line in Appsheet, it doesn't generate...

Patrick_Paul · 03-04-2024

Hello all. Often I come here to ask questions, but today I thought I'd share something I came up with that may benefit others. As many of you may know, Appsheet has a Google Calendar "integration". I needed to create an app that could manage Google C...

Patrick_Paul · 02-15-2024

The DateTime column type is, by default, kind of unfriendly for users. Even without setting an initial value, the widget defaults to the current day/time, which isn't so bad except you inevitably force a user to deal with fiddly stuff like setting th...

Patrick_Paul

Sorry if this is information overload, but I'm desperately trying to solve this today. I found that if I change the security filters to simple "=true", everything works. So it's not the mere presence of a security filter messing up these bot processe...

Patrick_Paul

To add to the confusion, I have now found that having the security filter on the *parent* table for some reason prevents certain things from occurring as well. For instance, the deletes work fine if I remove the child table filter, but I have another...

Patrick_Paul

I'd prefer to only do that as a last resort. The last time I filed a support ticket, support edited my app without my knowledge and caused more problems than they solved at first.

Patrick_Paul

I have now gone even so far as to create a bot that deletes related calendar events upon parent record deletion. I checked "bypass security filters". It won't work, either.

Patrick_Paul

It's worth noting I have a security filter on the parent table as well, which is:useremail()=[Creator]It seems to have no negative impact on its own. Is it possible there's some kind of interplay between the two filters?

My Stats

Patrick_Paul's Bio

Badges Patrick_Paul Earned

Recent Activity

Security filter stops auto-deletion of child records??

How to use images in Google Drive with Show column

Glitch with email automation subject line

Creating a calendar of events in Appsheet that puts them on Google Calendars automatically

Restrict user input DateTime field to 15 minute intervals and default to the top of the next hour

Re: Security filter stops auto-deletion of child records??

Re: Security filter stops auto-deletion of child records??

Re: Security filter stops auto-deletion of child records??

Re: Security filter stops auto-deletion of child records??

Re: Security filter stops auto-deletion of child records??

Patrick_Paul's Ideas (1)