Dynamic addition of fields in stateless form
This is with reference to dynamic addition in stateless form , ZOHO PEOPLE, where in a user can click on ADD NEW and a row of fields appears in the same form , LIKE adding WORK Experience more than once. How can we achieve this in ZOHO creator.
Alphabetize column
Why doesn't one column give the option to alphabetize the entire column? It used to do that, but after making a small change it no longer gives me that option. All I have in the drop down menu is Search.
Count characters in multi line text / Creator
Good afternoon. I want to count the character/letters in a multi line text box to avoid having more than 140 characters into this box. Is there a way to show how many characters are in a text box? I use "on validate" to tell users to stay below 140, but it's never clear how many letters have be deleted to match the maximum. I'd like to display the total of characters used in a separate (formular) box. Thank you for suggestions! Oliver
Bug found in zoho api for widget pageSize=200 multiple pages
Hi I think i found a bug in zoho api. when I fetch more than 1 page with pageSize==200 than page1 and page2 will have a duplicate record and an omitted record if pageSize<200 it will be ok. here is an example code ZOHO.CREATOR.init() .then(function(data)
Auto populate subform
Instead of having to retype the information again, I am looking for the proper script to automatically add the userID from the main form, into the subform, when I add a new row.
Filtering Pivot Charts via a URL parameter [my attempts, a discussion]
I know many have tried to filter pivot tables and charts via a URL parameter before and have failed, but I thought: I'm REALLY going to dig into this, get it working, then share my results with the Zoho Creator Forum community. No such luck. HOWEVER,
form can not be submitted
Hi, I created a form, and can not submit it. Got an error message: Error occurred, sorry for the inconvenience. The form has a subform with 54 rows. I do not want to loose data and do not want to create the form again. Any tip how it can be managed, please?!
Alternating the color of "batches" of HTML table rows
I'm posting to share the following code that Support gave to me that alternates the row colors of "batches" of rows. Use the following in an HTML snippet in a page. (Personally, I prefer to concatenate all of my HTML in an HTML variable then showing that,
Style the forms and reports in your CSS
I did a simple trick. - On a form, added a ritch-text field called pageStyler (Admin can only view) - Added a deluge on load as - input.pageStyler = "<style>#zc-component { background-color: yellow;}</style>"; - Login as Admin and submit one record against the form Now this makes my form width 100%. I need this for a huge form. However, I would suggest override the CSS with extreme care.
How to Pull Data from Zoho CRM to Auto-Fill ZC Fields & Update New Information Back to Zoho CRM
If you want your Zoho Creator application to pull data for a record from Zoho CRM, and auto populate the fields in your Zoho Creator App - then, upon submission, also update the new information back to Zoho CRM - here's a little tutorial for you. Here's how to do it: Step 1: Create a CRM Lookup Field for the record you want to pull info of lets say it's a LEAD and the ZC field name is Lead_Name. Step 2: Lets say you want to fetch "First Name, Last Name & Email" for this lead. Then create 3 fields
Send Email to Co-Worker when Field is updated
I am wondering if anyone has any advice on sending an email to another person in another department when a field is updated. What I want done: We have a price comparison section in the account page in the CRM. When a salesmen uploads customer's invoices
Fuzzy string matching / approximate string match
Does anyone have Deluge code that does a decent job at fuzzy / approximate string matching?
Project Creation Using Template ID and Field Name - Function
I wanted to share my successful function that associates a Project Template ID to the auto-create Project Function. I could not find it in my own search, but did realize what I was doing incorrectly so below is the correct function code in case anyone
Date Field Calculation / Today Function in Creator
Hi, I am trying to calculate number of days items are in stock. so in excel formula would be: today() - Stock.indate. I have two questions: 1) Is it possible to use creator to reflect Current date field in a column of a view. So it will always show the current date 2) In Creator's report, can i do a date calculation similar to excel = today() - Datefield Can you please provide some guidance. Thanks, DC Zhong
Reserved keywords
Reserved keywords If you name your form field to any of following reserved keywords you will risk runtime failure when communicating with your application: script – (this seems to have been resolved, please refer to the list in further reading) type count Background This post is here to address issues that randomly occur while using reserved keywords when communicating with Zoho Creator through the REST API and/or integrated Zoho services using Deluge. Since Zoho Creator does not use namespaces
Bidirectional lookups with 3 or more forms
Per the attached, I have 3 forms. My "main" form is PU, which has a unique field in it called PU_ID My two other forms contain PU-related data: PU PGIP and PU Data. I have bidirectional relationships established between PU and both PU PGIP and PU Data
Show same entry field in multiple rules
Hello, I am wondering if what I am trying to accomplish is possible. I currently have a dropdown field with numeric options (1 through 5). Based on which option is selected, I want to show that many additional fields. I have set up a rule that when 1
Using ZC to send sms with an alphanumeric sender id via Twilio
Hi, I want to create an api to send a sms from zc via twilio. I want to send a sms with alphanumeric sender id, in that way sms receivers will not see a number, I can customised any sender name in that way. such as i can send a sms with my company name
How do I populate a Subform with data that already exists from a lookup field in the main form
I have searched the help options for information about this, but can find no example that fits what I'm trying to do. I have a main form with several subforms for which I need different reports (already set up). Each of these reports needs to be sorted by the same fields which recur throughout, Client, Course, Provider and Trainee (all have their own forms). How do I avoid having to enter this information separately in each subform? It all appears as lookup fields on the Trainee form where the subforms
Copy the content of a field to another
Hi, I have a text content of a field.How can I copy to another field?
How to set iframe size dynamically?
Hello, I am working on displaying the following ZohoCreator form on http://sharespace.co (please scroll down to the section "Pricing, Quotes and Inquiries" to see the form). What I would like is to have the form's height change dynamically, as the content within the frame's height changes. The form currently works that only 5 questions display, and as you fill out the form, it expands to revel more questions. With the current styling, I can only set the iframe height to a specific value (I've chosen
Tip 32: How to set form field values using custom functions
Hi folks, We're back today with our next tip—how to set form field values using custom functions. Before we get started, though, let's take a look at the basics. What do you mean by setting values for a field in a form? To assign a value to a form field
Timeout or automatic sign-out
Hi guys, To improve the security of our data held in Zoho Creator I'm trying to find a way to automatically time-out a session after a period of inactivity or automatically sign-out a user if they close the browser page. Can this be done? Can we configure
Add "keep me logged in " option on Zoho Creator Customer Portal
How can add the option "keep me logged in " on login page? Otherwise, customer need to submit the login detail every day. Or any solution can make customer keeo a longer duration for logged in
Copy/Paste record in a calendar view
Hello, Is there a way to copy and paste a record in a calendar view? I know we can duplicate a record in the summary view but it doesn't seem possible in a calendar view. Thanks
Deleting all entries in other forms with references to the given form entry when deleted
Hello! I was wondering if there was a way to get a reference to the asset you are deleting in a workflow. I am currently setting up a system that has an "Asset" Form, and I want to make sure that when an asset is deleted it deletes all entries in various
Stateless Form Validation - Cancel Submit
I have a stateless Guest form (which I have embedded in my website). I have logic that the requires the user to enter the guest names based upon their input in a Number of Guests fields. I need to ensure that they have completed the fields before they submit the form. Apparently the cancel submit function does not work for stateless forms. Number of Guests:3 Guest Name 1: John Guest Name 2: Tim Guest Name 3: In the example above, I would like to alert the user that they need to complete all the
Troubleshooting in Creator #2 General Application Access Debugging - Shared Users
Creator has advanced sharing and app administration features that allow administrators to define permissions up to the field level, and allow data hierarchy based on roles. If these structures are not clearly mapped out and planned, it can cause discrepancies
Drop down layers
Hi, I recently switched from Zendesk to Zoho and tried to create a form but i could not find out how to add layers onto the drop-down list? Like what Zendesk can do as per below example and article? For example, showing in this article https://suppo
Fetch Email Id Associated with Username
I have a form that uses the "Users" look-up field, which is used to assign tasks to registered users on the app. I would like to automatically send an email to the User when he/she s assigned a new task. "Username" is a text string, but I'd like to be able to fetch their "Email ID" so the email can be sent. Doesn't seem like fetch records will work because the User info is not collected in another form. Any solution to this? Looks like I can set the field type to "Email ID" but would prefer to
Calculating Time Difference between Date-Time fields in Minutes
Hi everyone, I know that there were a lot of concerns regarding time difference calculation, especially if you want to calculate it in a number field. I went through a lot of articles but I couldn't find a solution that I wanted, I wanted to calculate
How to restrict file upload types?
Is there a way to restrict or validate the file type in the "file upload" field? I want the users to upload only image file types (jpg, png, bmp or gif), and they shouldn't be allow to upload zip, exe, rar, pdf... files. Thanks
Mobile Quick View Field Labels [Solution]
I've developed two solutions for field labels in Mobile Quick View: 1. [Simplest Method] Create single line fields (or similar-type fields) with default values of what you want the label to be. E.g. Field name = Due Date Label, Field link name = Due_Date_Label,
How to customize Creator customer portal sign up form?
Hi everyone, I would like to customize the text of sign up fields for showing better translation in Chinese. How can I modify the field name?
YYYYMMDD TO datetime format
I am having a hard time converting YYYYMMDD format into the Zoho DateTime format in : "YYYY-MM-DD HH:MM:SS" What functions or combination of functions should I use? thanks.
Twilio Lookup API solution
This had me frustrated over past couple days, trying to find a solution to what should have been a simple issue, so thought I would drop a line to put something in to this pool of info that I draw out of so often. Wanting to use Twilio Lookup tool to
Zoho Creator making REST api calls to a Moodle Web Services Module
Hi all, I am interested in hearing whether anybody else has tried to... Create a user account in a moodle system on the fly by REST API calls. I understand that someone in the Moodle camp was making a REST API Web Services module available within Moodle 2.0. Refer http://moodle.org/mod/forum/discuss.php?d=33521 It would be great if this could be accessed from Zoho Creator using many of the same techniques that are used, say, to make calls to Zoho CRM. Love to hear from anyone who has made headway
Size of Widgets in Creator - How to resize to just single line or double line?
... Happy Morning! We have custom widgets created for display of timer, messages and metrics... how do we resize these widgets to single line or double line of font size 12. the current size of widgets is too big for what we need on a page Thanks K
Proper() statement for a multi-line field
Hi, I have a small function to tidy up address data from a mix of lower/upper/proper case formats. The Address field is a Multi Line text field in the form, and I find that when I run this script, it only applies Proper case to the first line, and lower case to subsequent lines in the field. For example: ADDRESS LINE 1 ADDRESS LINE 2 TOWN CITY becomes: Address Line 1 address line 2 town city where I am expecting: Address Line 1 Address Line 2 Town City My initial guess is this is a bug, does anyone
Getting street address from GEO location system variable Added_Location
Currently, the only data you can get from the GEOCODE system variable Added_Location, is longitude & latitude, or district_city & state_province & County & postal_Code. However, what I really need is the street address. I can get this if I map the
Next Page