Challenging Task: How to prevent double bookings
Good morning zoho crew! My new task is how to prevent double bookings. Stateless form Guest_Reserve form Test_Reserve holds the table fields date time Zoho date/time start datetime Zoho date/time end number Number_of_Riders number Current_Seats_Available picklist Status (Reserved, Waiting, Available) is there a way for zoho to check for times that are booked ? maybe something like count Zoho date/time start between Zoho date/time end if input.Number_of_Riders is more than Number_of_Riders mark
changing text to other symbols
Hi. I've read some forums around regarding the lack of support for creating password fields in Zoho Creator. I noticed they were dated back around 2009 or so. I was wondering if there are any improvements about that as of today. In addition, what I really want to know at the moment if there is any way in Zoho Creator to change whatever is on the text field into something else, like how a password is like for example. Well, through coding... Like... my password "12345" will instead show up as "*****"
Aggregate Sum function
I am using the aggregate sum function <variable> = <Form_Name>[criteria expression].sum(<Numeric Field Name>); First issue is if there is only one row then I get a null variable. Second issue is when there is more than one row I am getting incorrect results.
Get property of record using only ID
Hi there, We have a Project form, a Job form, and a PO form. The Job form has a lookup field that links to the Project form's ID but displays the Project's Name. The PO form has a lookup field linking to the Job, but I'm not able to have it display the Project Name associated with the Project ID that is referenced in the Job form rather than the ID itself. Any way to do this? One way to do this would be to create a formula where it finds the Project where ID == something and then get another property
newbie question re: lookup fields & form/view
Hello: I have a form with perhaps 50 fields, which describe a new contact and various attributes of their business. Now I want a second form that allows me to look for a record in the first table optionally by various fields, such as 'BizName', 'LastName', 'ZipCode'. So I can find the record by whichever piece of data I have. When I select the correct record, I want to see many of the other fields from the original form displayed on this new form - so I can update them from here if needed, and so
More info and print buttons
I there ! I'm trying to build a simple online database but i'm having some problems dealing with Zoho. I'm stuck in the following problems.... i need to do something exactly like this and i don't have a clue how to do it! I need also to know how to format HTML Views to make nice database lists and be able to print them. Please, point me at the right direction ! Thanks.
Is it possible to set a custom schedule to run only on weekdays?
I have a daily custom schedule that reminds users to return items they have borrowed. Currently, if a user has an item due on Friday, and they don't return it, they get reminders on both Saturday and Sunday. I would like to skip the weekends, so they only start on Monday. This would be a great option to have in the Frequency GUI drop-down menu...
Email a single record
I have a purchasing form and for certain purchases, they will need permission before the purchase can be made. So I would input the information then put it on hold, email the info out, and then once given permission place the order. I know you can email a record upon submitting a new record or changing/updating a record. What I want to do is email a record from the List View by creating a custom function because not every record will need to be emailed, only certain ones will need emailed. Or
share 1 application to another zoho account multiple times?
Here's the scenario: I have created an application in my account. I have shared it with another zoho account so that when i update the application on my first account it will allow the other accounts it has been shared with to update the application. My question is, can I share the same application to the same zoho account multiple times? I would want it to have a different name for each share and each application would have different data. Also, when i update my single application in my first
[t_811321000000024029_PIDX] Exception occured while inserting rows Failed to update data.
Hello Zoho Creator Team: I have the following error while trying to update data [t_811321000000024029_PIDX] Exception occured while inserting rows Failed to update data. :( I'm in the middle of something here and needed fixed as soon as posibble, hope you can help me :) My app is: https://creator.zoho.com/andrea.gmcr/sistema-producto-mango/#Form:Sistema_Producto_Mango_Form I thinks its related to this posts: https://help.zoho.com/portal/en/community/topic/critical-error-t-734872000000029031-pidx-exception-occured-while-inserting-rows-failed-to-update-data
Syntax error: function doaction(recType).....
I receive this error when running an HTML view called Start Here in my application. The error message is: function doaction(recType) { } $(document).ready(function() { doaction(); }); I have shared the application with support. The easiest way to recreate the error is to select the tab Show Preview while Start Here is open. The script will prompt for an email address; enter a dummy email address (xxx@yyy.org will work fine). The script will display the correct form on the screen with the error
Hide certain fields based on what view the user is coming from
I have a fairly large form with a lot of information on it, so quickly filling out a small section is a bit tedious. I am wondering though if I can use "hide" or "show" commands for certain fields based on what view the user is coming from. I know I can do this based on the user's ID, but since all users need access to all the fields this is not an option.
Multiple tabs in forms
Hi, This has been a reoccurring question over time and I'd like to pose it again. I have many fields in my form and there is currently no good way to group them. Are you considering offering multiple tabs in forms? I know you offer stateless forms but this is not suitable for my requirements. It is purely a presentation issue, I need to be able to group information on one form, with easy, quick access to all. Multiple tabs across the top of a form would be the IDEAL fix for this. If this is not on
Library Database?
I am looking for a online database to catalog DVD's, CD's, books and the like. I stumbled across this website, and I was wondering if this program is designed for that. This is my first time maintaining a database, and I was looking for something that was easy to use and flexible to fit my company's needs. Thanks!
Auto generating a field scripting error
I have a subform on my Equipment View that when you hit will open up an html view in a new window that shows additional information for that particular item. I have it set up so it will automatically fill in the Asset number (Pick_Asset) based off the meeting application. That works fine. What I'm trying to do is then auto fill in the Asset Description as well so when you click on the subform it will pop up with the Pick_Asset and the Asset_Description already filled in. However it's not working,
Problem with coding 'Actions on user input'
Hi, I am a bit new to making this kind of thing and would like a bit of help with making a bit of code to make my form look better. I have a question with a drop down box with lists of towns in. At the bottom I have added the word 'Other' in case the town they live is not listed in the box. The next question is 'If other please specify' which is always viewable to everyone and I would like it to pop up when someone clicks on 'Other' instead. I have this kind of situation around 5 times through my
Variable Questions
I need a variable that can be accessed by multiple 'on user input' things. I don't seem to be able to declare the variable in the onLoad section and then access in the onUserInput sections, is there any way to make this work? I don't want to have to make a form to store a variable in a database. It seems like such a waste.
Sending information from one form to another quit working
Sending information from one form to another quit working I set up a form called Test_Reserve and a form Called Test_Cal_Form Was having great luck sending information from Test_Reserve to Test_Cal_Form so I could create a google cal feed. It quit working after I changed a field, but I looked up all the fields and as far as I can tell they match up fine...help? insert into Test_Cal_Form [ ENDS = input.real_end_time_date STARTS = input.real_zoho_start_date_time DETAILS = input.Riders_Names_Ages_Weights
Easy Styling of Forms and Views?
Is there an easy way to customize the way my forms display? I'm specifically interested in having more than one field per row per column, and allowing more than one checkbox/radio button per row. Instead of: Field | Field Check | Check | Check | I'd like Field Field | Field Field Check Check | Check Is this possible?
script execution tracing
Is there any way to do this? I'm getting an ambiguous error on a user function and it would be perfect to be able to trace through it, even without a full breakpoint capability.
Android & RTF
On an Android phone using http://mobile.zoho.com RTF fields show as plain text but with the html code showing. Is displaying these as full RTF fields on the roadmap or is there a workaround? Thanks Herb Wexler
Custom Action html View
I have created an html view called Maintenance that combines the Add_Maintenance form and the View_Maintenance view together. I have created a custom function so I can put a button on my Equipment view that when clicked will pull up the html view for that particular record. I have successfully created custom function buttons that separately pull up the Add_Maintenance or View_Maintenance subforms but having both was rather cluttered which is why I combined the views in an html view so there would
Problems with special characters
Hello, A time ago I had a problem with some scripts in my forms: https://help.zoho.com/portal/en/community/topic/deluge-script-if-condition-in-on-user-input-is-behaving-oddly and now it seems that there is the same problem, as the forms were working wrong again. May be it's exactly the same, because I was told that there was an issue with special characters, and I tried changing the characters that caused problems then (á, ñ), and everything works well, but I need those characters. Greetings
cannot import data into form
created a form via upload of an excel which was done perfectly. then i tried upload data from xls it showed the 3 steps and then said import successful "close now" How ever on going to the view im unable to see the data!
support hours? ticket portal?
Earlier today I read somewhere on the Zoho Creator website (although I can't find the page right now!) that Creator support is offered 24 hours per day on week days. However, I never seem to get any replies from support staff until late evening local time (GMT +10). It really seems that support is only working on US time. Is this right? Also, there doesn't seem to be any support ticket management interface, where we can access and update support ticket details. Why not use Zoho Support for this?
Search Page Embed results in list view ColumnS Getting stretch
Hi, Thanks for reading I have made a search page which function fine within ZOHO But when iembed it within my site it works but the result which i display in a list view become stretch for some reason. i have no idea why this is as it appears fine in zoho and it only 6 Columns which should easily appear within a frame which is 900 - 900 so i dont know why this is. i have try to work with the column width being adjusted but this did not have any effect. SO I AM REALLY STUCK PLEASE HELP!
I need a simple contact form with mobile = sms verification
I need a simple 4 field form with name , mobile , email age field with no replica. I need email field to check againt previous entries. Mobile should verify and send sms code to user that authenticates himself filling out the code. I have sms gateway and http api with me. http://your_domain/pushsms.php?username=your_username&password=your_password&sender=your_senderid&to=your_recipient&message=your_message&priority=route But i am unable to make out how to integrate it with zoho creator application.
How to read json data of zoho-creator via url ?
I have url of zoho creator from there i can get json data. here is this url " https://creator.zoho.com/api/json/yugapp-feedback/view/Guest_Book_View/apikey=" This script i am using for read json data $(document).ready(function() { $.ajax({ url: 'https://creator.zoho.com/api/json/yugapp-feedback/view/Guest_Book_View/apikey=', type: 'GET', dataType: 'json', contentType: 'application/json; charset=utf-8', success: function (data) { $.each(data, function
Bug in Script Builder: iframe dialog does not work properly
Dear ZOHO, The Script Builder dialog for OpenUrl with an iframe does not finish correctly. When I try to add a parameter to the dialog box (such as the name of the iframe), the correct code is not inserted. Maybe you can fix this? Kind regards, Silvester
Import + Global variables + linked fields
Hi everyone, and thanks fro stopping by… Here is a problem I have, I already spent several hours on it without success, so you're my last hope... (codes are below). I have 2 forms in 2 applications: Form1 in App1 and Form2 in App2. Form1 is for contacts and form2 is for restaurants. For each contact I have to link a restaurant, I can link the same restaurant to several contacts (the manager, the chef, the waiter...) Each restaurant has a reference contact, who is in the contact list. In
Stateless forms? Not sure
I am trying to create a web form that a use inputs contact info and then clicks a next button then an additional screen appears where they put additional info and then clicks submit. Any assistance in this would be appreciated. I have tried using the stateless form and I can get the fields to populate. Thanks!
Search More then 1 Field in a list view
i am looking to search a property app Which Allow user from a drop down box to select area, Bedrooms required & Property Type i have got the app to search one field thanks to this sample app which i use the code from but how do i get the search to take in to consideration the 3 fields https://creator.zoho.com/sampleapps/search-app/# Any help will be greatly Appreciated
Add to Lookup Field Bug
In my application there is the Task View or the Add_Task form, when someone adds a new task, there is an issue when someone attempts to add a new item to the lookup field in the form. In the add form, there are several lookup fields along with the Add To beside the field in case you need to add an option to the list. When someone is in the process of adding a task, and needs to add something to the lookup field an error message pops up that says an error has occurred, however the item you just added
create subform for purchasing form
Hello, I create a purchase form with date, purchase id and total cost. Than i create a purchase_item form with the purchase id, product, unit cost, qtd and total item value for every line of the purchase. There is a way to create a easy purchase form where the user could set the purchase data and id, than add many purchase lines as she want's? Thank you very much, joão melo
Want to use "deselect all" but no fields listed...
My assumption is I can use "Deselect All" to basically "uncheck" radio button selections? I use the script builder to drag "Deselect" into my script page. I click on "DeSelect all" and when I go to select the 'field name'.. the drop down is empty. I have everything from radio buttons, dropdowns, etc on my form and this list is showing nothing. What could I be doing wrong? I basically want to deselect all items in my Radio Button list when someone changes another field. I'm putting the code in
Recurring text input
Hi, I am using Zoho creator and inputting data into basic forms. In a section of the form I created (called notes) I have a phrase that I am having to type for every form that I input data to! This is making the work tedious! Is there anyway i can use the edit application feature to place this recurring text phrase into all my new forms. Thanks.
Why the button to generate the pdf is not working?
Why the button to generate the pdf is not working? See https://creator.zoho.com/marcosulzbacher/rbni/view-perma/Ficha_Publica_do_Imovel/Ag3ECRKSdAxRO9OTaK2hsSybNGQ0OuG1Fuf57eVMyjGyqhYmXWxVAS0FaD6Bdr1sW6g8q5usFHfjCAvv66vxPdzGUF60HCwuNUEq?potential_idstr=679162000000850015 Thanks Marco
Photos do not get loaded
Hello, I have created a very simple form with the need for the user to upload a photo as a required field and when I test it and I Add a photo in the required field this does not get loaded and as a result the e-mail notificaiton I get has everything apart from the photo that was to be uploaded. Can you please help me? The code of my form is the below. <iframe height='500px' width='100%' name='zoho-form' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/bettykarastatira/free-or-sell/form-embed/form/'></iframe>
How to trigger script in a stateless form via API call from external site?
Is this possible? In my tests so far the API call itself is successful but the code in the "on click" action does not run. Is there a trick to getting the script to execute via the API call?
Updating application across multiple zoho accounts
I have built a zoho creator app but this app is to be deployed to multiple clients. As a continuing service I am going to continue to develop and improve the app. My problem is i dont want to update each application separately as I update. Im sure there is a name for what I am trying to do. Is there a way to create on app that others can use that when I update will also update their version? I want to avoid doing new installs and exporting all data from the old version and importing into a new
Next Page