Lookup Drop Down Field
I want to use a lookup field to relate two tables in Creator. Does the function change to a search and select if the number of rows in the related table exceed 200. Otherwise a drop down will not work. If there is a max number for a plain dropdown record count is that number a configuration somewhere.??
Set Column width in new application builder
I have switched to the New Application Builder and want to set column widths for a view. The problem is that there is no option to set the column width. If I want to, I have to temporarily switch back to the old builder or edit the Definition. Can you please include an option to set column width in the New Builder?
Bulk update: missing columns
I want to bulk upload the SITE view at https://creator.zoho.com/essistmgmt/assets/#View:SITES_View I am missing the CONNECTWISE REF column from the dropdown to update. Can you please investigate? Note, The application has shared access.
How to load a form in edit mode?
Hi I'm looking information about how to load a form in edit mode. I found this forum post https://help.zoho.com/portal/en/community/topic/load-form-in-edit-mode#2266000004613049 Sadly the resources linked there doesn't exists anymore. Can anyone explain me or redirect me to a resource where explain how to do this on the current Zoho Creator? Thanks,
Application integration
we are interested in using several of the Zoho applications if I sign up for creator can I use all the applications I need without paying separately for them? otherwise it becomes very complicated and cumbersome. I would like to use HRMS, CRM, Books, Invoice and develop (or have someone develop) an online booking system for us. Also interested in using sites.
File Size workaround - open question to the community?
Hello, So Zoho creator does a poor job with file uploads in general. That much is clear. But I have seen the community come up with pretty innovative solutions for all sorts of roadblocks that Zoho cannot or chooses not to handle. So this is an open question to everyone. I have hit a wall and really need your help. What workarounds (third party scripts, third party online solutions, zoho api integration, anything) have you used or seen or think might work to do the following: When a customer
Programmatically create a new view
Hi Guys, Is is possible to create a view programmatically and dynamically using deluge? i.e. using a conditional if statement. Rgds and Thanks Andrew
link "#Form:formTest" in a view perma
Hello all, I have a page with a link like this <a href='#Form:formDummy?zc_LoadIn=dialog'>Test link</a> This works when the url page is normal (https://creator.zoho.com/xxxx/yyyy/#View:pageDummy), but when i try to use this link in a view-perma (https://creator.zoho.com/xxxx/yyyy/view-perma/pageDummy) doesn't works. Why? Any idea?
Problems with "parent window" openUrl function
I have my Zoho application embedded in my website. Today I just noticed that many of our application's buttons aren't working. They all use the parent window parameter in order to refresh the iframe its embedded in (I have a website with my zoho application embedded in an iframe. Some zoho applications views has iframes embedded so I use 'parent window' to refresh just the main zoho application iframe). I wanted to ask if there has been any recent changes (implementation wise?) to the openUrl
Need to remove or hide Duplicate option in my view
I don't want users to be able to Duplicate a record in my view. I set permissions so that the "Duplicate" option is not checked, but it still shows up in the menu. I found something about the view parameter below, but I don't know how/where to use it: Show/Hide "Duplicate" option zc_DuplRec=<true/false Any help is appreciated!
Date Format for a View
Greetings all... Does anyone know if it is possible to format a date field in a view? I don't want to change the default format for the entire app, just for one field in a specific view. For example, currently I have a view grouped by a date field which displays 08-27-2013. But I want it to say, Tuesday, August 27, 2013. Thanks in advance, Joel
Generate permalink for not logged users via an Script
Hi I want to know what it is the algorithm for create the not logged in permalink for a form. In my application I need to notify to the users (not zoho creator users) with the link to a form with some pre-populated data. I found some guides but them only say: Go to your form and get the permalink from there. Those links doesn't change? It is reliably form me insert those links on my email template? Thanks,
Add a record and immediately get its id?
Hello, I am building a stateless form that allows the user to enter a Contact and a Payment for that contact, each of which is its own form. I create a Contact record first, then need to get the ID of the newly created record to use in the Payment record. I could always do a find using enough fields from the input that I can be confident I will always get the record I just created, e.g. name, address1, address2, email. However this seems a bit kludgy, and I'm used to working with APIs that automatically
Get data by column number
I would like to retrieve data from a table/form by column number i.e. the nth field. Does anyone know how to do this?
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
Plan for CSV Feed
Hi, We are planing to upgrade Zoho Creator to have the feature of linking the database from Zoho Creator to Zoho Reports via CSV Feed. What plan are we going to take? Is it available in Standard? Thank you. Kiel
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
arithmetic operators of properties in a form
Hi, I create a form and want to do some simple arithmetic operations of column properties like "column C" is equal to the product of "column A" and "column B". So how can I do that in the script? Thanks
Stuck on "Loading Form... Loading View..."
Any idea why it just says "Loading Form..." and "Loading View..." when I open the program? Nothing else happens except for displaying those two messages. Thank you.
Problem with compare date
I'm trying a few weeks ago to do the following without success, if anyone can help me i will appreciate your help. I have 3 forms one is for the employees, second are a list of projects and the third is where I assign an employee to a project. My problems is that when the user try to assign an Employee two time in same dates i need to send an informative messages to the user, without use cancel submit (if i use this line i can see the message but can't save the record) In this form (Assign Employee)
Uploaded resume from Creator form to Recruit
Hi, I'm running into an issue where when a candidate submits a form made in Creator, with their resume attached, the data does not get added to our candidates database in Recruit. But when the same form is submitted without the resume, the deluge task we're using works fine and the record is added. What can I do about this?
Back up frequency and limitations
Hi, I have questions regarding zoho creator back ups. Are they automatic or do they have to be done manually? If they are automatic, how often are they performed? What are the size limitations for backups? In the event that I want to restore a back up, what is the process for getting it restored?
Stuck on problem - Adjusting count when record is edited
Hello, I'm a newbie at scripting and am working on a database to accept registrations for classes. The database allows the students to sign up for a number of classes. Each class has multiple sessions and the students choose one session. The seats are limited for each session. When no seats are available the students will be prevented from registering for that session. I have successfully written code with help of examples in the marketplace and forums to track the number of seats available for a
Load form in edit mode
Hi , How to reload the form in edit mode.At the time of accessing the application ,i need to load the form in edit mode.(not in on add--on load )
Search form for stage
Good morning, I need to make a loockup in Zoho CRM Zoho Creator to seek a potential with a certain stage. Is it possible?
Create a List from a String
I am building a search form to search CRM and manipulate the returned rows. I want to be able to search the CRM on one or more Account Names. I am working on the basis the user will enter a string such as "account1, account2, account3" into a field on a form and the system will return the Account Rows where the name Contains account1, account2 or account3. My plan was to use the searchrecords function but as this only allows one search criteria I have to run round it several times to cover all the
Removing an element from a Lookup List
I have created a Sales form for a sculpture exhibition we are organizing so each item for sale has a unique identifier. Once an item has been sold I would like that item to no longer appear on the lookup list, can anyone help me out with this?
Script not adding fields, will not hold () in script.
Below is a script I am trying to use. The purpose of this script is to update an "Inventory" form's "Quantity" field. It will not give me the total of the two stated fields "currentinventory + Inventory_to_Add". When I enter the script via the GUI or free scripting method, Zoho always removes the () from the script. I am no scriptwriter by far, but isn't it supposed to keep the ()? So when i use my "Re-Stock" form, the script adds what I enter to the "Inventory" report but does not ADD them, it
SubDay Question
Greetings all... I am using the following to determine a date in a script: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(churchinfo.reminder_email_days); Where churchinfo.reminder_email_days is a collection pulled from a table where reminder_email_days is of field type numeric. When I put in specific number: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(4); It works fine, but when I use the code referencing the variable for the subDay it throws an error message.
'ADDTOPICKLIST' can be used only in on load actions - error message
Would like to be able to populate a drop down list based on value of another field. Works fine on load action, but on update get error above. if (input.Title == "Mr") { Singing_Voice:ui.add("Tenor"); Singing_Voice:ui.add("Base"); } else { Singing_Voice:ui.add("Soprano"); Singing_Voice:ui.add("Mezo-Soprano"); Singing_Voice:ui.add("Alto"); } Thanks Tim
Please take pity on me...
I have no idea what I'm doing, and I'm hoping someone will come to my rescue: I am trying to organize this data regarding participants in a program we're doing for children living in poverty. I need to collect this information grouped by "family" Participant Name Participant Age Participant Gender Participant Ethnicity There are 19 program sessions. I need to track who attended each session and then be able to pull out demographic data by session as well as by all the sessions combined so I can
report filter criteria based on secondary related view
Hi, I have created 2 forms , which are linked via a lookup. Is it possible to create a view/report that will just show records that are in the first form, that have no link in the second form ie in database terms Select d.* from details d left outer join subscriptions s on d.id=s.membership_id where s.membership_id is null Thanks
Automatic Update of Variable Names in openUrl Calls
If Deluge enables the name of a variable to be read then the openUrl Deluge statements could automatically update if Form and/or Field names changed. e.g. where DelugeName() is this mythical function openUrl("#View:" + Form_Report.DelugeName() + "?" + Field_1.DelugeName() + "=" + input.Pass_Variable1 + "&" + Field_2.DelugeName() + "=" + input.Pass_Variable2, "Same window"); Is this possible? If not could it be done? Does it make any sense or is it a daft idea?
Need same functionality as the Zoho CRM field (relationship to CRM data)
I want to duplicate the logic and functionality of a look up like the CRM look up field uses. The related Look Up field has drop down but when there are lots of records, that does not work. Have table of records that need to be related from the parent form. Only one record needs to be selected and shown on the parent form. I've tried subforms but can't get it right since the subform is only for the selection not the display in the way it is used for the CRM data relationships Can anyone point
Remove duplicates from a list?
I have a list variable with hundreds of phone numbers. There are duplicate numbers in that list though. How do I remove the duplicates from the list? Thanks.
Formula based on a join
Two tables: Tutor - holds records of tutors Associate - holds records of associates (students) One tutor to many associates. I have a form on each one. I have a report on associates which is grouped on tutor so shows each tutor with their associates. I have a report on tutors. I'd like it to include the count of associates against the tutor. The Associate form has a field which is a lookup to the Tutor "name" field. I've tried adding a formula field to the tutor form, with an expression based on
Custom user roles
Hi, Is there a way to provide more customization for user roles? I believe I need something beyond page level permissions and user/designer roles. For example, I have a group of 6 people: -I want NONE of them to have designer capabilities. So, 6 "users". -I want ALL of them to be able to see all the same forms/tables. -However, I only want TWO of them to be able to edit records in the table. (to update information as we receive it) Any help?
iPhone skips over non-text form fields
URGENT: 5 days since I posted. I am a paid subscriber. When using an iPhone to fill out a form, I hit the Next button on top of the keyboard to navigate from one field to the next. Non-text fields such as lookup and radio are skipped right over to the next text field. A dropdown field however, can be accessed with Next/Previous. How to prevent this from happening? Form access: http://amis-inc.org/students "Sign up" Thanks, Nelson
Refresh CRM lookup fields?
I have a form that has multiple CRM Product lookup fields, below those fields are Quantity fields. Anyway I got it to work that when you choose multiple products and quantities it auto calculates the total in real time. So that works, it is great. (All 10 CRM Product lookup fields on the form have this script on user input. It works fine.) crmResp = zoho.crm.getRecordById("Products", input.Sample1_ID); input.Sample1Cost = ((crmResp.get("Cost (L)")).toDecimal() * input.Qty1); input.CostTotal = (input.Shipping_Cost
Next Page