About Penny_G

Penny_G · 01-19-2022

I have to find a good solution using appsheet webhook/json to zapier or power automate, then generate a pdf (from a template) and save the pdf to Gdrive or save the link to the pdf to Gdrive (or appsheet). Any recommendations?

Penny_G · 01-10-2022

Hi, Making myself a little nuts over here. I have created a PDF template that uses a Start-End to loop thru a referenced list. It works ok. But the formatting of the pdf is a little lacking. So, I wanted to identify the 3rd item in the list and add a...

Penny_G · 06-06-2021

all of my customers just received a To: email from my app. The app ignored the SELECT(Form 2 [AA Email],[CR#]=[_THISROW].[CR#]) and sent the email to every row. This is an issue. What is the problem? Penny

Penny_G · 03-26-2021

Is it possible to have 2 separate Row filter conditions in one slice? I don’t want to show rows that are older than 1 day for [Status] = “Canceled” OR “Closed”. The 2 filters are: NOT (AND (([Status] = “Closed”), ([Drop Off Date/Time] < (NOW() - “024...

Penny_G · 03-21-2021

Hi, I have REF views. 1st Ref view changes the [status] (updates column in sheet) when submitted. On submission, an action links to another Ref View (that is dependent upon the [Status] = “new status”). That ref View is loaded. Great!. But if the use...

Penny_G · 01-19-2022

Hi, Yes. I have spent too much time hand crafting numbered lists for my pdf content. And without been able to create header and footer spacing I am having a helluva time laying out start/end content that is variable with each new file. I am spending ...

Penny_G · 01-19-2022

So, update. I tried Marc’s suggestion, “SELECT( [Related…][key] , [status] = “Active” )” but it failed to find the key - maybe because the virtual column is calling a slice. But I did find a solution to the issue in the original solution - it seems t...

Penny_G · 01-18-2022

Hi, I am already using a slice that pulls out the “active” rows. “<> <>” The issue seems to be that the template wigs out when the # of active rows changes. The INDEX loses the plot and my PDF ends up with this: The code on the template is trying to ...

Penny_G · 01-18-2022

Hi, Unfortunately, this does not work when the # of items changes (make an active item inactive, for example). I have to find a good solution using appsheet webhook/json to zapier or power automate, then generate the pdf (from a template) and save th...

Penny_G · 01-11-2022

My God! It works. I would never have found that on my own. I really can’t say I completely understand it but I do get the concept. Thank you.

My Stats

Penny_G's Bio

Badges Penny_G Earned

Recent Activity

Need a recommendation for a PDF generator in Zapier or Power Automate

How to grab the index # of a list item to create a conditional statement in a Start - End loop

New Bug Encountered: Workflow email sent email to all rows

Slice Row Filter Conditions

Can I hide the previous screen nav arrow or change it's destination?

Re: Need a recommendation for a PDF generator in Zapier or Power Automate

Re: How to grab the index # of a list item to create a conditional statement in a Start - End loop

Re: How to grab the index # of a list item to create a conditional statement in a Start - End loop

Re: How to grab the index # of a list item to create a conditional statement in a Start - End loop

Re: How to grab the index # of a list item to create a conditional statement in a Start - End loop