Script help

Script help

I am trying to input a field in a subform depending on whether or not another form (Complete_a_Waiver) has previously been completed with the same first name, last name and DOB as the row in the subform. If yes, then it will input as yes, if no then it will input the field with no. I have tested with the below script and it is inputting No when I have a record in the other form with the same first name, last name and DOB.

Can anyone tell me what I am doing wrong with this script?

count = 0;
fetchRec = Complete_a_Waiver[Participant_s_Name.first_name == input.Attendee_List.Guest_Name.first_name && Participant_s_Name.last_name == input.Attendee_List.Guest_Name.last_name && Participant_s_DOB == input.Attendee_List.DOB];
if(fetchRec.count() > 0)
{
row.Waiver="Yes";
}
else
{
row.Waiver="No";
}





          Zoho TeamInbox Resources

            Zoho DataPrep Resources


                Zoho CRM Plus Resources

                  Zoho Books Resources


                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources


                          Zoho Sprints Resources


                            Zoho Orchestly Resources


                              Zoho Creator Resources


                                Zoho WorkDrive Resources




                                    Zoho Campaigns Resources

                                      Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方