Here’s a cool bite-sized function for you! We’re gonna show you how to add subform rows on Zoho CRM via Deluge scripting without overwriting existing row(s), no API calls needed!
If you’ve ever Googled this, you would probably find the API documentation on subforms. While this works, it doesn’t explain the parameters needed if you’d like to add additional rows without overwriting the table. Plus, if you’re gonna be executing this function in CRM, the method I’m about to show you is simpler.
If this is helpful, check out our other Zoho training and educational resources!
Think of subforms as a spreadsheet table where you can store multiple line items on a single CRM record. The ability to add rows to the subform via Deluge creates many possibilities:
Create a map with the subform columns (keys) and the respective values for the new row to add.
Note: Please replace the keys with your subform column API names and the values respectively.
Lists are required to update subforms. Create a list variable and then add the map to it.
This step will prevent the existing subform row(s) from being overwritten.
Update the subform on the CRM record with the updateList variable that you have made.
Click here to copy the scripts. For more Zoho-wizardry, check out our GitHub page.
When scripting, ask yourself this question – will this value ever be null? If it’s a yes, that’s a place for a null check! Here are 3 tips and best practices to help you kickstart the habit.
Learn to create a customized inventory report with Zoho Analytics. This tutorial contains a link to our GitHub page for SQL code that will help with your table creations.
How nice would it be if you could, at the press of a button, send clients an email w/a Zoho Books invoice? Replete with “Pay Now” buttons that link to PayPal/Stripe/other payment gateways?
Whether you work primarily out of CRM or the Zoho Finance Suite, you can use Analytics to build commissions dashboards. This involves some fairly simple SQL code.
If you are an inventory manager, this blog post could change your life. If you are not, it will at least teach you how to build some wicked inventory tracking for your business.
Convert fields, related activities, attachments, notes and more from one record to another across modules via custom function.
Responses