date matching
Hi I am creating a form to insert trauma records, in the date fields i need to insert a control for each date, to be mandatory later (also of a minute) of the prev date. (classical exemples are the booking date, check out date is showed as after the check in) How can i do this? in attachment a pic of the form. KR Claudio
Return Type Error in Custom Function - Return Map
Hi I have created a custom function to get order details with customer data. Please find code map GetCanCustomerHistory(string Custtype, string custname) { custdetails = Customers[Customer_Type.Type == Custtype && Name == custname]; custnumber = custdetails.Customer_Code; orderdetails = Map(); candelivered = 0; cancollected = 0; total = 0; amtcollected = 0; candifference = 0; amtdifference = 0; for each b in Can_Orders[Name.Customer_Code == custnumber] { candelivered = (candelivered + b.Qty); cancollected
Fucntionality based url to open a calendar report focused on date
Is there a way to pass a date in the url to open a calendar report and have it open with the focus set on that day? Or at least open showing the month of the date passed?
Quickbooks Integration - Create Record in Invoice Module - Response Error
Hi, I am attempting to implement the creation of a Quickbooks Invoice by using the Creator method as per the below help information: https://www.zoho.com/creator/help/script/quickbooks-add-record.html and the referenced Intuit developer information for the Invoice module as per below: https://developer.intuit.com/docs/api/accounting/Invoice However when I run the below code I am receiving an error from Quickbooks that appears to indicate that there is a formatting error in the request - any assistance
Notification
I would like to know if you have facebook equal user notification. badge
Filter iframe report in a page with a custom function
hi guys, i've got 2 reports in a page, Report A and Report B. Report has a custom function button named "View". what i want to achieve is that whevener user click the "view" button on report A, automatically Report B will be filtered by the criteria on Report A on the same page. i made both of the reports published. below is the custom function code: void CustomAction.viewallreport(WORK_ORDER_FORM recID) { openUrl("https://creator.zohopublic.com/howard200/icon-production-version-2/report-embed/Services_Report1/zFAFOx8SpJ0Mg6f393TJayHNOn2YF00CABYUqZGh5puBSRPxvsWFBQ2wJsZrNMDCGA8y8OxxDAA1N8a9UO7zCYVOkFy2xA7jnFhD?Work_Order_No=1047","iframe","test");
Tally the total of certain records then change the status of those related records based on the total?
Ok I might be pushing my luck but I am going to describe the feature I am working on and see if anybody has ideas on if its possible. I have a form called credit memo. This form has a look up field to the Vendors form. The Credit Memo form has a subform that allows the user to choose products that are being returned for a credit memo. There is a field in the main form that totals the subform and gives a total credit memo. I also have a form called Quotes. This form also has a lookup field to the
Problem with template attachments in mail notifications via custom action.
Hi, Im experiencing issues with pdf attachments on our emails since yesterday. For some reason the record summary pdf seems to loss its format or render incorrectly. I had implemented email notifications via a custom button in my report as in the following: https://zoholic.blogspot.com/2016/01/zoho-email-notification-with-record.html which has worked like a charm for more than 2 years, until 2 days ago. I attach some pics to clarify the problem: Incorrect PDF...the templates are sent rendered wrong.
getRelatedRecords doesn't work
Sales_Orders_List = zoho.crm.getRelatedRecords("Sales_Orders","Deals",ID.tolong()); {"code":"INVALID_DATA","details":{},"message":"the relation name given seems to be invalid","status":"error"} why?
removing onload error
tempCaseCustomerInfoFormID = Case_Customer_Info_Form[ID != 0].ID sort by Added_Time desc; //this ID belongs to the row that data lies // take the relevant.data tempID = Case_Customer_Info_Form[ID == tempCaseCustomerInfoFormID]; input.Case_ID = tempID.Case_ID; The code above allows me to bring a Case_ID of another form into this form, on load. I have got a error message saying "invalid value found for the variable Case_ID, Line 5. How can i remove this error?
Software as a Service
Hi, I would like to develop an App (property management) that will work as SaaS with the following terms: 1. As a customer you can create a user with limited functionality (you can manage one property - Freemium version) 2. If you want to create more properties in your business, you can do it with a monthly payment per property 3. You can have 5 users per business (for example 1 admin and 4 users) What is the type of licensing (zoho creator suscription) that I need to have an optimal cost? Thank
How to collaborate through chat or groups ?
Hello, I would like to chat through Creator apps & forms. Is that possible ? I can't find. Thank you,
Update contact ID in custom field while creating a contact
Hello, I am trying to update a custom field in Contacts Module itself when a new contact is created. What I want is that whenever a new contact is created, its contact ID should be copied to that Custom Field. respMap = zoho.crm.getRecordById("Contacts",input.CID); // get the record paramap = Map(); // create map to update CID paramap.put("C_ID",CID); createResp = zoho.crm.updateRecord("Contacts",pId,paramap); info createResp; Thank you for your help
Creator adress field
I experience strange behavior with the address field When you search an address and choose it, it inputs the street number in 1st field, street in 2nd and City & District in the related field. Here in Germany it is common to have first the street and then the streetnumber. Also the City is in general enough, so it would be good to have City in a seperate field and the District in another. In a Report the streetnumber is now first and then comes the street. So, I just wanted to avoid the address field
Can I put a better filter on Reports?
Hello, I'm trying to create reports for our stats, and I can't figure out how to fine tune the filters in the pivot tables. Right now the filters that I'm adding are an all or nothing sort of thing. I want to be able to use the and/or options (like in other filters on Zoho Creator)... but for the pivot tables it seems I can only do the "and" filters. For example, I am doing a quarterly report and I want to basicly filter for: status = active OR status = discharged AND discharge date = Jan 1 -
Problem with & character in ZML button
I have a simple 'for' loop in the ZML Editor like the below for each rec in Test_Form[ID!=0] { temp = rec.Media; %> <pr height='fill' width='fill'> <pc width='100%' padding='10px'> <pr height='auto' width='auto'> <pc> <button text='<%=temp%>' size='3' color='#000000' bgColor='#F0ECE6' type='flat' action='OpenReport' parameters='' target='new-window' componentLinkName='' cornerRadius='60px' /> </pc> </pr> </pc>
Which plan required for App Store submission?
I am a single developer interested in using ZOHO Creator for developing applications that will be available via the Apple App Store. I want to ensure that the Premium plan has the ability to do this. In the complete feature list, the "Ultimate" plan is the only plan that has: Download and publish rebranded mobile apps. Does this mean that single developers like me cannot publish our apps to the Apple App Store unless we pay the yearly fee for 10 users ($4200) on the ultimate plan?
Fetch Records
Hello, i'm 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 same
Error when I want use a WebServices with metod PostURL [URGENT]
Hello Zoho community! I have a problem with Zoho Creator when I want use my Webservices.... I'm use a WebService with method PostURL in Zoho Creator but when call this WebServices in my Application show me this Error: The code that I have in my Load page is: I try with other URL but show me the same Error, I need Help please! I can't finish a project for this!
Push Update from Parent to Subform (Child)
Hi, I have a field in a parent form called date sampled and numeric field in the subform. The fields work perfectly and generate a future date based on the date + number value, however, if the value in the parent form is changed it does not filter down to the subform, unless, I click a field in the subform. Then it re-calculates the field(s). Any suggestions on how I can get it to push the changes down to the subform? Many thanks TOG
iframe adding blank lines to bottom
For illustration puposes I created a web page with these workds, one on each line every good boy does fine When I insert the iframe between "boy" and "does", about 8 extra blank lines are added on the bottom. https://themezz.com/zoho/ shows the issue. (I want to use the frame code on a wordpress self-hosted web site and I do not want the added blabk spaces at the end) Any ideas?
Count days between two dates - How to automatically refresh the day count?
I want to count the days between the current date and a date field. I have tried the following formula which works: days360(zoho.currentdate,input.Last_Swipe) However, the day count remains the same on future days until I manually change the date in the Last_Swipe date field. How do I automate the above formula so that I do not have to manually update the Last_Swipe date field to make the day count update? Thanks in advance for your help. Regards, David.
How do you get one form to populate another form?
I am very new to Zoho and deluge, but I have worked quite a bit with Access. I cannot seem to figure out how to do something that was very easy for me to do in Access. I am trying to create a Campus Leave log for students in a dormitory. I have a form that lists the names all the residents and another form for them to fill out when they leave. That part works well. I also have a View that shows all the students who are currently checked out. The problem is I want the student to be able to select
Clearing a Date Field
Hi I am trying to clear a date field if the value is anytime in future. I have written the below code, which gives me error. Please suggest any alternatives. if(Date_of_Birth >= zoho.currentdate) { alert "Date of Birth cannot be Future Date"; input.Date_of_Birth = ""; }
Entering defautl values on a subform.
Hi! I'm trying to add as default values for a new row at a subform the values of the preceding row. Is that possible? Thanks!
Set Created by or Owner
The application I have developed seems to always put created by and owner (in the crm record) as myself, no matter which of my account users are submitting the form. I have pasted my code below that submits to CRM, and have set the settings to have created by as the person submitted but it still defaults to myself. Any ideas? //create the CRM vs Creator fields map to push data to the CRM module. myFieldMap = Map(); //add values to the map. CRM fields first and then Creator fields ( without the
Safari issues - embedded form won't load
Hi there I have forms embedded within iFrames. When we have users updating forms within these iFrames, they can successfully load the form while using Chrome, but not while using Safari. It won't load and just spins and spins. The form won't load. Searching the forums, it seems this has been issue from time to time in the past. Thanks Aaron
Nueva versión zoho creator
Hi all, I have seen some videos from YouTube and I notice that my version does not correspond to the one used in the videos. It seems earlier. Do you know how I can access that version? Or should you wait even for the new version? Thank you jose marquez
Format the Report List View Header
Is there a way to format the background color and text color for the Headers in the Report - List View? The conditional formatting only works for the fields - we would like to format the header tabs - see below.
For Each Loop - Multiple Criteria Problems
Hi, I am struggling to complete a for each loop with multiple criteria. I'm pretty sure I'm getting confused or going about it the wrong way. I have a contact form with email communication options. You have the choice of the following: Receive reports = Yes or No. Site Options = All or Selected. (if Selected, a box below with multiple sites to select from and All is void.) Age Options = All or Selected. (if Selected, a box below with multiple ages to select from and all is void.) Below is my criteria:
Is it possible to add/embed a Creator form into Zoho Desk?
Hi, I´m working with a client who wants to access and fill a form from their Zoho Creator app using Zoho Desk. Is there a way to do this? Thanks
Add a record based on a subform answer
Hi all, Wonder if you can help. I'm trying to add a record into a form based on a subform answer in a separate form I've trying a workflow with the below if(Asset_Register.Asset_Name == "Access Equipment") { input.Asset_Register = insert into Testing_PPM [ Development_Name=input.Development_Name Maintenance_or_Plan_Requirement=39703000000167523 (ID Number) Testing_Category1="Quarterly" Added_User=zoho.loginuser ]; } But it doesn't add the record into the form. Any ideas? Thanks!
how can i create a QR CODE o BAR CODE
Como puedo crear un codig QR en una aplicacion.
Mobile Sdk API's
Hi Support team, We have been really finding it though in getting the right API's to have our native app built on Zoho creator. Mobile SDK is the alternative? please suggest
Adding role via Deluge in Creator
Hi Support, I have been looking for many months to think of a solution to solve the current problem that we have. We have a production application with 1000 or more users and we can't give everybody developer access because if we do so, anybody can make changes to the forms or workflow etc, so we only want a few people to do system users administration. In order to do so, we created a custom form which allows them to add users. So in sequence this is what happens : 1. System admin add users and
Hide the Minutes for Formula Date Output Field
We are using a formula to input a future date filed and then show that in a Report List View - the issue that the date input is including the time - how do we remove/hide the time (see below). I assume we would need to add the remove/hide function to the formula or a deluge script.
Searching for partners to share costs of ZC Ultimate Plan
hey people! i'm an enthusiast of ZohoCreator, and I'm looking for partners to share costs of ZC Ultimate Plan how it could work? >> ZC Ultimate Plan is the highest ´plan of ZC, with access to REBRANDED Mobile Apps - YES, you create your app in ZC and publish in google/app store with YOUR logo >> this plan costs 35 US$/user/month, but we only can buy this plan to a minimum of 10 users (users != clients, ok?) >> if we become partners, you pay only as much users you need, and have SEPARATED access to
Formula / Deluge Script Help
We are coming from another database program and need help with Creator Scripting. On our form we have several YES/NO questions. If all questions are answered YES then the applicant is considered APPROVED. Therefore we would have a field populated as APPROVED or NOT APPROVED based on how the YES/NO questions are answered. We would also create a % APPROVED NUMBER field so if the APPLICANT only has 4 of 8 questions answered YES then they would be 50% APPROVED. (1) I assume we need to use a FORMULA field
Custom Schedules
I cannot seem to add or edit any custom schedules anymore? You can start creating, but cannot actually enter or edit any code! Have tried various browsers and the problem still persists. Any help greatly appreciated.
Calendar Navigation
We have an issue using the Calendar Report. If someone navigates to a different week/month/day from the what the current date is, and then edits an item on the calendar, after Submitting the updated record, the calendar returns to the "Current" view - NOT the view the user was at prior to the edit. Is there anyway to ensure that the user will be returned to the view they were at, and not have the view reset? Is there a way to know what view the user was in, and then use the openUrl task to go back
Next Page