This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I use a sql database as the backend for one of my apps. A while back, I
had one of the fields set up to accept too few characters. The users got
an error, I fixed the issue in the sql table, it was fixed when they
synced up the next time. Well, it lo...
I have a series of apps that have worked great for several years. I'm
connecting to a SQL database using SQLServer. There have been no changes
to the DB structure or administration, and no changes in Appsheet, but
in the last few weeks, I intermitten...
I'm trying to set updates permissions for a table using Current_User
slice guidance. I have used two suggested formulae from various sources
in the community but I get the following error (edit for clarity) during
sync:The following formula versions ...
I’m making an app for educational coaches to track how they are spending
their time each week. I have the UI set up just how they want it. The
coaches have sliders for 5 categories. Each Friday, they use the sliders
to say proportionally how much tim...
This seems like foundational stuff, but after trying to figure it out on
my own all morning, I will just bask in my newbie-ness and ask for help.
I have a Schools table and a Staff table. The Schools table has all the
addresses for multiple schools (...
Update to say that I was able to use Recovery Mode to save all the data,
then reset the user's app without incident. We're back in business.
Thank you for the replies!
@WillowMobileSys We followed the steps on the article you provided and
we're back in business! Thank you once again for getting us pointed in
the right direction.
Thank you so much for finding that! I will share that with our tech guys
Monday morning and will report back if it works. Either way, I really
appreciate the help!
Welp, I figured this out. Posting the solution here in case it will help
any other newbies such as myself in the future.I was testing this in the
app preview mode and was switching users using the "Preview App as..."
feature. I should have read the h...
Replying to say that I still can't get this to work after tons of
research and experimentation. The following expression provides the same
result: The app behavior is correct (allowing or disallowing edit
access), but I get the same error on sync.
