Please see script for stateless form below. I finally figured out how to update table with stateless form but am not programer and need help.
How do I remove the data from the form once it has been submitted AND display a confirmation message like "Your Data Has Been Submitted".... See from at: http://azrealestate101.wiki.zoho.com/GUESTBOOK.html
I am keeping it simple so I haven't learn how to do the data field validation. Where is there "beginners" documentation how to build more complex stateless forms. Thank you.
form Stateless
{
displayname = "Input Form"
store data in zc = false
success message = "Data Added Successfully!"
field alignment = left
column
{
First
(
displayname = "First:"
type = text
width = 200px
)
Last
(
displayname = "Last:"
type = text
width = 200px
)
Company
(
displayname = "Company:"
type = text
width = 200px
)
Email
(
displayname = "Email:"
type = email
width = 200px
)
Phone
(
displayname = "Phone:"
type = text
width = 200px
)
Website
(
displayname = "Website:"
type = text
width = 200px
)
Your_Profession
(
displayname = "Profession?"
type = list
values = {"Financial Professional", "Attorney", "Real Estate Agent", "Property Manager", "Investor", "Title Company", "Bank Negotiator", "Mortgage Broker", "REO Asset Manager"}
sortorder = ascending
height = 60px
width = 206px
)
Comments
(
displayname = "Comments:"
type = textarea
height = 100px
width = 200px
)
}
column
{
My_Interest_Request
(
displayname = "Inquiry / Request:"
type = checkboxes
values = {"Referring Short-Sale Homeowner", "Explore Alliance Partnership", "Add Me To Your Email List", "Contact Me", "Other (Use Comments Field)", "Propose Educational Event"}
)
Event_Date
(
displayname = "Proposed Event Date?"
type = date
width = 130px
)
Event_Description
(
displayname = "Event Description:"
type = text
width = 200px
)
Referral_Contact_Information
(
displayname = "Referral Contact Information:"
type = textarea
height = 100px
width = 200px
)
}
actions
{
Add_this
(
type = button
displayname = "Submit"
on click
{
insert into Analysis
[
Added_User = zoho.loginuser
Comments = input.Comments
Company = input.Company
Desired_Date = input.Event_Date
Email = input.Email
Event_Description = input.Event_Description
First = input.First
Last = input.Last
Phone = input.Phone
Referral_Contact = input.Referral_Contact_Information
Website = input.Website
You_Are = input.Your_Profession
Your_Interest = input.My_Interest_Request
]
}
)
}
}