About Ryan_S

Ryan_S · 10-21-2020

Is there any way to compare a fixed value to a list of values, and return the closest match in the list? It’s all numeric I’ve got a fixed list returned from a select operation on another table (Could be 1 result, could be 100 results) and a single v...

Ryan_S · 10-21-2020

Is there any way, short of adding another field to the base form to use a multi-part lookup by reference? Scenario -> Appliance’s have defaults based on Model Number -> Along with the defaults, the Appliance Manufacturer (by ref) is stored in one tab...

Ryan_S · 10-11-2020

Is it possible for appSheet to look up reference data in something like a JSON file? Here’s the scenario I’m using an app to track appliance maintenance information, there’s a lot of manufacturers and a lot of different models, and quite frequently t...

Ryan_S · 10-06-2020

So, everything was working well, but I manually deleted a PDF file created on my google drive via a WorkFlow Action. Now, when I re-run the test that created that specific file, it errors out and says the file can’t be found (human readable file name...

Ryan_S · 09-27-2020

First time using AppSheet, so sorry if this has already been covered somewhere I’ve got 3 mySql tables, one called ‘Locations’, one called ‘Devices’ and one called ‘DeviceTypes’ The setup (Obvious) is each Location can have many Devices, and each Dev...

Ryan_S · 10-22-2020

Steven_Aung: ‘’’’ My bad. A single quote (or just a quote) where I’m from is " an apostrophe is ’ Misunderstood the question, sorry… Try Quote Apostrophe Quote Quote “’”", Just tested here and it yields a single ’ Four Quotation marks yields a single...

Ryan_S · 10-22-2020

“”"" 4 of them

Ryan_S · 10-22-2020

Should change the name of Any to First, as in returns the First value in the list, also there’s little documentation on orderby being able to do calculations on the fly Elegant solution, love it! Thanks Steve!!

Ryan_S · 10-21-2020

I’ll look into that in a bit… Still trying to figure out if I can implement your original idea Thanks for trying

Ryan_S · 10-21-2020

I see where you’re going with that, but I’m not sure how I could integrate a solution like that The table it’s pulling the values from are all on separate rows, and the value it’s being compared to changes for each ‘active’ record… It’s a disaster th...

My Stats

KKSU's Bio

Badges Ryan_S Earned

Recent Activity

Is there any way to compare a fixed value to a list of values, and return the closest match in the list?

Multi-Part Lookup by Ref

Default Data

Workflow Action - Can not re-create file in google drive

MySQL Tables & References

Re: How to prefix a single quote in a CONCATENATE?

Re: How to prefix a single quote in a CONCATENATE?

Re: Is there any way to compare a fixed value to a list of values, and return the closest match in the list?

Re: Is there any way to compare a fixed value to a list of values, and return the closest match in the list?

Re: Is there any way to compare a fixed value to a list of values, and return the closest match in the list?