Duplicate Application and automatically update it
Well, my question is quite general concerning the duplication of an application. My question is, if I have a huge application and I duplicate it, is there any way when I change something in the 'parent' application then automatically to make this change in the duplicated application? In other words, to update automatically the second application. For example, if I add a new form in the 'parent' application then to automatically create this form in the second application. Or I have to do it manually
How to track running totals (e.g. inventory)?
Newbie here. I trying to accomplish something that seems like a simple task, but can't quite figure it out. I am trying to track product inventory at stores as follows: 1) I set up a form that adds a store to the database (add_store). 2) I set up a form that adds product to the database (add_product). 3) I set up a form that adds a product to a store (add_product_to_store). I used look-up fields to choose store name and product name. There is a also a numeric field to specify how many units of
How to create conditional fields?
Is it possible to create conditional fields? eg, If I have a field for yes/no, i want to show a text field for data entry if yes is selected. If nothing or no is selected, i do not want to show the text field.
Horizontal arrangement of the radio buttons
Hello, In trying to create a survey that is a single page w/o scrolling, I would like to have the radio buttons (numbered 1-10) horizontally arranged rather than vertical. Is this possible? 1 2 3 4 5 6 7 8 9 10 o o o o o o o o o o I have only half a dozen questions but the survey is 70 mines long and doesn't seem like it needs to be. Thanks for any assistance any viewer of this post can provide. Cheers
Don't understand setting field by scripts
Hello! In a live view https://creator.zoho.com/smt_online/tech/#View:terminalsView I have a custom action that launches the script: Блокировать SIM blockSimDialog(terminals) The script is simple: void terminals.blockSimDialog(terminals t) { s = SIMs [terminal == t.ID]; s.blocked = true; } It's catch the sim-card and set a flag in "blocked" field. It's working - i can see, that flag is set. Then i have a handler in SIMs form, on Update the "blocked" field: if (input.blocked) { sendmail
Customer Portal Compatibility with Browsers
Several of our users keep getting the same error “Untrusted Site” or “Untrusted Certificate” with all browsers (IE 9.0+, FireFox, and Chrome). How do we make this error go away for good? Please Help!
Rename label by selecting a field.
Hi help me please!! I have the selection field "COUNTRY": if we choose "ITALY" The second label called "STATE" should be changed in "PROVINCIA". if (input.country.contains(("ITALY")) and after? Thanks
Import data from email
Hi. Unfortunately I can not change our form on our website to "text" it is "rich text" or "html" as we use a template website, so have to stick to what they supply. Our customers fill out the form on our website, and the data gets emailed to us. Because I cant do plain text emails, is there a way of importing the data from the email? If not, I know there is a way to make a form from Zoho and create the HTML code for it, which can be put on our website. However, our database on Zoho has fields like
Unable to duplicate an application
Hi I am trying to duplicate an application. nothing happens. What should i do? Thanks
Look up function, just add new entries OR Subform size definition
Hey there, I just want to use my original inquiry form with a look up field to my address database, to send it to my contacts, that they could type in there inquiries by there own. Why ever there isn't such a function in Zoho Creator, where you could set up a adjusted kind of your original form for the public use. Of cause you could create a second adjusted form, but then it‘s very annoying to add this selected data to your old main view.... So I scripted a little code, which indicates if a stranger
Can I use RegExp to split a string into an array?
Hi Cecil Adrian Can I use a RegExp to split a string into an array, if so, how do that could you please help me. like this string ="12345678" split into array = [1,2,3,4,5,6,7,8] by RegExp Thanks! Stanley Guo 2011-11-5
Customer Email ID in Customer Portal
Hi, Is there a way to get the Customer Email ID of of customer in Customer Portal ? It's not working with zoho.loginuserid... it's null. Thanks, Pascal
Populate more data into subform
Is it possible to populate some inputs into a subfrom by scripting from a main form? I'd like to create a kind of dynamic subform which could shown up based on a dropdown list and would be populated by data from other forms. With other words it would be a pre-filled subform by 4-8 rows in that. See below the sub-form. Only the quantity would be optionally editable by the user, other field should be pre-filled based on a previous choice from the main form. I was able to add data from a form but only
Arranging Radio Buttons side-by-side.
Right now the radio button option lists all options in a vertical list. Is there a way to arrange a split list so that the buttons are side by side? That way it would take up less room.
Relationship help
I have four forms: Courses Offered Employee Req Training Courses Taken Course Name Name (Lookup) Name (Lookup) Course(Lookup) Course(Lookup) Expiry Date I am having trouble making the relationships. The forms with the look-ups are working great. I would like a report that looks like: Name Required Course Courses Taken John Smith Course (required Training) Course Expiry Date (Blank if not taken) Any help is appreciated. Thanks, Wouter
Not Contains Criteria
Hi There, I have put together a demo application to demonstrate this problem at the following link https://creator.zoho.com/zoho_beth3/contains-criteria-example# I want to be able to select all records where option 2 has not been selected in the multi select box. When I manually search for records in the view "Add Option Record Report" and set the criteria "Not Contains" Option 2. I get the correct results. When I save this as a new view, the results are no longer correct. See the view "Without Option
How to change currency/number separator?
How do I change the currency separator to show the currency in reports as 12,34,56,789 instead of 123,456,789?
Request fails to enroll in a particular profile.
Request fails to enroll in a particular profile, except where the record the following message appears, and nothing happens: java.sql.SQLException: java.sql.SQLException: java.lang.Exception: cannot getConnection when the Txn Status is STATUS_MARKED_ROLLBACK Exception occurred during get connection from datasource Thank You!
Resize reports in html views
If a have two or three embedded reports in a html view, is there any way to change the width, the height and the positions of each report in the html page? If yes can you please tell me an example? Because as you can see in the attached image4 the html page is not well designed. Or if there is any way to decrease the width between the roomtype and low season which is quite huge. I went to column properties of the report, I decreased the Column Width but nothing happens.
Grandparent records
I can handle parent-child relationships readily, but what about grandparent-parent-child relationships? For example, how can I put fields from those three levels into a report?
Query related records
Hi: I am trying to figure out if I can query related records on the save of a record with a look up field. I created an app in Creator called Work Order. Work Order has a look up to Products. In Products I have a lookup to Products for Parent Products. When a user saves a Work Order with a Product filled out, I would like to query on all the Child product records and created Work Order Lines. Is this possible? Thanks
Create an app for ordering food, can I do this with Zoho?
I want to create an app that will allow restaurants to easily take orders from online. First, restaurant managers will create an account and post the list of food items. Then, customers can to the page of the restaurant, and order food for pickup. The restaurant will get an email and/or text. Any restaurant can automatically sign up. So, the restaurant will sign up onto my website, create an account, etc. The restaurant will then post menus. Then, people will go to the restaurant page and order,
Change the order of records in zoho creator report
As we know when we add a new record in a form then in the form report it shows it first. Always the first record is the last one in the report Example: 1st: Coffee 2nd: Sugar Coffee 3rd: Milk Sugar Coffee and so on. Is there any way to have the first record always first(in the report) and the others below it? Like: 1st: Coffee 2nd: Coffee Sugar 3nd: Coffee Sugar Milk
Lock an entry?
For example, is there a check box that can be added, only visible to the admin, that can lock an entire entry? In the report it would appear grayed out, but still readable? The application of this would be that if someone leaves a study, we still retain all their information but have a visible way of graying out the record in the report.
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)?
Formula with lookup
I have a calendar view in an application that shows shifts that specific people will work. Right now, it only shows the name, but I need it to show the shift time as well so that it is simple to check what time people are coming in. The names are selected from a lookup field. I thought that a formula field combining the name and shift time would work, but on the view, it shows record id, not the name. Is there a way to make it show the name, not the number?
Accessing user profile fields in a Deluge script
I would like to be able to retrieve the following fields for the logged-in user in my Deluge scripts: User's first name User's last name User's phone number Is there a way to do this please? I need to use them in SendMail functions to populate the message body and/or subject. Thanks very much
How to track running totals (e.g. inventory)?
Newbie here. I'm trying to do something I think should be relatively easy but haven't been able to figure out. I'd like to track product inventory at stores. To that end, I have: 1) created a form to add stores to the database 2) created a form to add products to the database 3) created a form to add a product to a store; this one utilizes look-up fields from the add store and add product forms. There is also a quantity field to input the quantity of the particular product being added to the
Prevent "Click to wee the data" In Pivot Chart
I have a pivot chart in which I do NOT want users to be able to "Click to see the data" because the detailed data in the form includes information that users should not see. Is there any way to prevent the users from seeing the detail data? It would be nice if we could build a pivot chart from a view instead of only the form.
Zoho Creator Record Size Limit
Hello, as we are evaluating Creator for one of our customer from a luxury brand retail, they are quite happy with the functionality. They will use for local teams so the budget fits for the professional version only. However, they need to work with 50000-100000 records. So Creator really exceeded their budget. As hardware is getting cheaper and cheaper today, Creator stand out due to it's powerful and flexible platform. But the data(record limit) looks really expensive compare with other cloud based
Why does the same code appear in each individual schedule?
Either this is a problem or this is just the dumbest most confusing user interface... So I create a new schedule, in my case I have 3 custom schedules. I set up the "When to do" part easy then click Save. Next i click "Next". I would expect zoho to take me to a blank code editor but instead it takes me to a code editor containing code from my other custom action. I'm not sure that a new custom action actually creates its own code, instead all the code is stored in the same place. What is the point
How to eliminate temporarily all the headings, and titles.
Is there a way to temporarily eliminate all the titles, headings, icons, etc. when viewing and entering data, so that there is more actual working space. Now the titles and headings occupy at least 1/3 of the space on the monitor. Maybe a screen view with only column titles and the remainder nothing but data.
success message "<specify message>";
Please enable this for stateless forms. Cheers, John Whitney
ZOHO_CRITERIA in Zoho Creator Reports (dynamic filtering in Reports)
Hi, Can I use ZOHO_CRITERIA to pass parameters in URLS to filter data shown in Reports? I cant seem to get this done in Zoho Creator reports. I have a repprt that shows country data for all countries. I call this report from a View, which I would like to filter for the Country (row selected) in the View. It shows me all the countries which and does not filter. I fact, I get an error when tryin to use ZOHO_CRITERIA. Any help would be great Thanks! -Gabriel
What does this mean?: [Form_Button_WFlow] Column 'BUTTON_ID' cannot be null
Since there's no duplicate stateless form option, I'm attempting to paste a form definition with action into a blank stateless form definition. It's giving this error. Since it will not let me save the form, I cannot share it to support in any way... Cheers, John Whitney
Accessing variables amongst different fields
I have a form that will allow a user to customize the options of an oven. The oven has a customizable cook top that can have a pasta cooker or a griddle, or burners etc. There is a total of 160cm of space available and each type of cook top has a given space, such as 120cm, 80cm, 60cm and 40cm. When a certain oven model is selected, I wanted to set a variable called space_left = 160. Then display dropdown for each size, so a dropdown for 120cm cook tops, 80cm cook tops, etc. When a user selects
Email function not respecting line breaks of a multi-line field
Hi When executing an email function in which a multi-line field is forwarded, the resulting email has one long line of text for what was justified in zoho. Example: IN ZOHO text text text text text text text text text text text text text text text text text text text text text text text text IN INBOX, OF FORWARDED EMAIL: text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text
Go Fleet Corp data base
zoho running very slow for feb 20 2014 . reason why?
Email notification for sub forms and sub records
I have a form with some subforms. I would like to send an email notification that includes the submitted data. The email notification is sent with the fields and values of all types of fields in the form , but it only sends the ID of the subform and not any fields or raw. WC-352 : 1714287000000191043, 1714287000000191047 WC-352 is a subform and I would like its rows of fields be included in the email as it appears on the record report. the two ID above are related to the following field and values
Add to a picklist dynamically?
I have record Class with field Students, it is a picklist that looks up record Student I need another form, that will dynamically add student to the Class, code something like this theStudent = Student [ID == input.Student]; theClass = Class [Title == input.ClassName]; theClass.Students.add(theStudent.ID); This compiles with no errors, but it wont run or produce any results.
Next Page