11/17/2023 0 Comments Zoho creator input data as pivot tableTo enable your users to access the Form, you have to Share the Form to your users or embed it in your Web Site/Blogs and set required permissions. Sharing the Form and Embeddingīy default, only application owner can access the Form in a private application. Similarly, if a user clicks Update button, all the rows in the table of the Zoho Analytics that matches the given criteria will be updated with the submitted data. Write the following deluge script as shown below in script editor and click Save Script.Switch to Free-flow Scripting mode by clicking on the option present at the right side top corner of the script editor.This will invoke the script builder in the Script tab. Hover your mouse over the Update button and select Action on Click option.Add a button (say, Update button) to the Sales Form following the same steps as described above.In the given example, to Update an existing row in the Sales table of the StoreSales Workspace in your Zoho Analytics account with the submitted data via SalesForm, is the map object containing response returned by Zoho Analytics. Refer here for more details about the format for the criteria. is the name of the table in the corresponding Workspace in Zoho Analytics. is the name of the Workspace in Zoho Analytics. A generalized format of the deluge task to Update row(s) in Zoho Analytics is: To update a row in Zoho Analytics using a Form created in Zoho Creator, we have to write a deluge script with task update data(). You can also use a Zoho Creator Form to update existing data of a table in your Zoho Analytics account. When a user enters data and clicks Add to Zoho Analytics Workspace button in the Sales Form, the given deluge script executes and adds submitted data as a new row into the Sales table in your Zoho Analytics account. MapResponse is the variable which holds the XML string returned by Zoho Analytics as response on adding the row. MapResponse = ("StoreSales", "Sales", creatingMap) ĬreatingMap is the map variable that holds the column names (Date, Region, Product Category, Product, Customer Name, Sales and Cost) and their corresponding values submitted in the Sales Form. Write the following deluge script as shown below in script editor and click Save Script.ĬreatingMap.put("Date", input.Date_field) ĬreatingMap.put("Product Category", input.Product_Category) ĬreatingMap.put("Product", input.Product) ĬreatingMap.put("Customer Name", input.Customer_Name) ĬreatingMap.put("Sales", ()) ĬreatingMap.put("Cost", ()). Hover your mouse over Add to Zoho Analytics Workspace button and select Action on Click option.Once you have dropped the required fields and added Add to Zoho Analytics Workspace button to the Sales Form, Let's continue with the above example to illustrate how to use createRow() task to add data. The map key is the column name of the table in your Zoho Analytics account and the map value is the field value submitted in the Zoho Creator Form. is the map variable that holds key, value pairs. Is the name of the Workspace in Zoho Analytics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |