Live Page
Hi I am working on a hospitality app which requires the kitchen staff to see all food orders on a screen and update the order with the press of a button from the report itself. The latter is easy but I just can’t find a way to keep the orders report up to date. Manual refresh of page is not ideal as the customer wants their big kitchen screen to show all the orders with their live status. Wondering if there was a way to make a ‘live’ report? I mean I could make an HTML page to visualise the orders
Importing CSV data only to inline subforms
I have two forms, parent_form and child_form. The parent_form has inline subform which is child_form. My question is about importing CSV data which has many null values(so when imported, some rows are not imported correctly, but it's OK for me) to child_form_report. Import actions are done frequently. The results of imports are that the child_form_report has data from CSV, but the parent_form's inline child_form does not have. I think if could, when imports are completed, inline child_form will have
Approval Process of a Subform
I have a request form, Form A, which includes a sub-form, Form B, for any purchases that need to made for the request in Form A. When Form B has an entry within Form A, is there a way to trigger the Approval Process? I can only seem to have the Approval Process triggered when Form B is filled out independently of Form A.
Double "For Each" loop to update grand-child record
Hello all, I have three forms: countries > cities > airports. Each child is related to its parent with one to many bi-directional lookup fields. Saying it differently, each city is related to one country and each country is related to multiple cities. The same is true for the cities-airports relationship. When an update happen on a field on "countries" (the parent), I am trying to update fields on cities (the child) and on airports (the grand-child). I succeed to update the child using "For Each"
Embed a google map in a ZOHO page in creator
I tried to add the share link of my google map in Pages. Nothing shows up. How do i add a map . Any help is appreciated. Thank You, Chris Edit: I should mention, that it is just a static map from GoogleMyMaps. They provide a share link ,which is what im trying to use.
Changing behavior of lookup suggestion/autocomplete
Hi, 1-I'd like my lookup fields not to display records in a dropdown fashion. The info in these lookups are private and I'd like the user to type in his value (for example, email), and after 3-5 letters the field would start searching for autocomplete. 2-Or another solution would be to not give any autocomplete/suggestions: to just match the value with the existing record, and if there's no match, then prompt the "Add new record". 3-The last solution would be to filter the lookup in a way that no
Trigger "Created/Edited --- On success" workflow. of related records
Hi, In form A, I use a "Created/Edited --- On success" workflow. In this workflow, using deluge script, I'd like to trigger the workflow of other related records that are linked by lookup field. Is there a way to do that? Thank you!
URL parameters to pre populate a form
Hi Have tried to pre poulate a form from this... to this.. Product_Used is a Lookup field to another table, with values 1,2,3...etc Have tried the form url with "/Product_Used=2" or "?Product_Used=2" appended to the url, but that does not seem to work. Have also tried ui.add restrictions, but that dis not work. Cannot find anything on the forums. Can anyone help, going slightly mad as I am probably making a basic mistake?
User Input Pop-up - Does this exist?
Is there any way to have a user input prompt that pop's up asking the user for input? For example, exactly what is seen on the back end when you are executing and testing functions, there is a window that pop-ups prompting the user for input. Does this exist outside of the old stateless form idea?
Zoho Creator page in CRM web tab - dynamic filter does not work
Hi, My page has a report "Loan applications". The button "See related documents" triggers a custom function which passes the application ID as page parameter. The documents report is filtered in a HTML snippet which has the following code: <%{ %> <div elName='zc-component' reportLinkName='All_Documents' params='zc_Header=true&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&Application.ID=<%=application_identification%>'>Loading Form...</div> <% }%> It works perfectly in
How to clear field values?
I see how I can CLEAR by using 'Delete all items from the given picklist/radio/checkboxes/multiselect'. How can I clear the value from other fields like Date, single line and others? I am finding it difficult to use the show and hide command without being able to clear values on HIDE. In my other example, I have a 3 fields Allergy, Severity and Allergen. Severity and Allergen are hidden on form load and shown when Allergy == 'Yes'. If you add info to the 2 fields and then go back and change the
ZOHO Creator and ZOHO Sheet
Hi Can ZOHO SHEET be intergrated with CREATOR ?? Can I use the front end cut and paste functionality of SHEET with the backend validation of CREATOR?? TIA Allan
Dropbox PostUrl Save_Url
Good day Im trying to figure out a PostUrl to save a url file into a dropbox account, but I got a 400 sintax error, I try to do the same curl dropbox example with a postUrl, I try always encoding the url param. What I should doing wrong? curl https://api.dropbox.com/1/save_url/auto/images/downloaded.png \ -d url="https://dl.dropboxusercontent.com/s/deroi5nwm6u7gdf/advice.png" \ -H "Authorization: Bearer <ACCESS TOKEN>" headerMap = {"Authorization": "Bearer <MY TOKEN>", "url": "https://dl.dropboxusercontent.com/s/deroi5nwm6u7gdf/advice.png"};
Color of the custom action buttons that are shown
Can you change the color of the action buttons that are shown on reports/views for each record?
Calendar Report only showing 6AM - 6PM
We have a calendar report in our application. Until recently, it showed the full 24 hours of the day. At some point in the past few days, however, it started restricting the hours shown to 6AM - 6PM. As a result, some of our records are being cut off and we are unable to access them through this report. This is happening across applications, so it is not related to just one report or change we have made. There doesn't seem to be a way to set what the working hours should be restricted to in any
interacting with mysql db hosted on azure
How can we make a Zoho creator app to get/post data to a MySQL db which is hosted on Azure.
Security Update Applied to Public Applications
Dear App Creators, We have rolled out a security update on July 2nd, 2020, for "public applications" and "public components" — Zoho Creator applications or their forms, reports, and pages that are made public to all visitors over the Web: Note: Unless you receive an email from us regarding this, this update does not concern you. Emails have been sent About the update When a user (logged into their Zoho account) accessed a public component, the Deluge system variables zoho.loginuserid and zoho.loginuser
import xls file with european date format dd.mm.yyyy
I am trying to import data from an .xls file containing date fields with european date format like dd.mm.yyyy Importing the xls file the date column appears as a dropdown field. When I want to change it to a date field, I get the error message: "One or more rows contain a value that´s not a date. These won´t be importet. Proceed with changing the field type?" All the fields in the row have the correct format dd.mm.yyyy What to do to import the european date field correct?
Pass File_upload field as function parameter
Hi, I can't pass a File_upload field as function parameter. I need it to do the proposed workaround to preview a file: https://help.zoho.com/portal/en/community/topic/how-to-open-a-pdf-file-of-a-view-in-preview-mode Why is it not working? I activate the function through a custom function button found in a report. The File_upload field is shown in the report, but I can't select it as a function parameter. Thank you for your help!
Inquiry regarding how to customize CRM with CREATOR
We are using zoho CRM and CREATOR. However for accommodating our business more, we want to create an interface with CREATOR to link CRM database, and it needs customize tab made from CREATOR inside to operate database of another tab. In order to put it into practice, how should we do? best regards, Ueda
XML RPC API - Failure, Invalid or null criteria specified
I'm using the XML RPC API's for editing data, following the example that they gave (modified). This is the XML that I am trying to parse with the API: <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name='supportv15'> <formlist> <form name='Main_Database'> <update> <criteria> <![CDATA[(Return_ID=="HORP53376")]]> </criteria>
Sorting records by date on a subform
I have a subform sitting on the mainform. I have a fetch record deluge script. Two issues. First issue, I cannot do a sort on the records on the form unlike reports. Second, the records pulled up on the subform are duplicated atleast twice. Below is my deluge: fet = All_Table_Donations[Fk_Sponsor_ID == input.Child_Name.Sponsor_ID]; input.Sponsor_ID = input.Child_Name; input.Birth_Date = input.Child_Name.Birth_Date; input.Sponsor = input.Child_Name.Sponsor; input.Surname = input.Child_Name.Surname;
Workflow on form validation
I've added a workflow to extend my validation but it doesn't work. I have no idea why it is not working: Steps I've taken: Add workflow Select form to apply workflow on In my case I want to apply the workflow on Create and Edit And the next step is my line of code. But when I submit the form with one of the selected values, nothing happens, I don't get any alert. Not even when I just add an alert on top of my file so I am stuck on this. Please help me if(input.CompanyType.Name == "reseller" || input.CompanyType.Name
Iframe opened by OpenURL stopped working
Hi, I invoke an iframe into a HTML snippet in my Page using openURL. I created this workflow a few hours ago, it worked for a time and now is giving me this error: I invoke the OpenURL through a custom action. Here is the code: My pages are published: Also, when I invoke the same report within an iframe, it works. I use the following code: Please help! Also, I have a question: is it possible to filter a report by filtering a multi-select lookup with ID? For example: Url/Multi-Select_Lookup_Field
Calculate KPI
Hello, i need to calculate a KPI in ZOHO creator: i have the first Field called 'Montant_Total' using the Panel i can get the Sum() of all 'Montant_Total' like: <text type='Form Data' value='thisapp.Cr_er_Task.Montant_TOTAL.sum' size='8' color='#2A70E7' bold='true' marginTop='2px' displayType='actual' decimalPlaces='2' decimalSeperator='.' numberScale='none'> </text> and i have also all the inout (Count) using the script bellow : <text type='Form Data' value='thisapp.Cr_er_Task.ID.count'
Subform lookups
Hi All, I'm trying to fetch records but my usual method isn't working as I'm dealing with a subform now. My main form has 2 fields, part number and name. I have a subform within the main form which has a lookup to both these fields. I would like the user to add a row to the subform and select a part number(s). I then need the subform name field to be auto populated with the corresponding name(s). The lookups in question are both multi-select. Can anyone show me the correct syntax for this operation?
How can I get value from another form based on multiple user input values
Hi all, I have 2 forms, Material Cost and Quotation forms. I would like to fetch selling price from Material Cost, which 4 user inputs need to be matched. e.g. selling price is based on Material, T, W, L all 4 fields in Material Cost are drop down fields. Please see screenshot in "Material Cost Form" Here in Quotation form, I have Material - lookup field T, W, L - decimal field Please see screenshot in "Quotation Form" How can i fetch the selling price? Thanks in advance Mien
Creating a New Record, can I retrieve URL parameter?
I have a report that is filtered using a URL variable, like this: https://app.zohocreator.com/xxx/xxx/#Report:PlanReport?PlansID=3918399000000852003 When I click the "add" button from the report header, I want the new record form to open and populate the Plans field in the form with the PlansID parameter in the URL. How do I retrieve the parameter in an On Load Deluge script (to pass into the field)?
Matching Products to Deal Requests
Dear All, Use case: Real Estate agent I want to have a button on my Products page that when clicked opens a 'Matching' page that lists all the potential customers that may be interested i.e. matches on the price field, no. of bedrooms, neighbourhood etc. I then want to be able to select those I wish to email with Product brochure. Can someone describe the bones/structure of this configuration? Would it be creating a 'Matching' module, running a report on the search criteria? Would this all be done
zoho creator
How to create a workflow of auto number generating without using a auto number field?
I need to insert 300 records to a zoho creator report
I am trying to insert 300 records, but I get the following error 414 Request-URI Too Large, but if I send 2 registers everything goes well . How can I insert the 300 records into the report? I share my code. //Two Records $data_xml = "<ZohoCreator> <applicationlist> <application name='zoho-cdr'> <formlist> <form name='Formulario_Carga_Inicial'> <add> <field name='ID_CDR'> <value>1213</value>
How to check the dropdown selected value is null or not.
How to check the dropdown selected value is null or not. Iam using the following code , if(input.dropdown!=null && input.dropdown!=""),But this is not working for me. EX;if(input.dropdown=="Some value") show "Some value" else if(input.dropdown=="--select--") hide "--Select--";//i need to hide the "Some value" but that is not happening. Please suggest any solution.
autofill lookup field in subform
Thanks for any help on this. I have created two forms/tables: property and building. building is child of property and has a lookup field of 'property name' in property table. I added a subform building to property mainfrom. My goal is: 1. when user edit an existing property, all the buildings associated with the property through the lookup field will be shown in the subform of the property. 2. when user add new building to an existing property, 'property name' is automatically filled in the subform
Source IP address of Zoho servers for postUrl() commands
Hi, Is it possible to get the current IP address range of Zoho servers making postUrl() requests? We'd like to whitelist these addresses from our firewall. It would be useful if these addresses were published on the docs (or maybe they are, couldn't find though ;) Best regards, Ville
Using localized letters in Creator Forms
Hey, I´m facing the issue that my employees can´t use the german letters : Ä, ä, Ö, ö, Ü, ü and ß in my Creator Forms from the keyboard. They are getting a constant error message. Is there any solution for this problem, so that the Forms are accepting that specific letters?
Zoho Integration with ActiveCampaign
When Adding a contact in Zoho creator it should add automatically on ActiveCampaign. For that I am using workflow but it always returns:- {"errors":[{"title":"Email address is required.","detail":"","code":"field_missing","error":"contact_email_was_not_provided","source":{"pointer":"/data/attributes/email"}}]} I am using this code :- m = Map(); m.put("email","abc@gmail.com"); h = Map(); h.put("content-type","application/x-www-form-urlencoded"); response = postUrl("https://shobhitagnihotri123.api-us1.com/api/3/contacts?api_action=contact_add&api_key=d13fe84cffb52d11060b3daadc75172982e4e16d21b3f57b5b1c09363a041fe2aa779aee",m,h,true);
Multi-Select Data in Charts - How to?
Hi - I have a simple asset library (1k records) where I track things like asset type, and date. There are some fields that are multi-select (like which product an asset relates to, it can be more than one). How do I graph multi-select fields? This is a critical feature for my app.
passing parameters on embedded forms and reports
hi i have 2 forms and a report embedded on my website and i want to pass parameters between them. i was able to do it on zoho platform by writing open url script on the first form to call the report and then writing a custom action function on the report to call the second form but unable to do it after embedding them to my website. thank you for your help.
Continue display of the next form field on the same line.
I want to be able to design my forms to logically use the space on the page with some lines containing one field, some two, and even some three, horizontally. My forms are so enormously long because a whole line is wasted for one small field. I am aware of the two column option, but I can't place my fields where I want them, they just start at the top and cluster together. One column only and two columns only is not friendly at all to the way forms look in reality. Please add the option to continue
How to get total record county for application
Hello all, I'm sure this is a simple question but, I have an application built in Zoho Creator Premium and I'm signed up for 3 users (25,000 records per user). I'm planning on importing new records into the application but want to make sure I don't go over my record count since as of now I have 75,000 records at my disposal. I'm wanting to import some records from a past database we used to use (300,000 records). I want to import a couple thousand just to show my employer that it would get beneficial
Next Page