About Greg_L

Greg_L · 06-10-2020

For some reason I cannot figure out how to combine or use the needed expressions to get the list I need. Here is what I am looking to select (in more of a SQL format): SELECT TOP 2 [Quantity] FROM Batch Details WHERE AND([Batch ID]=[_THISROW].[Batch ...

Greg_L · 03-02-2020

I have an app that uses parent and child records with IsPartOf turned on. When I delete a parent record, it only clears the records in Google Sheets, leaving the sheet with many large gaps over time, which gets unsightly and annoying for my OCD So I ...

Greg_L · 01-08-2020

I would love to see AppSheet create a DATEADD() expression that allows you to easily add (or subtract) time in different types of units (minutes, days, hours, months, etc…) It would look like this: DATEADD([date], [#], ‘units’) So… DATEADD(TODAY(), 1...

Greg_L · 01-04-2020

In the article for the MONTH() expression, it states you can use MONTH(TODAY())-1 to get the integer value for last month. So you could also use MONTH(TODAY())-2 to get the month integer from 2 months ago, etc… Problem is, that isn’t true. If it’s Ja...

Greg_L · 12-16-2019

Here’s my scenario: I have three tables: Products, Orders, and Order Details Now consider this. I’m building out an order, adding line items (order details) to an order. For each line item, I select a Product and quantity and when I click Save the li...

Greg_L · 11-11-2020

Hi @Jordan_Davis1, I’m not 100% sure, but I think you would get that error when the sheet has no data in it. The problem is that the script wants to delete all the rows in that case, but at least one row is always required.

Greg_L · 06-10-2020

That’s it!! Thank you! I’ll be more descriptive next time. I tend to think in SQL and then try to convert that into AppSheet expressions. I would have never come up with that complicated expression. It’s very simple in SQL.

Greg_L · 06-10-2020

The ORDERBY is to sort the filtered records by _RowNumber in descending order, showing most recent records at the top. TOP takes those 2 most recent Quantity values. I don’t need to sort those Quantity values. I need to SUM() them.

Greg_L · 06-10-2020

It seems everyone is having the same problem I had. I need the Quantity value from the filtered records, not the ID (key) value. I think I must require this in one expression because I’m using it in a Action where I am setting the Quantity field of a...

Greg_L · 06-10-2020

@Steve I’m sure you could figure this out pretty quick. I hope you don’t mind me knocking on your door about this. I’d be very grateful for your help.

My Stats

Greg_L's Bio

Badges Greg_L Earned

Recent Activity

SELECT with filter and order by

How to delete blank rows in Google Sheets

DATEADD() expression

How to truly get "Last Month"

Prevent duplicate line item. Increment Qty instead

Re: How to delete blank rows in Google Sheets

Re: SELECT with filter and order by

Re: SELECT with filter and order by

Re: SELECT with filter and order by

Re: SELECT with filter and order by

Greg_L's Ideas (1)