About Elijah_Magrane

Elijah_Magrane · 10-05-2021

Good Day, I am attempting to create a template that SUMS up list of the SKUs made for a specific Lot. I have tried several iterations of the Start expression with no luck. See a generic dereference start expression below <> <> <> Output 1,080 1,080 2...

Elijah_Magrane · 03-19-2021

Good Day, I am racking my brain to try and figure out why my SUM(Select expression is not returning the correct value. Here are the values the expression returns in AppSheet… But as you can see when we look at the DB there are several values that are...

Elijah_Magrane · 03-18-2021

Hi, I am trying to come up with a Valid_if statement to prevent users from “checking-in” or “Checking out” more stock than what w have available at any given time. For example, I have a transaction table that tracks all of the in and outs. I know how...

Elijah_Magrane · 02-18-2021

Good Day, I am wondering if there is a more efficient way to achieve what I am currently trying to do. I currently have an inventory table that displays quantities of [Total Inv], [Allocated], and [On Hand] in cases I would like users to be able to s...

Elijah_Magrane · 02-12-2021

Good Day, I am experiencing a bizarre result when trigger a scheduled report. I have created a very simple template expression… <> Q1: <<[TEMPLATE].[Q1]>> OPT1: <<[OPT1]>> <> The result is successful however, this is the result perplexing to me. More...

Elijah_Magrane · 10-08-2021

Hi @Suvrutt_Gurjar, that workaround makes sense to me. I will try it and let you know how it goes. Thanks

Elijah_Magrane · 10-05-2021

Basically when I trigger the workflow on the parent table [Lot#] I want to sum up the quantities of the child table [related packagings] by [Product] (which is unique to [related packagings]), for which there are multiple entries. For example there m...

Elijah_Magrane · 10-05-2021

Steve: <> That is what I thought, I get an error. * Error 1 : 'New process 2' task 'New Task 2' Body template. Expression 'UNIQUE(SELECT([Related Packagings][Id],(AND([Product]=[_THISROW].[Product],[Lot#]=[_THISROW].[Lot#]),TRUE)))' is invalid due to...

Elijah_Magrane · 10-05-2021

Tried both the start expression as well as the general expression, no luck same output <> <> <>

Elijah_Magrane · 09-23-2021

Down in Eastern Canada

My Stats

jlazoCP's Bio

Badges Elijah_Magrane Earned

Recent Activity

Can't remove duplicates from list generated from template Start expression

SELECT expression omitting values in a list

Valid_if statement to prevent inventory imbalances

Using user settings to Swap between Units of Measure

Workflow triggered successfully but yielding no results

Re: Can't remove duplicates from list generated from template Start expression

Re: Can't remove duplicates from list generated from template Start expression

Re: Can't remove duplicates from list generated from template Start expression

Re: Can't remove duplicates from list generated from template Start expression

Re: Is Appsheet down 9-23-2021?

Elijah_Magrane's Ideas (1)