Hello all,
I have a Zap set up but just running into a tiny problem that has become a head scratcher. My firm provides business financing. I have created a formula to provide prospective clients with a quote for what an offer would look like using Gravity Forms and Google Sheets. Upon submitting the Gravity Form it automatically updates a chart in Google Sheets and redirects the client to a different page showing them their quote.
So all is good and fine except one tiny issue. It is not a unique URL so every time a NEW client submits a quote request the table updates and changes. This of course does not scale and if a client ever wants to come look at their quote later on it will likely be different.
Here is a step by step of the Zap.
Form Submission in Gravity Forms (http://4pillarfunding.com/quote)
Create Spreadsheet Row in Google Sheets (with Gravity Form Submission Data)
Lookup Spreadsheet Row in Google Sheets (find newly created row)
Update Spreadsheet Row in Google Sheets (in a different sheet that is used for providing the quote (i.e. this row changes each time a new submission comes in and automatically updates the respective table)
This is where they are redirected to: http://4pillarfunding.com/quotedecision
How could I get a screenshot of the Google Sheet table at submission OR pull the data and put it in a visually appealing table where the data would not change?
Any thoughts?
