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     www.energyefficientbuild.com.

user Meljord said: (http://productforums.google.com/forum/#!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.
Thankyou

----
The link is below ( with EDIT rights)
https://docs.google.com/
spreadsheet/ccc?key=0AoELb6rygp6AdEN6TVFvbFlxWEUzSmQ1RG9fa0tRZXc#gid=0
This same link can be accessed at the top of the Website page with the form ( little gold key image)
Thanks 
Meljord
-----------------------------------------------------------------------------------------------
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