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