Rounding a Pivot Table Report Value to 2 Decimal Places
Hi, I'm hoping someone can help me. I'm trying to round the values in a pivot table to 2 decimal places. The pivot report is based on a view which is based on a form field called Square Foot Cost. In the scripting for this field I've included Value = Square_Foot_Cost.round(2) which seems to work well on this calculated field when displayed as a view (rounds correctly to two decimal places). However, when I created the pivot table report based on that view, it would not round to 2 decimal places.
Deluge Adding User to profile via secondary email created duplicate account. Soft reset permissions on all apps.
A second, duplicate, user account was created when the following code was used in an application. sec_Profile_Name = thisapp.permissions.profileForUser(input.Secondary_Developer_Email); if(sec_Profile_Name == "") { thisapp.permissions.assignUserInProfile(input.Secondary_Developer_Email,"TestProfile"); } The user was already setup as a developer, so it appears that the profile was returned as null string, then a duplicate user account was added to the user's domain and to the application as a non-developer
Attachment in custom function
In Zoho CRM, I have an attachment in potential data. But I can't get the attachment in a custom function. That custom function is used to push the data into Salesforce using API. Please suggest how can I get the attachment and send to Salesforce using Zoho CRM custom functions. Thanks.
Calculations from 2 forms that is looked up from main form.
Hi, I'm very new to and need help with calculations from 2 forms that is looked up from main form. 3 forms - Bookings, Price Retail, Price Supplier. Booking form has fields Booking Number, Price Retail (Lookup field) and Price Supplier (Lookup field). Both lookup fields are bidirectional with Booking form's ID as reference. Price Retail has fields Price, Discount, Fees, Total and Agent Credits. All currency fields. Total is populated with script below on user input. input.Total = input.Price - input.Discount
Autopopulate the date from a main form onto a subform
My application has a main form and a subform. Main form = deployments Subform = incidents - incidents responded to during each deployment. I have successfully linked the relationship of the two using the main form's ID. Here is my issue, if my user wants to go to the incident form to update something, he/she has no way to determine which incidents go with which deployment day (unless he/she knows the ID number, they will not). So I would like to have the date autopopulated from the deployments
Spreadsheet export cells format seems to have changed.
When I need to import new records in Creator, but I don't want to import duplicate. I export the list from Creator and then compare with my new list using the conditional formatting for duplicates. Since a couple of days, even if there is duplicates, Excel doesn't recognized them anymore. It seems like the format of the cell is different then it used to be, creating this problem.
How to calculate totals from different forms and display on dashboard
Hello team, I'm currently using the Free license to test and train myself on how to create apps using Zoho Creator. I have developed a small application to manage our fundraising activities. I have two main forms : 1) Contributions - Records all members contributions 2) Fundraising Activities - Records all our fundraising activities including a subform that records our expenses related to each fundraising. What I need to calculate : Now I need to calculate the Total Income to display on my dashboard.
Schedule invoke function, what are the arguments?
I have a simple function defined: void CheckAge(Children recAge) { if (recAge.Age >= 18.0) { recAge.Status = "Over 18"; } } Now I want to run this function in a custom schedule. I don't understand what the "value for the arguments" should be, or in other words what should be between the brackets in the schedule: thisapp.CheckAge( ?????? );
Closing iframe from page
Hi everyone, I've got an annoying issue. I've been opening a form in iframe with openURL, and adding &zc_NextUrl=#Script:dialog.close closes the iframe when I click submit/update. Now I want to open two forms, side-by-side. This (I think) means I have to open a Page that has the two forms embedded in an iframe. However, when I click Update/Submit, nothing happens. The dialog doesn't close. It redirects to "Data added successfully!" and you have to manually close the window. If I add #Script:dialog.close, #Script:page.close
Rich text field size limit?
Is there any limit to the size of a rich text field in a Zoho creator form? We have an application with one report having around 7,000 records, including three rich text fields. Two of these have 500+ records exceeding 32K in size, with a few dozen being 60K or greater. Probably 80%+ of the database is taken up with this data. Is there any limit to the size of a rich text field? We quite often have users complaining of extreme slowness, with the odd record getting lost (and not appearing in the
FILL DATA IN 1 FORM FROM ANOTHER FORM BASED ON CONDITION
Dear All, Basically we area recruting consulting firm and we have clients paying us different recruting fees, Have created a form with candidate data where ,when i select the client name,i want the recruting fees automatically populated,which is ther is another form filled against the client. Can anyone help please Rgds Vijay
Validating Variable
My form has 200 questions and the question A is the 5th question. So how can I to restrict the user to go to the 6th question until unless he/she enter the correct value in the 5th question?
If max number of student exceeded in the class
Hay, I have a Form named as add_class 1. school_name (lookup field) from Form school_master 2. program_name (single line field) 3. max_student (number field) 4. start_date (date field) 5. end_date (date field) And in my website there is Form named as Registration. Which have many different fields including school_name, program_name, start_date and end_date . what i need is when the max_student value exceeded for that particular program_name in that school_name then nobody can
Page Panel - distinct count for subform
Hello! I'm setting up a volunteer database for my organization, and I'm trying to capture how many volunteers we have in a given year. I've set up a main form for volunteer profiles, then a subform to record their hours for various events. I have a page set up where I'm putting some stats for us to look up easily, one of them being how many volunteers we have in a given year. I connect the subform to the main profile form via a "Vounteer ID" number that I created and then linked to the main form
Problem with embedded forms on mobile
When accessing ZoHo creator via mobile our form application is optimized for mobile view, but when we access embedded forms via mobile on our website it does not switch to mobile view.
Have a Decision Box open a pop up to edit related contact information
I have a create order form. On this form I have a lookup field to a form called contacts. On the contacts form I have a field for Email. On the main Create Order form I have a decision box that says Update Email. I want this decision box to then checked pop up the related forms contact info in an edit pop up window. This way the user can then adjust the email address if needed in the Contact form and keep it all nice and clean. I am having trouble getting the pop up window to open the form with the
Doubt
Hi there, <div elName='zc-component' formLinkName='Sales'params='zc_Header=true&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&zc_HdrFontClr=Blue&zc_HdrFontSize=20'>Loading Form..</div> why we using this elName='zc-component' in this line of code. I erased that line functionality doesnt change for this code. I Searched in internet I didnt get exact explanation for the usage elName='zc-component'. Help me to understand that line clearly
Possible Bug in zoho creator Timeline-report
Right-click on a record in timeline-report ,flashes 2 pop-up boxes , which appear & disappear within a second.
How can I restore a complete application along with data?
Can anyone assist me as to how to completely backup and restore an application along with its data? Presently, the only solution is to download a backup zip file and then re-import the tables manually which is very tedious as you have to remap the fields completely. This is also highly prone to error. Any response would be much appreciated. Thanks in advance Shon
Setting default value in pop-up for Lookup field with "Allow new entries" option
I have 2 tables, Sample and Test, with a bi-directional relation. In the Sample table, I have a multi-select lookup field with the "Allow new entries" option enabled. When the user clicks the Add New function, a pop-up box appears with the Test form. The form has no value in the Sample field on the Test form. I want this field to default to the sample from which the new entry was initiated so the user can't accidentally select a different sample. How do I make this work?
email reminders to specific user
Hi I have a database of procedures, where the operator is specified in a field. The operator is a zoho user. I would like to send a reminder to review the procedure to that specific operator after a set interval (say 90 days). How can I do this? thanks!
change expression of radio button with update records
I'm using a script in a subform so that when I change one field, the expression of a field in another form changes. I'm doing everything according to the instructions of ZOHO but nothing happens. The field I'm referring to is a radio button with 7 options. So the setting should change from one option to the other. Does anyone know if this is not possible? or if there's a workaround? The script I'm using is: x = Nueva_Muestra[Lote == row.Numero_Lote]; x.Ubicacionlote="Trillado"; Nueva_Muestra is
Zoho Creator Form Rich Text Field
A very weird bug, I have created forms in Zoho creator using rich text field, now when I am copy pasting from word files, some of the spaces are disappearing. Why is this happening? Refer to the screenshot below:
Deleting Subform rows Via Script
Please help this topic Thank You//
Id Names in Form
We could be able to choose an ID name for the fields we create in forms, so we can edit their CSS without problems. Maybe the ID could be the same as the "Field link name". That way we could really improve the the style and user experience in our applications.
PDF Record Template - text getting cut off
I'm having an issue with one of my PDF record templates. One rich text field that is populating the template seems to be overflowing / getting cut off on my PDFs. I've tried fiddling with the settings for about an hour, and I cannot stop the text from being cut off on the right side. I've use the HTML editor to increase the div margins, I've using the record template settings to try various settings for the padding and margins. All to the same effect - the text is constantly overflowing / cut
Zoho Creator: Hide subform add entry task won't work if you add a condition. Possible bug?
Hi guys, when trying to add a task to hide subform buttons such as "Add entry" and "Delete entry" it only works if action has no condition. If I add any condition it won't just work. Also this happens when disabling buttons in the base form. Some buttons are not being disabled on condition.
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!
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?
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.
Next Page