About GreenLee

GreenLee

I'm running into some trouble importing some store orders via REST API/Google Apps Script. I have three AppSheet Database tables - Listings, Orders, & Line Items - where Line Items will reference the key values of Listings and Orders. I am able to ea...

GreenLee · 02-15-2024

I am currently trying to create two columns in a MariaDB table to hold two drawings that the app user can annotate and associate with each row, but I'm having trouble getting the drawings to use a template image that changes based on another column -...

GreenLee

Does not seems to fix the issue - still getting error 400: bad request thrown when attempting to pass the order number either with escape characters or without slashes. If I output the order number 123-456-7890 to a separate plain-old text column ins...

GreenLee · 02-20-2024

For future reference, I managed to solve this by creating a trigger in the database table itself. The issue seems to be that because the record already exists, AppSheet won't use the default value formula to calculate an empty column, since that colu...

GreenLee · 02-16-2024

Unfortunately doesn't seem to work, still have the same problem. I think the issue lies in the fact that I'm trying to set a default value of a column in a record that already exists - because MariaDB has already defined it as NULL when first created...

My Stats

GreenLee's Bio

Badges GreenLee Earned

Recent Activity

Can't get API POST to add records with a reference to another table

How to display a drawing/image with different backgrounds in an external MariaDB database record?

Re: Can't get API POST to add records with a reference to another table

Re: How to display a drawing/image with different backgrounds in an external MariaDB database record

Re: How to display a drawing/image with different backgrounds in an external MariaDB database record