How to import data into a page
I want to use zoho to fill out a contract automatically if we choose a customer (name,e-mail,address.etc.). I made the contract as a page. I've added the contract text with INSERT HTML, but I don't know how to add expressions from a form. (I made a stateless form to choose the client and I've added this to the contract page). Can I get some help,please ? :)
Details on the working ?
Hi, I am very new to the Zoho, so I came across many doubts in the same, 1) Whats an application ? with the forms created in application how can I gather data from my customers ? 2) Can I create a single form with 135 fields ( 25 Dropdowns, 70 text, 20 Checkbox, 20 Date ) in one form ? 3) If not how can I do it with multiple forms ? 4) Ho can i implement the multiple form application to get data, if single form is used we can embed it to some of the web page and get data, in case of multiple form
Update records using Function
Hi, I am trying to create a function that will update the respective fields when it meets the respective criteria . see below form screenshot , there you can see the Coverage-01 and Coverage-02 are blank. I want to input "Full" in the coverage fields if respective MVPD fields is not null. like - for station : TV1 , the MVPD-01 is not blank so Coverage-01 field should be updated by "Full" but Coverage-02 should be blank since MVPD-02 is blank. I was trying to use below Script but not working **********************************************
other not working in drop down
Hi, I have added the other option for some of the drop down fields in the form. They all show in the report view except in the case of 'spread sheet view' but while I export the data none of them are shown in the exported data. Am I missing something ?.
'clear' can be used only in on load actions (deluge error message)
But In the following page: https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html you say: Example Below is an example code that can be specified in the On User Input action of a subform picklist field. list = Product [Category == row.Category] sort by Product_Code ; clear row.Items; row.Items:UI.append(itemlist.Product_Code.getall())
Page with embedded form requesting login but shouldn't...any workaround?
Hi All, I have a form embedded in a page using the script builder embed form gizmo: <div style='border:2px solid rgb(125,186,0); margin:4px;' elName='zc-component' formLinkName='DataEntry' params='zc_Header=false&zc_SubmitVal=Next&zc_ResetVal=Reset'>Loading Form...</div> Accessing the page via its permalink, I am asked to log in in order to see the contents of the form. How do I get the form in there without login request? Do I have to scrap the Embed format and insert the public access
Finding out the logged in user's role and/or profile from within Deluge Script
is there any easy way to determine the role and/or profile of a user that is currently logged in, in a similar manner as we can find the zoho.loginuserid - can the role and profile of the user be retrieved in deluge script at all ? thanks in advance, Jennine
Adjust editing in report
Hello, Can I change the order of the edit options in a report: Edit Delete Duplicate Print View record See attachments for a print screen. Greatings, Erwin
update formula when script updates fields druring edit
I have a formula field that sums the total value of several decimal fields. Example: Formula 1 = Decimal field 1 + Decimal field 2 + Decimal field 3 I have some on edit scripts that update the decimal fields with certain decimal values when a user changes certain fields. My question is how can I get the formula field to update / recalculate its value when an on user input script is triggered and updates a decimal field with a new value? It seems that when an On User input script updates one of the
Quick Access to Forms and Reports (right sidebar) questions
Maybe someone can help: 1. The titles (bold font) of the respective apps don't change although I changed the report and the form names. See attached image: The word 'Qualifikation' should not be there anymore. How can I change the titles or is it a bug? 2. Can I change the order of the quick access to apps and forms? At the moment it just places the forms and reports I added last at the bottom. I would like to move some up... 3. Can I make this sidebar stay there forever? Because everytime I acces
Maximum amount fields in form
Hello, What is the maximum amount of fields in a form? Greatings, Erwin Fennema
Main form sub form question
I have a two Main forms and 1 subform Form A Subform A (embedded in A) Form B I have data stored in multiple rows in the subformA of Form A ex. Form A SubformA record 1 record 2 on success of Form A, I would like to insert 2 new records into Form B that contain information from Subform A Any help would be greatly appreciated
No access to application
I have been shared an application through my gmail account. I have downloaded Zoho creator from the App Store and can log in and access the application on the mobile app using my gmail credentials. However, when I access the Zoho online, and log in with Google, I'm told that "You are not allowed to access this application." There are currently only two users for this application, myself and its creator. The creator can access the application through a browser or the mobile app. She tried logging
Public form/record editing
Hello, I'm building an application in ZoHo creator. Now in the application someone can make an assignment for a supplier. After making an assignment the application sends an e-mail to the supplier with a link which opens the record in editing mode. The supplier should put his comment and whether he aggrees with the assignment in this record. He only has to fill in two fields. The supplier will not get his own login (user). The problem is when I open a public record in editing mode, I can change every
speed application
Hello, I'm making a functional design for building an application in Zoho. Now I'm wondering if the following effects the speed of the application: Amount of databases Amount of scripts Amount of records I really need to know this because if these do effect the speed of Zoho Creator I have to think about combining some databases. This is not something I prefer. I've asked this question serveral times on the support desk and I tried to contact the support center by telephone, but I doen't get any
Stateless Form Not Updating Correct Record
I have a simple test application where I click on my custom action button displayed for each record. This custom action lunches a stateless form that contains a drop down menu to make a selection. Upon clicking submit on the stateless form a new record is created instead of updating the record that was selected from the custom action button. It looks like the custom action is not being properly being tied to the record where the custom action was selected. Can someone offer some assistance? - Thank
How to aggregate or concatenate text field content in multiple records
Review of Book A , Book B etc with a varying number of reveiwers. Records are grouped under Book A, Book B etc Reviewer 1 enters a record with a Review Field and submits: "A very good description". Reviewer 2 enters a record and submits "I enjoyed the plot analysis" Review 3 enters a record and submits " Yes it was suspenseful" How can i combine all the comments into a single review commentary of Book A so that it reads: A very good description I enjoyed the plot analysis Yes it was suspenseful
Creator with Google Analytics Web Tracking
Can we use Google Analytics Web Tracking in Zoho Creator? We would like to measure how users interact with our content and marketing initiatives in Zoho Creator. Thanks.
Number Formatting
Is there no support for spaces for thousands units in regular number fields? It's quite basic...
How delete a row from another form
I need to delete a row for one of my tables but i do in other form whit de id
Error execute Post URL
Hi Helpper. I have one problem with method PostURL of Zoho, please help me soon. This is my issue. This is my code: ================================================================ string = "{\"listObject\":["; for each form in forms { // Set make profile date == current date form.make_date = zoho.currentdate; // Create string to send to MyAPP string = string + "{"; string = string + "\"fileContents\":\"" + form.file_upload + "\","; string
How to add a message on Note/ Rich Text field
Hi, What I am looking for is that I would like to add a message on Note/Rich Text field. So user will have idea what information he should put in the field. You can see below screenshot what I am looking in the Note field where it is the multiselect field in creator.Here you can see there is a message "Select multiple Values". I would like to have the same in the Note filed but different message. Thanks for your help. Arfater.
Update successive lookup fields based on previous input.
HI, I have a form which has several fields.But there are two lookup fields which are looked up from same field Fips code like Fips-01 and Fips-02. you can see below screenshot . What I am looking for that I want to update the Fips-02 field on User input of Fips-01 . Say if user enters the value - 1001 in Fips-01 then this value should not appear in the Fips-02 . So finally in the Fips-02 should have only 1003,1005,1007 . It is possible to do that in creator ? Arfater.
How to update lookup field when using the api?
I'm trying to upload data using rest/json api and having trouble getting linking between forms with a lookup field. It is my understanding that I need to have the ID of the parent record to put into the lookup field. Can someone please elaborate on this? I think I may have misunderstood something. Any help appreciated. Thanks!
Order Management App rounding prices
I have started using the order management app that is provided by Zoho. I have made some minor changes to field names, but nothing major. I noticed that it is excluding my .99 from all of my pricing that I have entered for products. So the products are entered as 34.99 and it shows that correctly. But the add products field of an order entry brings in the price as 35 It comes in from the Product Subform but I cant find anything that is telling it to round up.
Connecting Zoho Creator with Zendesk
Hello! I'm in the process of testing itduzzit with one of my Zoho Creator apps and a Zendesk account I have. Basically, I will update a ticket in Zendesk when a record is created in the Zoho Creator app form and update the ticket in Zendesk when a record is updated in the Zoho Creator app form. I did some searching on itduzzit and I found some questions posted on this subject but no answers. I'm stuck trying to create an itduzzit connection to my Zoho Creator account. When I follow the steps
Limit the Aggregate in grouped records
AddressABC Record 1 $20 Record 2 $30 Record 3 $20 AddressXYZ Record 1 $40 Record 2 $10 Record 3 $20 Using the Aggregate criteria in script builder how do I return the aggregate of a specific address. For example the aggregate for Address xyz as $70. When I try to limit the records by the ID = ID i am still getting $140 The report is from a form where Address is a lookup field pointing to the Address Table.
Can't see more option to file upload
Hi, can anyone please tell me why I can't see more upload option like Zoho Docs into my Upload fields properties. as mentioned here https://www.zoho.com/creator/help/fields/uploading-files-and-images.html#Upload_Files Screenshot of my option:
How to import into a table in ZCreator from an external REST API source
Would be VERY glad if anyone could share a simple deluge script (.ds file) with an example of how to import data and put it in a table in ZCreator. The data are picked up from an external source with a REST API. In my case I want to import data from from Zoho Books, so if anyone have an example of how this is set up, it would be even greater. I know the REST API works, tested with curl, but need an .ds example to be able to get this into ZCreator. Thank you.
Error execute Post URL
Hi Helpper. I have one problem with method PostURL of Zoho, please help me soon. This is my issue. This is my code: ================================================================ string = "{\"listObject\":["; for each form in forms { // Set make profile date == current date form.make_date = zoho.currentdate; // Create string to send to MyAPP string = string + "{"; string = string + "\"fileContents\":\"" + form.file_upload + "\","; string
Customer Portal - Application Submission
Hi, I have an employee application program that is divided between seven forms (application part one, application part two, etc.). I need a customer (applicant) to log in and fill out each form sequentially. Each form goes to the next form upon submission of the preceding form. The applicants will login through the customer portal. I attempted to modify the permissions of the customer to restrict tab access, but I quickly figured out that it restricted access to all of the forms and defeated the
Hiding Fields on Embedded Forms
Hello, I have a service order form on which several fields are hidden, since only employees should make changes to them, not the customer who submits the request. Hiding the fields works fine in the application, but I also need these fields to be hidden when the form is embedded in an external website. Is there any way to do this? Thanks in advance.
Execute Custom Function on Selected Record
Hi, Is it possible to execute a custom function only selected records as like as below screenshot.I would like to select the specific records first and then execute a custom function to all selected records. Thanks Arfater.
Removing permissions
I have compiled a system for our web site and it works well except I would like to remove from the readers the option to do anything to the record (add, edit, print, delete etc). I cannot find a way of disabling them. This is the report that I would like to use https://creator.zoho.com/woodyham/group-leaders-report#Page:Reports1 Kevin Wallace
Import all data from MS Access (table,form,query,report)
Hi Guys, This website is good. How to import all data in Ms Access? Including Table, Query, Form, Report to Zoho? Thanks Adhie1973
Version history?
I accidentally overrided a function Ive created. When checking version history I can only see the changes made today, I need to retrieve the function as it was yesterday, is it possible ?? Thanks Walter
get Profile and Role in Deluge Script
Hi, Is there a way to get the role and profile of users using Deluge script ? Many thanks!
For each loop to Update a Field
Hi, I have a Report which have about 6,000 rows of data. Today I have added a new drop down field ( "Yes", "No") . So Now I want to update all records to "Yes". I know I can use Bulk edit to update the field. But I would like to create a custom function that will update in a single click. Below script I was trying but it is not working . void Test.AprovedToYes() { for each rec in MVPD_Subscriber_Calculation { rec.MD_Approved = "Yes"; } } Can anyone please help me Arfater.
ZOHO UI Is User friendly or not
i saw all your webapps that was cool stuffs but your UI is not user friendly ,and lots of stuff you are dumping on 1 page is there is any reason behind your UI or you will develop Rich UI,
Can forms in html page be placed side by side?
Here is the code for my html page: htmlpage THIS_WEEK_Timesheets_and_SMSs() displayname = "THIS WEEK Timesheets and SMSs" content <%{%> <table width="1200" border="0" align="center" cellpadding="1" cellspacing="1"> <tbody> <tr> <td> <div elname="zc-component" viewlinkname="THIS_WEEKs_Time_Sheets" parameters here </div> <div elname="zc-component" viewlinkname="TimeSheetTexts_Report" parameters here </div> <div elName='zc-component' formLinkName='Paid_Holiday_Amounts'
Next Page