Sunday, August 5, 2012

yogi_Publish Only The Latest Record Submitted Via Google Form in A Web Page

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #674   Aug 05, 2012

user Meljord said: (!category-topic/docs/spreadsheets/qjL51WCdP_M)
Logging of latest submission
I am using a form embedded into a website for users (tenants) to submit required maintenance issues.
So users do not duplicate a submitted item, it would be helpful to have a area on the website (above the Form ) where they could see the date & subject of the latest submission ( being last item on the first 2 columns).
Appreciate any ideas of any gadget/script that could provide this solution.

The link is below ( with EDIT rights)
This same link can be accessed at the top of the Website page with the form ( little gold key image)
In the following solution I created a sheet named yogi_LatestRecordToBePublished, and the got the iframe code to only publish the range A1:F2 of this sheet