User defined checkbox choices
I'm using the portal to have individual users fill in the their own forms. How would I allow my users to define the choices in a checkbox field on a form? Thanks, Scott
Problema con los usuario de mi licencia
Buenas, tengo contratado 2 usuario en una licencia standard, pero solo puedo entra con un solo usuario , el segundo usuario no me deja entra. Que debo hacer
How to use mandrill in zoho creator application for sending emails?
How to use mandrill in zoho creator application for sending emails?
How do I add days to a date?
Not sure where to ask this, but I want to add days to a date. So, for example, the users puts in a target date when they want the item to arrive. Now, depending on a few different things, the actual ship date may be a few days different. What I did was create a target date input field and a ship date formula field. In the formula field I tried to do target_date = ship_date + 5d What am I missing here? Thanks
Display subforms like forms
Displaying subform forms as if they are list reports can make data entry unwieldy on smaller devices. I'd like the option to present them in form view (like the forms they belong to). A collapsible list displaying an identifying expression for each row that would expand when selected to display the subform would make it more manageable.
Customize or override CSS in Reports
Is there a way to override the group row color on reports? Currently it's yellow and I'd like to change that. The CSS class is zc-grouprow.
Send email from action
Hi, I am trying to create a simple Stateless form to send email to selected records. the main form: 'Register' includes email field 'Email' the Stateless form: 'Emailtoselection' includes mulltiline field 'RegID', and Email_Subject and Email_Message fields. I basically followed this post where Cyril M explains and my code looks like this: function to open Emailtoselection form and below that the sendmail function for the Send button: void SendEmail_toselection(Register rec) { openUrl("#Form:Emailtoselection&RegID="
Zoho creator api query where field blank or null?
I tried posting a long question related to this but it was marked spam so I'll just have to post multiple smaller questions. I can't seem to figure out how to do an api query where a value is blank or null, not sure how zoho stores it, whether it's blank or null as the underlying value. What's the proper way to query with criteria this way?
Record Audit search by Record ID
Is there a problem with searching the Record Audit by record ID? I tried with Firefox and Chrome and could not limit by the record ID. When searching by the email address sometimes it worked and sometimes it didn't.
Error 500 when selecting settings
Error 500 when selecting settings, I can't select settings. app is shared.
problem in ical feed implemetation
I have problem with ical Feed, When we replace the ical field DTSTART with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page.
Ical feed not working in goole calender
I have problem with ical Feed, When we replace the ical field DTSTART value with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page.
how can i Create a list with uploaded file
Hello, i worked in zoho creator, and need create a page, to show some data from a report (zohocreator). I can show all the information, but when show a upload file, just show me a plaint text with the name, but i want show the link to download the file.. how can i do this? This is the code: htmlpage test(numso) <%{%> <table width="100%" cellspacing="1" cellpadding="1" border="1"> <caption>Facturas</caption> <tbody><%for each r in Ordenes_a_Facturar {%> <tr> <td><%=r.Numero_de_So%> </td>
Combine data in pivot chart
Hello. I have Dropdown field named (Procedure) with options: "Primary implantation 1xICD" "Primary implantation 2xICD" "Primary implantation 3xICD" "Replacement of implantation 1xICD" "Replacement of implantation 2xICD" "Replacement of implantation 3xICD" "Explantation 1xICD" "Explantation 2xICD" "Explantation 3xICD" And i want to create pie pivot chart with two options of data: 1. Primary implantation that contains summary of "Primary implantation 1xICD", "Primary implantation 2xICD", "Primary implantation
Insert record function stopped working and cant access usage limits
Out of no where we are unable to insert records using functions and it seems we cant see our usage limits section any more. It just loads but will not show any date. Im thinking maybe we have gone over our record limit and so we cant insert any more records. I have added another 10k records but still cant insert records or see how many records we have used in the add-ons usage limit section of setup. Please help, the error message i get when inserting records does not say much but here it is...
append data to URL
Hi there, I had a function with an URL in a variable that appended some data to pre-populate fields: link = "https://creator.zoho.com/zoho_mikis/rangitane-beneficiary-database/#Form:Registrant_survey?Registrant_Email=" + recSurv.ID + "&Registered_with=" + recSurv.I_wish_to_register_with; That worked well, however it's Public that needs to access this form, so I published the form, which gives me the URL with the long public code. I added the same fields to it, but that does not seem te be
Creating multiple records
Hello, I have another question. I have the following forms: Form 1: In this form you have to make a rule and fill give them 3 labels: Label_1 Label_2 Label_3 Description Form 2: In this form you have to make a selection based on Label_1, Label_2 and Label_3. After selection the submit button it has to do: Create new records in Form 3 based on all the rules in form 1 from the selected Label_1, Label_2 and Label_3 in Form 2. So all the labels which are equal on the select Labels in Form 2. I have do
Automate time calculations
I have in many of my forms time fields that calculate the difference between currenttime and a set time: ( ((ETB - zoho.currenttime) / (1000 * 60 * 60)).round(1) ) This works fine when updating and editing the record. However I often work in a report overview, and I need to find a way to re-trigger the calculations for all the records in order to get updated time difference on regular intervals i.e. every 2 hrs, I have however not been able to figure out a way to do so yet. Any ideas?
Admin fields visible and editable by user?
I am a little confused how user permissions work. I have several Admin fields, but my users cannot see those. I want to hide certain fields when forms etc are published (as they do now), but my users for this app need to see and edit those fields. Can I give a user permission to see the admin fields?
Zoho Creator Report: large-number formatting
Hi can anyone tell me how to format large numbers, say "3 billion", into comma-separated format like 3,000,000,000, in a report?? Thanks!
Mobile App - Error on loading
Hi, I am having trouble loading the mobile app on one of our user accounts. I have enclosed the error message, and screen shots of the error: ------- Log Details ------- https://creator.zoho.com/api/mobile/xml/orchestra/sections/zc_ownername=johndobble2&scope=creatorapi&isCrm=true&isRules=true org.xml.sax.SAXParseException: Unexpected end of document at org.apache.harmony.xml.parsers.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:125) at com.zoho.creator.jframework.ZOHOCreator.postURLXML(ZOHOCreator.java:2161)
Does not in years work?
Hi, This saves: rec = Form_Name[!Date_Field in last 18 years]; But does not work, I can't find any mention of whether it should work or not, can you clarify? Thanks, Damien Cregan Hire an Expert
proble in ical feed implemetation
I have problem with ical Feed, When we replace the ical field DTSTART with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page. This is my ical url ' https://creatorexport.zoho.com/tantawy/pipeline-management-and-metrics-tracking/ical/New_Appointment_Form_View/DTSTART=Appt_Date_Time_Original&DTEND=Appt_Date_Time&ORGANIZER=Practic '.
Conditional formatting on upload field.
This is working just fine for standard fields. How can I test for blank upload fields, ie where a file has not been uploaded I want the report to show "red".
How to Send XML API String to crm
I am trying to convert a lead in zoho crm to a potential from Creator. I have followed the documentation here as best I can: https://www.zoho.com/crm/help/api/convertlead.html I have created the XML String but im not sure I know how to properly post this. I am using POST URL function and hopefully I have it formatted correct. I took all my values and put them into a map variable including my XML string. The process of stringing together values to make the XML string is pretty stupid. Maybe there
Zoho generated email are not received by client anymore
Hi, I started this topic yesterday but somehow I do not see it anymore so I post this again. Recently our client stop receiving notification email sent from our Zoho application although we receive it (we cc ourself in the email). According to our client they did not make any changes to their mail server. Anyone have the same issue? We suspect that somehow the email from Zoho has been blocked. So could anyone tell me what is Zoho mail server IP Address is so that we can remove the block?
Will Zoho ever support the distribution of Modules?
Hi, We would like to use Zoho to create a custom module which we can distribute to clients. However, we have been informed by Zoho support that a module can only be installed once. Therefore we cannot distribute updates to our module. It also prevents us from migrating our changes from a test Zoho environment to a production Zoho environment. Is there a way of achieving this at the moment. If not, will it be available anytime soon? This limitation must be preventing a lot of people from using this
Page Title Variable
I would like to put a variable in a sentence in a Creator form that identifies the Wordpress page title that it is in. For instance, the sentence might say "To get a link to (variable) fill out the boxes below." The variable would be the title of the page that the browser is showing the form in. The page title might be "the brochure" or "the video". Alternatively, I could put a piece of code on each page that identifies it, so then the variable would be filled in by that piece of code. How would
Pass search criteria from stateless form to report.
I'm using a stateless form with a lookup from customer input form. I created a new report Log_Reports with information from the Customer_Name input form/report. Using this deluge script I am trying to pass the dat variable which contains the name selected from a lookup in my stateless form and pass it to my report to include all the customer logs selected. The dat contains the customer name, "John Smith" dat = Customer_Name [ID == input.Customer].Name; openUrl("https://creator.zoho.com/<name>/test-htmp-page/#View:Log_Reports?name="+dat,"popup
New to ZoHo Creator and have a couple of questions
Ok firstly thanks for taking the time to read this. So my project i am working on is an Asset management tool, that will allow us to photograph assets (computer equipment) in our company and add relevant spec info. I have the forms working ok and am happy with that. What we will want to do though is sell some of the Asset's through ebay. Currently this is a very manual task and I would like to make some of it simpler. So what I would like to acheive is: 1) Create a list of all asset's not listed
Can't create a solution for this kind of loop...
I used to find solutions for loops in various situations, but now I am stuck... I need to automatically fill new database table (form) with multiple records. One record represent one calendar day. Records shall start from user-defined StartDate and finish with FinishDate. For instance, 07/12/2015 ... 08/12/2015 ... 09/12/2015 ... This will be used to calculate some statistics for each day, and to print a report / chart. Typically, I code similar loops through recurring function. Hope you've
Is it possible to do Boolean search in Creator?
I am entering recipe information, including ingredients. I'd like to be able to do a search for recipes with, for example "tomato and basil" or "balsamic vinegar or cider vinegar." Is that search capability possible in Creator, to do a Boolean search with "and" or "or"?
Zoho Creator Application/Software Development Agreement Template
Hello, Do you guys (zoho creator) or any anyone else have a Zoho Creator "Application/Software Development Agreement Template" we, zoho creator users can use when creating apps for friends or businesses? Iram
Transfer Creator Application to Other User
Hello, I have a professional Zoho Creator account and I don't have a zoho creator developer certification or anything like that, just a regular user of zoho app user. I created an application and shared it with a friend. My friend has added a lot of data to the app including pictures in the picture fields. I would like to transfer the application and data with pictures completely to the same friend. I ran across the below zoho forum question that was posted 5 years ago. Do the instructions in the
CreatorAPI via Powershell
Hi! I have been struggling with the Creator REST API to get it work from Powershell. I have created an API token and I've been working with invoke-webrequest and invoke-restmethod without success. I'm using invoke-restmethod for accessing data on Dropbox via their REST API so I'm pretty familiar on how to do it but obviously not enough... Can someone provide me with a simple list-applications example or similar so that I can just replace the token with mine? Thanks in advance
Look-up a fields 2 forms deep
I have a form called "Shifts" with a look-up from a form called "Employees" Employees uses an other look-up from a form called "Functions" Is there a way to show a field from "Fuctions" in the "Shifts" form? Thanks in advance Perry
Customer Portal Security Issue
When a portal user is signed in, his username is displayed at the sign out link. Please remove the user name. Cheers, John Whitney
Ip address of person submitting public creator form
Is there any way to get the ip address of users who are submitting a public zoho creator form on my website? It seems zoho.ipaddress only gets ip address of login in user which is not what I need. I need the ip address of anyone who submits one of our public zoho creator form. If zoho cant handle this directly does anyone know a service or some method that could be used for this?
display "null" in empty fields like ""
Hi ! How to display "null" value in HTML page like a empty word in number and decimal fields max_rate = IFNULL(r.max_rate,""); don't work > error "oth the argument should be same type for 'IFNULL' task. Expecting 'BIGINT' expression found 'STRING' expression" Thanks !
can you enable or disable fields with an open url command?
I want to disable fields in a form that I open with open url commands. is this possible?
Next Page