Why Subform is not showing User field type and Notes field type?
In my simple task management system, i have a subform that has the following fields and types: Service (lookup) Assignee (users) Notes (Add Note) Due Date (date) In the actual subform, only the Service and Due Date show up? Why? Where can I find documentations of the subform limitations? If these are indeeded limited, what's the recommended workaround?
Subform Shows No Records [ Resolved ]
My main for, "Lots", has a subform, "Residents". I created them both from an Excel file at the same time. I later decided that I wanted "Residents" to be a subform. Getting things to link up properly was difficult. At first, the subform showed no records. Using Deluge, I can fix this by editing each of the Lots records. This is a painstaking process. I have more data I want to bring in to make additional subforms. How can i do this so the linking works right away?
Best data storage / method to use with Zoho Creator
We have a large amount of data currently stored in Excel sheets, we would like to reference this data in Creator and we're looking for the best service/method to do this. Our stored data is fairly large (can be in excess of 100s columns and rows per sheet), split across multiple data-sets (sheets). We believe it is not suitable for storage within Creator because each data-set has a unique number of rows and columns that could not be easily laid out into a SubForm etc So instead, we are thinking
Formula referencing date entered on form.
Hello, I am trying to figure out how to write a formula that references a date that was entered into a date field on my form. I am trying to create a report that will tell me which licenses have passed the expiration date, the expiration date being the date entered on the form. If my license expired on 10/1/2017 I want to have a report that generates that it has expired. The issue I am having is that I do not know how to write the formula that references the entered date. Hopefully, this
No Image Field Action? [ Resolved ]
My record has a field to upload an image. I also have a field to display the image. On Load, if there is no image shown in the image field, I hide the field used to display the image. What I want is for the field to appear and be filled when the user selects or changes the image. There is no field action for image fields. Is there some way to do this?
limited to 50 published forms/reports
I started building a custom CRM for a new client using a subscription at Enterprise level, but just learned that it's limited to only 50 published forms/reports (but there's nothing in the subscription pages that will tell you so) I've built similar apps for other clients in the past, without this limitation, so not sure when that change was made, but pretty crazy. I guess Creator is now being oriented for use by babysitters and softball teams, rather than businesses. Checked with customer support
Null displays on pages in phone app
I am having a problem where a page I have that display correctly through browsers on both desktops and phones, only displays as (null) through either the Creator app or the Creator Portal app. I'm not sure what is causing the problem because other pages seem to display without a problem in the app. I've tested it by taking the page down to it's bare bones with just the work 'Test' and it still displays as (null) in the app. The only thing I can think is that it has something to do with the location
call function during onclick of button in page
Hi, I am trying to call the creator function say example thisapp.func() during onclick of button or anchor tag. I have tried the below code which is working automatically on page loads instead of onclick of button. <a class='zc-formbutton' onclick="<%=thisapp.divideTelecaller()%>">Wanna Split up and assign Clients to users?Click here</a> Thanks, ITKES
Convert string to number in formula for total sum.
Hey all, thanks for the helpful response for my last question. Hopefully this one will be a just as painless. I'm trying to take the sum of 4 string values in order to calculate a total. I know in order to do this I need to convert those string values to numeric values however I seem to be missing something. Tonumber(Sum1) + Tonumber(Sum2) returns: Tonumber cannot be resolved. I've also tried, Sum1.toLong + Sum2.toLong returns: Variable 'Sum1' is not declared Thanks in advance!
SUBFORM IN ZOHO CREATOR
Hi, Is it possible to fix the number of rows in subforms by giving the number in number field. I know that it is able to fix the number of rows by it's field properties(set default entries and limit maximum entries),But my requirement is based on the value which is given when the application is on live mode. kindly help me. Thank you.
Showing images on a form
How do I show an image from the database on my form? I'm able to load all of the other data but I can't get it to display the image. I'm able to load the full path to the image.
You may only fill this form out one time --- message?
Hello, would somebody please let me know what this message means? You may only fill this form out one time I have created one form, intended to ulpoad files that only allows me to enter one record regardless of the sisze of the record. Even with empty fields! what does this mean?? thanks a lot
Error importing the app in Zoho Creator
Dear Zoho expert, I meet problem when importing the app into my home, maybe because it has many row. When I import the scrip window appear, and no app was imported after that. I tried to copy this script and paste into new app, but the error is null, and I can't meet my app again in home. Can you help me pls?
API form submission - retrieve & use response status on website (callback)
We have a html/php form on our website that submits data to our creator app via the https://creator.zoho.com/api/xml/write API URL. When the form is submitted, we want to retrieve the status response from the Zoho app and use it on the website i.e. "Success" or "Failure, enter a valid..." I can't find any documentation on this, can anybody share the simplest way to do it. Many thanks
how to send creator data to google spreadsheet
how do I send some data from my creator app to a cell in google sheets?
API - Create Google Calendar event when record is added. Without G suite
Hi, I dont have G suite but I know that it is possible to create/update a Google Calendar event when a record is added/edited via API. How would I go about this?
Online booking System with Zoho Creator
Hi, I am trying to create Online Booking System with Zoho Creator. Problem i am having is: Staff allocation, E.G We have 5 person and each of them is available 9-5PM. I need 5 Columns in Calendar Day view with Staff Names. If it possible i can achieve this which Zoho Creator ? Image is attached for the reference.
Option to rename Print -> Print as Record Summary
I think it would be a nice feature to be able to set a different name for print dropdown in reports. So far we have "print as Record Summary" but it would be nice to our end users to have "Print Invoice" or "Print confirmation" instead. Easier to remember what it is for and to distinguish from "Print as Summary". Next thing would be to allow to hide "Print as Summary" as I think it is rarely used.
Drop down
In a form A we have a drop down field based on a form B with 2 fields: location name and location address. When we select a data (location name) in the drop down field, how to display the location address in form A in a different field? Thank you for your help.
Text() Function
In the Help system under Built-in-Functions there is one named text(). I cannot find it elsewhere or get it to compile.
calculate the age of a person doesn't work
Hi, I want to calculate the age of a person, so I tried this formula(I found it in Zoho Creator Help) in formula field. ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2) but it's doesn't work properly. for example Today is 30-Sep-2017 BOD of the person is 02-Oct-1973 Age of a person : 44.02 (It must be 43!) I live in Japan, but I've set Japanese Time Zone in General Settings. I have no idea...Please Help me... I'm sorry for my poor English. Thanks.
Forms and sub-forms
Suppose we have a form and a sub-form. The form has a drop down field with, for instance, two different data, A and B. A refers to sub-form a and B to sub-form b. Is it possible to show only sub-form a when A is selected (sub-form B being hidden) and sub-form b when B is selected? Thank you for your help.
How can I disable a theme?
Hi everyone, I'm developing an app in Zoho Creator and I wanna to use pages ans custom HTML to navigation, but I don't figure a way out to disable or hide the standard themes. Is there a way that I can hide or disable standart themes? Best regards, Eduardo
Time in auto-generated e-mail
I have an application I built in Zoho Creator that sends out automated e-mails. These e-mails include a date/time field. In my form, the dates/times are correct but sometimes (not always), the e-mails being generated are off by 3 hours. I am wondering if it's some type of time zone setting. I have already verified that the time zone set in my application settings are correct. Any suggestions on what to check next?
Can Zoho replace Google Sheets ?
Hi We currently use a stack of Google Sheets to run some of our business functions We use it to manipulate data and create reports. Some of the key things we do are 1 . Import lots of changing data 2. Modify it in some way 3. Export data back to our website Is Zoho a more stable replacement for this? Google sheets has issues with the amount of data and imports we use. Ian
Fetching data from another application
Hi Zoho Forum! Please can you help me :) I want to use the Aggregate Records code to fetch data from another application in my account and use the data on a "PAGE", but I don't know if this is possible.. Example below (which doesn't work) <variable> = [Application name] formname[criteria].sum(<fieldname>); Best regards, Rob
Count records which have had a subform record added this week / month / year
WeekCallcount = Company[Call_Logs.Time_of_call in this week].count(); MonthCallcount = Company[Call_Logs.Time_of_call in this month].count(); YearCallcount = Company[Call_Logs.Time_of_call in this year].count(); Company = my form with Company records and subforms for contacts / Call_logs Call_logs = subform within Company, used everytime customer is contacted The functions above list total amount of calls in the time periods, however I want to add another set of functions which contains
Break subform view into multiple columns
Hi Zoho, my client has requested a feature: He is trying to export the data into MS Excel. Obviously this feature would only work properly if there was only one row in the subform (e.g. one child entry). If you had multiple rows (multiple children), perhaps the values could be provided separated by tabs (since tabs cannot be added to an input field), e.g. for child name: "Bruce, Tom". cheers, Jeremy
very slow in loading the page
Hi, can you please fix? The loading of pages are very, very slowly and it started yesterday. https://creator.zoho.com/accounts12/abn/#Page:New_Business_name
Multi-valued fields in MS Access
Hello, I have an Access database where the main data table has many multivalued fields. I imported the database into Zoho creator and all the tables were created but the data in the table with the multivalued fields did not import. All other data in tables without multivalued fields were imported correctly. Any ideas?
Pivot Table doesn't work in smartphones
Everyday I have issues with the pivots of my customers whom use smarphones because some pivots NEVER, NEVER are synced. I was informed that a pivote takes 10 to 20 minutes to be synced but that doesn't work. The last solution suggested was to use the "Regenerate" button but it doesn't available for smartphones. My customers are very dissapointed with the Zoho Solutions because we can't trust on pivot table reports. Are we the only business with this issue? We have reported this situation 2 months
Any ideas to improve the screen display speed of Zoho Creator’s form that has lookup fields.
Hi, I need design ideas to improve the screen display speed of Zoho Creator’s form that has lookup fields. Some lookup destinations has over 400,000 records. I think that the lookup fields automatically read the records of the lookup destination at the timing before the lookup fields is displayed, but is there any way to disable the reading or control the number of records to improve the display speed? We'd tested to investigate what is the main reason to slow the screen speed as follows: Testing
How can I submit eMail data from a service account.
Hi, Before the restriction on 'public sharing', I was able to set up a form for eMail data import, and I would be able to have our SQL server use a service account (email address) to send data into ZOHO. Now the restriction is in place, I cant do that, and I will have to set up the SQL Server account as a user in Zoho, however this is not an email box that accepts incoming emails. So I cant authorise the Zoho account. How can I achieve email posting of data, as I used to with the applications that
print html page in small size paper
Hi, Greetings! I have a requirement to print the html page in creator as a gate pass or as a event ticket or as a hotel bill. In these cases, I may use a thermal printer and I need to print it in a small size papers (like hotel bills/ gate pass). Is it possible to change the paper size or print properties from creator? Or else how the above mentioned requirement can be achieved?\ Please help me out it is an emergency. Thanks, ITKES
Sending Email to Collection of Records
Hello, I need to send an email to the collection of records, where collection of records belongs to the single contact no or email. So I need send a single email to those collection of records. So, I tried with schedule by added time, there i have given the criteria but it was also not working for me, it is sending email with collection of records for collection of record's count times. Say example, if i have 10 records as a collection belongs to a single contact or email, it is sending 10 emails
Using Deluge to programmatically insert a URL into a URL Field
Hello. I'm evaluating Zoho Creator and have a question about using deluge to programmatically insert a URL field on a form. My URL looks like this and works when I paste the URL portion of the href into the address bar: <a href="https://app.zohocreator.com/<myusername>/<myapplicationname>/#Report:MyReport?Jobs=DBA&TheSkill=Innovation" target="_blank" title=""><Innovation></a> To insert the URL, I'm using the Add Record deluge task which uses INSERT INTO <formname> URL_FIELD = my_URL_shown_above.
Zoho Creator iPhone App Geofencing Problem
Hi, I've created a simple form that can only be submitted by a user from a specific geographical location using the geofencing option on the right panel in form builder. I tested it out by trying to submit a form from an iPhone 6 Plus, iOS 10.3.3, location services for the Zoho Creator App are turned on. When I click submit, the Zoho app says it's unable to determine my location and to turn on location services. I'm at a stand still, can anyone provide some insight? Thanks.
Unable to translate captcha content
Hi, My native language is Portugues and I can't translate the captcha! =/ Will have in the future support to do this? Thanks cabello
Zoholics 2017
Hi everybody! Can anyone update me about the news emerged during Zoholics in Pleasanton at the end of August? What will the new implementations be? Thanks
Where is data stored ?
In Canada we have a data privacy act we must comply with, and there are concers about the Patriot act in the US. Is Zoho data stored in the USA, Canada, or elsewhere ? markv
Next Page