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

    • Write-Off multiple invoices and tax calculation

      Good evening, I have many invoices which are long overdue and I do not expect them to be paid. I believe I should write them off. I did some tests and I have some questions:  - I cannot find a way to write off several invoices together. How can I do that,
    • Unable to pay bill from Prepaid Expense account

      Our transport vendor requires us to use their prepaid system.  We have paid R1150 upfront into the Prepaid Expenses account: As we use their services, we get billed.  These bills must obviously be settled by from our prepaid account.  I am unable to record
    • Unable to import data into zoho analytics using the post man APIs of udemy for business

      Hi Can some one help me with the following Unable to import data into zoho analytics using the post man APIs of udemy for business through API beta feature, I have created the sample report in zoho analytics through the table structure but i am unable
    • errorCode":8504. What is wrong with my CONFIG?

      I can't determine what is wrong with my config. It worked properly until I added an additional field, but the additional field is just a number and shouldn't effect the config. I am attempting to do a bulk update add to an existing table based on this
    • Analytics report issue

      Hey, does anyone know why suddenly our Analytics report goes blank whenever we add a field from the contacts module? It shows when adding fields from all other modules. Thanks.
    • COST CENTER

      Hello, Is it possible to add cost centers.
    • High cpu load on client side by process sessionaudit.exe

      Hi, as stated above. This happens every time with different clients. Now, the first thing I have to do after making the connection is to go to taskmanager on client computer and kill the process 'sessionaudit.exe' If I don't their cpu is very high and
    • Urgent - issue with VAT registration

      Im trying to enable VAT but it wont let me add my company VAT details. I'm getting this. Please disable Adjustments and Entity level discount before registering for VAT How do i do this as i cannot find answer. It would be nice if there was a help icon
    • No Updation of manual journals in case of Accrual basis of Accounting

      Hi Readers, Please help with a query of mine, Actually I am not able to see any of the transaction updated in the manual journals, if i view a the report(Balance Sheet) in Accrual format. Like the transactions which are to be there even in accrual basis
    • Excise Tax for Oman

      We are a long time user of Zoho for multiple businesses. We have now started a new business division which is trading of beverages. This product however has an import excise tax (50% of assessed excise value) and sales excise tax (50% of invoice value).
    • NEW TO ZOHO

      I am transferring from company accounts which are being recorded in written book keeping method. I have stocks which are purchased in cash some by credit from vendors. I have datas from pervious year like total sales and purchases etc In future i will
    • Member Portal with Subscriptions

      We are a subscription box business using Zoho One.  How do our members login to make changes to their subscriptions, contact details, etc.  Is there a portal?  If not, what should we do to create one?  Also, we must be able to customize the portal with tabs and custom fields.  Finally, we need form and survey information to show up in the portal with some items editable and others read only.  I really need this information soon.  Thank you! Paige
    • GROUPING OF CUSTOMER

      SIR PLEASE ADD GROUPING OF CUSTOMER IN ZOHO BOOKS
    • Convert Sales order to Delivery Challan

      Dear Developer Team, In Zoho books we cannot convert sales order into delivery challan before making invoices. As a service business we have to get the delivery note signed then only we can make the invoice. In Some cases we don't receive a purchase order
    • Why does a field dependency auto choose the 1st field in picklist when set as mandatory?

      I have a pick list in the cases module called "Warehouse" with 2 options DC 1 or DC2. I also have a field dependency for Case reason = Mispick which will make the picklist a required field however the picklist auto defaults to DC1 (Even though the default
    • Cost Center accounting

      Hello all. We are looking at switching from MYOB to Zoho books. Love all the features in books - esp. CRM integration, but the big gap for us is the lack of cost-center accounting feature. Are there firm plans to develop this feature in Zoho Books? If
    • [How-to with Example] Getting field value/data in Client Script from lookup field record

      Imagine you have a field you would like to prefill a field based on a value from another record in another module. In this case, we are looking into a scenario where an Asset (custom module) module is being created from a Deal module. Meaning, there is
    • Shopify to Zoho Books Integration

      I have had to go ahead and disable my Shopify integration entirely.  When a Sales Order comes in from Shopify, it lists the shipping charge as a line item with no SKU attached to it.  As you are not able to edit a Sales Orders that comes in from a Marketplace,
    • Using functions in Zoho CRM Circuits, howto and solution

      So, I don't know if anyone has tried this yet but Circuits can be a pretty powerful solution to process data and get the job done in a more structured way. However Circuits are not that easy as it looks. One of the problems that we had to overcome was
    • CRM 'Connection' to Desk - "Use Credentials of logged in user"

      From Desk to CRM, I can create a Connection in Sigma (to CRM) that gives me the option to Use Credentials of logged-in user. In CRM, there is a separate option in setup for 'Connections'. As there is no specific Desk connector, I can create a 'Zoho oAuth'
    • [Free Webinar] Enhancing your dashboards with JavaScript widgets in Zoho Creator - Creator Tech Connect

      Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
    • Quickbooks Online Customer Creation Code

      Hi! I'm looking for code that will automatically create a quickbooks customer account when clicking on a button located directly within Zoho CRM - Contacts Module. Here's what I have and I can't seem to figure it out. xxxxx is our company id which we
    • Zoho carbon footprint

      Hi, I am calculating the carbon footprint of my company and would like to include the use of Zoho, because it is core to the company's operations. Do you know the carbon footprint of using Zoho? This for example could be emissions from using Zoho for
    • Configuration de la signature de messagerie dans zoho crm

      bonjour, j'essaie d'ajouter une image de signature mais en cliquant sur l'icone image, rien ne se passe. merci de m'aider :)
    • How to record Staff payment and receipts

      I'm a bit new with zoho so I have few questions its great if anyone here can help I work for a logistic company, every 1-2 months we transfer a lump sum $A to drivers so that they can pay for fuels or they can buy some tools. So my questions are - What
    • Chat function not working properly

      Ever since upgrading to plus, the chat is all messed up. it is coming up behind the web page so that I cannot see what I'm typing and cannot read replies. I can only see the bottom of the text box at the bottom of the page, and then it is blocked. I've
    • How to make a ScreenPop with Customer Information

      Hi, I need open a customer sheet when I receive a call on my pbx. I have a client on my PC that are able to open a web page with a specific url. How can I leave open the Zoho CRM application and search for a customer? Thank you in advance, Mauro
    • Create Package From A Picklist

      Dear Zoho, Can it be made possible to create a package from a picklist? The reason our company makes a picklist is for that to become a package Our sales orders have 600-1000 items I hope that makes it clear that it's hard to delete 990 items when we
    • Enable Organization-Wide reCAPTCHA Settings in Zoho Forms

      Hello Zoho Forms Team, We appreciate the existing security options for Zoho Forms, including Google reCAPTCHA v2 (checkbox) and reCAPTCHA v2 (Invisible). However, we have a major usability concern: Current Limitation: Right now, CAPTCHA is a form-specific
    • Store Google reCAPTCHA Site Keys & Secrets in Zoho Forms

      Hello Zoho Forms Team, We appreciate the support for Google reCAPTCHA v2 (checkbox) and reCAPTCHA v2 (Invisible) in Zoho Forms. However, we have a significant usability concern regarding the current implementation. Current Limitation: Every time we want
    • Ho to restrict access to row level to Zoho Analytics users

      Let me explain the scenario we are trying to achieve. We have an online system our team members work with. On it we have 6 users that manage data from different areas (North, South, East and West). We would like to transfer this information to a Zoho
    • CPQ - Price Rules applying to a prodcuts group

      Hi Zoho Team, In Product configurator is possible to make a rule where you can select "Any product" and set an "aditional condition", thanks to this we can apply a rule to group of products. In case of Price Rules, when I make a Rule for Any product is
    • Zoho Creator Upcoming Updates - December 2024

      Hi all, We're excited to be back with the latest updates and developments on the Creator platform. Here's what we're going over this month: Deluge AI assistance Rapid error messages in Deluge editor QR code & barcode generator Expandable RTF and multi
    • Importing Attendees- Excel

      I would like the ability to import attendees using an excel file. Sometimes groups, such as schools have to sign up attendees through there system and then send my organization an excel spreadsheet. Right now there doesn't seem to be a way to import those attendees. If Backstage can export to an excel file it seems like a no-brainer that one would be able to populate that template and import attendees into Backstage.
    • How to add new row in a custom SubForm using Deluge Code in Deal Module

      Hi, Can someone help me with Deluge code to add a new row with data in a custom Subform in a Deal Module. Thanks, Shatakshi Misra
    • CASE Module - email function

      HI there, I dont know if this has been asked or answered before as i couldnt find it on the forums. Issue: when a new case is raised, it goes under case tab and everything is captured. Then how do i send emails to the client who raised case with the details
    • How to add row numbers to Subform?

      How do I add auto row number rows of a subform in CRM?
    • How to change contact record owner to its creator?

      When I convert a lead record into a contact and a deal then a the contact record will have User AAAA as record owner, and the contact record will have User XXXX as the record creator. I don't have any workflow rules in Contact module. I use the blueprint
    • Function to update field in CRM Meetings from Bookings Appointment Status

      Hello, We're creating some reporting in Zoho Analytics using data from CRM and Bookings. Unfortunately it looks like when Bookings Appointments are carried over to CRM Meetings, the Bookings Appointment Status is not recorded in CRM Meetings. We would
    • Unresponsiveness in Zoho Cliq

      Time of post: 6:56 am PDT, 19 July 2023 Dear Cliq users, We have encountered an unprecedented issue in our messaging servers. The details of the issue are as follows: Impacted users : 1/4th of users in US DC (users who access cliq services through cliq.zoho.com)
    • Next Page