CREATING INVOICE with Supabase

[AMMAR_ALASBAHI]

I am creating an app to create invoices for accounting purposes. I have a table for product names with the highest and lowest prices and another table for invoice numbers, items, quantity, and unit prices. I set the validity of the unit price to be between the lowest and highest prices. I used this procedure with Google Sheets with no problem. However, when I put the tables in Supabase, It seems like I get random lowest and highest prices for random items. How to fix this?

[WillowMobileSys]

---

@AMMAR_ALASBAHI wrote:

I used this procedure with Google Sheets with no problem. However, when I put the tables in Supabase, It seems like I get random lowest and highest prices for random items. How to fix this?

---

If I understand correctly, you have an AppSheet app that originally used a Google sheet as a datasource that included sheet formulas.  You migrated the Google sheet to a Supabase database and that same functionality is operating differently. 

You will want to ask this question in a Supabase forum.  This is an AppSheet dedicated forum and very few, if any, will have experience with using Supabase as a datasource.  (I didn't know about it until this post!)

As for a way to fix, in my opinion, the best solution is to include these types of operations in the AppSheet app itself.  That way it doesn't matter which datasource you connect to the app, the functionality will always work in the same way.

[SkrOYC]

---

@WillowMobileSys wrote:

(I didn't know about it until this post!)

---

[Updated] Supabase mets AppSheet - Google Cloud Community

@AMMAR_ALASBAHI Could you share your Supabase config for those columns? Also the AppSheet config? As @WillowMobileSys said, it's better to always use a database just as a plain database and manage almost all features from within AppSheet

[WillowMobileSys]

---

@SkrOYC wrote:

@WillowMobileSys wrote:

(I didn't know about it until this post!)

---

[Updated] Supabase mets AppSheet - Google Cloud Community

---

Yeah, my summer was extremely busy, so was in catch-up Mode most of the time as far as the Community is concerned.  I missed a few things!

[AMMAR_ALASBAHI]

PROBLEM SOLVED. THERE WAS A PROBLEM IN VALID IF.