record_summary ID?
How do I get the ID? I have this as an example for a a "comment" I @ mentioned myself on. <SNIPPED>/record_summary/UAS_Aircrafts_Report/3850763000000308019/ How do I get this full URL???
When I am creating a new customer, after filling all necessary details I am getting this error message "Invalid value passed for attention" . I am not able to figure out what is causing this.
I haven't done anything different from other times but not sure why it wont let me save the new customer.
How to use a conditional formula based on a lookup?
Hi, I need a formula that is something like this : if(Test = TRUE, if(Installer.toString() == "Patriot", 1000, 0), 1). However, Installer is a lookup field and zoho doesnt seem to be catching that. How can i make that work?
Adding Subform Row Values together
I am having a hard time figuring out how to add values from a subform together. I have a subform called - Payment_Information When people pay us, I record the payment in that sub form called - Amount_Received. If they pay in full, it's just one line and
Add Days to Calendar
I am creating an Invoice system. I have a field called - Terms, which is a drop-down with four options since I have customers that pay on different lead times. Due on Receipt Net 30 Net 45 Net 60 I have another field that is a date field called - Due_Date.
How do you remove name or account name from Permalink url?
I created a private form I want the public to fill out. So I did a permalink iframe without login. However when I load the iframe and right-click, View Source...my personal name or account name is in the url. How do I remove or change this? Thanks! Robert
Creating country drop down menu
Hi there, Apologies for the incredibly basic question, I'm just starting out building my first form on zoho. I would like to have a simple drop down menu field where the answer options are the standard list of countries. Is there a quick and easy way to do this or do I need to type in each country? Any help much appreciated. Thanks!
Can you make an email update a record in Zoho creator table?
On my application I set up a stateless form "Issue Request" that when the user clicks a button to open issue request it displays the stateless form. The users will then select the email address or multiple address' to send to. Enter the issue type and
What is "Link to view"?
I'm having an hard time finding what the "Link to view" feature does of Zoho Creator: Thank you
Automatically export
Hello, is there a way to automatically export all entries once a day as a csv file and store it in a folder? Alternatively, how can I access the entries of a form in Creator and retrieve them from Creator via Power BI? Best regards Jörg
How to show a report to the admin only in the Zoho creator app and hide it from other users of the app?
How to show a report to the admin only in the Zoho creator app and hide it from other users of the app?
Can I get stock prices in Creator
Is there a way for me to get current stock prices, DayHigh, And DayLow into Zoho Creator the same way as in Zoho Sheet?
Update / Refresh report automatically?
I have 2 forms: newspapers and prices. I have a report of newspapers linked to prices. If I update the price for a specific newspaper in form "prices", I would like to see the price of the existing record in my newspaper report change as well, which is currently not the case. How to automatically refresh the report? Thank you in advance
Single User Subscription
Hi Everyone, I am working as freelancer. I am exploring ZOHO Creator. I am thinking for purchasing single user for my self for practicing. Please guide me whether I can purchase single user for ZOHO Creator.
Zoho Developer Console: How to add developer access
How can I give my developer access to my Zoho Developer Application? I know how to add a developer via Zoho One and/or Zoho Creator, but I cannot do the same thing for the Developer Console...Any ideas? *This documentation was not accurate: https://
Footer needs to be static and be anchored to the same place on every page
The footer needs to be anchored to the bottom of the page - in the same place every time. When I show footer and if my data runs long - the footer shows up on the next page. How do I 'fix' the footer to the bottom of every page in the same place no matter
Multi Page Form
How do I create a multi page form? I am trying to create a web input form that has many fields per record, and I would like to create categories which represent separate pages and have the record persist from page to page until they reach the end of the multi page form and submit it all at once. So for example, I would create a form for "Hotels", and it would include: "General Information" which would include the following fields: Name Location Description Address "Amenities" Pool Spa "Rooms" etc.
Pivot Tables report problem
Hello, I pressed Regenertate on my pivot table report page and now it's stuck for over 2 hours. "Regeneration has been initiated for this report. You will be able to regenerate again when this process is complete" Can you help, please? Thanks,
IOS ‘Tab’ key
I’m currently building a app for customers to fill out their details and there’s a lot of fields for them to go through, they’ll be primarily be using the application on iPads using the creator or customer portal iOS app. I’ve noticed in testing that
Update Date
I am trying to use a start date (manual entry) for a program "Start_Date" and add 6 weeks to the start date to come up with an end date "End_Date". I want this value to update all of my members in a report so I can see who's program is ending soon. I
Pivot Tables problem
Hello, I pressed Regenertate on my pivot table report page and now it's stuck for over 2 hours. "Regeneration has been initiated for this report. You will be able to regenerate again when this process is complete" Can you help, please? Thanks,
Cannot see multiple forms when creating new report
Curious if someone can help explain. I have 3 forms in one of my databases. However, when I try to create a new report, it only lets me pull from one option. Am I missing something?
DS File Import Error - can't edit the script in the browser
I am unable to edit a DS file in the browser when presented with an error during import. For example: Error at line number: 5896 The "from" address can only be zoho.adminuserid, zoho.loginuserid, or a verified email address. Please specify a valid email
Scanning not available for Cutomer Portal
Hi all, I have created a small app in Zoho Creator where i have 2 single line elements that support QR and Barcode scanning. If I access the application through the Creator mobile app as a Zoho user, then I am allowed to scan as i get the relative icon
Fetch data
Hi, I am trying to do the following. I have developed a plant database where I want to create an observation record from a plant record. So when in the plant record I click 'Observe' (Havainnot) which opens the Observe record. I want it to automatically
Adding subform columns while creating a new report component
I have created a form for adding inventory purchases. To add multiple entries, I have created a subform. The form is working fine. However, while creating a new report component it is not allowing me to create a dashboard using subform columns. PL h
comment avoir une version française de l'application hotel management
les différentes rubriques de l'application sont en anglais, pour mon hotel j'ai besoin d'une version traduite en français, comment l'avoir? merci d'avance.
How to get a image url
Hi, This is Surya, 1. I want to get the URL of an image that was uploaded to the Zoho creator using image field (uploaded through local storage). I referred [https://www.zoho.com/creator/newhelp/forms/fields/image/understand.html#File_download_URL] to this link but i didn't get the solution. I followed the instructions in the above link.and when i click the button I get an error. Refer to attachment for error. 2.I am trying to integrate with Facebook and i want to post an image to Facebook from the
ZOHO Upgrade - What a mess
Since you Upgraded us automatically nothing has worked correctly. Our developer has contacted you several times but to no avail. Therefore, we have developed our own system and are cancelling our subscription. It was a great product but, as far as we are concerned, your auto upgrade is a real mess. Maybe you should, like all other software suppliers, offered the upgrade but not made it automatic. Anthony Gemmill - CEO Imagic (UK) Ltd.
Filtering for Date Field
I am wanting to create a filter so I can filter by day of the month, rather than filtering for the whole month. For example, if I have data input on 22-Jun-2007, I want to be able to filter on just this specific day. Any suggestions?
Convert Date field DD-MMM-YYYY to DD-MM-YYYY
I cant seem to figure out how to change a date field in the format DD-MMM-YYYY to the format YYYY-MM-DD I understand i need to use string and date functions but still cannot quite get it right. Any help? Thanks
Formula field to output a percentage
I added a formula field to my form that I would like to have the output be a percentage rather than a decimal. what script can I write for this to occur?
URL is no longer available when needing to export view without login
Previously, this was working fine. However, today when I try to export a private view using CSV feed, the link to enable "To access the view without login" is no longer visible. See below.
Remove Heading of Subform
can we hide /remove heading of subform while loading?
Find all code associated with a field
One very helpful thing when deleting a field in a form is Zoho's alert messages to tell you exactly what code is associated with that field and where it is. Is there a way of doing this when NOT deleting a field? When I'm making changes to a field (e.g.
Zoho Creator Open URL Action: Need help auto-populating multiple fields
Please see the code below, it's triggered via Detailed Record View Button. The purpose is to open a separate form via url (popup) and autofill some of the fields with information from the existing record. This code example works great but I cannot get
Change Subform to Vertical Layout
When I create a form, the fields are set up vertically. But when I use that form as a subform, it makes them one horizontal line. Is there any way to make the subform appear like it does on the editing page?
Centering a table in a dashboard / Responsive Tables
I have a pivot table spanning roughly 2/3 of a dashboard page (left to right) with a widget next to it on the right. Depending on screen size, my pivot table may have scroll bars (smaller screens) or half of the area for the pivot table may be empty
Problem with the pipes
Hey there, I am trying to fetch data from an API populate it into a drop down. The problem I am having is the data being fetched is separated by pipes. And anything I have tried just puts the whole pipe separated list into the drop down. Exterior_Color:
Can I add a file download section to a client login portal?
Hi. We need to create a client login portal which has a file download section for participants on our training courses. Is it possible to do this in a Zoho Creator App? Can anyone point me in the direction of a tutorial or even better, a prebuilt app that can already do this? (Preferably a free one.) Thanks a lot. Damien.
Next Page