Fetching information from existing record when populating form

Fetching information from existing record when populating form

We have 3 forms:
Form A (has multiple existing records)
Form B
Form C

When Form B is submitted, we want it to automatically open Form C and then:
1. Using a field in the submitted Form B, find matching/existing record in Form A
2. Insert information from record found in Form A into Form C

Would I use "Fetch Record" or "Get Record" for this type of action? I am getting stuck when trying to get information from Form A to be inserted into Form C...

Thanks for your help!

In this example below, I was able to get Form C to be populated with information from Form B. My issue is when I start trying to get information from Form A's records...

  1. //When Form B is Submitted, populate Form C field with information from Form B:

  2. if(What_Do_You_Want_To_Do == "Add a new asset")
  3. {
  4. openUrl("#Form:Form_Asset?Barcode_QR_Code=" + input.Scan + "&Status=Active","same window","height=<height>,width=<width>");
  5. }

    Zoho Marketing Automation

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      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


                                      Qntrl 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