Is there any autofilter for singleline field in zoho creator?
Hello, Is there any autofilter for singleline field in zoho creator? Thanks, siva
Creating Authority account in zoho creator?
Is that possible? for example.. accounting can view only this data. warehouse can only view this data personnel can only this data? is that possible?
Spreadsheet View cannot copy/paste Dropdown or Lookup field values?
It seems that the nice copy/paste feature of the Spreadsheet view (in this case copying from another record in the same sheet view) is not able to copy/paste values in Dropdown and Lookup fields? I've tried in 2 different apps, both in Chrome and Firefox. Dropdown fields (choices are defined in the form) and Lookup fields (choices from another form) don't copy/paste. Is this a bug or instead a not-yet-supported feature? Are there other field types that do not copy/paste? thanks...
Form email notification with form data
Hi! I use "Insert Field" to insert form data to the notification email, most field shows correct data when I receive email, but some custom field from other form that I use "lookup" to insert shows something like this on my email: 1929807000000018033 I don't understand what's wrong, anyone can help ?
error link
For about one hour on all my applications it does not work display view ( or pages ) passing parameters via links . Example result with blank page : https://creator.zoho.com/name/application/#View:Test?Code=1 Working example : https://creator.zoho.com/name/application/view-perma/Test/Code=1 We use the latest version of Internet Explorer to date one month ago. We It is urgent , hundreds of people can not work well . David
when i edit the record from formreport it should update the record in zoho crm?
help
Deleting dates that have passed
Hi there, I am trying to work out how to automatically delete calendar dates that are over a week old within zoho creator. Any ideas? many thanks!
Generate PDF in Zoho Creator
Hi Team I have created a Page in zoho creator using HTML. When I submit that page then a pdf will be generated and a email is send to user with attached pdf file. How it is possible in zoho creator?
Question regarding users and free subscription
Hi all, I am just getting started testing and using Zoho Creator, and have a question. I have a very simple database that I wish to share with my organization - it is simply a database of our members. I wish to have a second person be able to add/modify/delete members; I have added their e-mail address to the Application, and they can see it listed, but cannot modify it or view it. They are getting a message saying that they do not have access to that Application, although I have added them to that
Create & Update Records from Zoho Creator Form to Zoho CRM
Hi, I have a Form in Creator which have lead fields, when i create a New lead from Creator ,it should be created automatically in Zoho CRM. Need Same Functionality for Update also, Please help me how i can do it. Thanks, Neha
when i edit the record from formreport it should update the record in zoho crm?
the code i return till now record = zoho.crm.create( ("Accounts") , { ("Account Name") : input.Account_Name, "Phone" : input.Phone1, "Emplyees" : input.Employee } , 2 ) ; its updating only in formcreator but not in crm account
zoho creator for SMS reminders?
Hello, I was wondering if zoho creator can be built to send SMS reminders to recipients. I am aware that creator provides auto email reminders however not every trady uses a computer. Any info on this would be helpful. Thanks
Export Master and Sub Forms data to one spreadsheet
Is it possible??
unable to edit when i click on insert html from pages?
when i click on insert html from my page unable to edit or do something.after clicking nothing is working.
Bug creating a list
Here's my code userID = users_form[Email == zoho.loginuserid]; Location=userID.Location; proj_list = (project_form[Location.contains(userID.Location) ].Project).getall(); The obtuse error says Error at line number : -1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression project_form is a database of project names each one having a multi-select of locations I'm basically trying to make a filtered list of all projects ("proj_list") with the commonality
I have Copied my Application and it is showing Copy of Application
How i can remove Copy of from the Application Name. Thanks, Naveen
Record summary horizontal label adjustment
Hi, I need to know how I can adjust the horizontal position of the label-object for a field. I looked through the options of "Format Label" but couldn't find anything besides the left-middle-right alignment options. I thought it might be possible using the "edit as html"-option but after trying several commands I gave that up. Can somebody help me? Thanks, Hans
I need help ?
i want to create search interface? till now i have done this created stateless form containing username and search button here is code(in registration form i have username, firstname,lastname,email,address) if (Registration_Form[Username == input.Username].count() > 0) { x = Registration_Form [Username == input.Username]; } else if (Registration_Form[Username != input.Username].count() > 0) { alert("Invalid username"); } if i enter username and click on search it should
auto filters should respect "set criteria"
Suppose there's a dropdown field "Group 1 Reviewer". This field is linked to another form which contains names of all possible reviewers, as well as the group they belong to (a text field "Group"). The "Group 1 Reviewer" field has a criterion "Group == '1'", since I only want the dropdown to show names of reviewers who belong to Group 1. Now when I add this "Group 1 Reviewer" field to the auto filter in a View, when I try to filter while accessing the View, I can see all possible reviewers, not just
Is it posible to run script auto updating a field when one of the fields used to find it is its self being calculated with script?
Hi I know this may sound link a big ask but I would like to use this in a couple of places. I would like to calculate a total from rows in a sub form the problem is that the field in the sub form is pulled from the CRM rather than being user entered. I also would link to us this total in a formula field (i.e that this fired and subtract another calculated value to get a figure for the profit. Any thought would be greatly appreciated. Cheers Dan
Lookup Dropdown default value
How can i set Lookup Dropdown default value?, I have a Cliente Lookup Dropdown. I capture the client ID and with it i get the contact ID, based on that I want to set the Contact Lookup Dropdown to this value. With the code i get the value and i have in the Dropdown the select option and the value, I want to have the value, not the select
Zoho Creator auto email
I know there is an ability to send an email when people click submit on a form. But how can I send an email that contains the data that was filled out in the form. Also, is there a way to trigger emails based on a specific field that was filled out. For example if in the dropdown "Color" someone selects "Blue" I want it to go to person A and if someone selects "Red" I want the email to go to person B. Sorry if this doesn't make sense but I've been working on this for a month and cannot figure it
un/share deluge task too restrictive
I was really disappointed at how limited/restricted the deluge share task is. What should have been a simple 1 line loop has turned into a 100 line routine due to the fact that this task requires a hard coded name that is validated for its existence at design time precluding the simple use of tables rather than : for each rec in permissions[] { share (rec.item,user.email); } we are instead forced to unwind it for each and every possible sharable item : if(item=="xxx_tab1")
Create Formula for Pickup Value
Hi, I need assistance to set up a formula to match values between 3 drop down list. I have 1 drop down named it as ITEMS with 2 listing. HDD and RAM. The 2nd drop down named it as Size with 2 listing..4 GB and 8 GB. The 3rd drop down names it as Cap with 2 listing..100 GB and 500 GB. Who do i write the expression to show that when i choose HDD it should only shown Cap with 2 listing? Highly appreciate your assistance.
Sorry we are unable to regenerate this report
Hi, I am unable to regenerate data in my report. When I select regenerate I see the message 'Sorry we are unable to regenerate this report' Please advise Thanks, Kris Tyte
zoho creator export
How can i export report from zoho creator with PDF format but keep the headline for each page?
Help with html code
Hi Before I start, please excuse my lack of knowledge regarding the correct language/terminology to use in this request for help! Our IT Manager (with the assistance of a very helpful developer she found through this forum) devised a report in Zoho Creator using html - it pulls together lots of information from different forms within the Zoho database she created, in to a lovely looking health and welfare plan for each child at our school. There is a consistent field (child's name) within each of
On Edit > Validate... script does not work with "bulk edit"
On Edit > Validate... totaal_beschikbaar = 0; if (input.Beschikbaar == "Ja") { totaal_beschikbaar = (totaal_beschikbaar + 1); } if (input.Beschikbaar1 == "Ja") { totaal_beschikbaar = (totaal_beschikbaar + 1); ...... input.Spelers_Beschikbaar = totaal_beschikbaar; danny.bontinck
PIVOT CHART SHOWING DELETED RECORD DATA AND CAHNGED CURRENCY
Issue01: Pivot chart showing deleted records. Even after deleting the records chart still showing deleted records but I don't see them in corresponding view. Not sure from where its getting. Issue02: In one of the form I changed Currency from Dollors($) to Rupees(Rs) but in the chart it still showing Dollars but at the same I see Correct values(Rs) in corresponding view. not sure why
Integration with Zoho CRM not working
I have been trying to follow the examples in the help documents to the letter in setting up integration between a very simple Creator form and Zoho CRM, but I can't get either of the examples to work. Using the script builder, I created the following: crmResp = zoho.crm.create("Leads",{ "Company" : input.Company, "First Name" : input.Name, "Email" : input.Email },2); This is the action "on success" and it executes without any errors, but I do not get any updates in Zoho CRM. Also, I have tried the
Code Problem
Hi I am a beginner with creator and I am following the tutorial - Add Business Logic - https://www.zoho.com/creator/help/tutorials/add-business-logic.html In one exercise we are asked to enter this code. if (input.Products.size() > 3 && input.Products.size() <=5) My problem is that every time I enter it I get the message Error at line number : 1 Not able to find 'size' function The size function comes from a built in Map Function. Please can someone tell me how to get passed this problem. Thank
I am struggling to get data from CRM to creator, Any advice greatly received
Hi I am trying to pull data from our CRM to my application. Creator recoginises the records with out an issue but the code on the tutorial gives me an error. Please help te code recommended is crmResp = zoho.crm.getRecordById(“Products”, input.Product_ID); input.Unit_Price = (crmResp.get(“Unit Price”)).toDecimal(); input.Quantity_Available = (crmResp.get(“Qty in Stock”)).toLong(); but the error is Error at line number : 1 Improper Statement Error might be due to missing ';' at end of the line
Downloading from Zoho - Enable ID view?
We have all of our company contracts in Zoho Creator and need to download ASAP. I used the Zoho File Downloader tool but now it is saying "Please enable ID view" Total Zoho Newbie here. Can you please walk me step by step through how to do this so I can download all the documents from Zoho this is very urgent Thank you!
Zoho Creator Email to include all fields
Hi: I understand that form action "submit" can trigger an email " on success" to use the variable formdata to include all fields and values of the form in an email.... but in a custom-written function, for example I select 20 rows/records and click the button to send one email per each row, what variable can I call so all fields and values are included in the email? I set it up so one email per each row is sent. Thanks!!!!
Digital Consultation form
I was wondering if anyone could help me with Zoho Creator or let me know if a different application would be more suitable? Within my buisness I frequently have consultation with customers where I fill out their details and requirements on a paper form then add them as a contact to zoho books. I was wondering if there was a way of creating a digital version of this form that once submitted would create a contact and save all their requirements under their profile or as a lead? I have managed to
My Account package details
Hi, Can't seem to find out where to find the details of what Zoho Packare I am on and my Plugin purchase history. Is there anywhere I can get a summary of this please?
Filter, unless the value is null
Hi, I am trying to create an order form - I have a Vendors, and those vendors offer items, which are stored in Vendor_Items form, using bidirectional (Vendor Items is a subform on Vendors). My subform in the Order Form for Items Requested has Vendors and Vendor Items. I would like to filter row.Vendor_Items by the row.Vendor, but ONLY IF a value is put into row.Vendor. If they have not put a value into row.Vendor, I would like all of the Vendor Items to be available. Is this possible? Any
I just got locked out of editing my account for no reason
This is not a good situation. I have an enterprise account attempted to add a user, got message saying I had hit limit. (which is not correct) and then suddenly I could not asses any editing of setup features of the application. I am the only administrator for my application. Urgent assistance needed. bfstrachan@bahamaselectricity.com Spoke to support. Told fix can taken up to a day. Given the subscription cost I would expect quicker resolution to a problem that should not have occurred in the
Why does this keep giving me a null error?
form Principle_Investigator_Registry { displayname = "Principle Investigator Registry" success message = "Data Added Successfully!" field alignment = left PIReg=investigators.Investigator_Registration[]; I've also tried these iterations. PIReg=investigators.Investigator_Registration; PIReg=investigators.Investigator_Registration It just gives me 'Error modifying the page null'.
Customer portal page centering
I have customized the size of the customer portal page to 800 px, but it's not centered on the browser as shown: Cheers, John Whitney
Next Page