Error adding a developer
I'm trying to add a developer to my app and I get the following message: "Failed to add user. Adding user, with secondary email address is not allowed. Contact the user for their primary email address." Does this mean he has already registered to Zoho Creator with a different email and set the one that I'm using as secondary? Also, do developers count toward the number of users in my subscription?
Are there additional formulas for Zoho Forms? If not, how would you create a formula to find a date that is X amount of weeks from a set date?
I'm building a form where I need to get an output date of 52 weeks from the input date. I'm finding that Zoho Forms is limited in the date formulas allowed (unless I'm missing something). Seems like I may be able to use Zoho Creator for this (also not sure on the integration between Creator and Forms or if there is any). My questions are if there is a formula that I could use for this in Zoho Forms and if not, what would the formula be for Zoho Creator?
Filtering Lookup Field in Subform based on Lookup Field in Main Form not working
Hello Everybody, I am new to Creator. I have searched and searched and tried everything I find but nothing is working. I am trying to alter the Quote Management Program available from the App Deck to filter a lookup field in the subform of create quote. I have The Main Form: Create_Quotation I have created another form called Vendors On the Main form is a Sub Form: Products _On_Quote The Sub Form is referencing the form: Product_Service_Subform ON the form Product_Service_Subform I have added a
Implement payment methods in Zoho Creator (other than PayPal)
Hello, I would like to know if it's possible to implement other payment methods besides PayPal in a Zoho Creator application as long as it offers an API? My customers sell wireless service and do activations though us as a wholesaler, I need them to be able to add money into their accounts, and then when they make a sale and activate service for a customer their cost would be deducted from said balance. I believe this is possible with PayPal because there is native integration but I want to know
Get latest data from account from report load (not form)
Hi, I have a report which has test reports waiting to be sent to clients, however, I have a problem. I have a condition on a custom send button which checks their account status. It's either Operational or On Hold. If it's operational the send button works, as expected. The pulling of this data requires the form to be opened to trigger the "On Load" event which checks the account status. How can I go about this without going into each record, like from the report list? Is there a way to get the latest
Clear the search criteria of a report through code or URL?
I have a stateless form that uses a workflow to display a link to a report with criteria using URL. example: app.zohocreator.com/owner/app/#Report:Name_List?Customer_Name=[Kim] However, doing this only adds the criteria Customer_Name=[Kim], it does not clear any criteria that was made before the user clicks this link. For example, if someone had searched for a range of dates on the report Name_List and did not clear the search criteria, then going to the example link shows the Name_List report
Displaying two linked values from forms in a new form
Hi, Just signed up for Zoho creator as it seems like the perfect fit for me. However the learning curve is quite steep. I'm trying to make a reporting system for our business. I have a form with staff details. One of the fields is 'Level' which is a lookup to a level form (i.e level 1 to 5) Then I have a third form which is a team setup form. I have a lookup field here for their name (and the possibility to add if missing). I get the name field to work, but also need the assigned 'Level' to show
Form Object in custom variable comes up as Form Name + ID, does not fill my multi select lookup
I have build a stateless form to be used to change fields on selected records from a report view. I have created a custom function with form object (ID) as the argument. I have built an action in the report quick view for multiple records, selected collection of records, created an workflow with action to run the custom function. When I run the action on a number of checked records in the report view, it pops up the window for the stateless form correct, but the lookup fields with multiselect shows
Help with Deluge Script for Checkbox
Hello, I am where I want to display certain sections depending on someone's entry in a checkbox. I have entered this script: if (input.Checkbox.contains("Gas")) {show Gas_1 } and I get an Improper Statement error. Can you please assist? Thanks!
Does Zoho CRM support Arabic Language yet or not?
Does Zoho CRM support Arabic Language yet or not?
"for each row" script error message
I'm having an issue with something that I thought was simple... the following code won't compile. It is the only code I've put in an "on edit on input" workflow for a form which contains a subform. I am sure it is something obvious, but I can't see what is wrong with the syntax. FYI - the subform name is correct. The error message I get is " Error at line 3 'row' is system keyword and cannot be used". 3 for each row in Remaining_Activities_Subform_in_Mainform 4 { 5 row.Free_Float_Days
Custom Button in Report
Hy , I have some questions , how to implement them :- 1. wane create custom button in report from through which able to change Status (lookup field) .but if it changes once and click again on status then its shows popup message cant change it again . 2.wane make search module for all categories in report .(see image 1.png). I'm making this Application in ZC5.
Help needed to build an application
I am new to zoho creator.I am looking to build an app for Athlete registration for Gymnastic Competition and then use athletes to Apply for game participation in different competition and age categories Different Age Categories are: 1) Age 11 or below 2)Age above 11 below 14 3) Age above 14 below 17 4) Age Above 17 Different Competion Categories Are: 1) Individual Men 2)Individual Women 3) Mix Pair (1 male and 1 female) 4) Trio ( Team of three not gender Specific) I Have managed to get User Registration
Geographical information Systems
Hi Zoho The GIS method is poor on the system, could it be linked to a suitable satellite GIS locator with touch and capture technology for field asset collection please? we used sixmaps.nsw.gov.au to map our positions this week, but it is not a global provider. ESRI could be an option to consider? Cheers Michael
Zoho Creator - Customer Portal - get notification when new user signs up
Is it possible to receive a notification by email when a new users signs up via the customer portal? I see a checkbox "Notify on Sign up for approval" in settings, but do not receive a notice by email. Furthermore, it is unclear to me to which email address this notice will be send.
Fetch Data
I have two forms Form 1 - enter employee details - which has fields like employee_id_1 (number type), Designation(dropdown) Form 2 - activity details - which has fields like employee_id_2, designation, activity details, location Now, I want to populate designation on the basis of input for employee_id_2. I have made this employee_id_2 as a lookup field from form 1 (employee_id_1) To fetch the records, i wrote the following script { temp_var= Enter_Employee_Details[employee_id_1 == input.employee_id_2];
Invoice to Work Order
Goal: Choose and invoice and have the option of creating work order with a custom set of fields to go through production. To have my digital file system (art files) with folder names that match Invoice #'s / Work order #'s. That way we can at anytime look up an invoice # for a client and find the art work and pricing with ease. Has anyone created anything like this? Work order would have the same # as the invoice and would carry over the contact information, etc; basically the same top portion as
Sharing Zoho Application on the internet
Is there a way to share a Zoho Creator application on the internet without requiring users to sign in ? Thanks.
Filtering in MultiSelect Field
Hi, I have a list of Room numbers in Multiselect field. Whenever I select a Room No it should disappear in next time. I have tried intersect and remove All strategy. But it is not work properly. Can anyone give me a solution?
How to add Bootstrap Nav Tabs to HTML snippet in Pages
I find the record views or base Creator to be lack luster and only data visual and not much to be able to edit and really use the data so I have bee creating my own Pages for data views of records to be able to view them in a good layout and be able to interact with the data and do actions. I have been looking at Bootstrap and it has a lot of components that would be awesome to do this. At this moment, I am messing with Nav-tabs to be able to minimize the page length to only show what the viewer
Fetch Data In A View/Page
Hello, I have 3 forms Form 1 is a parameters form Form 2 is a tasks form (subform) Form 3 is a search form Form 2 is linked by a lookup field to form 1 - ID Form 3 is embedded in a page, and i would like to know how i can enter values in form 3 and pull entries from form 1 inc subform values of form 2 and display values in the page <= the criteria set in form 3. Any advice would be great thanks
SearchRecords with Variable in criteria
Hello, I'm trying to use a variable in my searchRecords Criteria, but is not working, how can I use this ? I'm sending Email var for another URL external page and I created ID variable in my zoho creator application. Now I need to find a Lead using the email and get all lead records. ID = "rico@gmail.com"; <--- URL VAR , I set this value to test. Record = zoho.crm.searchRecords("Leads","Email:equals:" + ID); RecordMap = Record.get(0); LeadId = RecordMap.get("Name"); Thanks
Update Detailed View on Mobile via Popup
Hello Zoho Community! I have been trying to make this work on Mobile, but am having difficulty finding a proper solution. My application is based on one main form for all of the records in the app. To make quick updates to various fields in a record without the user having to open the main form, I have created a custom action that opens a popup window (which is another short form) from the detailed view which updates the main record with the entered data when submitted. The record created from the
Bulk duplicate and add new duplicates as child records of a different parent?
I am trying to figure out a way to be able to bulk duplicate records in a report (Tasks) that have a parent record as Task Template and be able to add those new duplicates to a different parent which is a Project? The Task Template is a Project but being used to store tasks to be able to copy and put into different Projects. Thanks for any help with this
How can I insert the Creator form into Web?
How can I insert the Creator form into Web? https://www.dropbox.com/s/65z5cwfsorl2tqa/app.gif?dl=0 I made the above App on Creator.
Can't access User Portal despite support recently saying I should have access, support no longer replying
I am writing this because I filed a support request 3 weeks ago and haven't received any reply from zoho support yet, so I'm hoping someone can help here. We are on the previous zoho creator pricing plans (at least, I think that is what they are) and in a previous support ticket, zoho confirmed we should be able to access and use the user portal. However, trying to access the user portal on creator 5 leads us only to a screen saying we need to upgrade our account (screenshot attached). Anyone know
Updating data in one form based on condition in another form
Hi Here is my scenario. I have two forms. One form is called Airstrip Profile. Thats the form we INITIALLY entered data and we have about 50 records to date. Recently I have imported a Excel file and as a Form with data and called it Rural Airstrips. Its has about 600 records. Common fields in both forms (Airstrip Profile and Rural Airstrips) are: Airstrip_Name, Lat, Long. The Rural Airstrips has a dropdown field with 2 options. The 2 dropdown options are 'Verified' and 'Not Verified' Now I would
Break Line in HTML Forach
Hello I am trying to list records from a form in a page but currently they show all subform valuesnext to each other rather than as a list underneath each other. is there a way to achieve this? currently: gate duties, gate duties required: gate duties gate duties here is the code so far <%{%> <% for each record in RMP_Requirements_Parameters [ID != 0] { name = record.Requirements.Task ; %> <%=name%> <% } %> <%}%>
Suggestions for Zoho Creator
Hi, I have been using Zoho Creator for about a week now. It seems like a promising tool but I have come across a few blocks that were quite frustrating especially since it seems that they could have easily been added to the current feature set of Zoho Creator. Maybe these features are available but I have not been able to find them or at least not in a directly convenient way. If not, then I would like to list them here as possible feature requests which I think would give ZC a big umph. 1 - More
Is there a way to define dropdowns (not lookups) as value-description pairs?
Hello. I have searched the forum, but found no solution. It would be very useful to have this feature, specially when you have to take different actions based on the user selection: instead of checking against a (probably long) string, you could check against a key or ID. Is there a way to accomplish this? And if not, would the Zoho Team be so kind to include this feature in future releases? Thanks in advance.
Record Template - Yet another half baked feature
Please, stop adding half-baked features to ZC, you're driving us crazy! Record template is amazing, but at the same time, useless in so many ways. Here's a basic scenario: 1. I have a Staff form with a relation to a Tasks form. Tasks are assigned to a Staff each. 2. On a regular basis, I want to email my users a list of Status="critical" tasks they need to complete. Stupid as it sounds with record template I can't: - Filter records based on a field, so all the tasks will be included in the email
Duplicate Values
Hii, I have an issue regarding No Duplicate Value option. I have a Field that is in lookup. How can I apply No duplicate value Option to filter that field?
Fetch Records
Hello, i am having an issue and struggling to resolve it. I have a form with a subform inside that has static data with an increment number. I also have another form with a date field and a number field that allows the user to input a number in a field which is embedded in a page. I am trying to pull values from the static subform and display some of the values on the page based on the date and increment number <= the value entered in the second form i am struggling to display the results on the
Embedding form on web page
Hello, I've created a form for public use, and I've embedded it on our Wordpress site. Everything seemed to be working great, but I just noticed one item that will be a huge issue... I have a video upload field where people can either send us a video file, or they can record from their webcam. When testing out the form on its own (not embedded), everything works great - when I click to record a video I get the message saying that I need to allow the browser to have permission to use the webcam -
Is Realtime access to Zoho creator from MS Access possible?
I have a client who wants to be able to view data from their zoho database inside MSAccess in realtime for reporting. I can see API calls in the zoho help documentation about writing zoho records from Access and web sites etc but nothing that allows me to pull data into an Access database or just view it in access. There are two things being asked for. 1) The ability to view realtime data in MSAccess for reporting. 2) Pull data data directly from zoho forms into corresponding forms from MS Access
Troubles setting up Webhooks
Hi Zoho Creator team! I'm facing some difficulties setting up a request from an external application (Docparser) I setup a 'on succes' action to send a PDF file to Docparser. When the document is parsed, I want docparser to send me the parsed data. This data should be updated in the record the file was uploaded to. While sending the document I also provided a remote_id to identify the record for updating the record values. At first it looked like a straightforward thing to do with the creator update
URL parameters: subform
Hi, I'd like some help passing values via URL I know i can add ?Fieldname=value to the end of the URL to pass a default value. However, is it possible to do this to a subform? I've tried ?Subform.Fieldname=value with no luck. EDIT: You can pass the value to a placeholder field in the main form, and have it copy across to the subform on load. Still would like a direct solution, though. Thanks, Levi
Method call tracing
We have a form that has a subform, and when we add rows to that subform, we want to initialize it with values from the previous row. This works perfectly for *most* of the fields in our subform. However, there are a couple of fields which appear to be getting cleared AFTER the subform "On Add Row" method is called. The problem is that I cannot for the life of me determine which method is clearing the values for these fields. I have commented out calls in other methods that clear these fields even
Math functions in Creator
Is there a more complete list of available math functions for use in script builder? The current list is pretty small, and doesn't seem to cover everything that is available: https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-number.html for instance, only sine and tangent are on this list, but cosine works as well. I was hoping for a more extensive list, the current list just isn't enough to calculate most things. As an example, once i geocode an address in my database
Please clarify maximum fields on a form, and the max data a form can contain
Please clarify the maximum #fields on a form, and the max data the form can contain. https://www.zoho.com/creator/help/general/known-issues-or-limitations.html#Limit_on_maximum_number_of_fields_in_a_form We are evaluating Zoho Creator towards an Enterprise Express license and although we don't have plans or desire for crazy-large forms, the wording of the page above seems to limit a form to 80 text fields leaving room for no other fields of any type? Plus, we'd like a clear and complete picture
Next Page