Updating mass records
I need to update 4,000 records with one try. Do I need to use Deluge scripting to do this? To learn Deluge systematically what is the best resources/training courses/ Thanks!!!!
Automatic email for a form
I have configured Zoho Creator in a form, so that whenever a record is updated an email is sent. I can see that the emails are successfully sent when the records in a form are individually updated. But when I mass-update/bulk-update the records, the emails are not sent. Is there a way to fix this?
New fields automatically added to report?
If I change the design of a form, can the new fields added to the form be automatically added to the relevant reports/views as well? Thanks.
Creator: show records that have one (non-unique) field repeated
Hi - is there a way to output a View, that we can then do bulk edits on, which shows only records that are repeating multiple pieces of data? For example, if I have a recipe database and I want to see all records where any ingredient is used in more than one recipe. so this is not filtering for one ingredient, but rather to see all records where any ingredient is used multiple times.
Please document best practices for URL links in applications
Related: https://help.zoho.com/portal/en/community/topic/find-and-find-replace Zoho Creator support should document best practices for using relative url links for better application portability. Forms Views Pages This seems outdated: https://www.zoho.com/creator/help/url-pattern/zoho-creator-url-patterns.html Cheers, John Whitney
Syntax Errors?
I can't seem to see the errors in this one. Here are my goals: If ${Accounts.Prelim Financed Amount} <= 20000, then 395 If ${Accounts.Prelim Financed Amount} <= 50000, then 595 If ${Accounts.Prelim Financed Amount} <= 100000, then 795 If ${Accounts.Prelim Financed Amount} > 100000, then 995 This is the nested forumla I have, but it keeps coming up with syntax errors... IF((${Accounts.Prelim Financed Amount}<=20000),’395’,(IF((${Accounts.Prelim Financed Amount}<=50000),’595’,(IF((${Accounts.Prelim
Repeated (Add New or Add Another) Fields
Is there any way to create a repeated field(s) or form(s)? For example, lets say that there is Text Field is entitled "ChildsName" and a date variable entitled "ChildsBday". Is there a way to have a button that simply lets the end user repeat "ChildsName" and "ChildsBday" to store the names and birthdays of multiple children? I specifically do not want to have to create ChildsName1, ChildsName2, ChildsName3, ChildsBday1, ChildsBday2, ChildsBday3 and so forth while using Hide/Show functionality.
openUrl vs record-edit
I use my ZC app in a Google App window (i.e. thin border, no back forward button etc.) When I use: openUrl("#Form:... , "Popup window"); to open a form and populate it with data ready for any additional editing then when I use 'Popup window', the form opens in a true popup in the original app window and when I click Submit, the popup closes leaving the original window as was. When I use: openUrl("https://creator.zoho.com/.../record-edit/.../", "Popup window"); to open a form for editing
Issue Uploading Logo
I'm sure a ton of you will pass this post right up, but that is alright by me. I've been winging it through trial and error and answering most of my own questions. The embarrassing thing is that I cannot seem to upload my logo. The diminsions are exactly 90 wide X 55 long, and the file type is a .png. When I go to upload, the upload status bar just keeps going and going. Am I missing something?
Fetch data from another app
I have two apps, Warehouse Database and Pricelist Master Database. In Warehouse Database I have a form called Orders and in Pricelist Master Database I have a form called ContactForm. I have created a Lookup in Orders called input.Company which fetches the Customer name from ContactForm. What I want to do is then using this link fetch the remaining data such as address / customer no. etc and populate fields in Orders. I know how to do this in the same app between two forms, I use something like:
how do i change where the email notifications of a new request go?
the admin who created our request form left the company and i want to change where the email notifications go, as of now they still go to his email address. ps im a programming noob. joe
CSV Imports & Relations
We need to import data stored in CSV into Zoho Creator, and have built into Zoho Creator multi-form relationships. How do we get that to work? For example, we have a form for adding Employees, and a form for adding Companies. The Employee form has you select a Company from a drop down that links to Companies. Then, we have a CSV file of Employees, with a "Company" column that lists the company as a string. How do we import that CSV file into the Employees database in Zoho Creator to where it will
printing help please
Ok Hi, I have the following conditions PDF file on external site that I want to print Page view for staff Name Tel No File to print (which is the pdf file) I use a script to populate the "file to print" field Looks like this https://drive.google.com/a/signedfast.co.uk/#folders/0B8WoWXP12Cw0TTR3ZHUyejZQcmM/" + input.Job_Code + ".pdf" When the page is viewed the link is underlined and clickable but is does not print the PDF file. What am I missing please. Thanks NIgel
URL field help
Why does this script not populate a URL field please Thanks input.Print_File = "https://drive.google.com/a/signedfast.co.uk/#folders/0B8WoWXP12Cw0TTR3ZHUyejZQcmM/" + input.Scan_Code; Print_File being the URL field
Adding notes to a form!
Is there a way to add to a entry i have already saved, without updating the original form i made for example if Mr smith bought 100 apples on Monday and i have logged that. Then on Wednesday he says they are bad, i need to be able to go to his entry and add a note saying this.
Export to Excel template
Can anyone tell me if / how I can export a report into a pre formatted excel spreadsheet? I want to be able to manipulate the report using VBA and macros....anybody help?
Help required field (mandatory)
HI I have a required field that is hidden. But when I send the form I got an error because the hidden field must be filled. How can i do? Thanks
Barcode Integration
Hi, I saw on the forum that Zoho Creator does not support barcode integration. If I had an excel file with barcode information and imported it into Zoho, is there a way to access a barcode number from a form (to be an ID for a product that I have information to fill in in the form)? I'd appreciate any direction on how to get barcode information into Zoho creator. Thanks!
OpenUrl vs insert into
As far as I can see, there are 2 ways to create a new record: 1) Use openUrl... and pass all the field values as "&fieldname=" + fieldvalue... The disadvantage is the string nature of the field names which don't get updated if a name is changed in the form. 2) Use insert into... and set all the field values and then open the form for editing using the openUrl 'record-edit' format. The advantage is that all field names will be updated if changed but I guess because the form name is a string, the form
scheduling email for record with certain criteria
So if I had a bunch of records with say 3 fields Email address Message to send send email y or n so say there are 100 records I want to send the "message to send" to the "email address" once every 3 hours if the send email field says "y" Could someone explain the logic please
Variable not declared. How I fixed it.
I need to know the number of items in a picklist. So I put a counter in a loop of the picklist like this: count1 = count + 1; Zoho didn't like it. Gave the error: "variable not declared" So I tried putting this before the loop: count1 = 0; Lo and behold, that solved the error.
Adding data to a multi-select lookup field
I have a multi-select lookup field (Email_To) which contains the ID for a table of Persons. I am trying to set the value of this field to the ID of a person record. What am I doing wrong? for each sales_enquiry_record in Sales_Enquiries [(Created < "01-Jan-2006") && (Email_To is null)] { sales_enquiry_record.Email_To.add(sales_enquiry_record.Person); }
Read Text Field and get the sum of any currency values?
Hi, Is there a way to analyze a text field and then use a function to get the Sum of any currency values contained in the text field? Thank you very much.
Passing a multiple select field to a function
I am struggling with to get a list of record IDs (in this case from a multiple select field) to a function without the following message: Wrong DataType specified. The Template Variable Person_ID_List should be of type LIST. This is the function: void Functions.Send_Document(list:int Person_ID_List) { for each person_record_id in input.Person_ID_List { .......... and I'm calling it from here: email_list = List:Int(); for each person_record_id in sales_quote_record.Email_To { email_list.add(person_record_id);
404 message for every forum topic
Why do I get 404 message for every Creator forum topic I click?
Automatic Field Name Updates
Cleverly, ZC propagates changes to field names to all functions, forms, pages and apart from headings, reports. Unfortunately, because of the nature of the openUrl statement, field names passed as parameters in the URL are entered as quoted strings and are therefore, not updated automatically. Has anyone come up with clever way of making openUrl statements update automatically as well?
Zoho Creator to Zoho Projects integration
Has anyone done a Zoho Creator to Zoho Projects integration? function / integration Task is NOT available in Zoho Creator. Thanks in advance for any tips you may have.
Function not working for On Delete/On Success to update a running total
I have the following function set up to calculate a running total of donations in a ‘donations’ form. float totals.DonationTotal() { total = 0.0; for each d in donations { total = (total + d.donation_us * d.exchange_rate + d.donation_mxn); } return total; } The following function is invoked on the On Add/Action on Success and On Edit/On Success in the ‘donations’ form: for each c in campaigns [campaign_name == input.campaign_name] { c.total_collected = thisapp.totals.DonationTotal();
Change a bi-directional 'Dropdown' lookup field to 'Multiple Select'
I have an existing lookup field that relates Sales Invoices and Shipments. When I created the bi-directional relationship, it was a 'Dropdown' field. I would now like to enable multiple Sales Invoices to be tied to a single shipment. Can I change the lookup field to 'Multiple Select' in the Shipments Form i.e. to allow more than 1 Sales Invoice per Shipment (I don't need more than 1 Shipment per Sales Invoice)?
Problems with migration tool
It should be noted that some days I can not update zoho through the migration tool. The system gives me error like "username or password is incorrect." Username and password are the same ones used to access zoho and turn out to be right. This is the script used: zohocreator.exe c:\scripts\Magazzini\Articoli_famiglia.xls <Username> <password> -e giacenze -au Articoli_famiglie Codice Codice that has until now worked!!! How can I fix the problem? Best regards
Removing the currency symbol in a formula result
HI, I am calculating ROI which means I am constructing a ratio between currency values and time. My results are showing as $5.10 months. Any simple suggestions for removing the "$", other than redoing it all as decimal? Thanks, PM
Custom Image / Icon and Header Text for HTML Views Without Having to Custom Code the Entire HTML View
I worked out a way to add custom icons/images in the header of your custom app/html view. So when you create a webtab in the CRM your custom app looks just as professional as the standard zoho apps I.e. Potentials, Contacts etc Here is how to do it. Create a HTML View and embed the associated Form View. Add 2 div tags before the div tag with the main zc-component, and you have your own custom header. Note you have to set zc_Header param (shown in example below) to false so there are not 2 lots
Field validation in ZOHO Creator
I would like to add a number field to my form which shall only accept three digit numbers between 10 and 350. Any idea how to do that?
How to grab the display information from an lookup filed
Hi, I was wondering how to grab the display information from a lookup field. Kind regards, Ray
Application wont duplicate
Hi My application will not duplicate Can you help? App is https://creator.zoho.com/mrcomputer/mrcomputer# and I have enabled access for you Thanks
Export pivotchart report into .JPEG - trunckated image
Hi, I'm trying to export a chart into JPEG. The export work fine but the final result is a picture with the last few inches of the right side truncated. something like that : Any idea on how ti fix it? Riccardo
How to set up help button in a form dropdown
Hi, In a form a line which has drop down ( can I have a Help button around it - which displays pdf diagram which helps choose the choice for the drop down). Please help I am a newbie to zoho. Thanks, Geeta
Duplicating an embedded view in a page
Hi I had an existing search form embeded in a page. I wanted to add another search form on the same page. I simply duplicated the first embedded form (so that I could then modify the search parameters) but when I inserted this duplicate into the html, the duplicate form would not appear. However if I changed the view link name of the duplicated form, then it would appear. This was the html: <tr><td><div elName='zc-component' viewLinkName='Search_Form'></div></td></tr> if I copied this row then
Help with a formula please
I need some help with the following code please.... visitDates = Signing[(Run_Number is not null)].distinct(Run_Number); for each dt in visitDates { code = ""; for each r in Signing [(((Run_Number == dt && Post_Code != "") && (Post_Code is not null)) && Job_Status != "Completed")] sort by Time_of_Visit { code = code + ":to:" + r.Post_Code; } for each r in Signing [(Run_Number == dt && Job_Status != "Completed")] sort by Time_of_Visit { //r.Map_Location
Unable to open attachment files in Google Doc Viewers
Even though I imagine this is not your top priority. I'm looking for a way to attach documents in the system PDF or DOCS and be able to view them in the browser. The problem is that Google Viewer does not work with Zoho attachment links. I've tried to translate a working link here: http://docs.google.com/viewer and copy paste the address to the browser address bar, google is stuck with translating DownloadFile.do script. Any chance you have a work around to not download attachment, but work more
Next Page