Fetching data from a related form
I related two fields from related forms with the lookup option,so I get the code for the second form to display the rehab value from the first form but it doesn`t works.Here is the code if(Property_Analysis1[ID_Operation == input.Property_analysis_I].count() > 0) { x = Property_Analysis1[ID_Operation == input.Property_analysis_I]; input.Rehab1 = x.Rehab; input.Property_address1 = x.Property_Address; } Here's the program when it executes the code If someone could help me I'll really appreciate it
Add up values of one field of two forms base on the value of another field
Hi I have two forms: Form A: Add_product, contains fields of product name, Product description, EC code and sales Form B: Sales_report, contains fields of EC_code and sales I want to send the value of sales from Form B to Form A and keep adding up when there is new record, when EC code of two forms are the same. And here is the code i wrote: fet=Add_Product[EC_Code == input.EC_Code]; fet.Sales = fet.Sales + input.Sales; I try to execute the code when the Sales_report is successfully submitted. However
Make app run on a specific time zone no matter where the user is
Hi, I'm based in Ecuador and a client which has access to some forms is from Spain. There is a form with a date field that doesn't allow to select a previous day from the current date, and this is a problem given the 7 hour difference between us. Sometimes he needs to add something fox example at 3AM Spain time on May 25, but it should have Ecuador's date which is still May 24. He can't pick the date because it will give him a validation error as his computer is already on May 25. Is there a way
Is it possible it iterate against multiple collections at once?
I would like to know if you can do something like this.. for each r in <collection1>, <collection2>, <collection3> It would seem this is not possible as I cannot find any reference to it. Any help? Thanks!
Create 1:N application from import
I am trying very basic 1:N (Member:Transactions) Import. Primary Key is Member ID. XLS spreadsheet has a Members sheet and a Transactions sheet. I created the relationship during the "Create Application with import" wizard. But no relationship gets created. All data got imported, but no relationship between the two. I followed instructions exactly. Help.
Import Phone Number
I'm importing data from a CSV. One column is a phone number and it's mapped to a Zoho phone number field. The import fails with the error on all rows with phone numbers: Row 3 Col 10 - The field value '262-1986' needs to start with the + symbol How do you resolve this? There is no way to add a + symbol in a spreadsheet cell, as it gets dropped. Thanks!
How to deselect an item in a Checkbox/MultiSelect field using a separate stateless form?
Hi guys, Is possible to deselect an item in an another form Checkbox/MultiSelect field using a separate stateless form? I have 2 forms: Form_1 is a stateless form with 2 fields (record_ID, Name) and a Submit button. Form_2 is an database form with 2 fields (record_ID, Multi_Select_names). For all new records in this form the multi select have this options selected by default : Tom, Steve, John, Marc. In form 1 I want to be able to enter into the field ”Name” that is single line type the text ”Steve”
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?
Deluge script after record duplicate action
Hi, I am searching how to add deluge script after a record duplicate action into a report form. I want to duplicate a record and just after that, change some fields values.
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.
Color Background
hi , i didnt find an option to change the font size or the background color of the form . IS there any way i can change my background color of my form because my website background is blackground and when i add this , its full transparent . mraviprakash06
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?
Zoho Creator price - subscription
Hi all, currently i am testing Zoho Creator, i think i have now an old price plan Unlimited users express for 199,00€ - 250000 records - GB? / i cannot find the price information on the Zoho website Is this plan also availible in the future? I hope so. As i see, Zoho Creator have also a new user price plan. Currently i have for future 6 inhouse users here and want to integrate some clients & vendors. For now I do not figured out the different, between Client portal and maybe to offer Clients a
User Licence vs Customer Portal User vs Mobile App User
This is a pre-sales question so sorry if I have posted to the wrong forum. If I create a rebranded mobile app for IOS or Android with Zoho Creator, I am confused as to the number of users who can download the app and use it from an app store. For example, if I have a 10 user Zoho Creator Ultimate subscription which comes with 1000 customer portal users, how many users can download and run my rebranded app from the Apple Store? Is it 10? A 1000? Or some other restriction? Thanks in advance.
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
Stuck on deluge script for if one dropdown field in a subform is a certain value and a numeric field is above a certain amount.
Hello, I have been trying to figure out how to get the correct code to make a suggested retail price based on some user input in a sub form. I have the sub form with product rate and product category. The product rate is a lookup field and is called up by row.Product_Rate.rate The product category is a drop down field that has the values bulk, pre packed, individual, group, etc.. and is called up by row.Product_Category_Ref I have another field in the subform called Suggested Retail Price. What
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
Recurring events showing as expired
Hi, when someone sends me a callendar invite from Outlook to a recurring event (e.g. weekly calls) that started in the past, but still has occurencies in the future (e.g calls started on Jan 02 and last until Dec 20 2019), Zoho nevertheless shows te invite as expired and I cannot put it in my calendar. Can you please look into it? Many thanks David
Google Address Autocomplete on a form
How could I use the Google Address Autocomplete API for a standard Form? I guess I can trigger a function by writing an On User Input script for a plain text field. But I'm not sure how to execute Java from a script. This would be a cool feature if I can make it work.
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 = ""; }
Conditional formula in a formula field
I had the following very simple formula in a formula field: 12 / input.Interval_months (where input.Interval_months is a decimal) This works absolutely fine. However, I want to make this a conditional formula, so I amended it to the following: if(Charging_Method == "NO FORMAL AGREEMENT", 0, 12 / input.Interval_months) Very strangely, this formula now only works if the result is a whole number. If 'Interval_months' is 6, the formula correctly shows the value '2'. However, if the 'Interval_months'
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!
Next Page