How do I create multiple customer portals?
I have multiple customers using the same app we going to develop. Each customer will have their own set of users and data and even their own domain URL. Each customer much not access other customer's data. How do I set that up? What subscription level do I need to supports this?
Show a percentage of total records in a Panel component on a Page
Hi, I want to provide a rating which is based as a percentage of the number of records in a report. E.g. there are 10 records, the total achieved in Score is 5. The percentage is 5/10 = 0.5 (or 50%) The thing is I can't see how to use these type of calculations
Sendmail function cannot be saved. "Improper Statement Error might be due to missing ';'"
Hi, I'm trying to make new rule to automize new-data-added notification. what I did is 1) I drag&drop "sendmail" parts to script field, 2) change "from", "to", "subject", "message", 3) press "save script". but I cannot save this script with error message "Improper Statement Error might be due to missing ';'..." Could anybody give me any suggestions? thank you Tadashi
Don't Zoho Creator support company logo in the trial version?
I have a trial Zoho Creator trial account. When i am adding company logo it is not showing, but i my favicon is showing. Don't Zoho Creator support company logo in the trial version? Note: Please take a look at the attached file.
Export image stored in record using summary report?
I have a record summary report that displays an image stored within the record (image field type). Looks great in the browser but when I export the summary report to PDF the image does not display. How can I get the image to export/print from the generated record summary report?
View URL with OR condition
I am trying to create a URL string to be added to openURL() function. I have a view set up and I am trying to dynamically open the URL by providing two filter criteria. My problem is that my filter criteria require 'OR' option instead of 'AND'. I know that 'AND' option (& is used for AND as shown below) in such a scenario works and its syntax is below. What should be done if I want to use OR option? http://app.zohocreator.com/<app owner name>/<app name>/#Report:<report name>?<FieldName1>=<FieldName1
Exporting Report PDF in Landscape view
Hi, I have followed directions at http://help.creator.zoho.com/Functionality-based-URLs.html regarding how to generate landscape PDF views, but I can't get it to work with the reports on my account. For reference: 4. The url format to convert an HTML view to PDF with the PDF's orientation value. The orientation value can be landscape or portrait. The default value is portrait. http://creatorexport.zoho.com/<app owner name>/<app link name>/pdf/<HTML view link name>/&zc_PdfOrientation=<orientation
Opening Up Google Maps App Via Link from Andriod or iOS
I am running into an issue. Goal: I would like for a link I have added to a Zoho Creator Form in this format <a href="LINK">Test</a> to open in the Google Maps app on each respective mobile device; android and iOS. Problem: The link format for iOS is:
Data Field, Time Field and Date-Time Field Arithmetics Question
Hi, I have a date field and a time field (or even a date-time field and a time field) and I want them combined and then place in a date-time field, how can I do this, I tried a couple of things but I can't reach the desired results or even a correct one.
Retrieving custom field into Zoho Creator from Zoho CRM
I have one integration field that provides me the account name from the accounts module in Zoho CRM. It works fine. I would also like to populate another field with a custom field value in the Accounts module for the same account. For example the account
How to convert firstName.lastName@domain.com email to a proper name in formula field
I'm having difficulty converting an email field into a proper name. The email address all are firstName.secondName@domain.com Here is what I've created in a formula field based on the "Primary_Tax_Partner" field but it only seems to work sometimes: (input.Primary_Tax_Partner.getPrefix(".")
IT Asset Tracker app Search by QR Code
I am setting up the IT Asset Tracker and I would like to be able to search by a QR code via the mobile app. I am able to use a QR code to input data in form fields for Add New Hardware. But when I click the search button on the All Hardware page, I am
CAUSE=INVALID_PASSWORD
Hi I tried generating an auth token but getting an error whenever i added the url in the browser kindly help. See the full result below #
#Tue Dec 01 08:05:54 PST 2020
CAUSE=INVALID_PASSWORD
RESULT=FALSE
How to display zoho.loginuser and zoho.loginuserid on Page
Hi, I would like to make a page with user name and user's e-mail address. It might be very simple thing, but I could not find a documentation about how to display zoho.loginuser and zoho.loginuserid on page by using script. As I am not a programmer, I tried print(zoho.loginuser); write(zoho.loginuserid); by putting after <%{%> or <%{ but nothing worked. Can anybody help me to make my page work correctly? Thank you very much.
Como hacer que diversos elementos de las paginas carguen los datos de un intervalo de tiempo
Hola, tengo una aplicación de visitas comerciales y técnicas y en algunos de sus elementos me gustaría que se cargaran los registros del ultimo mes, por ejemplo. Mi problema es sobre todo en un grafico circular, en el que se divide el numero de visita
Can a customer portal user change his email?
Hi, I would like to know if a customer portal user can change his email? Because sometimes we want to create the account for the user (a customer portal user) and fill it with data and give it to him for testing instead of just inviting and then asking
Zoho Creator Third party Access
Dear All, I hope you are well and healthy. I want to ask a brief question regarding Zoho Creator. Is it possible to have third parties accessing the Zoho creator through a web interface and without providing them the right to edit or modify the data?
Is it possible to change relation Call_X>Contact_1 to Call_X>Contact_2
I've got a bunch of data in Zoho CRM. By some reason I'd like to make some historic Calls be related to another Contacts. I.e. Call with ID=zcrm_0...x relates to Contact_1 with ID zrcm_0...1 (or even has no related Contact at all) should be changed to
Syntax for Tab and Enter keys
Hi: In a Multi Line field a user can press the Tab and Enter keys. I would like to know how one references these "invisible' characters inside such a field with Deluge commands like ... <string>.getPrefix(<substring>) ... is there some special syntax that can be used to define such characters for <substring> ... like "\t" or "\n" or "	" or "
" etc. ? In one of my projects, I need to parse entered values separated by spaces ... but users might mistakenly type Tab or Enter keys ... so I want
Comparing one list to another fails
LIST1 = ("cat", "dog", "bird", "fish"); LIST2 = ("cat", "dog"); for each element in LIST1 { if (element not in LIST2) { // do something } } Gives an error "Left expression should be a field name for 'not in' operator". REALLY? The help section (https://help.creator.zoho.com/Operators.html#List_Operators) states that The List Operator not in checks whether a value is not within a set of values Syntax <expression1> not in <expression2> where, the right expression should be of type
Date/Time fields on iPhone Using an Invalid Format and being set 2 Hours early
A user of our app recently noticed that date/time fields were causing problem when a record was updated. When a user clicks "Submit", the app pops up a warning claiming that "Invalid entries found. Please correct and submit again.". At this point the app focuses on one of the date/time fields and shows an error message that reads, "Enter a valid date format for date/start time." The date has not changed for this field, and the format has not changed either. This only happens on iPhone - desktop
generate pdf of customized HTML contents using zoho creator deluge script
Hi Team, I am creating a request to send a set of HTML contents using SendMail function of zoho creator. I can send the HTML contents succesfully in email but along with that I want to do is to create a PDF file of that HTML contents & send it as an attachment from zoho creator's SendMail fucntion. Firstly is it possible.? If yes, how do I achieve this scenario.? Thanks & Regards Amit Thakkar
Approvals in Zoho Creator
Hi, This is Surya, in one of my creator application I have a form called job posting, and I created an approval process for that form. When a user submits that form the record directly adding to that form's report, even it is in the review for approval.
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
Next Page