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
input.user
hi Zoho Support Would like to check whether will this deluge work? input.users="abcd@zoho.com"; Regards
Function calling a condition
I'm trying to set up a function to set a variable based on the current logged in user. void fuction_name() { if (zoho.loginuser == zoho.adminuser) { path = "path_1"; } else { path = "path_2"; } } But I'm not sure how to invoke this function when loading a form. The form will need to do things with the variable "path" but after invoking the function, it errors saying "variable path not defined". thisapp.function_name(); Single_Line=path; What am I doing
On Update Form Script Not Working On Multi Select
Hello Zoho Community! I'm having a bit of a problem. I've got a deluge script that runs on update in one of my form fields. At this point I'm just using the following script for testing. info 'Can you see me?!?'; If I edit a single record from a report and edit the appropriate field, I'll get my 'Can you see me?!?' prompt. But, if I select two or more records in my report and update them, I'll see no info box at all. Am I missing something here? I thought the code in the "on update" section
Email Updated record
HI I'm new to Zoho so sorry if this is a basic question, feel free to point me in the right way of some documentation to read. The issue I have is the database (A facilities management database) emails certain people when a record is added. This works well using the email notification setting with the default template. The issue I have is making it recreate the exact email when anything is changed or updated in the record. This might be contractor assigned or notes added. I want it to send all the
Changing Field Name value
Hi Everyone, Is it possible to change the field name on a form base don the value of another field ? So I have a drop down where I select the account name and then based on that account name I would like a particular field name to change. Field deluge is "Reference", can you change the field name So for account 1 the field name would be "REQ#" For account 2 the field name would be "TASK#" Thanks Matt P
Brain Fart - Simplest way to update many records in another form with my current form?
I feel like I should know how to do this, but my brain mapping of how to solve this just isn't working, or maybe I'm overthinking it, or probably both. So I have a form for my products, called "Add_Product". This is where data is stored about each product, like its name, size, quantity on hand, etc. Then I have another form for quick inventory updating called "Add_Inventory". In this form, I have a field for each product (I know this probably isn't the best way to do this, but it seems to work
How to insert records in a HTML Page/custom created HTML Form in Creator?
Hi, I created a custom HTML Page. I have 3 fields namely name, email and contact number. Using this custom page, I want to insert records. Basically, I want this page to mimic the behavior of a standard Form created in Zoho Creator. I tried to put the Deluge scripts to insert, however it is not working out. Also, tried to use a function with parameters, did not work out. Please let me know if this is possible in Zoho Creator or not. Unfortunately, the documents to create custom functionality
calendar report filter
hi, i have a calendar report based on a form "task" in which there is an user textbox and a partner multiselect. we are 4 colleagues, and i'd like to make a filter that shows record in which the user is selected in "user textbox" OR in "partner" multiselect. thanks
ZOHO CREATOR NOTES (CRM STYLE)
Hey guys! I'd like to create a notes field in my Zoho Creator form that automatically time/date stamps the note...and allows me to continue adding more notes by clicking a button such as "new note". This function is available in Soho CRM...BUT i'd like to build a similar function within my Zoho Creator...is this possible? Thanks!
How to bring other fields from Zoho CRM when choosing one contact?
Hi, Im not the most experienced in Zoho Creator so any help is well received!! I have been trying and still cant figure it out. When I build my form, I am able to choose a Zoho Crm Contact Button to put in my form. I would like that when I choose my Zoho Contact, some information such as the Mailing Address, City an Email are brought to my zoho creator form automatically. I have read about getmyrecord by id but haven been able. Can anyone explain better than just posting the link about getmyrecord?
Section doesn't show on menu
I have created a new section and added a couple of reports to it, but the section does not show up on the menu bar at the top. I am the administrator/owner of the application so I should see everything. What am I missing?
Inventory in zoho?
how to make an inventory in Zoho, do you know any tutorial? thank's
Sorry Public, you are not allowed to access....
I created a page and made it public. I also created a report and made it public. Both links work for users with no password. When I embed report in the page and try to access the page from the published link I get This report is not accessible. Sorry Public, you are not allowed to access current_dogs. Please contact your administrator to get access. current_dogs is the report that is public on its own.
Next Page