Display a field list from all records to aid in data entry to prevent duplicates
I have an "Add new customer" form with a Single Line text input field to get the customer name but to prevent users from accidentally adding the same customer which existed already I want to show them a list of existing customers from the same form. What's a good way of doing that. I tried a formula but that only refers to the current customer. I want a list of all customers already in the db to be displayed maybe next to the entry field. Thoughts?
Can I highlight a field to indicate out of range numeric inputs?
I want to indicate an out of range numeric input on the form to the user by (say) putting a red box or highlighting it in some way. Is this possible in Zoho creator? e.g. say the form is a quality control form and if a parameter is greater than 10 I will flag it. Note, I know about alert and cancel submit. That's not what I want. The user should only be gently nudged not that the form entry should be prohibited.
Criteria involving Lookup List of BigInt
Hi, I have a form (Class_Rooms)with one of the lookup fields being a list of Students ID (BigInt). How does set a criteria for Class_Rooms where the list contains a particular student ID. This is what i wrote for each Class_Records in Class_Rooms [List_of_Students.contains(Student.iD)] { } But I've been getting the following error. Error at line number : -1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Script to edit all form names?
I have a collection of applications, each with several form names containing the string "easy": EasyPlus EasyBall etc... I'm wondering if there is some way (using a function or otherwise), to loop through all the form names in an application and replace part of the form name; in this case, each "easy" to "busy." So upon execute, the names of the forms above would change to: BusyPlus BusyBall etc... Thanks,
Using New ZOHO CURL REST APIs in Creator
Hello, this Post will show the way i use to PUSH, GET, UPDATE and so on, Data from the Creator Deluge Script to for example the New Zoho DESK API via PHP-Script. My Deluge code example to add a Ticket in Zoho Desk: urltwo = "http://YourURL.com/phpfile.php?value=60¶m=" + TicketID + "&string="; StringRec = "{ \"secondsSpent\" : \"0\", \"executedTime\" : \"" + thisapp.GetDataFromDesk.TimeStringForTimeEntry() + "\", \"customFields\" : { \"TaskID\" :
Error in deluge behaviour: Currency type
Hi guys! It seems there was an update in Zoho deluge scripting, and now we get a error with Currency type field: If I use Currency type field as a float type in expression, it works well. If I try to send it as a float parameter to function, the function get "null" value instead. Examples: Contract.Amount is a form field of Currency type y = Contract.Amount + 1000.00; - works well, and return the amount increased by 1000, as a float variable. Now, we define function with float argument: string
Filter Aggregate Records by Month?
I'm trying to use criteria to filter records by month, e.g.: Date_Field.getMonth() == zoho.currentdate.getMonth() or Date_Field.getMonth() == zoho.currentdate.subMonth(1).getMonth() However, it doesn't seem like I can use a function on the left side of this equation. If that's the case, how is it possible more me to aggregate all the records from a certain month? Thanks!:)
We need the application environment with our own logo both in android and IOS
Hi I'm Kishore Kumar.S as developer in Sixty One Steps Advertising Private Limited, we have been using the zoho products around 7 to 8 months as of now We developing web applications through Zoho creator for our clients and we want mobile application with our logo as both in android and IOS platform is it possible if, please let us know the steps. as already we know about zoho creator portal application (it is very simple and compare to mobile application in play store this is difficult) we want
Number of rows per page
I found that I need to have more than 200 rows to work with some times in a Zoho Creator Report. Can you guys increase the 200-lines limit? Thanks.
open a record from a form
hi, as you can see in this screeen, https://photos.app.goo.gl/qDVQPK4Dpblm0rqj1 in my form "nuovo compito" (that means new task) i have a "candidato" lookup field. this field take value from another form (applicants). may i find a way to open, maybe using the url field, the relative record of "applicants"? obviously setting the url after input of "candidato" field thx
from subform entry - link to mainform
hi! there is mainform (contacts) and subform (purchases) one contact has many purchases - in one mainform's entry there are many entries inside subform after adding entry to subform - we can view such entries in subform's report how from subform entry can view to which contact they correspond? example 1) open subform entry 2) click on link inside this entry 3) opens corresponding mainform's entry
how to add entry to subform (via CSV) and associate this entry with mainform?
hi! there is mainform with subform how to add entry to subform via import (CSV) and automatically associate this entry with mainform's entry ?
Auto-increment
Hi, I would like to assign a unique Alpha numerical value to each record. The "Alpha" would be the first letter of a field in the form. The Numerical will be increment + 1 Thanks for helping me out! Brian
Lookup with multiple fields
Is it possible to create a lookup that displays more than one field of information, For example if I had a table of jobs with a lookup to select a client, could the lookup display more than one field from the client table such as client_no, name, postcode. Thanks.
What is the fastest way to delete 17,000 records?
Deleting 17,000 records in groups of 200 is not working. Is there a faster way?
About Rebranding Again
Good afternoon. My question is: Is there any way to hide alerts, marketing messages , invitations to seminars etc. on applications made with ZOHO creator . I am a freelance programmer I'm starting to work with ZOHO seriously , I upgraded my account to enterprise , and I would like to offer my work without customers know what my methodology and what my economic gains , since it could easily deduce at your price list. Is there an alternative to further consider ZOHO creator as my work tool ? I have
Powershell REST API
Hi! I'm using Powershell to do REST operations with various online services, such as Dropbox etc and it works fine. Now I'm trying Zoho Creator but with no success. Does anybody have a general Powershell script that would for listing applications and return the result in json format? Preferably I would simply replace the token-code with mine to get the concept. Any input would be appreciated. I have looked at all the examples available and tested for several hours but I've run into a dead end...
Function to create multiple tests
Can I create multiple choice tests by using Zoho Creator or any Zoho utility? If yes, what modules can I use? Can you please give me detailed instructions? Thank you very much!
Confirm before deletion in subform
I just clicked the "X" in a subform row by mistake. Is it possible to ask "Really?" before it vanishes forever?
Sum of formulas (within subform)
Hi, I have a timesheet subform, with an "Hours worked" field, an "Overtime" field and a "Total" formula field that combines the two values. In the main form, I want to include a grand total field that would be the sum of the "Total" formula for each row. I've achieved this with "Hours worked" only, but not the sum of "Hours worked" and "Overtime". input.Total_Amount = input.Total_Amount + row.Hours_Worked; That works. (in Main Form>Subform>Hours_Worked>On User Input) input.Total_Amount = input.Total_Amount
Updating a lookup field issue
Hi All, I have a subform that has a single select lookup that needs to be replaced with a multiple select lookup. Both lookups exist now in the form and access the same source "Add_Labels > Labels_Description". Before deleting the single select lookup field, I need to copy the single select data to the multi-select lookup field so I've created a temporay form and script to process make this change - and this is where I'm stuck. I appreciate that the mult-select lookup requires the record ID so I've
Update Subform with field from Parent Form
I am looking for deluge script to update multiple subform entries with the date of the parent form. The purpose of this is to allow me to run more detailed pivot reports with the subform data.
Schedule export of data
Hello - Is there a way to schedule the export of the data from a Zoho Creator application to an external server? Thanks Anil
How do you get the value of a lookup field instead of the record number
I using the value of a lookup field on a form in another formula on the same form and instead of the value being placed in the formula, the record number is placed there. The formula ---- input.Competitor + " - " + input.Media_Channel + " - " + input.Offer Competitor is a look up field on this form from another form/table. When this formula runs, I get the following result 3444267000000037515 - House File - 20% Off All Men's Wear I get the record #, not the value in the field. How do i fix this?
custom PDF name from Record Summary
Hello everyone, following this forum i tried to use a custom action in order to download pdf from a record summary with a customized name (for example the number of an invoice or something else) i've found this function and i've adapted it to my needs void scaricaPdf.scaricaPdf(Nuova_Fattura Numero_Fattura) { openUrl("https://creatorexport.zoho.com" + zoho.appuri + "record-pdf/Elenco_Fatture_Estero/" + Numero_Fattura.ID+ "/customName", "new window"); } everything was compiled correctly but when i
Invalid entries found Please correct and submit again.
Hi, Trying to add the first record to my first form...and got this "Invalid entries found Please correct and submit again." error. All mandatory fields are filled. Don't understand whats going on. Any help would be greatly appreciated. Thanks Cyrille
enter text on summary report with images
I would like to develop your classic shopping cart experience... on the right side of the screen an iframe with report of all available inventory with pictures, an input for the qty and a custom action to "add to cart" on the right of the screen an iframe with the contents of your shopping cart. But Zoho does not allow me to have the user enter a number in the qty field on the left report. How do I work around this.... any ideas?
Emailed link to record in report now broken as of last week
I have been using a scheduled script to email me a link to a report that will show one record. Example the script looks like this: linkToReport = ((((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/html/reportName/") + reportSearchTerms) + "&showHTMLOnly=false"; it creates a link that looks like this: https://creator.zoho.com/zoho_user/zoho_appname/html/reportName/&ID=1986294000004712003&showHTMLOnly=false As of last week the link now pulls up "https://www.zoho.com/creator/"
use one lookup to reduce the records in another lookup
I have created a function and form to copy a few fields from one record and paste in another record. I select the record to be copied using a button on the report which also calls a form where the record to past to can be selected. The problem is the list of records to select from when choosing where to paste is 4000 records long. This makes it difficult to find the record to paste to. I want to reduce the selection by using another field that is linked to the selection or in other words I want
Getting extra Blank page on printing customised record summary
i am getting this problem on all browsers ,so its likely to be an issue with zoho creator itself. Whenever i make a new record summary in a report, It prints with one extra page (even if the data remains on a single page, the extra page just remains blank ). i have tried to create a blank summary still it prints 2 pages. My default paper size set in the printer is A6. If however I Keep the default template for the record summary the printout is limited to just one page. I am stuck on this.
Center a form
Hi, That's maybe a silly question but is there a way to center a form (without embedding it in a Page) ? Thanks!
On a form, value of a field depends on the selection of a data in a drop down list
In a form "Session Location" I have a single line field "Location Name" and a multi line field "Location Address". Each location has a unique address. This form allows me to record an address for any specific location. In another form "Sessions" I have a drop down list to select the location name and a multi line field to display the corresponding address. When I select a location in the drop down list, I want the muli line field to display the corresponding address. How can I do it? Thank you for
Can you show/hide edit record fields based on which report calls the edit record?
Is there a way to detect which report the Edit record command came from, and use it in the Form Actions - On Edit - On Load to show/hide specific fields?
Populate Multi selection Look up field
Hi, Is it possible to populate a multi select lookup field in a form? Main form: has a date field and a Orders multi select lookup field Here is the behavior i want: 1) User selects a date. 2) On User Input, the script populates the Orders multi select lookup field based on the date selected. input.Orders.add(orderID) doesn't seem to do anything.
splitting records in report equally to no. of users
Hi, I want to assign the no. of records in a report to the number users after the equal division of the records. say, I have 500 records in a report i want to assign it to the 4 users. so I will do the division of 500/4. When the no. of records divisible by no. of users (i.e.) when remainder is 0, then the code is working for me. But when it is not divisible (i.e.) remainder > 0 then my code not working. the remainder no. of records is missing for me during assignment to the users. Please help me
Error when trying to get CRM records using deluge script
Hi, Pardon me if this is naive but I'm new to zoho. I'm trying to get all accounts from the crm records. When trying to call: zoho.crm.getRecords("Accounts"); The Object returned is: {"4813":"Inactive user"} I added another account to the app and logged in with it to try, but the same object is returned. Can someone explain why this happens? Thank you.
Currency Field
How to add a currency which is not listed out in the Currency Field (LAK for instancen which is the Lao currency)? Thank you for your help.
How to show records from Zoho Reports in a paging table/grid?
I am trying to use Zoho Creator (ZC) to allow a user to select a range of criteria and return a list of records. These records, however, are not stored in my app but in Zoho Reports (ZR). There could be a million or more rows in the ZR view. I want to show the selected records in a grid so the user can select one of them and show the record in a read-only form. I have already written the read-only form as a Page. I can already read the data using the ZR API but I'm struggling how to show the records
My Account is inactive
Hi Support team, My business account (email phuongnam@vpppn.com) returns "Account is inactive" when I try to log in to Creator. Unfortunately, the locked account also means that I cant access my previous business emails and business CRM data having a major impact on my business. Could someone please activate the account as soon as possible. Thanks a lot for your support, Loi
Change "This report is not accessible." page
Hi all, I have a public form that, on edit, will send an email notification. This all works fine. When I click submit, though, I get sent to the "This report is not accessible" page. I don't want the user to see the reports, but I also don't want them to see this page. How can I direct them to a page that just says "Data Entry Successful"? Thanks in advance! Levi
Next Page