Percentage and deluge
I am trying to update a commision value field with certain values based on two parameters, but are not doing this correct as getting errors, have not been able identify exactly how I need to code same in the help section hence reaching out here. What i want to achieve in this case is when Pay At equals DEBRVTM and Currency equals USD the ADDCOMPCT should update to read 1.5% The two determining fields are radio buttions and the ADDCOMPCT field is percemt field. Current code as below. if ((input.Pay_At
How to display total numbers in a report?
I created a form and added number of records. The problem I have is that the report shows each record separately. Is there a way and how would I create a report that would show the total for certain period of time. For example: I would like to keep track of all rentals I have made. I enter each rental into the form. In the end of the month I would like to print a report that would show total numbers from all entries in that certain period of time - like total rental amount for the month, total tax
how to set age field to autopopulate based on DOB field
I'd like to create a field in a form that is called age and have it automatically calculate based off another field called Date of Birth. Is this possible?
How do I make a report with the last record for each employee?
Basically I have a report that displays records (evaluations) for each employee. I would like to have a second report that will display only the last record for each one. How do I do this? What option/filter would I use to display last record for each employee?
How can i group a list of input fields?
how can i group fields in a form, to call them in my workflow since a variable?
Auto Generate field based on other fields
I was wondering if i can create a field that will auto generate using what i picked in the form for example. I am creating a form for clothing inventory and I have the following fields Brand - Nike Type of clothing - Shirt Size - L I was wondering if i can generate a autonumber based on what i pick./ So it wuld generate NIKSL003 This number would not repeat Any Ideas??
Lost all my data
Hi, I have been trying to create a rect tracker. I had loaded a lot of data and now I find that all the data is gone. Can you tell me why this happenned? What is the security level that is currently there on the site. Pl let me know. Also if I want an audit log of the users can I have that. PLEASE HELP!!!!! Rgds Raghesh rdasannachar
Just starting out. Is Creator the right choice?
I'm just starting a new project. Its a (minority) sports results system, where members of the sport can input their results and see how they compare to other members. Stats need to be run on the whole results list. Simple database stuff, but with a few thousand end users. What would the cost be? I also want it interactive so people can put their own personal goals in and training plans and have the app return achievement awards. I want the users to link to their trainers and and so the trainers get
Zoho Creator Reports Unlimited? or Limit 50?
I am using Zoho Creator to create embedded web forms to collect data and generate reports on that data. On the pricing plan I see under Application Components: Reports Unlimited But under Web Components: Web forms, reports, pages Limit 50 for the Enterprise plan. Does this mean I can only embed or publish 50 total forms and reports? I can limit my forms to keep me under the 50 limit. But for the reports I would now have to use Email schedules. I don't see an option to email the report as soon as
For a List type report is there a way to change the format of a number?
Can I modify the type of format in a numeric column into a List Report? The number is too long, and I would like to include commas. Thanks
Record Summart Printable Details
Hello i have problem with record summary and subform, showing. Here how it should be And this is what i get How i make it Please tell me how to do that. Thanks.
How can a field change it's name, depending who is seeing the form?
Hi, I want a field change it's name according who is seeing the form, so let me explain. I have a form and, Depending on who enters to the form, some fields will be displayed and hidden, But one part of the form appears to both equal people, but i need to change the name of "Hospitalizacion PR" to "Hospitalizacion" when Admin1 enters to the form, and if Admin2 enters to the form the field will appear like "Hospitalizacion UG", how can i change it?
Cannot submit form
Dear Support, My app users are getting a "Permission Denied." message when attempting to submit forms on their iphones. Please help urgently. Best Regards, PARAMPARA
Still wrong the names of the fields in my pivot charts.
Hi, i communicate with you 'cause the names of the fields in some pivot charts in my application appear like: "Number", "Number2", "Number3" Etc etc etc, and i still have no answer, i ask this since 15 days ago, you response it, but the problem still with us, and we can't create a pivot chart without know what are the names of the fields we need in that chart. Please, we need help for this problem, thanks a lot.
How can i do to share a page?
I want to know how to share a page with some people in my aplication, how can i do it?
Limit max characters in multi line box
Hi! I would like to limit the max number of character that a user can write in a multi-line box. Is this possible in any way? Cannot find the option when I edit a multi line box.
Link To File On My Computer
Newbie Here. I want to link to a file on my computer - not on a website. For instance: File Location would be the field. I see where I can link outside but I don't see how to make it link to a file on my computer. Am I missing something. Or is it because it is cloud based?
Ideas for my form
Hi everybody. I'm trying to make a form to distribute all the biopsies through the pathologist (residents and assistants), and I need to add two fields which I'm not able to find out how. The first field I need is one in which I see the sum of cases of each pathologist for the day, updated every new biopsy is added. The second field is one in each I can see the pathologist who received prostate biopsies in the previous day. Can anyone help me?
Boolean fields in a map?
Is there a way to have a boolean field in a map? if you use this code mymap = map(); mymap.put("aaa",true); mymap.put("bbb",false); then alert mymap.get("aaa"); shows 'null' is there a way to make the value for aaa behave like a boolean instead?
how do i sum values in fields?
Hi, how can i do to sum 8 fields in a form? This is how i actually do with 3 fields: if(input.field1 > 0) && (input.field2 > 0) && (input.field3 > 0){ input.total = input.field1 + input.field2 + input.field3; } how can i do to simplify the code, cause the example code is for 3 fields, and i need to sum like 8 and And can also add to clutter. and i think it will takes more than 20 if conditions.
On validate if statement with two conditionals.
In my form validation script I would like to have an if statement with two conditionals. I feel like the following script is formatted correctly but it is returning an error at the first if statement. Any insight as to why this is happening? wordsList = input.MyField.toList(" "); wordsCount = wordsList.size(); if(input.MyField2.contains("Some string about this long") && wordsCount > 150) { alert "Sorry. Only 150 words allowed for MyField2"; cancel submit; } else if { ... continue
How do I add many fields in a form?
Hello everyone, I have a form, and in the form i have some sections, In each section I have the sum of the fields that section has, i was addend that fields, it was only 3, so add 3 fields is easy using conditions, like: if(input.field1 > 0) && (input.field2 > 0) && (input.field3 > 0){ input.total = input.field1 + input.field2 + input.field3; } As you can see, i can do it, but i have to put every condition in every "On user input" so, in case that field2 == null, do this.. in case that field1
Jumping to a different input form
While entering data on FormA the user can elect to enter data in a different FormB. Actually, we anticipate 5 or 6 choices which require jumping to another input form. I cannot find any documentation on how to do this, but I expect it is quite easy. Barry Sammons Sammleton Distilling LLC
Domain mapping
Does anyone know how to create domain mapping in ZOHO CREATOR ? I have tried to follow the documentation but on my setup screen there is nowhere I can enter the domain name to be mapped. The documentation leaves a lot to be desired. Mike
Using bookmarks in the HTML page
Hi there, how is it possible to use bookmarks inside the HTML page ? I set up a bookmark with <a href="#link">Part 1</a> and mark the HTML block with <h2 id="link">Part one</h2>. When I run the app, open the page and click on this hyperlink, app opens another view/form which is placed first in my app. I checked the URL behind the link in the running page, it looks like https://customerportalname.zohocreator.eu/portal/appname#link which is clearly wrong as it misses the page name. Any ideas how to
Load all [input] Fields in Form with specific 'Fetched Record' Values
Hi, Till now, we are able to only set individual field values using the 'set variable', in a Form. Could we have a statement, or variable name, for the current unsubmitted records, i.e all the form input fields, so that all their values can be set to a fetched record value, in a single statement. This can only work for, forms fetching data from the same form, or in an identical stateless form. lastrecord = (Songs[ID == input.ID]); //fetch record e.g formdata = lastrecord ;
Hide Submit Button
Hello, I am using a form that calculates user data and displays the result; http://www.beergrains.com/priming-sugar-calculator. I have no need for the SUBMIT button and it is causing confusion with the users; when they click Submit the results appear then quickly disappear. They just need to view the result without submitting data. Is there a way to hide the submit button?
Issues with Customer Portal feature.
Hello ZC Team, I have a couple of problems in using customer portal: When the settings is such that users need the approval of the admin, the entire workflow doesn't tell that to the signing up user. The user gets the invitation email, gets the add-password link too. All this gives a false impression to her/ him that there is no approval involved. We really need the message to read something like - "you will receive an email with further instructions *after* the administrator approves your request."
Custom domain for zoho creator app
I am creating an app for the workplace of a large company. Unfortunately, it is like working for the government and I cannot convince the enterprise security folks that zoho does not pose a threat to their security and they have banned the zoho.com URL via their firewall. So I am considering whether or not I can use a private domain access to zoho in order to access a creator.zoho app. I believe that if the app were accessed through my_domain.com in some way that things would work. Am I understanding
Add table to query from?
I would like to use two fields (thickness and length) to fetch a price from a grid. I would like to transition from excel (or zoho sheets) to creator. For example: If a user input in on a from lengthfield "31" and thicknessfield ".375", I would like to see the value of $7.84 returned.
Check Box field in Pivot Table
Is there some problem with using a check box field in a pivot table? When I go to set up the table none of my checkboxes appear in the field list to select from. Weird and really a problem for me. Thanks for any thoughts.
Automatically add subsequent datefields over a time periode
Hi I'm quite new to Zoho Creator but the possibilities seem endless...if you know your way around. I'm building an application for the management of participants on a long term training course. Participants have different start dates. Form 1 has all the details on the individual participants. Form 2 is a attendance protocol foremost for adding participants to the report. The report is the actual place where I do day to day updating of the protocol with attendance/no attendance/sick/absent with
to copy an specific field from a lookup - dropdown field
Hi, I have a form named "Customer" with Name, Lastname, Address, etc and I have another form named "Orders" with a lookup/dropdown (this field is named "CustomerOrder") to the first one. In "Orders" I need to have a field with the name of the customer, then I did a Formula Field related to CustomerOrder Field, but it returns the ID of Customer and not the name What can I do? Thanks in advance
Unable to install Order Management 3
Hi all, Can any1 help me or guide me on how to install order management 3.0 apps, as i stuck up on loading OM 3 page and doesn't move further. Thanks in advance
Create New Record Summary?
I want to create a new record summary which only shows certain information. I've been trying to follow the online help, but it's not working. Online help: Select the Record Summary option from the Report Settings page. Click on New Record Summary to create a custom record summary. If you look at my screenshot, you can see I'm on the record summary page, but there is no New Record Summary button. Am I missing something?
The names of the fields in a pivot chart appear different from the form.
I have more than 5 pivot charts, but the name of the fields appear like: "Number", "Number1", "Number3" etc etc etc.. why happend this? and I can't change it or fix it, can someone one help me?
License and number of users Zoho Creator
Hi there, How does the license model of Zoho Creator work? I want to to build a couple of web applications. Customers and other external people need to enter data in these apps/forms. I prefer to distribute a custom URL per customer so they don't need to login and can simply enter data (to monitor quality of sales appointments for example). Does I customer count as a user or not? I will be the only one making and editing the apps and forms, do I only need one user license in that case?? Regards,
can not edit some record fields in edit mode.
Hi, when I try to edit some fields from a record they don't appear so I can't edit them. I attach some examples. INSERT MODE: EDIT MODE:
Signature PNG In Report and Summary
Hi guys, Im looking for the best way to display the customers signature inputted into the form in the record summary for print and also where possible in the record listing page.. Any help would be great, Im just stuck on if creator is made the signature as a png and I can reference or a different file...
Display subform items in another subform?
Hi there, I was wondering if it's possible to display the data of a subform in another subform from a different form? If so, can someone help me and tell me how? (If it's not possible, is there a way to get the data of a subform in simple fields?) I would really appreciate your help, thanks!
Next Page