Conditionally Required Field
I'm trying to conditionally require two fields to be filled (ie, not EMPTY) BEFORE a specific lead status is used: on validate { if ((input.Lead_Status == "3. Qualified Lead") && ((input.Forecasted_Monthly_Revenue == "") || (input.Forecasted_Hourly_Rate == ""))) { alert "enter BOTH Forecasted Hourly Rate an Forecasted Monthly Revenue"; cancel submit; } } This code sample is as close of a mirror as what I found in the documentation here: https://www.zoho.com/creator/help/script/app-builder-deluge-scripting.html#fieldmandatoryFetch last record based for reporting
Can this be done? Please advise...Thank you! payment table: customer, billing code and payment information I need to fetch the last payment made into "Payment_Details" by customer AND each billing code for reporting so basically for each customer I need to get last payment made in each billing code I have many iterations of the code below and it's not working properly. IDList = List(); IDList.clear(); for each R in Payment_Details [Customer_ID ==input.Customer_ID] { PRecConcatenate issue
i am using Zoho Creator to mark the attendance for my staff: Form: Attendance_Form - has the Field:Employee_Name (its is a lookup field from Form: Employee_List Field: Staff_Name) i want that when i select the name of staff from Field: Employee_Name, it should Concatenate the name of the employee with the Field: Date_Field (with is also in the Form: Attendance_Form) Example: if i am marking the attendance of "09-11-2018" (DDMMYYYY) for Staff "Mark Rogers" then the output of the concatenate functionUpdate a field in second form from Look Up
Hello I have 2 forms that have a relationship through a lookup. I am trying to update a status field to complete when that record has been looked up. The lookup field is looking up an auto number from the first form. Can someone guide me on this Thanks AmandaAdd note/ description to CRM contact via Zoho Creator
Hi, I want to add a new note to a Zoho CRM Contact via Zoho Creator. I have tried different versions of the following code on "on success": crmResp = zoho.crm.updateRecord("Contacts", input.Zoho_CRM_1, { "Description" : input.Info_02 }); But it doesnt work. Could anyone give me an advice on what the problem is? Thx Bo ThygesenCurrency Field Formatting
Howdy - Seems simple. I added a Currency Field to the Form. However, when in runtime, the Form isn't formatting the field as currency ($#,###.##). It's instead (#####.###). How can I get a Currency Field to format itself on the screen as Currency? Thanks for your help - RImages in JSON REST API
Hello, I developed a contact-like form using Zoho creator and I access the content through a view using an authtoken and JSON. I have an image field in my form and this field is set to appear in the view I use. However the data that I get does not make any sens in the context of JSON because I get an HTML IMG tag. Furthermore, the url of the image in that tag is relative. So to actually get the url of the image I would have to parse the HTML then contextualize the url, but this won't work becauseWordpress plugin for creator is not working
Hi all, I can't get Wordpress plug in to work. I see it in the menu after installation, which means to me it was installed. When I click it, it will start but never finish loading. Anyone can give some pointers? Thanks.Export as Excel; Can I do it all at once for all reports in my App
My App has some 10 to 12 reports. So far I take app backups on a daily automatic schedule but to get the report data in excel format once a week I manually go to each table and export the data as xls or csv. But is there a way to get (say) all 10 to 12 excel or csv files at one shot? Rather than go to each report which is time consuming? Alternatively, the.ds file that is produced, does this have all the excels or something within it?link in html page in dialog
Hello, I have a HTML view open in dialog mode (zc_LoadIn=dialog). Inside the html code I have links to other views (<a href="#View:XXX">link name</a>) When I click in a link, the site is loaded but the popup windows (html view in dialog) not disappear. How can I do it? <a target="_top" href=.... <a target="_self" href=.... etc... not working. Navigator: Mozilla 3.6 ThanksDate Time Format
Hi I have to create a calendar entry as follows: Departure Date and Time Arrival Date and time I would like the date and time to be displayed as Date: Hour; Min and no seconds Can I have both these vaues displayed side by side ( horizontally) rather than one after the other verticallyHow to Move a Record from One Form to Another Using Condition
Hello, I've seen one or two similar questions regarding moving data from one form to another, however it did not involve the same scenario and testing out the code (customising to my own variables) on their solutions, did not work. So I just created a new database, I'm new to Creator since it's to replace an old database. I currently have one form/report named "Live" (since they're live jobs being dealt with), and another named "Archive" - used for what jobs have been completed... but keeping a logHow to create a record in a Creator form from a CRM function with Integrator and Subform fields? Using zoho.creator.createRecord()
I want from a custom function in CRM, create a record in a Creator form, sending data from the CRM. The problem seems simple, but I can not fill in all the fields that the form has. I can create the record, and fill in basic fields like text or date, but an integrated field with CRM, no. Neither do the fields within a subform. This is my "Visitas" form. ("formLinkName") mp = Map(); Visitas_del_dia = List(); visita = Map(); visita.put("Oportunidad","68916000001564945"); visita.put("Hora_Visita","12:30");Add Button
I've noticed in one of the example applications there's a facility to add a button to a form, but I can't see this function in my version of Creator - see below: Any ideas? MartynAll Emails going to spam folder
All my emails are going to spam folder, irrespective of the formatting. This is a very serious issue and is affecting our business. I would request the Zoho team to come up with a solution quick or I will have to move to some other provider.Setting filter to only show items matched to another field
Hello i want to set a filter to only show items that match another field on my form. But when I look at the filter it does not give me the option to say equal to a field it wants me to put in a value. Has anyone else come accross this Thank you Amandaerror
Hi, I'm seeing this while trying to access my data. IDoes anyone know how to create recurring events in Zoho Creator?
We use both Zoho CRM and Zoho Clendar and they both facilitate the creation of recurring events. As an example I can create an event which starts at 10:00 AM and finishes at 11:00 AM. It will start on a specific date and end after a certain amount of recurrences or you can use an end date. You can then choose the frequency. In our case it is weekly, usually on two specific days of the week. We would like to be able to do this in creator and then report information on each event. We cannot find thePDF Manual inserted in Page
Hi, On the Zoho Volunteers App you have a Help Page that shows the PDF instruction manual. I have tried to replicate this in my app but am having issues. I've uploaded a PDF into my app (created a form/report to do this) just one single static file that i want to show on a page. I've right clicked the file to get the url. When i click on the Page header it downloads the pdf instead of showing it on the screen. The url looks like this. https://blahblahblah/HelpPDF_Report/3389823000000154384/File_upload/download?filepath=/1536723812345_USER_INSTRUCTIONS.pdfRemove seconds from date/time field
I would like a date/time field to either not have the seconds show, or at least have the seconds set to "00". is this possible?Remove ss from Date/Time field
I am unclear on what the formula needs to be to remove the seconds :ss from a Date/Time field. This solution is unclear https://support.zoho.com/portal/zohocorp/ShowEntityInfo.do?module=Solutions&id=677280f03da271dd1f1cd9c6123cc8de&from=listView&showpage=DetailsView&&prevModule=Solutions&TO_INDEX=10&FROM_INDEX=1¤tOption=50&selectedDept=71d0ea6e5216eb98d3e3b1cbce495042&cvid=null&recordNum=3&ct=1358056144062&isload=true Can someone provide the correct formula expression please?Is it possible export project data to Excel?
I want export projects data to excel tocreate custom reportsNo Attachment on Service Desk email request
Is there a character limit for a service request received from an email? We have one vendor that sends an email with a pdf attachment but when we view the request in the service desk, there is no attachment.Creator: Report Criteria for Select Users
Hi, Is it possible to set criteria so that the logged in user can only see records in the report that have been assigned to them? Note that they are not the addeduser as they did not create the record. I've tried: Assigned_Case_Mgr == zoho.loginuser But since not working, assume this is because the two names may be appearing differently, ie the zoho.loginuser = joebloggs and the Assigned Case Manager = Joe Bloggs. Any suggestions?add lookup values dynamically
I currently have this code to add lookup values to lookup fields on my form dynamically. It works well, the only problem being that it resets the value of the field to null. I don't want it to erase what values might already be there. I currently have this: Locs = Locations[ID != null].ID.getAll(); Trip_From:ui.add(Locs); anyone have any ideas? i tried this workaround: Locs = Locations[ID != null].ID.getAll(); myvalue = Trip_From.iD; Trip_From:ui.add(Locs); Trip_From = myvalue; It works, but changingphone number field
how do i format a field to accept only a phone number in that format like (000)000-0000 ??? thx, sarah sjohnsonAdding Multilist options to a drop down list
Hello, I have a form called Job Data which contains and ID and a Operations in the form of a Multi select List. And then there is another form Planning which also has an ID and a Operation but in the form of a drop down. First the Job Data is Filled and Submitted. When the ID is put is in the Planning form, I want the Multiselect List in the Job Data form appear as a drop down in the Planning form. Can this be done ?View and sign an added file
Hi what i want to achieve is to upload a PDF through the file upload allow the user to view the file and digitally sign and then saving it to the form to submit it. If anyone knows how to view the uploaded file that would be very helpful Thank you AmandaZoho Creator integration with zoho sign
Hi I would like to integrate zoho sign with zoho creator. Ultimately what I need is a signed PDF If anyone can help me with this i would be very grateful Kind Regards AmandaGet calendar date
When i click on my calendar report, i would like the form to open, with the date field autofilled to the date i clicked on the calendar. Is this possible?Need Subform Field to Populate Based on Parent Form Field
I have a form with a subform. This is done to create a one to many relationship. The main form is Vendor and the subform is Vendor Account Number. On another form I enter the subform Vendor Account Number and want the Vendor Name field on that form to be filtered for the Vendor Name from the Vendor form based on the Vendor Account Number selected. The only way I've determined this can be accomplished is to include the Vendor Name in an additional field within the Vendor subform alongside the Vendorfetch and modify data in another application
hi i found already a 4 yr. old answer to this topic - so if nothing changed with Creator 5 i will use this approach. - create a function that provides the data in App A - call this function in App B and fetch the data same with modification of data or is there a more elegant approach in Creator 5? eg. something more "query-like" thank you kind regards LambertI want to run a comparison across attributes that can be selected by a user during profile creation
I have an application having two forms, one seller form with a list of attribute and the other a buyer form with a list of attributes. I want to create a compare function such that once the buyer uploads a form with any matching attributes to that of the seller, a notification (email and SMS) goes to the sellerCan I add data in a field automatically when a dropdown option is selected?
The dropdown is a lookup field that takes the information from another form, the form has the product name and price, I want that when selecting a product I get the price in another fieldCompare Field data of 2 different application form fields
I have 2 applications. 1. daily records (contains form name as ORDERS) 2. monthly records (contains form name as ORDERS) Both forms contains email field, such as 1. daily records(app)->orders(form)->Email(filed) 2. monthly records(app)->orders(form)->Email(filed) now i want to compare those two emails, e.g. if(form1 email == form2 email){ cancel submit; } No any idea, how can i achieve this?Save Script button missing in Free-Flowing Script
Save Script button is not available in Free-Flowing Script. Even the shortcut Ctrl+S is not working. Please see attached screenshot.Scheduled backup
Hi I miss a feature in your backup procedure. I need a way to schedule my backups. It is okay if the old version is overwritten by the new one. I would like the automatic backup to start every day at 17.00 CET. BR SkouboeError at on submit script
Im having this error on my application even i do not have any problem on my script. please see images below:Lookup
i have 1 dropdown and 2 textbox. i want to lookup ColumnB and ColumnC in a 2 single line textbox after i selected the ColumnA. example: if i select Jake in a dropdown list, the Department column must automatically lookup "Admin" and the Position column must lookup "IT" is that possible for zoho creator?Values from dropdown menu multiplying with numbers
I need some help. In a form I have made a Lookup. This Lookup refers to a VAT dropdown menu. I can choose different VAT rates (6.0, 8.0, 10.0 etc.). Now I want to multiply the chosen VAT rate with a Value field. I do this with the Formula button. The outcome however is a very long number -> 358930000000120350.00 What am I doing wrong? Kind regards, ArthurNext Page
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from aroundUsers Add-on at $1/user for Enterprise Edition
Up until now, subscribers of Enterprise Edition had to contact our sales team to add more users to their account at $3.5/user. We have now slashed the price and made it a much more simpler process. Using our newly introduced User Add-on , Enterprise Edition users can now purchase more users at $1/user directly. To add more users, go to your Subscription tab . If you are in Enterprise Edition, click on "Manage" under that edition and if you are in other editions, click on "Upgrade" correspondingFile download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certainEnabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. CharlesMerge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
Top Contributors
Karunakaran G
【CSL】三井 翔
ishwariya.gurunathan
Valeria
pandapotan.s