Unspecified "Error" When Updating Row from Action to PostgreSQL DB, Working in Builder not in Production

Ask for Help
1

Hello Everyone!

New to Glide but experience with no code tools like it. I am working on a project where with a button I am updating one of the columns in a row. The column is named ‘case status’ when the button is clicked the status is changed to ‘Open’

Here is my action:
image

Currently the button is in a button block but I have tried out of the block and am experiencing the same issue.

The data source is NOT a Glide table but a PostgreSQL database. In the editor the button works without issue but in the published application I am getting an error message with no explanation or idea of how to figure out what the error actually is. Here is what the error message looks like:
image

Big thanks to everyone in advance!

2

Not sure why this would happen. Is your SQL table a read-and-write table, or a query table?

3

Thanks for the reply @ThinhDinh !

This was my initial thought. I checked the permissions of the users at the database level and it has access to every function as shown below:
image

I understand if the permissions I would not be able to update rows in the builder either but in this case I can ONLY update the rows in the editor and not the shared app.

4

I was referring more to how you construct your table in Glide.

You can check the two sections: “Creating a read-and-write table” and “Creating a read-only table with a query”.

5

Oh yes! The table is a Read-and-Write table.

6

Then I’m not sure what can cause the error. Maybe you can try submitting a ticket.

7

Thank you again!
Submitted a ticket yesterday, waiting to hear back. Did it through the portal! It’s a business team.

1 Like
8

Please report back here if you hear anything from them. Thank you!

9

If anyone in the community has a line on the Glide support team please let me know.
If the platform can not properly support DB connections I would like to know this before it’s too late into my billing cycle for the Business plan.

Thanks!

10

@NoCodeAndy can you check this case? Thank you.

11

I’m having a similar experience. I can’t add a row manually from the data editor and I can’t add a row from an action.

12

This certainly seems like a glitch or bug.
I spun up a different DB and connected it and had the same result. I also know that there is no issue with permissions on the DB side because I can perform all DB activities from other tools.

Did you reach out to support, if yes, any luck?

I will keep this thread posted for updates if i don’t cancel the membership and move to Retool…

It seems that support just isn’t really there.

13

I’ve raised this with support.

1 Like
14

Support contacted me this morning. Still waiting for a solution. Will keep you updated.

15

Support reached out to also asking questions that were clearly stated in the initial support request. Followed up and no answer since 7:03 AM.

Will keep this thread updated on the resolution if any.

16

I’ve had similar experience - Followed up again via email.

17

@david can we get someone on support to update us today?

18

I’ve raised it with support again.

19

Hey folks,
Support is looking into these issues and will follow up with each of you individually.

Thanks for your patience.

20

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.