Syntax for IF
Hi What is the syntax for an IF on two dropdown boxes? Want to say IF Dropdown box 1 is "x" AND Dropdown box 2 is "y" then show field 1 hide field 2 but IF Dropdown box 1 is "a" AND Dropdown box 2 is "b" then show field 2 hide field 1
How do I show the Submit button using Conditional logic?
I would like to only show the Submit button based on a choice from a radio field. If a user selects one of the options, using conditional logic they are shown a message field, which is what I want, but rather than the form allowing them to click Submit, I need the form to not go any further, deterring them from continuing on. Currently, they can click Submit regardless, which causes our organization to receive many invalid form submissions. The Submit button needs to show only on the 1 option we
Refer Fields Function Back
Last week I was able to use Refer Fields function to update some Apps, this week just gone? Anyone know how to get this button back? We got lots of forms and fields link together. Thanks
Dropdown showing 'Choice 1 Choice 2 Choice 3' instead of my custom labels
Is this a known bug, or is there some reason why my custom labels are not showing, and instead my application is showing users 'Choice 1, Choice 2, Choice 3'?
Why can't I update 'Add notes' Field Deluge name
Every time I try to update the field deluge name for an 'Add Notes' field... it does not save and reverts back to the default name (e.g. plain, plain1, etc) Is this a known issue? or is something else wrong? (I'm beginning to question if Zoho Creator app is production ready since things like this shouldn't be happening (and within my first 30 mins using the tool)) #gettingworried
Deleting duplicates in a form
I am trying to find an algorithm where I can find all duplicates in a form according to a key field or composite key field, and in each group of duplicates I only keep the oldest record per Add date. How can this be achieved with Deluge? Thanks
Sending SMS Through Twilio - Trouble with IF Statements
I am trying to send a message to only certain workers who are: Active and either Foremen or Leadmen The if statements below don't seem to be working like I thought they would. Any thoughts? for each r in Worker_Information [Worker_Status1 = 2937369000000532011] { if (input.Enter_Worker_Designations = 2937369000000747003) { mob = "+1" + r.Mobile_Phone_Number.getAlphaNumeric(); m = "<Red Iron Alert> " + r.First_Name + ", " + input.Message; resp = twilio.sms.send("Zoho1",
Backup in a client?
Is there any option of getting the back up for the data of an application that is being published to a client?
substring
I am needing to separate the characters in a zipcode, so I found the substring function and tried to use it to fill a field named region with just the first characters. However, when I wrote the line below in the free-flow scripting for on user input of the zip field, but it said "Not able to find 'substring' function". Is there something wrong with the script itself, or in the way I did it? region=input.zip.substring(0,2);
Boolean field
I would like to show a check mark instead of the value of boolean field (true/false). How can i do it using Zoho Writer?
Just getting started Need to create hyperlinks
I am just starting the process of possibly migrating all of my systems into Zoho. This question may be answered somewhere in the help files, but I have been through the 15 videos and didn't see an answer. I have a single line text field which contains a ticket number. I need to concatenate a rather long URL (www.specialsite.com?ticketnum="[value of ticketnum field]. I need to be able to click on this and launch the web page either in a new window, or at least a new tab, I believe that this will
Form Data in Email no longer formatting correctly.
I have forms coming to email with all form data in body. They use to arrive formatted correctly. Starting last week, they all come broken now. Shown below. Please help. User submitted data Are_you_18_years_of_age_or_older :Yes If_no_why_not : Email : May_we_contact_your_supervisor :null Address :test Your_Job_Title : Reason_for_leaving1 : Employer_s_Phone_Number : Present_Last_Employer : It use to be like this: User submitted data First Name John Last Name Doe Address 123 Main St City Sunnyville
Changing number field to text
I have created a form with a number field. We have so far generated around 400 records, now it has been identified that we actually need to be able to replace the number field with a text field. Is there any smart way to implement this or is the only solution to create a new text field and update all records manually to move the data entered so far in the number field to the text field?
How do I import people's availability from spreadsheet and generate a calendar?
Hi Zoholics, How do I import a spreadsheet of people's availabilities? I've been using Zoho Creator as part of my attempt to create a client/provider availability calendar, and although the form What I Have I have a spreadsheet (attached to this question as a Google Sheet) similar to a CRM format. The information represents students' names, ID#, and availability. Each availability time-slot is represented as a column - F1 for Monday 1st Period, G1 for Monday 2nd Period, H1 for Tuesday 2nd Period,
How can multiple users edit same row in spreadsheet
Hi I would like to know if there is a possibility for 2 (or more) users to edit the same row in a spreadsheet, we tried to do this, but it seems only the data from the user who clicks SAVE button last works. Meaning, that if 2 people worked on the same row, User 1 data is lost, and only User 2 (who clicked Save) later is kept. Is there a way to enable multiple users to edit same row at the same time? Or to somehow block the row, so that other users do not try to change it. Please let me know Thanks
Setting a Default subForm entry, On Add Row code does not work
When I set a default entry on a subForm, the On Add Row code does not run on the default entries as it would if I manually added those rows. It probably should. Any workaround?
Report Image is not viewed to the shared users
I want to display my report which contains images with the URL Format http://creatorexport.zoho.com/zoho_admin_user/app_name/report_name/ID/image_field_name/image-download/1493994637400_3029081000006627203]_photo_one. If i share my report to other users, the image is not displaying. how can i solve this issue?
My Frist Creator Application
Hello Zoho Community, I created my first Zoho Creator Application. It consists of a basic form in which I record usage data by date. The form consists of 5 columns Date - Value1 - Value2 - Value3 - Value4 01-01-2017 - 1000 - 2000 - 3000 - 4000 08-01-2017 - 1100 - 2200 - 3600 - 4050 16-01-2017 - 1201 - 2400 - 3800 - 4100 23-01-2017 - 1308 - 2600 - 3990 - 4150 How can I add a column that calculates the number of day since the last entry?
Creator Issue with App Since New App Uppgrade
Has anyone else experienced a issue with the Creator Mobile App since the App upgrade? It seems to get "stuck" if you have a process that needs to take place before moving on to the next field. IE. Capitalization to "Allup" letters, a math calculation or a lookup. This has become very UNPRODUCTIVE in the field. We get the "waiting spinning" icon. Sometimes its clears after several minutes, most of the time it doesn't. We have to close the app, force stop the app and try again (until it works).
How to add attachments/uploads to a different record?
We created a multi-page application that updates records in a 'master' record. Each form collects different information and adds it to the master record by passing an ID between the forms. One of those forms allows users to upload documents. How can we create a form that allows the user to upload attachments and add those attachments to the 'master' record by ID? Is this possible? Thanks, John
Conditional Dropdowns in Subforms
I created a form where the available values of some of the lookup fields were filtered based on selections made in other lookup fields. The filters work great if I access the form directly. But, the filters don't work at all when the form is used as a subform. Is it possible to filter lookup field values in subform dropdowns based on selections made in other lookup fields in the same row of a subform?
Sendmail Issues - Other Users Having Issues?
Any other users having sendmail issues frequently? Emails are currently not sending in our application and this has happened multiple times in the past few weeks.
Invalid Characters
Hi, I am trying to enter data in to a form via the report interface. When i try to submit I get invalid character error message but the error message doesn't report which character is the issue. The error message is below and the text from the file is attached. "1 . Failed to update data. ." Please could advise which characters are causing this issue so i can find and replace them and upload. Thanks
header within a report
Hi I use to print each record of a report as a "summary" and I want to insert a header - my name and address - on the top of each printed page. I have been told that this can't be done only creating an html page. I am not so good with html.... I tried to embed the report within a page but it is pasted as it is and can't be edited. How can I append this two rows before the report itself? Thank you!
How to display line breaks in an html view for multi-line text?
If I put html line break code in the text then that br code shows up for people who view the field within Zoho's non-html views. But multiple lines of text show up as one line in an html view, although they show correctly in other types of views. Is there a simple way to make multi-line text show as multiple lines within an html view, without the html code showing up in other views?
Click to call in Form
Hi, I want to be able to click to call from a clients profile. This works from the Reports running off my Forms, but I want to be able to do this from within the Form itself so Data can be updated at the time of the call. However, unlike on the Reports screen, when I click a telephone number in the Form view it does not call the number as desired. Is there a any way to get this to work?
Changing a dropdown list's content with a variable.
Thanks in advance for any help! Here is what I'm working with: Form A (created from a spreadsheet): Has 3 columns labelled: Fruit, Vegetable, Grain Each column has several related entries. Form B Contains: Dropdown List 1: Which displays the choices Fruit, Vegetables, Grain. Dropdown List 2: I would like this dropdown list to display choices from the appropriate column in Form A, depending on which which choice was selected in Dropdown List 1. I'm new to Zoho Creator so I know there's a way of
Time Field
Hi, I want to manipulate a time field without displaying the date but there seems to be no time field available, just a time date field. Is there a way to hide the drop down calendar in a date-time field and just make it display time? Why isn't there a time field?
Column Creation
I've searched all over and cannot find where I created a multi column view. I created this view and cannot find where to edit it, it changed the behavior of the fields on entry and I would like to delete it. Sorry for the vague reference, I'm new to the product and not quite familiar. Thanks!
Search field in the dropdown
Hi, It looks like there is no search field in the new android version of the zoho creator app. How can I fix this? Regards, Gianfranco m
crm create quote - why are price not calculated automatic?
The quote and product price are not automaticly calculated when adding a quote and product with deluge scripting. Screenshot in Swedish language: If unit price and quantity is given, it should calculate the product total, right? If I edit the offer, the product total is automaticly calculated and added as soon as I enter edit mode. The total amout isn't either calculated automaticly. If I am in edit mode and edit tax, then the total amount is calculated. If I manually create a quote with the very
days360 function return incorect result for March month
I try to use the days360 function to get the number of days between the first day and last day of March and it returns incorrect result: 29 instead of 30. For all other months with 31 days the days360 function will return correct result: 30 between the first day and last day of the month, only for March is shows 29. The strange thing is that until year 2007 it will show correct information: 30 days between 1st of March and 31th of March but starting with year 2007 it will show 29 days between the
Basic Subform Behavior
I'm scratching my head trying to figure out the basic subform behavior. What I expecting was the subform (based on a form linked to parent) would act similarly as a list report. Where you could click on the row and the actual form would popup with all the fields available for editing the subform information. However, what it does is all editing of only "shown" fields in the row of the subform, With no way to get to the actual form, that I've found. I building a contact list. Parent form is Customer
Paypal issue
I am having an issue with some payments from PayPal, when completed and returning to merchant the screen just say transaction being processed please wait, this just goes and on. The payment is being completed and the confirmation email is sent, but the hang screen is worrying customers. Is this ipn settings in PayPal and if yes what is the return url address I put in, and will this work for forms and creator? Thanks, Simon
Numerical format field report
Good Morning
I could collaborate, to know how to format numerical reports Zoho Creator. For the numerical field shows it without any format and I would like, if possible, to show it with scores of thousands, hundreds, etc.
Example: 1234567 see 1.234.567
Thank you for your cooperation
Alternate version of same data
Is there a way to display an alternate version of a data in certain layouts ? For example, I have a radio button field with two choices : Yes and No. In a "list" layout, I would like this data to show as Y or N instead of Yes or No (...or show as X or "empty"), but I still want the data to show as Yes or No in other types of layout. Is there a way to create an alternate version of this data and indicate which version to use in which layout type? Thanks for your help!
Pre-tick a check box in a form
Hi, is there a way to "default pre-tick" one or more check boxes in a form the same way you can "default pre-select" a radio button? Thx!
View record button
Hi, The dropdown button coming by default in Zoho Creator is not practical for quick viewing/editing a field (very often you open the record just below!). To avoid this problem I have created a Custom Action called 'Edit' which is much easier to use (it is not a dropdown-list). This is better but not fully satisfying as I am viewing records more often that I do edit them. How to create a 'View' button in custom action? I could not find a command for that. Regards, Chris
Sending cv's to zoho recruit by e-mail and create the candidate
Hi all, I would like to know if its possible (and what will be the process) sending cv´s by an e-mail account to zoho recruit and create the new candidate by that. Thanks in advace. Pedro
Retrieve associated field in nested lookups
Hi I have a a set of nested lookups in forms: Country Region (with Country lookup & filter) State/County (with Region lookup & filter) I have another form Profile on which I have a State/County lookup. When a user selects a State/County, I want the associated Region to load into a regular input field. So if the user selects Nottinghamshire, East Midlands appears in an input field. As Region is a lookup inside State/County form I can't access it the same way as I would do other fields. Can you help?
Next Page