Greetings,
I'm trying to add a record to a form called Walkers whenever there is a new record in a form called Teams. This is exactly like the example you have in your wiki. I have put this in the "On Success" section of the script, but it is not being added to the database. The script used to contain a redirect to another page, and that was working. When I added the Insert, the redirect stopped working too. I have since removed the redirect, and the Insert fails all by itself.
Can you tell me how to make this work? I've tried everything I can think of.
Here is the code that looks right to me:
insert into Walkers
[
Added_User = zoho.loginuser
Captain = "captain"
City = input.City
Email = input.Email
First_Name = input.First_Name
Individual_Goal = input.Individual_Goal
Last_Name = input.Last_Name
Photo = input.Photo
Status = input.Status
Team_Name = input.Team_Name
Volunteer = input.Volunteer
]
Thanks.
Ellen