Quotation marks in a string
I see this same question multiple times in the forum, but no answers. How do you set a string variable with a " embedded in it. I need the resulting string to be ... "text"... It cannot be a ' Help please, thanks!
Creator : Lookup Firstname and Surname of app user when selecting from a list
I have creator app that internal staff use to record training, I need to be able to pull a first name and surname from their ZohoOne profile when selecting them via a dropdown. The only fields I seem to be able to fetch are : username, email address and
Limit the length of a field in a list view
I have some multi-line fields in my application with a large amount of text in them. I need to include these fields in a view, but I don't want to display the entire contents because it causes each row in the table to be excessively tall. I'd like to limit rows to a certain height and have fields truncated with elipses (...) letting me know there is more content that I cannot see in the table.
How to access a records in a function called with a button
Hi, apologies for what I'm sure is a ridiculously basic question. I'm also not exactly sure what terminology to use to ask this, so I hope this makes sense. I want to write a function to look at all the records in a form and update them if they meet certain
function to calculate minutes between 2 time fields
Does anyone know of a function to calculate minutes between 2 time fields? I have 2 input fields, one called LKW which is defined ans a Date/Time field and second is called ER_Arrival which is also defined as Date/Time field. I want to calculate minutes between the 2 fields and present that in a third field called LKW-Door. Can't seem to find a function that will work.
Combined Reports / Reporting Across Forms
How does one report across forms? My specific use case is that I have two forms. One captures attendance (hours worked) for employees while the second captures work performed. Both forms have user field and date field, which ought to be sufficient for cross-reporting. There seems to be no way to do this in Creator, and only half-baked ways to do it in Analytics. There is documentation that this feature used to be available in Creator as "Combined Reports" (link), but I see no way to achieve this
Scan Barcode metadata and image source
I love the barcode scan feature for mobile devices. Please add the following or if they are available please point me to how I may access the following: Many times it is important to know what type of barcode is being interpreted. Is there a way to determine what type of barcode is being scanned. There are times when the data present in a Code 39 barcode has a different purpose or context than the same data present in a PDF417 barcode. Especially where 2D barcodes are concerned such as Data Matrix
Validation not Running on Create
I would like to validate some data before saving but I'm having trouble getting my apps to execute the validation when creating new records. It works fine for edits. I create a new application with a simple form with the attached workflow but it does not seem to work.
Onboarding of users via Stage
Hi, I read somewhere that it is possible to onboard users through Stage, and they can upgrade into Production. Have I understood correctly? I have a customer which I placed in Stage due to a temporary problem in publish to production, now this is fixed, and would like to just upgrade them direct into production from Stage rather than creating a separate account and migrating the registers manually. I can see that the option to upgrade is there, but just hoping that this will take the customer into
Photos keep disappearing
I add a photo and see it in the creator database. When I go back for any reason it is gone and I must put it in place again. IF I have two photos same record, one will disappear and newest remains. Each has unique name, but similar location.
Creating a Report with Sub Forms
I am trying to figure out the best way to create a report based on Sub Form data. Preferably a spreadsheet report. Here's my scenario. Say we have a form called DATA. The DATA form contains two forms as sub forms, let's call them OLD and NEW. I'd like to create a spreadsheet report for each entry in DATA that includes fields from each sub form , OLD and NEW. Is this possible? Thanks!
Username Change
If you change your Username this then changes the name in your default URL. WIll this affect other apps with already live default URL's with the old Username or will these continue to work with no change needed? Many thanks
How can I control the Permissions of buttons that I create in report?
How can I control the Permissions of buttons that I create in report? Does it have standard way to do that?
Unique ID
Hi, Is it possible to have Creator automatically generate a unique ID for each entry? I cannot find a way to auto-increment and in the expense tracker I am building I cannot think of any other way to guarantee that each entry is unique - for later finding. An alternative would be to use a Unix style datestamp, but I have had no luck scripting that either :) Any suggestions welcome Owen
Line Break in formula field
I am trying to put items on a new line in a formula field. I have found many solutions but none work for a formula field So far have tried Item1 + ''<br/>'' + Item2 + ''<br/>'' + Item3 Item1 + ''<br />'' + Item2 + ''<br />'' + Item3 Item1 + ''<br>'' + Item2 + ''<br>'' + Item3 Item1 + ''\n'' + Item2 + ''\n'' + Item3 <br>" "br/>" "<br />" all show up exactly as entered. Without Quotes, I cannot save the Expression.. Using "\n" doesn't show "\n", but also does not add a line break. Is it possible
Deluge script - button click - can't hide or show field
Just wondering why custom buttons can not hide or show fields? Error on show or hide is "show" can only be used on load actions. But a decision field can show or hide a field, so why not a custom button?
Is it possible to merge two Zoho Creator apps into one app
Is it possible to merge two Zoho Creator apps into one app It would be very useful if I could
form.submit
Hi, I'm using the Zoho Creator for an inventory management application and have found most things really awesome. I require to do an auto submit of the forms once all the fields are filled up correctly, something like a form.submit in Javascript. Is there a way to do this ? Is there a "force submit" counterpart of "cancel submit" ? Is there a way we can embed our own Javascript to do this ? Thanks, Zainul.
Conditional switching of mandatory field status
Hi I have a form that requires a number of fields to be hidden depending on the selection of a yes/No radio button field, ie if the radio button selection is "no", then about 6 other fields are not necessary and must be hidden. Obviously, if the fields which must be conditionally hidden are defined as mandatory, then on submit, errors are thrown for each of those hidden fields. Conversely, if the radio button selection is "yes", then all fields must be shown and they must be required fields. Is
Intigration with facebook
Hi, This is Surya, I am trying to integrate with Facebook and i want to post an image to Facebook from the creator using deluge [The image was already uploaded to creator using image field from local storage]. It is working when I use an image URL from external sites. But I can't post the images that are already uploaded to zoho creator.Please give me a solution for this. Regards, Surya.
how to create a button in View and a timer
Hi! I am new to Zoho and I need a bit of help with something. I want to add a button in a View so that users can click and go to the next Form. How can I do that? Also, is there any way of inserting or creating a timer for my application? Thank you!
Coupon Generator with end of date use
Hello World, I needed a coupon generator to generate about 200 unique coupon per day for my ecommerce and couldn't find one. I never coded before the last 48h and didn't know what a variable,function or index was. I watched a video about JavaScript for Beginner and went true the Zoho Deluge website to find functions. I then created this one. It gives about one and a half billion combination per day. Should i worry about having a double coupon value happening? Is there a way of avoiding it? Should
About Record Add Permissions
Hi there everyone, This might be a simple question, and I might just be overlooking something minor. I am trying to figure out how to allow the permission to add records for the Zoho Support team. As I am working with them on an issue and they asked me the follow: "If the script is triggered while adding records to the form, please provide your permission to add records from our end. " I know right now they are busy, so I may not get my answer for a bit. I was hoping someone could help me here in
Help regarding hide Reset button from form.
Hello I need some help. I have a form in which I am getting a value into single line field. I have two button Submit and Reset. I am doing functionality on Submit button. Reset button is no use for me. I want to hide reset button from Form. Please tell me how can I hide reset button from the Form. Otherwise suggest me alternative.
Developer / Creator EU licensing per user cost please
I am looking at Developer Creator Application, and wondering what the licensing model is? Is it the aligned to the Developer Creator Solutions starting at $2 per user, or Creator Apps starting at €10 if in the EU? Thank you.
Creator Calendar - On Validate
In my app, I've added some On_Validate logic to prevent users from changing a date field to a day that is "off", i.e. Sunday or Holiday. However, in the Calendar report, users can drag any appointment to those days. In other words, the On Validate script seems to only fire when the record is opened for editing. In the Calendar view, the date field gets updated. I could write the code for the "OnUpdate" event but by then, the data has already changed. Also, I don't not have access to the old date
Workflow schedule to send email
Hi there I'm setting up a workflow schedule based on my add employee form to email reminders annually on the employee's anniversary date/hire date. I want to remind the employee's manager to book the employee's annual performance review. However, the fields I have on the form are the employee's email address and the employee's reporting manager, which means that I would need to fetch the reporting manager's email. How can I use the reporting manager's email address in the To: line of the notification
How to use fetch and update to calculate current wage
I am new to deluge and I'm really struggling to figure out how to set up my creator app, particularly when it comes to referring to fields in other forms. One example: I have a form called Add_Employee which lists all basic employee info including Starting_Wage. I have a second form called Enter_Wage_Increase which uses a lookup field for Employee Name. I want to have a field called Current_Wage that calculates the employee's new wage based on Starting_Wage + Amount_of_Increase. For starters, I am
MAJOR Security hole in ZC5 reports(kanban)
@Support: With the introduction of the kanban report I have discovered a major security flaw. If a user creates a kanban report from a filtered lookup field, the filter will not apply to the values in the kanban. See: http://prntscr.com/lhr2k4 There is no mention of this in your help documentation. So if someone was creating all list reports and not using kanban they would not be aware of this. The only option is to remove the column from your report, in which case you lose the ability to see the
Creator - Schema Builder - Can you save the view?
I find the schema builder really helpful at times for visualizing my apps and their architecture as they evolve. That is, is helpful after I reposition the form icons to make some visual sense. The thing is, the schema builder always defaults to a random system generated view/arrangement, which is generally chaotic to look at. This happens upon refresh, it happens if you leave the view and come back to it, and it even happens on print - the print view itself reverts to the chaotic system view. I
Exporting report data to Excel?
Is it possible to export data from reports into Excel?
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"
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
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?
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>
zoho creator
How to create a workflow of auto number generating without using a auto number field?
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
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);
Next Page