About GGL

GGL · 04-27-2021

Hi all, Our use-case with photos is that we take a lot (10-30) per job and for “before” and “after” photos we only ever need to take photos, not upload them from our device. Having the “Select Camera Source” menu is an inconvenient extra step. I see ...

GGL · 04-26-2021

Hi, In the transition from a Google Sheets based CRM to AppSheet there have been a lot of great strides forward but with photos I’m a bit stuck about how to proceed. Each job has around 10-30 job photos and we currently process these on the laptop an...

GGL · 04-25-2021

Hi, It would be nice to be able to control the min-value of a Y-axis of a common chart. Here are two results from the same data, with two extremes. Is there any way to specify a min-value for the Y-axis?

GGL · 04-23-2021

Hi, I’m a bit puzzled in that emails via Actions seem to be plain text only. I was planning on having an HTML email created after clicking on a “Prominent” Action button. With workflows (ok, deprecated so bots), it seems that there needs to be an int...

GGL · 04-21-2021

Hi folks, I have addresses like this: 123 Sample Street 456 Example Road and some like this: 123 Sample St 456 Example Rd To clarify, there are multiple entries with the same addresses but different “endings”. I plan to clean them up at some point bu...

GGL · 04-26-2021

Oh man am I happy to be proven wrong! Thank you. Sorry to have bothered you about this - it turns out that the app wasn’t saving due to having a later numbered version saved in another window. Lesson learnt. And thank you AppSheet team for getting th...

GGL · 04-26-2021

Thanks but I’m pretty sure, from testing, and a post from a year ago, that it only accepts a static path like “Job Images/” Trying to create a dynamic path so it’s different for each job like this: “Job Images/” & [Street] & [Suburb] …doesn’t seem to...

GGL · 04-26-2021

Thank you @Suvrutt_Gurjar . In the above charts I posted (same data), I would have chosen something like 9 to have given a bit of bottom “padding” in the case of the line chart to make it less erratic and to reduce the excessive length of the histogr...

GGL · 04-23-2021

That seems a bit fancy but good to know. Thank you very much for the confirmation. Enter the bots!

GGL · 04-21-2021

Thank you for your reply Steve. And just wondering: Is the double CONCATENATE formula I’ve used a reasonable approach to retrieving a subset of substrings from a string, in this case the first two substrings of an address? Just curious whether there’...

My Stats

GGL's Bio

Badges GGL Earned

Recent Activity

Any way to go straight to camera (i.e. avoid the "Select Photo Source" screen when adding an image (Android)?

Alternative for customer viewing of job photos given no dynamic folder paths?

How to specify the Y-Axis start value for a chart?

Wanting an HTML email via an Action button, or equivalent

Any better way to compare concatenated substrings?

Re: Alternative for customer viewing of job photos given no dynamic folder paths?

Re: Alternative for customer viewing of job photos given no dynamic folder paths?

Re: How to specify the Y-Axis start value for a chart?

Re: Wanting an HTML email via an Action button, or equivalent

Re: Any better way to compare concatenated substrings?