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
Importing data into related tables
I have a csv file with data for three related tables and want to import it but am not sure best to go about it. Curriculum -< Course Course -< Lesson Lesson -< Resource Do I import them all at once or once each for each table?
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")
UI issues with position:fixed headers
Is anyone else having issues with the report headers? For the Zoho Team... I checked out the console and it looks of course like position:fixed is used with a scroll spy event listener to update the top css property. The issue is probably due to the fact that a dialog (with screen mask) jossles the scroll but doesn't fire the listener when closed.
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.
Validating File Uploads and Disappearing Uploads
I want users to be able to submit up to 5 attachments via File Upload and I want to validate those attachments. To do this, I have a Dropdown list called How many Attachments with 1 through 5 This dropdown list will either show or hide the appropriate number of file upload fields. After they upload the files, and click Submit this On_Validate script runs: if (input.How_many_Attachments == "0") { input.Attachment_1 = ""; input.Attachment_2 = ""; input.Attachment_3 = ""; input.Attachment_4
Is there a program available to open/edit .ds files?
Hello, I am trying to import a .ds file to duplicate my application for testing purposes. The application is built on an older version of Zoho Creator, and there are scripts in the .ds file that are no longer supported in new applications. I'd like to edit these out of the file, but I'm not able to do that on import. I have attempted to open the file in WordPad and Notepad, but I believe this corrupts the .ds file. It generates incorrect characters that I believe interfere with the import (in addition
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
PRD refresh to DEV
I have a Zoho Creator App which I have been using for years. It's PRD and I never had a DEV version of it. Now I want to create a clone of PRD and call the clone DEV, in another Zoho account. In the future all development and coding will be done in DEV, and from DEV I will push incremental changes to PRD.... how this can be done ? this is in a retroactive fashion... usually u create a DEV then do a copy from DEV to PRD and call it system copy... thanks!!!!
zoho creator export
How can i export report from zoho creator with PDF format but keep the headline for each page?
Criteria with space and date add time
Hello, Could you help me in two items: I'm trying to make an API via query by using: https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html # 1 - But I can not seek criteria containing space. I can get situation = Cancelled I can not get: situation = Waiting Sale How should I do? # 2 I would seek also to seek the registration date, as I do? Added_Time> = 4-May-2015 11:13:10 It does not work. How should I do? Tanks Tulio
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
how to calculate days in month
hi how can via function calculate numbers of days in month (current or future)? example - right now is may-2015, and there is 31 days in june-2015 there is 30 days how can i make automatically this type of calculations?
Dialog Helper function
Hello everyone, It's been a long time! Anyways, I'm working on a client application that uses a lot of view actions and dialogs. Just thought I would share a nice helper function to make building dialog's (using openUrl) with complex params much easier. void open.dialog(string resource, string resource_name, map params) { keys = input.params.keys(); str_params = "?zc_LoadIn=dialog"; for each k in keys{ str_params = (str_params + "&" + encodeUrl(k) + "=" + encodeUrl(params.get(k)) ); } url
Creating a function to populate another field
Hi, Working on a small inventory system here and running into bumps along the way. I am importing some 900 entries into this form and trying to populate a unique inventory number for each. The On Add > On Success or On Edit > On Success actions I've setup dont work for bulk edits or imports, so im thinking maybe its an idea to just have a button in the report that says 'Update Inventory Number' for those times that new records are imported which is hardly. But I dont want to go and manually update
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
How to add placeholder in a Zoho Creator field?
Dear All, I would like to ask you if there is any way to add a placeholder with a message in a field (lets say a multiline field) like the Zoho Invoice. I know that I can write a Tooltip Message but what about placeholders? Is there any hack way with CSS?
Create subform from a different app
Ex Code: Subform ( type=grid values=investigators.Investigator_Registry.ID ) This doesn't work at all now and it was working yesterday. Now everytime I try to add something to it, it says error null (I'm paraphrasing). Also if i try to change a subform value through free-flowing script mode it gives me a error null message again. Really though I want to be able to create a subform from Investigator registry app and implant it into PCRS Project tracking app. Also I'd appreciate a more
Drop down list values
Hello, I am trying to build up an Inventory Number creation script… or at least, a form where some of the values will generate an inventory number in a Function field. I have a drop down with 4 different values for an employee to put in… for example Part Structure Object Value Other I am calling this in the function field however I don't want the word to be generated in the Inventory Number. So if a user selects 'Structure', I would like to have the Function Field show a number instead of the actual
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
how to count entries with multiple variables?
hi! right now works the next code res = zayavki_form [sold_result.contains("0.1")]; count = res.sold_result.getall().size(); if (count > 0) { alert "Alert"; cancel submit; } this code works fine. it counts all entries from zayavki_form which contains "0.1" in sold_result. how can i count number of entries which in same time contains "0.1" in sold_result AND "zero" in field_A ?
Data gone missing!
In the last 5 or 6 hours, the last two months of records have disappeared... I know it's not a 'view' problem, because there are multiple different types of records, and in each case, anything added in the last few months has suddenly disappeared. Was there an update rolled out a while ago? Does it have bugs? Nothing from our end was touched. I generated a report one minute, and saw the data. A few minutes after that, it was gone. Anyone else having the same, or similar, issues? I suspect it might
Auto Increment Number based on other field values
I was curious if there was a way to Auto Increment Number based on the values of another field? For example, If Field 1 =A and Field 2 =B then increment by 1 based on the amount of entries containing 'A' and 'B'… So if I have 32 records where Field 1 =A and Field 2 =B, then the next record I add which has A and B will increment to 33 If i then make another record after that one, that has Field 1=J and Field 2=B, and I have no previous records that have those conditions, the auto number will display
Embeded public html views and error 400 (Bad Request)
Hi, i have embeded multiple html views in a website, with public sharing option. When i load the page, the first items are displaying correctly but others are not displayed, i get the zoho creator login page instead of the content i want to publish. Using Developer tools for chrome i can see the errors that are generated : 400 (Bad Request) Unsafe JavaScript attempt to initiate navigation for frame with URL The frame attempting navigation is neither same-origin with the target, nor is it the target's
On Dashboard show last modified date, record count
Can additional information be provided on the application dashboard with the list of all the forms? The ability to see the last modified date and the user who made the change will help in maintaining the application. Showing the record count for each form will help in buying the correct subscription. Being able to sort/filter by these fields will be beneficial.
Looking for Zoho Creator / Developer - remote work --- my client in Dallas, TX
Need 6+ years developer (.net or java or php) along with 2+ years Zoho Developer (Creator / API ) experience - certified Zoho developer or equiv experience. Zoho Code Review / Analysis -- enhancements ..... Contract Role - 3 months and could extend START June 1st 20-40 hrs per week -- flexible on hours jeff.kohnle@correlationpoint.com 214-450-4494
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!
How to add attachments in Zoho Invoice mail using create zoho incoice function
Dear All, With the usage of create zoho invoice I can send an Invoice (as an email) to a user-client with a default text (which is editable through Zoho invoices.). Does anyone know (if there is any way) how can I add an attachment in zoho.invoice.createinvoice ? Because I would like to send an email with an attachment (which I uploaded it in a File upload button). I found this but I do not know how is working.
Cannot adjust manually the width of a radiobutton in a subform
Dear All, I created a form with 2-3 radio buttons. Then I used this form as a subform in another form.As we know in the new form the radiobuttons are shown as dropdowns. My question is, I am trying to adjust the radio buttons width (dropdowns in the subform) manually but they are not shown in the Configuration pop up. Why this happens? Is it a bug or is is something else? Is there any explanation for that?
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
Double digit number field
Hello, I was curious if there is a way to enforce double digits in the number field? For example, i inserted a Number Field with a starting value of 01, however when it displays the form, it just shows 1. Also if I call it in a formula it returns 1, and ignores the 0. I would like to force the display of the 0 because this is part of a formula I am trying to write to formulate an inventory number… Example JW 01 01 15
Email Dependant on Input
Hello, I am creating a form which will be embedded on my website, On the form we use a "Postcode" field which we expect our clients to input their postcode. Within this field we expect the postcode to begin with either BD or S. We want an email to be sent to a person based on the postcode entry. So any postcodes beginning BD would need to be sent to John Smith and any postcodes beginning S to be sent to Joe Bloggs. Is this possible?
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?
Next Page