ZC_Subject & ZC_Content but is there a way to capture FROM or TO or CC?
Hi there, I am using a form with the ZC_Subject & ZC_Content to capture the subject and body of the email. is there a way to capture any other parts of the email? Like TO or FROM, or better yet a unique header id? Thanks, David
Variable Not Defined
I copied the code exactly as it was stated in your help link: https://www.zoho.com/creator/help/script/fetch-records.html#Fetch_Related I updated it for the forms and fields in my application and I'm getting a Variable not defined error. What am I doing wrong if (Wanderist_Details[ID == input.Name].count() > 0) { x = Wanderist_Details [ID == input.Name]; //input. refers to fields in current form input.Wanderist_Number = x.Wanderist_Number; input.Passport_Issued_by_US = x.Passport_Issued_by_US;
Auto apply a formula to a table
Is it possible to bulk edit a table using a formula? The following formula is currently in the form actions on user input: if (input.devices_room != null) { roomid = Locations[ID = input.devices_room].locations_room_ref; input.device_ash_code = roomid + "/"; } I want to amend the bulk edit existing records and then delete the bulk edit formula rather than go in and edit each record
Retrieving screen width
Hi Zoho, I need to retrieve the user's screen width for my html page. jQuery solution did not work (not supported?) how can I get it? any Zoho internal script? Thanks Ravid
Problem with the function for each
I have this code and I need you "for each i in input.R" run Only with Certain records, but when i keep the record is saved as "R" is not input. Then when i select That box Belonging to a subform, I changed all the fields INSTEAD OF only of the subform Those That are inside. (Including the data That Already Been HAD registered Earlier) I have the same code and another field and in this if the input is saved. I do not get it. if (input.Clientes1 != null) { if (input.Correo_Electronico != null)
Zohologinuserid
I have a form "Employee" that contains their email and name. I have another form Test with the employees name field as lookup. (incase it does not fill in log on). I am trying to get that field (Test/Employee_Name) to auto populate when the user logs in. I am thinging I am going at it incorrectly, meaning Fetching email record from "Employee/CO_Email" and comparing it to the logonuserid. Then trying to input the logonuser name in the employee field of the test form; I wish I could also code it to
Record summary templates
It would be nice if we had the ability to save a record summary template and reuse it across the platform. Of course the fields will change in each form, but the general design and layout can save lots of time. Currently within one form you can copy templates, but what I'm suggesting is universal template design that can be used for any form. Maybe there is a possibility of doing this in Zoho to which I'm not aware?
Adding an edit button to a record summary
As the title suggests, I would like to add an 'edit' button to a record summary that would immediately put me in the edit page for that record, without having to close the record summary and find the record via the list view. Can this be done?
developing a timesheet application
I looking at creating a timesheet application for my business, i need to be able to record hours each day and then get the timesheet to add up the hours and days for the week. Then against days when people are sick or on training i want to record a code against that day, i also then want to print the timesheet out for signature by the client i need the timesheet to calculate the hours and days, for example hours less than 4 equal 1/2 a day and then over 4 equal 1 day Any helps would be greatly received
Mobile App IOS
Any trick to limit individual field width in a report when viewed on an Ipad,
Not Receiving Emails From Zoho (Invites, Password Resets etc.)
Hi We are not able to receive any Zoho originated emails to our ourdomain.com mailboxes. We have contacted our mail providers and they are not receiving any connection attempts from transmail.net hosts. Could you please trace the outgoing emails and check if there are any bounce-backs (Non Delivery Reports) coming back to Zoho. We are sending from accounts@ourdomain.com and have sent a few tests in the form of user invites and password resets. The emails were destined for tba@ourdomain.com and tba2@ourdomain.com.
Dynamic picklist works incorrectly for Multi-Select Field
The following is deluge script returns a list that is set as the picklist for field, My_Field_A: Dynamic_Choice_List = ( My_Lookup_Form [ My_Lookup_Field_1 == "ABC" ].My_Lookup_Field_2).getall() ; My_Field_A:ui.add ( Dynamic_Choice_List ) ; If My_Field_A is a Multi Select field then the value selected from the picklist is added to My_Field_A's Choices list in the Form Builder. This is WRONG. If My_Field_A is a Drop Down field then no value is added to the My_Field_A's Choices list in the Form Builder.
Pre-populating data to a form
I am building a data collection application and I have two forms, populate_data and abstraction. I have imported data to the populate_data form and have a unique column of data called form_number. On my abstraction form, I would like to create a lookup field on the form_number column of data in the populate_data form so that certain data fields in the same row as the form_number I select in the lookup field from the populate_data file will populate to respective fields on my abstraction form. I
Disabling a column in BulkEdit
I want to disable only 1 column from the list of BulkEdit. Perhaps it's a very simple to do but I don't find how! Is it possible to do? If yes, How can I do it?
Auto populate
I want to concatenate two fields into a third with a separator of "-" Field 1 - wiring_from_device (Look up field) Field 2 - wiring_to_device (Look up field) Field 3 - wiring_label (Single Line) Seems easy but struggling.
Extremely long latency time
Hi Zoho, When I open a new page in Zoho its takes VERY long time to load (about 30 seconds!). This won't happen when I open the same link as a popup. Why is that? How can this be fixed? This also affects the time is takes the system to save changes in script. Thanks Ravid
Record Summary not displaying linked filtered view
I have a form "Strategies" with a bi-directional lookup to "Programs". In the 'Column Properties' of the 'Strategies' report, I include the linked field to 'Programs' and selected the view 'Programs-Active', which is a filtered view (Active = 'Yes') since I only want to see the currently active Programs for each strategy: The filtered view on its own works fine. However when I look at a Strategies record summary (default or my custom summary), I see all the Programs that were ever selected, not
Transfer all fields from sub-form into parent form
Hello, I created a form with inputfields which I embedded as subform but I'm not happy with the current layout. I want to just "drag and drop" all the inputfields from the sub-form directly into the parent-form without recreating every singe field there. Is there a way to do so? Thank you in advance.
URL for universal search?
In a Deluge script, I'd like to fire off a search (using the master search at the top of the page) and pass it specific criteria. My hope was to add a custom action, to be shown in the menu for all rows on the report, so that selecting it will fire off the search and then let Zoho display the results as if someone had typed them at the top and hit enter. I know about the openURL() function. I just don't know what URL to pass it, and how to pass in the search criteria. Thanks! Bruce
Import data to form and subform
Hi Zoho, I have a form with multiple subforms. I need to be able to import data to the form including the subforms data. I've added a bi-directional lookup to the ID fields, so I can add the subform's fields to the main form report -but: 1. When exporting the main form report, and trying to import data based on the template - I get an error, the subfrom fields are not recognized by the Zoho system and in the drop-down list of the field options the subforms' fields are not showing. 2. When viewing
Update all records and keep them updated
Hi, I have a schedule that is triggered when two fields are equal. One is user´s day of birth and the other one is the current date. so I did this: DOBB = DOB.toString("dd-MM"); Current_Date = zoho.currentdate.toString("dd-MM"); But, the Current_Date do not update automaticaly, I have to edit each user data in order to update it and that is no practical option. How can I update all the users data and keep them updated? Any help will be appreciated
Add calculated number of hours to date
I'm not very much into Deluge yet, so I am having a little bit of trouble of with below, where the ultimate goal is to add a calculated number of hours to a date specified in the form. My first five lines works fine, but the last do not return a value. (I.e. 16-05-2016 12:00 + 72:00 hrs = 19-05-2016 12:00) input.Ops_Time1 = ((input.Reporting_Time - input.Operations_Commenced) / (1000 * 60 * 60)).round(1); input.Moves_Performed = (input.Units_Discharged + input.Units_Loaded); input.Moves_Remaining
Help with custum schedule
Hi, I want to create a custom schedule, but, I don´t know how to write in Deluge what I need the schedule to do. I need to send a daily mail to all users in a report. The mail should have de names of all the users that are having their birthdays on this day. Does anybody know how can I do this? any help or hint will be appreciated
Report based on multiple criteria
Hi, I have no idea what I am doing wrong here, as I copied coding that I had from another (similar) page, and it worked there, but not here. My form has two fields - one that is a dropdown to choose Purchaser/Assistant, and one that is a number field to enter a Product SKU. I am trying to pull all records to be shown on a report, based on what is chosen. if((input.Purchaser_Assistant != "") && (input.Product_SKU != null)) { openUrl((“https://creator.zohopublic.com/zoho_jchan5/requests-for-purchasing/view-perma/Transfer_Requests_for_Purchasing_team/CZwJ0VjVyUvUHYyaKuwEgOUCX36DmEJFnqydeKV4KS8bOnaxPpSXnGwK91eQ1jKHakX4UA3bUZQ7KFWvCdNVYqa4yTr40eeVr5Ov?Purchaser_Assistant=input.Purchaser_Assistant&Product_SKU=input.Product_SKU
Image rendering in the forms
I am creating a clinic management system. In the patient forms, I need to show several images in the forms with patients old facial pictures (before treatment) and a new facial picture (after treatment). so while filling the form the user can see the image rather than image to be viewed in a view?? is there anyway, i can achieve that??? Any help will be appriciated
File Upload Shorten Field Name
After a user submits a form that includes a file upload, is there a way to use script to turn the original file link to show as something like "Download File" in the corresponding view? For example. I would like the following to be a link that says only "Download File", instead of the original file name of the uploaded file. Thanks
Add a check mark to symbols
Dear Zoho creator< Can you add a check mark symbols to symbols, I really need it for my project check list but have no check marks to check. So can you please add a check mark, I prefer feedback today or tomorrow. Thank you,David kenneth goicuria
Is there a place to discuss Beta features of Zoho Creator?
Hello, Is there a place to discuss the beta features of Zoho Creator? Thanks.
Creator App Custom Domain SSL
Hi there, I'm just wondering how we can use our own custom domain to access a creator app whilst avoiding SSL certificate errors? Can we use our own certificate? The example below shows the custom domain used to access the app gets a certificate error.
why is the parameter "pageSize" available in Report but not available in rest api view record ？
why is the parameter of pageSize available in report but not available in rest api view record ？ Here is example: 1. the parameter "pageSize=4"below is not available. the json return contain all records. https://creator.zoho.com.cn/api/json/productv3/view/ProductLook?authtoken=****&zc_ownername=<appownername>&scope=creatorapi&raw=true&pageSize=4 2. the parameter "pageSize=4" below is available. the view will only show 4 records. https://creator.zoho.com.cn/<appownername>/productv3/#View:ProductLook?pageSize=4
Error popup on new interfance......
Hi Zoho, The interface' new look is great, but the error popup is a little problematic: please fix this :) Thanks! Ravid
Zoho Creator pages Not working in mobile
Hi I would like to know whether we need to have seperate coding for pages to work in Mobile and Desktop at the same time. Because the pages which worked in Desktop is not working in my mobile. Please Clarify
Wrong Date Language in Reports
Hi Zoho community, I created several apps and all of them have their language set to spanish. When I fill up the forms and I choose the date, the date is in spanish, but, in the reports the date format is in english. This is a problem because I have to generate different kinds of documents with the date on them and some of them are formal documents, and that doesn,t look good in a spanish speaking country : ( How can I fix this? is it possible ? any help or advice will be very appreciated
Update record by other form
I tried to find the article but I cant see it anywhere. My case is like this for example: Form A [Product] which will have name of product and its cost. From B [Order] which will lookup the product name from form A and fetch the cost of that product from form A too. For adding record in form B, everything is fine. Now when I update the cost from form A [Product], how can it automatically update in form B [Order] too? I will have for example 10 records in form A [Product] and just some of them need
500 Error Page After PayPal Payment redirect
Hello, I am having issues with my form after a payment is made. I opened a ticket with Zoho Support more than 10 days ago about this issue, but I still have not received a solution or fix for this. I am hoping someone else might have some insight on what is going on. Please help because I keep getting an error page when payment is made using any Zoho form and my clients need their application to go LIVE in a few days. Here is a description of the problem: When I test the form from the application
Lookup field in mass import
When I import data into a form, for a lookup field, why can't I use the ID of the related form's rows? It does not seem to work with the ID; I have to use a value from another field in the related form. Isn't the database design relational?
System down?
I can't get to my apps
How to select the fields available for BulkEdit?
I'm made a Custom action with the purpose to replace the BulkEdit for this column. Now I want to hide this column from the list of BulkEdit fields. How can I do IT? TIA
Lookup field performance is very slow when parent table has thousands of rows
We have a parent form with 39,000 rows. Our child form references the parent form via a lookup field. We need to display context info from parent so we use a dropdown and display "Parent.Name - Parent.Age - Parent.City". We never want to change the parent of a child. We set the parent when creating the child by passing ?Parent_ID=xxxxxxx at the end of the URL when opening the child form to create a new child. The child form takes 30+ seconds to load and is getting worse since all of the 39,000
Picklist created by "add item to..." is empty on edit mode!
Hi Zoho, In my form I have a subform, with a picklist populated from a field in the main form. I have tow problems on edit mode: 1. every item chosen from a picklist when submitting the original form is shown under it, like an "other" choice (which I did not marked as feasible in the main form) 2. the picklists on row 2 and onwards are empty. (All the picklists were empty, I've managed to solve row1 picklist by re-populating the picklist at Subform.PicklistField on the "On Edit -> On Load", but this
Next Page