Custom Scripts
Could someone help me with a couple things. I have a form set up and the data goes to a report however I would like to add some custom scripts but don't know where to start. 1) I have a form field that needs to be forced into all caps on user input (or data submit). I have tried a few options with the .toUpperCase() but can not get it to work. 2) Is is possible to have data on my report (specific row) to highlight a specific color based on a the date/time? For example, if the system date is within
False advertising - Misleading - Liars - SCAM Warning
To our disappointment, Zoho is an elaborate scam. DO NOT UPGRADE. According to this link: https://www.zoho.com/creator/help/zoho-creator-pricing.html Clearly shows branding is part of $49 Express plan - Only AFTER you sign up do you find that this was a lie. Typical. In addition - there is NO SUPPORT. The number is an answering machine. No one is there, and no calls back. DO like we did, and use a Virtual Credit Card if you want to upgrade anyway and see for yourself. This business is in India
Count grouped records
Hello, I am new here. I have made a report which shows records by grouping. How can I show the count of records for each group in the report? If I can make this work, I am sold on zoho! Any help will be greatly appreciated. thanks.
Adding existing users to share a report/ form
Hi there, I am trying to share a report with about 120 users (Amateur theatre company) Zoho complains that this is too many users and I should use a group. However when creating a group it asks me to invite users. I do not want to invite users as I do not want them to receive an email from zoho to join a group (for sharing a report/form I can switch the automatic invitation off) . I want to send them a personal email from my email account sending them a link to ZOHO to sign up, login and update their
Cannot log into Creator without security selections?
Hello, I am having trouble logging into Creator bypassing the new security option - it will be difficult to get all of our users to enter daily codes delivered through text messages each time they access the applications. Please advise. Thanks, Silvia
sharing an application does it even work?
According to this document, its supposed to work, but it doesn't seem to for me. https://www.zoho.com/creator/help/share/adding-new-users.html#Adding_a_Developer_to_account_and_allow_one_of_shared_users_to_access_the_application
Why my code disappeared in Z creator?
I have written the code in creator and after saving the code when I reopen the page I see the code is missing from the page. Please help me. Please see attachment ZCode.png.
created a user, but it can´t share the app
Hi, I´ve created a user with a zoho.com email and password, but it can´t access my app. I´ve shared the app with that user. Why is that ? What should I do to share my app with a user with a zoho email ?
Can't even get a simple fetch data to work
Why is this so hard? I have two test forms: Form1: Name Age Form 2: Name lookup dropdown from form1 Age I just want the age field on Form2 to auto enter the age from the selected name in the dropdown. Essentially looking it up from Form1 It keeps telling me the name is an integer. What EXACTLY do I need to do? thank you.
Lookup field in 'Record Summary View' shows ID, not value
Hello, I've got a Record Summary View to summarize customer data. Some of the fields on the source form is are lookup field, such as from a list of technicians or service operations. However, in the view, it displays only the ID of the lookup selection(s), not the value, as shown in the attached image. Is there a way to correct this? Thanks, Elizabeth
automatic data uploading?
Hi. I'm trying to build a web page around an embedded zoho creator application. I need the data to stay up to date for the application to be of any use. This needs to be an automated process. Is there a way to upload data from a server to my zoho creator application? For example, in .csv format?
Extremely poor and unprofessional services from ZOHO Creator
Hello All I may be the only person experiencing this, but since the middle of August, the services provided by Zoho Creator has gone to the dogs. Case in point being unresponsive and dodgy customer service, who among the many ills include unresolved ticket issues and a case of speaking from both sides of the mouth. Additionally, for the last two months, I have had a persistent problem with schedule execution, which despite numerous calls and emails, has remained unsolved. To add salt to an injury,
Sending a notification to all users
This must be an easy on, but I can't figure it out myself. How do I configure the form notification in order to send an email to all users of the database each time a new record is successfully added. The only available variables in the To: field are "zoho.adminuserid" and "zoho.loginuserid" but there seems to be nothing to send the mail to all users, regardless their current login state.
How could zoho forms be integrated in my website?
Hello! I what to know how could zoho forms be integrated in my website? For example, I created a registration form. I want my clients to register with your Name and email. Then, I have an email verification form to be sent to the client to confirm their email. And when/after they click on the email confirmation link their account is created/added in my database. I created the sample form using the "Creator" app and added the "CRM" app in the form (have the CRM app as invisible for other users).
Simple Calculator with Zoho
Hey there, I have created with Excel a simple calculator. The topic is a plastic specification called MFI. There are three different kinds of MFI: MFI 2, MFI 5 and MFI 21 I have created the calculation between these three. The aim of the calculator is to calculate the other MFI´s if you have got one of them. I.E. you have got MFI 2 and you want MFI 5 / MFI 21. MFI 2 MFI 5 MFI 21 Input 1 Output 1 4,5 100 As I said I have got all the calculations in all directions, but I can't implement this into
Import multiple entries to stateless form
Hello, I've created a stateless form to update certain values in a selected record. However, I thought that I would be able, as with a non-stateless form, to import/upload a file with multiple data entries to have them all update automatically. However, there does not seem to be a way to import data with a stateless form. So, my questions are: (1) can you import data into a stateless form to achieve the goal exemplified below, and if not, (2) how do you change a stateless form to a non-stateless
Problem with using the "select" task for a multiselect lookup list - data won't be saved.
Hi there, I'm trying to pass values in my form from a text field to a multiselect lookup-list (on user input). When a certain string is entered in the text field, the exact same value should get selected in the lookup-list. This works fine while I'm adding data to my form. The values in my lookup list get selected. BUT: When I submit the data, the selected values in the list won't be saved! (In the second screenshot, the data from the list should show under "CRUs" - but it's just empty...). My simple
Field check and validation
Hello people, I'm new to this Zoho Creator and I'm developing my very first on line form. You can find it embedded here: http://www.suezo.it/iscrizioni-on-line (sorry ... it's in Italian!) This may be a silly question, but since I'm new to this it's causing me some trouble! I added a few "number" fields (quantity of tickets) but I need to check and validate numbers. Example: one field needs to be "20 or more" so I would like not to the form to be submitted if that field is 19 or less. One other field
Setting an end date 1 hour later than the
What's the simplest way to have the end date 1 hour after the start date for a calendar view? I tried adding a variable field and setting it to have an expression of Demo_Date_Time.addHour(1) which works but then on the calendar page, I can't set the end time to be that variable (it only shows fields with a date/time property, not variable fields): http://ge.tt/85F7Jmy/v/0?c
Not getting download request
Dear Sir, One of my client is asking to download my apps but I am not able to find his download request for approval. Please guide, how can I get it. Awaiting for an early reply as the customer has made payment but I am not able to approve his request. Regards, Abhinandan Sharma 8010855550
Return value type from a map
Hi i'm confused about the map's 'GET' function return value type form the tutorial, it seems not have to do explicit casting https://help.zoho.com/portal/en/community/topic/map%28%29-tutorial-%28intermediate%29 but when i try the following codes (firstly, create a "num_val" number field) vars = map(); vars.put("Num", 123); num_val = vars.get("Num"); i got error message like this Variable 'num_val' is already defined of datatype 'BIGINT' but trying to update 'STRING' datatype so
using the URL field with no URL
Hi All I am a newbie both to databases and this particular method of creating them. I have made a form with the main primary field being the identifying name of an item. What I would like is that the name is clickable to an associated URL path, if there is no link I would still like to see the identifying name. I have used the URL field but it doesn't like a blank URL field and if I use just http:// it brings up a blank page (not very elegant). The important part of the URL field for me is the link
Form data formatting
Hi, I have a form which sends user input data to me via email notification but I want to know how to format that data in a presentable for in the email that I receive. For instance, one of the fields is a text box which can contain several hundred characters and I want to be able to condense that into a text box on the email, rather than just one long line of text. Anyone know how please?
Import Issue
Is anyone experiencing import issues? I exported the data to excel and when I went to import it back into the database an "Unexpected Error" occurs telling me to contact support. I have done this but have not heard anything back. Does anyone have any advice? I really need to get this figured out tonight. Thanks for any help.
Linking Zoho database to email account for bulk mailing
Hi there I am working with a non-profit organisation and I am using your fabulous Zoho Creator and wondered whether there was a way to link it to an email account for bulk mailing purposes. Many thanks Christine Bacon actors_for_refugees
Email Attachment
I have put together a purchasing application where I am uploading the vendor quote into the form. I would like to email the vendor with the purchase order information when the form is submitted successfully. I have figured out how to send the email to but have two questions. 1) I have a Contact field in the form which looks up values from the Combined Name field in the Contacts form. How do I get the email address from the Contacts form corresponding to this contact into the To: field? 2) I
Field Border Color ???
Hello all, I can see in the excellent article Style-based URLs that pretty much all parameters for a ZC form can be changed... However, I am not seeing an option to change the FIELD Border Color upon field entry. Right now, the default gray blue exists, however I need this to be a very specific green. How can this be achieved ? Thank you very much for any suggestion. Francois
Removing Reset button in the forms
Hi, I want to remove the reset button in the form I create Is there any way to achieve this?
Event and Attendee Subform Tracker
Hello I have an Event form with an Attendee subform within it. With the example I have below, I have Test Event with Test1 and Test2 people attending the event. How would I attach the event name to each attendee without having to select the event name over and over again for every record? Thanks!
Sending a value to a field in an embedded form
Hi. First of all - good job on an excellent product with a huge potential! And the support so far is amazing. A question about embedding forms: I am writing an application that manages our customers and among other things collects leads from our site. I have written a form "leads". One of the fields in it is "Industry". The leads come from different industries, and on our site we have a page for each industry. I don't want to create a lead form for each industry (becuase we have many), rather use
Moving columns
I can not figure out how to move columns in Creator in a view. When I added a new column, it went to far right, and I find no way to move it into the column order I want. In the old app builder, I just clicked on it and slide it to where I wanted it, but I cannot find any feature like that now. http://tinyurl.com/30thRoster
Updating consecutive records
Dear Zoho Creator team, when one updates consecutive records, it's very helpful to have the screen remain in place, showing the line just updated - instead of (the current default of) going back to the 1st record on page, and wasting time trying to find where you were. on top of that, since Ctrl + Home/ Ctrl + End already brings the user to the top/ bottom of the page (respectively), it makes more sense to have the default being "stay where you are". hope to see it soon at work, thanks, Anat
Chart Based on View Request
@ejaffarian We have come up with an option to create Pivot Table & Pivot Chart based on a View like our old app builder and it is available in creator.zoho.com now. You can try this option via "Create New" -> "Report" -> "Pivot Table or Chart" -> Choose Form and its View to create one please check the same. @Others Please note this option will be enabled for certain users alone (on request basis). Thank you, Saran Please enable that for user sigroup
How do I get a field to be required once someone enters any data into a date field?
In my form I have a "Document Date" field, when someone enters any date in that field, I want the field "Upload file" to show and be required. Here is the script I wrote for a similar one but the field Filling_State = to PA. I just want any date entered to trigger a similar action. if (input.Filing_State == "Pennsylvania") { show Date_Estimate_Filed; show Date_Estimate_Filled; show Estimated_Filing_Amount; show Proof_of_Payment_Due; show Proof_of_Payment_Filed; } else {
Dynamic Display of fields in Record Summary View
Hello, I'd like to know if it's possible, and if so how to, create a record summary view which allows for fields to be displayed dynamically based on conditionals. For example, if I have a field for Extraction= (No_Extraction), (In_Progress), or (Extraction_Complete), and a checklist of extraction-related tasks, then I'd like to do the following: (1) if Extraction == No_Extraction display "No Extraction Planned" display Service_Plan (2) if Extraction == In_Progress display a 'Removal Progress' section
Vertical Divider in 'Record Summary View' Section
Hello, Is there a way to add vertical dividers between the columns of a Section in a Record Summary View? Thanks, Elizabeth
Lookup Box Dependency Filters not working.
I submitted this directly to support 3 days ago but as I've not received a response, I thought I would try the open forum. First I'm a creator newby, but none the less... I'm trying to filter a lookup field based on another lookup field on the same form and I'm trying to use the instructions found here as guidance. I have three forms which are created as a basis for each of my lookups for my final input form. However for this discussion I will only discuss two input forms and the final data collection
Word Count in Multiline NOT working :(
Hello all.... I have the following script to stop a user from submitting a narration text to us that is above 125 words. However, for some reason, the submission does not get cancelled... wordsList=input.narration.toList(" "); wordsCount=wordsList.size(); if(wordsCount > 125) { alert ("Sorry. Only 125 Words or less are allowed. Please correct your narration text accordingly. Thank you."); cancel submit; } Thank you very much. Francois
ONLY DE ID...
I want a form to give me the value of an Id in a lookup field from a form wwith the structure IdX (Num) - X (Text) the "view" view. Ex: I select the value X in a lookup field (that has an Id, Ex: 1). I want the form to give me just the Id. I did a form that gives the "1-X", I want only de id...
Users cannot access shared applications on Zoho Creator
Currently none of my users can access the applications I shared with them on Zoho Creator. Can you please inform what is going on? Also, support phone lines are stating there's no representative available for Zoho Creator.
Next Page