Updating Subform Record from other Form

Updating Subform Record from other Form

Just wanted to ask how to properly approach this. I have 2 forms and would like to trigger an auto update on the subform once record submitted.
block below only updates 1 row
for each  recordRow in input.AV_System
{
AssetRecord = Site_Asset_Services[SOR_No == input.SOR2 && Type_of_System == "AV System" && Site_Asset.Serial_N == recordRow.AV_Serial_N].Site_Asset;
for each  rec in AssetRecord
{
AssetRecord.Floor=recordRow.AV_Floor;
AssetRecord.Room_Name=recordRow.AV_Room_Name;
AssetRecord.Brand=recordRow.AV_Brand;
AssetRecord.Model=recordRow.AV_Model;
AssetRecord.Serial_N=recordRow.AV_Serial_N;
AssetRecord.Description=recordRow.AV_Description;
AssetRecord.Status=recordRow.AV_Status;
AssetRecord.Remarks=recordRow.AV_Remarks;
}
}

    • Recent Topics

    • Authentication details provided was rejected by Source server. Kindly provide valid username and password.

      Hello, I am trying to migrate mails from old server to zoho email hosting. I have added all details correctly, including email id and its password. also tried with none and SSl setting, but still unable to connect. Authentication details provided was
    • Zoho Mail not fit for business

      How are businesses using Zoho Mail? In Zoho Mail: You cannot create subfolders in a shared mailbox You cannot add a second email account eg. a non-Zoho account that could then provide the function of providing a shared mailbox with subfolders In the Trident
    • Additional step for Deleting an app

      Have an additional step for deleting an app. When the popup occurs, the user needs to write "DELETE" into a text field. This is what Google does. At the moment, it is too easy to Delete, which increases risk, and this should be easy to implement.
    • Enhancement - P&L Statement and Balance Sheet

      Hi there!   Providing an option to compare financial statements from different quarters was one of the most requested features in  the recent times . We're more than excited to have come up with a solution - a  Comparison  feature for P & L Statement and Balance Sheet.   Profit and Loss Statement and Balance Sheet provide you with  a clear picture of   the 'hows'  your company can generate more revenue or cut down on costs and what you own and owe. But, then having this year's statement compared
    • restrict access to user to create invoice

      hi team we need to restrict particular users from accounts dept to create invoice directly from invoice module in zoho books . Rather , they can only able to create invoice is by using "convert to invoice" from "Sales Order" module . pls help us to solve
    • Request to Make Cheque Printing Available as an Add-On Across All Plans

      Hi Zoho Team, I have been using Zoho Books and other Zoho products since 2019, and they have significantly streamlined my business operations. However, I believe there is room for improvement in terms of feature availability across different plans. One
    • Zoho Forms Lookups Not Accessible

      I am trying to set up a sign-in form where visitors can scan the QR code onsite, select the job from the lookup field, and it attaches to the job in the CRM. It looks like external users cannot use the lookup feature. Is this correct? It seems almost
    • Notes Filter is not working

      I am trying to filter the CRM down to specific notes that I want that'll show up all the data that has a specific keyword for example, "stocks" and it says no leads are found... Don't know how to fix. don't know if it's a system glitch. I even put a note
    • Customize the Date Format based on preference

      Hello Everyone, We have rolled-out a new field called Date Pattern in the user layout under Locale information. Note: If you notice any change in the date format after this roll-out, please select your preferred format from the settings. Previously, the format of the date was automatically set on the basis of the country locale selected by the user. Now, the user will be able to edit the format in which the date is displayed according to their preference.  The Date pattern field has around 40 patterns
    • Scheduled function not firing workdrive.uploadFile task

      I have a creator app that takes submissions from a published form. I setup a daily scheduled function to send a record template of the form, as well as 3 different uploaded files to workdrive folders. (Initially I intended for this to happen on the submission
    • Automatic Email Alerts for Errors in Zoho Creator Logs

      Hello, We would like to request a feature enhancement in Zoho Creator regarding error notifications. Currently, Zoho Creator allows users to view logs and errors for each application by navigating to Zoho Creator > Operations > Logs. However, there is
    • E-mails to suppliers

      Hi, i want to upload a spread sheet every day and send an e-mail to our suppliers every day (or when triggering a button?) with info from the spreadsheet lines. The supplier e-mail would be on each line. Unfortunately, when creating a scheduled automation,
    • Rearrange web - hidden components

      When you have a good number of forms, reports and pages, searching for one among the hidden components to add it to the menu is simply hell. Huge amounts of time are wasted.
    • Using Insert into to transfert a date in another form

      Hi, I have an order form that creates a record in a calendar form, for managing the delivery date. My customer can change that date in the calendar form, but i need the new date to be put in the original order form. I tried the following but it doesn't
    • Migrating from Zoho to Cpanel

      I would like to migrate my few of my email accounts to Cpanel, yet keeping Zoho Mail active just in case. Is there anyway to do that? As all my mail still goes to the Zoho Account instead of Cpanel
    • Zoho books api - sales order last ordered date

      I would like to get the last ordered date for each contact in the book. How can I do this?
    • Pay Contractor Timesheets

      I have contractors that fill out a timesheet. Each hour must be assigned to a current client. I need the easiest way to get the contracts paid. They are paid on an hourly bases. How can this be done?
    • Telegram -> Zoho Creator answer via API.

      Hello! Did anyone work or established back connection from Telegram to Zoho Creator via API? I'm able to send notification from ZC to TG Bot successfully. (webhook is set) My notification consists of some information and inline buttons "yes" and "no".
    • Update a form record based on another form with same user ID

      Hi, I have 2 forms linked : Customer and Subscription When a customer fills-in a subsequent subscription form, there is a automatic subscription number created in the subscription form that I want to paste in a miroir field in the customer field. What
    • Issue Configuring SSO Integration with Cognito in Zoho Help Center

      Dear Zoho Support Team, We have been working on configuring SSO integration for our Zoho Help Center using Amazon Cognito. While the setup appears to be completed successfully, we are encountering an issue when attempting to access the Help Center. The
    • Date Time

      Hi Everyone, I would seek some help about this concern that bugs me. I'm currently working using Zoho Flow to automatically plot a calendar on the Calendar Report. Whenever a ticket from Zoho Desk Field was updated this will trigger to create a plotted
    • Introducing Bot Filtering for Accurate Email Campaign Analytics

      Update : This feature has been revamped. For the most current information and improved functionalities, please visit the updated version here. Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign
    • How can I make time entry mandatory for tickets?

      Hi guys,  I just want to make a time entry field mandatory for tickets. How can I do that? At this stage of our usage, it's not mandatory and it could be forgotten to input a time for a ticket.  Thanks in advance 
    • Zoho Workplace gets yet another security boost: The addition of Zoho Vault

      Hello Community, Passwords are often the first line of defense, yet they're also one of the most common weak points. We're thrilled to announce that Zoho Vault is now integrated with Zoho Workplace! Zoho Vault Standard is now included at no extra cost
    • inventory removal at packing list or shipment.

      currently our system is set to remove inventory at invoice. This is creating an inventory nightmare? Is it possible to change the settings to remove the item from inventory at either the packing slip stage or shipping the item.
    • Change to copy/paste functionality in Deluge code editor

      Recently there was a change to the Deluge code etidor where it now inserts backslashes into strings automatically when copying/pasting strings with double quotes, it's a nightmare to have to go delete all these. Is it possible to toggle this on or off?
    • Clear a date field?

      I've got a date field, let's call it Returned_date.  I'd like to write a script that clears the values from another date field called Expected_date upon a successful entry.  I know where to put the expression, but I'm having trouble building the expression.  Any assistance from anyone for a newb question would be appreciated.  Thanks in advance!
    • Integrating ChatGPT with Zoho Creator for Automated Report Generation: Is It Possible?

      Hi everyone, I’m currently working on an application in Zoho Creator and would like to know if it’s possible to integrate ChatGPT to automate the generation of reports based on the data captured within the application. Has anyone successfully implemented
    • There anyway to change a creator app Back to DEV thats not got a back up?

      As above, is it possible? Thanks.
    • Submit to hiring manager

      It would be benficial to be able to send assessments as part of the attachment when submitting candidates to a hiring manager. Recently i created a recruiter assessment which i complete when phone screening the candidate. I would like to send the supporting
    • Cross-Posting to a Telegram Channel

      We don't have a native way to cross-post to Telegram channels. Did anyone find a way around it? I checked Zoho Flow - but Telegram isn't there. Maybe some 3rd party integrations connecting Facebook, IG, etc., bypassing SalesIQ altogether?
    • How to connect the Squarespace website with Zoho Thrive

      Our website is created using Squarespace. To boost our sales, I planned to do the affiliate program and I thought to integrate our website store with Thrive. but I don't see the Squarespace platform. if I choose the custom build, I have to generate the
    • Incoming Emails Landing in my News Letter Folder

      Hello, Most email is landing in my inbox but those that come from a web form from my site are landing inside my News Letter Folder. What do I need to do to make them land inside my inbox? Thank you, Cindy
    • Possibility of Recording CookieConsent in a Hidden Field in Zoho Forms

      Dear Zoho Forms Team, We are using Zoho Forms on our website and have encountered a technical question related to GDPR compliance. Currently, we have Google Tag Manager installed, along with a script that tracks UTM parameters and GCLID. To comply with
    • Snapshot of totals

      Hi, I'm more familiar with Creator so it's taking me a while to wrap my headaround the CRM. I've been asked to produce a metric that takes a snapshot total of ceratin fields everyday when they meet certain conditions : Total Average Value for example.
    • Bulk change color of selected notes

      When I select several notes, I want to change their color, but there is no such function. I miss it.
    • Supercharge your operator productivity by leveraging the power of OpenAI in Zoho SalesIQ

      Heads-up: The OpenAI integration is currently available only for users in (US, IN EU, AU and JP region). We will be rolling it out to other regions soon. From complex neuroscience to simple note-taking, AI has seeped through every part of human lives,
    • Digest Janvier - Un résumé de ce qui s'est passé le mois dernier sur Community

      Bonjour chers utilisateurs, Le premier mois de l'année s'est écoulé à toute allure ! Découvrons ensemble comment s'est passé janvier pour Zoho Community France. Dans un monde où l’information a une valeur inestimable, la protection des données sensibles
    • Zohocliq status change automatic

      Greetings Zoho, So, i've sync my G-mail calender with zohomail, now every event i get from gmail goes thru zohocliq (WHICH is what i wanted) but the thing is that when the event is there  let's say from 11:30 til 12:30PM my current status doesn't change.
    • Workflow rule to assign new case owner sends email to customer from Original owner issue

      I have a workflow rule to assign a manually created case from a sales rep. to a customer service repr to handle. I also have a workflow rule to send an introduction email from the case owner to the customer. The Problem: The email is going out on behalf
    • Next Page