Creator JS SDK SubForm items manipulation (ADD/GET/DELETE/UPDATE)
I want to ask for help from anyone who's worked with JS SDK on Creator widgets, as I am not clear and I can't get it work the following manipulation of SubForm items.
So in my widget I want to be able to Get,Update,Delete,Add Subform items, so far I am able to get the SubForm items through the standard getRecordById which gives me the following response (from the SubForm)
"Subform": [
{
"display_value": "Service Equipment,New Order",
"ID": "5212750000433263"
},This is also mentioned as expected in the documentation at: https://www.zoho.com/creator/newhelp/app-settings/widgets/creator-api-for-widgets.html around GetRecordByID and GetAllRecords methods.
I then tried to add new subform records, and I am able to, so on addRecord I am able to pass down the array of the subform items (objects) and add a record, therefore it's subform items.
I then tried to add new subform records, and I am able to, so on addRecord I am able to pass down the array of the subform items (objects) and add a record, therefore it's subform items.
But then when I try to update records this is what I got so far. First of all, there is one hoax that is really unclear and that is how to get full JSON format of the SubForm items, not only display_value and ID from each item. It's very hard and almost an impossible task when working on a complex app with many fields to make a custom parser for each of those forms and SubForms. So the SubForm items have unique Zoho generated ID. How to fetch each of the SubForm items? What is exactly the config?
The workaround for getting each item's field is through a parser that I mentioned above that would require following the same order of how the fields are ordered in zoho and then taking the value from the display_value and the separator used.
Can someone explain to all of us that have this problem with config examples of each of the tasks Get/Update/Delete Subform items?
So far I was also able to edit the subform items by creating the item object as I'm creating new, but that doesn't fix my problem as upon fetching I only get display_value and ID which is impossible as I said to map all the fields correctly, including their data type etc.
From support I got a totally unserious response(see below) guiding me to Creator APIs docs, which really doesn't answer even 1 bit of my question. There is a missing part in the JS SDK Docs when it comes to SubForms, as nothing is explained how to approach. So far I tried more than 50 combinations, but knowing that it's a widget that has to be uploaded it's a really slow process of testing and figuring out myself.
(Support's Response:)
The workaround for getting each item's field is through a parser that I mentioned above that would require following the same order of how the fields are ordered in zoho and then taking the value from the display_value and the separator used.
Can someone explain to all of us that have this problem with config examples of each of the tasks Get/Update/Delete Subform items?
So far I was also able to edit the subform items by creating the item object as I'm creating new, but that doesn't fix my problem as upon fetching I only get display_value and ID which is impossible as I said to map all the fields correctly, including their data type etc.
From support I got a totally unserious response(see below) guiding me to Creator APIs docs, which really doesn't answer even 1 bit of my question. There is a missing part in the JS SDK Docs when it comes to SubForms, as nothing is explained how to approach. So far I tried more than 50 combinations, but knowing that it's a widget that has to be uploaded it's a really slow process of testing and figuring out myself.
(Support's Response:)
