Cancel Submit on a Stateless Form
I know the cancel submit function is only valid on a non-stateless form to be added during the validation action, but what i'm looking for is exactly the same function on the stateless form, does anyone know if there's another function out there that can accomplish the same?
Auto Fill selections from list
I have two forms, one for Product information and one for Supplier information. The Product information for has a supplier list linked to the supplier information form, and the Supplier information form has a products list linked to the Product Information Form. Is there any way to have the list auto-select/fill the products name from the Product Information form when I select the corresponding Supplier Name in the list from the Product Information form?
Second set of Leads
How can I set up leads for future use by creating a separate category of leads?
Option to have user "add" another group of fields?
I am wondering if there is a way to have the user be able to click to "add" another group of fields. Example: A group of 3 fields for them to fill out: Traveler Name Transportation Notes Then, the user could click "add" and the same three fields would show up again. So they could add (in theory) an unlimited amount of travelers in their group, but each would be individually entered. Does that make sense? Thanks for any help!
Combine Pivot tables to form a single report
Hi, I have the need to combine two pivot tables in Zoho Creator. The pivot table report s are generated from the same Zoho table(Assignments). Pivot Table 1 is a summery of all tasks and income generated in a month. Pivot Table 2 shows the same data presented in more detailed way. Pivot Table two show a weekly breakdown of task and total income generated from those tasks. I would like to combine those two pvot tables to form a single report with the summery report at the top and the more detailed
Send email to multi select fields
I have to send email to checkbox if selected, how can i do that? if i put input.Email_Copy_of_setup_to == "email list" error in return
Group multiple fields as variable
Hi, I was wondering if there's a way to group multiple fields as a single variable. For instance, if I have a form that has these billing and shipping address fields: Billing_Name Billing_Address Billing_State Shipping_Name Shipping_Address Shipping_State and Shipping_Same_As_Billing it would be great to define, somehow, Shipping_Fields = (Shipping_Name, Shipping_Address, Shipping_State) if (Shipping_Same_As_Billing) { hide Shipping_Fields; } else { show Shipping_Fields; } Instead of
Center the data in Reports in zoho creator
Is there anyway to center the data on the columns? The current is too much left align
Manually empty an upload field via script?
I have a file upload field that is hidden or shown depending on whether a radio button is checked as "yes" or "no". That is simple enough to do: if (Radio.contains("Yes")) { show File_upload; } else { hide File_upload; } But, along with hiding the field, I also want to flush it of any files the user may have uploaded, since he could possibly be doing that by accident, and after realizing it, chooses not to click the "[remove]" option next to the field, and instead
Validate Textbox with scripting builder
hello friends I try to validate a textbox, using a for ech. So i have hte next example: 1.one form that contain a textbox (user) 2 the second form contain different field, dependencia grupo user valor I need to find the textbox's value of the second on the other form, that contain diferent data. I used a for ech y the FORM ACTION validate, but it does not execute nothing. thanks for your help. regard Jorge Caro
Hide form fields from users who are not logged in to Zoho
I have created a form within an app I created using Zoho Creator with numerous fields on it that I don't want non-zoho app users to see. I set these fields to "Admin Only" in the form builder so that now only I (as the admin) can see/edit them from a view when I'm logged in, but I want to be able to invite others to login to my app and see/edit them from a view who are not admins. Is this possible?
New to creator - help needed
I am creating a booking form to go on my website. I have a number of questions I have created a client database and want the cient to be able to access the booking form without them having to enter their details or see the names of my other clients. So far I am using look up butthat shows all my clients. I also want the client to see a calander showing dates of their bookings - I dont need to see time as the service I offer is restricted to anytime on a day and is not time sensitive. Can anyone
Zoho Creator Lounge - Whats cooking?
We have a few avenues from where we reach out to our users. An all formal blog portal at Zoho Blogs where we make the high profile announcements and the Forum which is our 2 way communication platform - our users voice their opinions, ideas, suggestions etc and get help from us and other power users when they are stuck up at some place. We felt that other tiny announcements, geeky tips and tricks, ways and means to make any application jaw dropping, informal posts – bordering on technical stuff
Form doesn't show in browser
A small percentage of my users say that my form doesn't appear on their view of my webpage. My form may be viewed at http://www.jaxareagolf.org/index.php/meeting-notice/. My form does use some deluge script. Can this be a browser issue? It shows for me in IE, Firefox, and Chrome. Is their anything I can suggest to my users that they may try? Barney
Failed to Update data
Trying to save and it won't let me, everything I edit gives me "failled to update data.." messages, please help!
Limited editing for users
I want my users to be able to edit their data entry without being able to edit the application. How can I achieve this?
Problem to join a group when account was created through Google (federated login)
Hello, We have users in Zoho with federated accounts (Google login). In creator i created a group and added the users I wanted to join. They received an email invitation to join the group, but they cannot proceed with the invitation request since they have to log and only an username/password is asked. They cannot log with their Google federated login credential. Is there another method?
I need help in report.. Formula Field Logic
I'm using 3 formula field. One time commission, Monthly Commission and Grand total (total of 2 ) It is working but i need to ask what if One time payment is Paid, How can i put logic to formula field that it will not add The onetime commission to the grand total and it will just show a 12usd instead of 232usd.. please see picture pelow One time Commission is made up of 2 number fields Monthly Commission is made up of 2 number fields Grand Owe is made up of 4 Number Fields This is what i want
Issue with Summary View- urgent
Hello, I have an urgent issue which has recently occurred on our Zoho Application. I have two or three views set on 'Summary View' which are no longer viewing correctly. Results columns are out of order from where they should be. Please see this view for an example: https://creator.zoho.com/rachelogg/kiwioz/#View:Job_list_UK For example the result for the Job ID field should be MF1D (it is correct if you view in "List" view) however instead in summary view it says UK- London South. Please advise
Zoho Creator send Email with rows attached
I need to send an email to each user with all the rows in which they have been assigned. The idea is to send a mail per person every Wednesday with all rows belong. How can I do it?
Stateless form issues
This is almost copied out of the examples with changes reflecting my forms. I am trying to create a stateless form so that when cnumber is selected it will display name and account as well. But somehow the script yells at me whenever i try to save it and i get this error with a long list of what it was expecting...including that it was expecting "form" hmmmm. I tried form = Transfer and it didn't mind that but it didn't like { Encountered "form Transfer" at line 1, column 3. Was expecting one of:
Confirmation email with data from lookup fields
Currently when a confirmation email is sent any lookup fields show the record ID. Normally I would just add a send mail in the On Success section after fetching the record. However the Confirmation email can include a PDF attachment of a form Template/Record Summary. Is there a way to fetch a record in the Send Mail notification section or Is there a way to include a PDF of a Template/Record Summary.
Formula Field..
Asking for youre help. How can i do this? If date feild is Not null, it will not count the data and turn it to 0. please see picture
Is this possible customize view?
Hope you can answer me
Email Builder: Insert Expression Broken
Similar to https://help.zoho.com/portal/en/community/topic/html-builder-insert-expression-broken Now inserting an expression into the email builder fails. You only get what's shown in the picture and the "X" does nothing to close the window. You have to refresh the whole page to get out of this. Cheers, John Whitney
HTML Builder: Insert Expression Broken
Attempting to insert an expression in some HTML only gives this: ...in Chrome, Safari, and IE Cheers, John Whitney
Linking form with calender
I amnew to creator! Have created a booking form which I will embed in a website. The booking form has a date field and I need to link the date field to a calnder so each of my customers can see the bookings they have made on a day to day basis, without seeing bookings by other customers bookings. Can this be done and if so some help would be very much appreciated.
Search criteria in mobile app
I have a DB with approx 18,000 records of names and address's. When I view a report on the iphone mobile app and I put in a search criteria the results I get are just the first 50 records repeting over and over. For example .. I have a field called SN (street name). whan I bring up report on monile app I can scroll down and see many records. When I search on the field SN = Main St it returns the first 50 address's on main street and stops. when I scroll down it brings down another 50 address's
Application Context (Again)
So in testing out my clients application, everything is within the application context EXCEPT for the confirmation email for the newly created zoho account. In this email, you get a link that opens this page: I'd like to see the links for "HomeBlogsForumsFAQ" removed as it will confuse customers. Additionally, the zoho logo should be the admin's logo. Once you click that "Continue to Sign In", I'd expect as a customer to see the application. Instead you get this: This is not acceptable. I understand
Questions about limits ...
@ZOHO Creator Team: A couple of questions about limits. Over here ... https://creator.zoho.com/platform/home/settings ... it says that ... 1) Maximum number of executable statements per deluge action (e.g. on load or validate or on submit ) is 5000 When you compose an HTML View, do the commands constitute a deluge action ? 2) the number of times you can post data to another website per day is 500 Is there any limit on the number of API calls that can be made from external applications ? Gaev
eliminate sign-in on form on my website
I have attached a form on my website and I don't want to have parents sign in with email and password to get into the fill form data sheet. Can I also get an email sent to me when a form has been submitted? Sean
Help for report , i got the message : we are unable to fetch this data sorry .....
Listing des personnes par évenements : We are unable to fetch this data, sorry! Please note that your data is SAFE.Reporet this problem to support@zohocreator.com
Dynamic picklist updates on manual entry, but not on scripted entry to reference field.
Hello, I have a form with 2 lookup-picklists ("A" and "B"). First the picklist A selects a record from a database. An OnAdd / Success script for this picklist uses the selected value to populate two fields (field1 and field2) with information extracted from the selected value. The second lookup-picklist (picklist B) uses the values in the two fields to create a dynamic picklist to further select records from the same database based on criteria for the picklist that filters against fileds1 and 2..
Adding 2 formula fields ( Solved By me :)
Is there a way to add 2 formula fields?
Lookup on edit android app issue
Hello, When I edit a record from the android app all the info in lookup fields is lost. Any ideas???? Thanks
Sub forms in a view
Hi I have a view in which I display a column from a sub-form. I would like to filter the sub-form records which are shown dependent on a value in the sub form. Is this possible? Thanks Craig
Formatting a number field
I have tried to follow previous posts on this subject, but don't have enough programming skills to make things work. In short, I have a number field. I want to add "," as a thousands separator. eg 210000000 becomes 210,000,000 If I understand right, I have to create a second field (single line text) and call the input value from the numeric field, then convert it to a string and add the commas. I've tried everything, but an make this work. My numeric field is called <non_Comma> and my text field
Setting null to variable
Hello!I need to set different pairs of fields, depending on the user's choice. If the field is not necessary to set, there should be empty. Fields are lookup fields with ID's value. BIGINT type, maybe? I try so: tw = if(input.tBotcl, referencies.states.getIdByEng("onClientHands"), referencies.states.getIdByEng("employee")); te = if(input.tBotcl, null, input.employee); tcl = if(input.tBotcl, input.client, null); insertConfig = insert into changeConfig [ ... tBwhere = tw tBEmployee = te tBClient =
Group Edit
I used to be able to do a search and then click on Group Edit (or something like that) and then make changes to the entire found group. Suddenly I cannot do that. Did I do something wrong ?
Problem in downloading image from Zoho creator.
I have created a form in creator and from this form I want to download the images that i have stored in the zoho view without any tool like zoho client. I want to do this programmatically. Please help me out as soon as possible.
Next Page