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
Subform Row with Previous Rows Data
Hi, I have been getting good results by searching the forums but I couldn't find a solution for this one. We will typically add rows and only change one or two of the subform fields from the previous row. is there a way to copy the last rows date to the new row as we add them? Regards,
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
Use zoho creator page to fill PDF.
Hi team I have created a HTML page in zoho creator. I want to fill that page and on submit that page it will generate the pdf file which containing this information. How can I generate the pdf file with this information or please tell me alternative for this.
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
How can the data in the multi-selection (Lookup) field be sorted uppon the original sequence I selected?
Hi, In a form I create a lookup field with multi-selection from another form. It works. But when I picked up my choices and saved and reopened it, the sequence of my choices is changed and by random. I contaced support, he says it's order by the ID(created sequence) of the form which is referred. But I checked and it's not true. Any idea about this? Random order is really a mess to user.
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
Auto Fill Field In Custom Module Based on Lookup Field
I have built a Custom Module called Products Leased that is related to Accounts. It also contains a lookup field to Products Module. I am wanting to store all of the Products each account leases from us. When I lookup a Product I also want to bring over the Unit Price of the product into the new Module Products Leased. Is there a way to auto-fill a field based on the lookup value?
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
Importing flat file with 160 columns into Zoho Creator
I have a flat file with 160 columns and about 200,000 rows.... what is the best way to upload this file to Zoho Creator? It has a 70-columns limit for mass uploads... is there a way to get around this? Thanks.
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
Subform not updating when changing selection in lookup field
Hi I can select my lookup field selection:'quoted service' from one app, which is looking at all records in another app, that match this client and are accepted. The problem is if there is more than 1 accepted quoted service. I can see it in the lookup field selection:'quoted service', but no matter which selection i choose , it is only retrieving the data from one of the accepted quotes to populate my subform data. Any ideas?
My function to insert records based on record in another table is inserting a record ID instead of a field value
Hi, I need to populate a table with new records based on another table. I have written this function to do this: void createOrder() { insert into New_Order_Header [ Added_User=zoho.loginuser Supplier_ID=Suppliers[Supplier_ID = 3].ID Supplier=Suppliers[Supplier_ID = 3].Supplier_Name Order_Entry_Date=zoho.currentdate ] When I view the result in the New_Order_Header table I see the correct value for Supplier_ID (which is a lookup field in that table), but instead of Supplier_Name I see a rather large
Upcoming updates - Mar 2019 - part 1
Hello App Creators, Continuing with our recent post on Feb-2019's updates, we're here with a few more updates for you. In the coming days of March, 2019, the Zoho Creator team will be rolling out the following feature updates: Zia-powered smart data import
Auto-refresh of related elements in pages
Ability to drill down data points in pivot charts
Application of field-level permissions when viewing related data
Domain restriction
In addition to our changelog, we'll leave a comment below as each
Upcoming updates - Mar-2019 - part 2
Hello App Creators, We're almost done rolling out updates mentioned in the Mar-2019 - part 1 post. Here's "part 2" - the remaining items that we'll be rolling out by or before the end of March, 2019. Email authentication using SPF and DKIM Deprecating "Switch to old version" for new sign-ups In addition to our changelog, we'll leave a comment below as these items are rolled out. - - - - - - - Email authentication using SPF and DKIM Availability: Accounts that have registered using their own domain's
Multiple connected subforms in one form or a suggested workaround
I have several objects that are 1-many related objects in a kind of vertical hierarchy so for example Courses have several Units and Units have several Objectives and Objectives have several Criterias etc. I would like to make it easy for the user to add this structure in one form since a lot of the information is common so no need to repeat the whole hierarchy again every time they want to add a Criteria for example. I created a Add Course form which allows adding Units (as a subform): I was also
Thousands separator ","
The thounsands separator "," is not being recognized by Zoho Creator when in mass uploads. Also the Zoho Books accounting application does not recognize the separator either. This is not very convenient to say the least. Thanks guys
Number of Business days between two date values - minus public holidays :-)
hi i know there is a possible way to calculate business days (mo-fr) between two date values... but has anyone tried to deduct also public holidays ..... best would be to use a public available service somewhere. second best solution would be to import a table with the holidays to a creator record..... thank you Lambert
Need a way to build public application on creator
Hi There, We need to be able to publish app without login, basically publicly accessible. No sign in or registration required.
zoho.crm.getRecords("Users");
I want to get records of CRM but this not response when try to get information of Users table, this issue is provoke for permissions or not is possible to access at this information for security reasons or why? varUsersList = zoho.crm.getRecords("Users"); This return "null" when try to access at this information in applications in Zoho Creator. Thanks for your time to help to explain why not access this data.
Limit searchable fields in published report
Hi, I've created a database with 1000s of records and published a report (un-editable by agents) that only shows 6 fields (of 26). I want agents to be able to search ONLY within those 6 fields. The report only shows 6 fields. I've created a print template to only show those 6 fields. The problem arises when the agent clicks the search button. It shows all 26 fields. How can I limit the search options to only those 6 fields? Thanks!
images in Notes Field
I am having Form A which contain 5 note field to display 5 different images. That displays Correctly. I am having another one note field that is 6th note field which should display the all the 5 images in a table format fetch from previous 5 notes field. How can be it is Possible?
Not able to get Query Parameter to work to show related tasks to a project
I have an app that have Projects and Tasks. I created a page that shows related project information that you get to by a function that goes to the page with the RecID as projectRecId. I created a panel that shows the number of tasks and for the action, I want it to go to a report for Tasks that are related to the project. In the Add Task form, there is a Project lookup field and it pulls the Project Name. I created a Query Parameter for the pane action as Project=${projectRecId}. It pulls up all
Next Page