If then script
Hello. I am trying to figure out the Deluge Script in Zoho Creator. The result I am trying to generate is this: Through inputting, these variables are defined. vs (this is a percentage) Week_Gross (this is a decimal generated through a formula by adding several previously inputted numbers) Guarantee (this is an integer) In plain speak, the result I want is If vs * Week_Gross is greater than Guarantee, then output vs * Week_Gross, otherwise output Guarantee. I have generated the following
new calendar view - drag and drop - time zone problem
When an event is dragged and dropped or when the duration handle is moved the edited record jumps to the wrong date/time - apparently because the feature does not adhere to the application's time zone setting.
Setting Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. Does anyone know how I can
Creator added auto-filter on pre-existing applications automatically
As of yesterday I went back to check some pre-existing applications and noticed that auto-filters were applied randomly (and automatically with-out my input) to my various applications. On top of that some of the views will not show up and I get the following error [ServletException in:/jsp/edit/view/viewedit.jsp] null' Please look into this problem and get back to me Thanks
Pulling information from two forms
Is there any way I can have a report that pulls information from two forms? If not, how can I auto-populate a field in one form with information from another form in the same app? I tried to use the instructions here: https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form, but it did not work for me.
Styles for Embedded Forms: IE issue with blockquote CSS
In Internet Explorer, the blockquote shown below is white. In Chrome, it takes the color of the form. Can this be fixed? I'm using style url attributes to control the appearance of these i-framed forms (ref). Cheers, John Whitney
Popup window reported a bug
Hello Zoho Support team and Developers, I am added a problem here which i am encounter in my application, i am add many clickable icons or links in my HTML view and all of them are opened in popup window. now the popup window encountered a problem. when i am click on the clickable link i am see a popup window appear now i am close the popup window by click on cross icon on the popup window. as i click on the cross icon of popup window the popup window is disappeared, now when i am again click on
Add Data by Email Issues
Shared to support https://creator.zoho.com/buzzap/form/209/edit/ I have a custom gmail account authorized to forward email to the form linked above. It worked a couple times but now it's not. Cheers, John Whitney
convert xml response (from ZohoCRM) to simple “key=value” pairs (for SurveyGizmo) using php or Zoho Creator
Hi there, This deals with exchanging data between CRM & Gizmo. I'd like to Creator (or php) to convert the response. SurveyGizmo posts (insert) data to ZohoCRM. After insert, Zoho responds with xml that includes an ID of the inserted record. Gizmo needs that ID for subsequent updates. The problem is, Gizmo will only accept a response in a simple "key1=value1,key2=value2" format.I'd like to have ZohoCreator receive Gizmo's post, pass it through to ZohoCRM, receive the xml response from ZohoCRM,
HTML VIEW
Hi, I want to embed 3-4 views on a single HTML view and I want to set criteria to each view by passing a parameter via a form embedded on the same HTML view. Example: On the form, there will be a drop down to select a name from the list. This selected name should be used as an criteria to show specific record on each of the embedded views. Can you please tell me how this can be done? Thanks! V
Add row to subform in other application
Hello! I'm new in ZC. I have Application 1 and Application 2 with subform. In Application 1 i have Lookup field wich show name of records from Appl. 2. I need to add new row in Appl.2 subform, when i chose data in Lookup field of Appl. 1 and save it. Row in Appl.2 subform contain some data from Appl.1 Can you show me example how to do this? I try to use bedirectional relationship in Lookup field wich add to Appl. 2 subform, but it not add new row to subform when i chose data in new record Appl.1,
Any man can do what they want in my database... (embedded view ) HELP!
Hello! I have a database. The database is private. I have put the address on my home page and clicking on the address the user enters the page, which needs to connect to database... (https://creator.zoho.com/ (My username) / (database name) / write-Permian / (My database name) _View /) Database viewer entering database with facebook.com account. Why he can add, delete and edit entries in my database? It is not normal! Any man can do what they want in my database... This is very
Create incremental Number in SUBFORM if requested by "radio field" in the same subform record
Hi We use a lot of incremental numbers around our application for various things, however, I haven't had much experience with placing them in subforms on success of the parent form. This is what I've tried to write so far, and it comes up with errors: if (input.SUBFORM_NAME.RADIO_FIELD == "Increment required") { x = MaxValueHolder [ID != 0]; input.SUBFORM_NAME.SUBFORM_FIELD = (x.highestval + 1); x.highestval = (x.highestval + 1); } ERROR: expects = on line 16 I'm sure its simple,
Creating a "Two Step" Form in ZOHO Creator
Is it possible to create a "two step" form in ZOHO Creator enabling a salesperson to "edit" a existing entry in a ZOHO Database/Table? Here is an example of what I need the form to do: STEP 1 | Enter the invoice number (ex.123456) in the "Invoice Number" field. Then click on the "Submit" button ---------------------------------------------------------------------- Sales Entry Form ---------------------------------------------------------------------- Invoice Number: _____123456______| ----------------------------------------------------------------------
Is there a good way to create random passwords
I'm trying to create random passwords for users, but there is no random function. Yes I can use input.var = zoho.currenttime.toLong() 00; to generate something similar based on time, but try running this serveral times rapidly to choose characters in a list and you'll get similar numbers. Just as a test I tried: random1 = (zoho.currenttime.toLong() % 1000); random2 = (zoho.currenttime.toLong() % 1000); random3 = (zoho.currenttime.toLong() % 1000); random4 = (zoho.currenttime.toLong()
database restructure help
Hi I'm at the stage now where I need to restructure my database as I've decided on a solution which will meet my requirement to avoid duplicate rows. My issue is this - I have two core tables of 'organisations' and 'stations' as well as a table linking them to manage ownership relationships. Historically I have linked owners to the stations through a lookup on the 'station' table but this has left it impossible to sensibly manage joint owned stations. What I want to do is copy all the
on import (excel file)
Hello, I have three fields in a form I created (serial number, module type, is used(checkbox yes) On the import the user will select from the excel file just the serial number. I want the checkbox to be automatically set to false ( I imagine since it is not considered checked it is false, but I think it is actually Null instead) and I want the module type to be 0. Is there a way on import on each field imported the two other fields get their default values? Thank you.
Zoho Creator Maintenance - Aug 5, 2012 (09:00 PM - 09:30 PM PST)
Dear Users, Due to database cluster restructuring for better optimization of the system, Zoho Creator service will not be available for a short period on Sunday, August 5, 2012 between 09:00 PM PDT and 09:30 PM PDT We regret for the inconvenience this may cause. Regards, Karuppuchamy.
Help on viewing a related record field captured using aggregate records function
I wonder if anyone can help me please? I'm relatively new to Creator and i'm struggling to find a way to do the following: Using the syntax below, I can capture the appropriate value for the "Date_Worked_1" field, but i'm stuck when it comes to returning the value from another field in the same record that this returns. Suggested_Date = jobs[Allocation == "AVAILABLE"].minimum(Date_Worked_1) ; What i'm aiming for it to return the value for a field called "Hours_Worked_1" from the same record that
Want to include a Linking icon in Form View?
Hello developers and Support team. I have any application and in this application there are many forms and different views. i want to palace a icon like help icon to all forms views, where when user click on that icon they will automatically redirect to an another address. please see below picture for more clarification: If it is not possible to add icon to the form header then also provide me an alternative for where i can use it? Cheers
Common script
Hi, I've created a form that has a number of look-up fields. When the look-up values are selected, it changes various numeric fields, I therfore need to re-calulate all field upon update. I've copied the required script in each field. As the code is common, is there an easier way to call a script to re-calculate. This way I only need to maintain a common script? Thanks, Martyn
Can I submit once to multiple tables?
I need to have a single form that contains fields associated with different tables. When the "submit" or "save" button is pressed it saves the field data to the appropriate table. An example would be: Data entered into the "part description" field would save to the "Parts" table. Data entered into the "List Price" field would save to the "Pricing" table, and so on. Is this possible? Thanks for looking at this.
Is it possible to use foursquare data as an input to a form in zoho?
I would like students at my school to be able to register onto a zoho database through the foursquare app - is there any way of doing that?
Import data to existing app
I'm sure it's someplace! I exported the data from my ZOHO creator app, then made some changes in excel and now I want to import the data, replacing the current data. I can't find an import button. Herb Wexler MBA www.PreventingMediocrity.com Norwalk, CT 06854
User Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. UPDATE: I have created a duplicate
Need to create a standing order form with log-in
We have 1500+ members. We need to provide them with a standing order form for materials that allows them to log-in and change the order as needed in the future. Can this be done as a zoho app?
Zoho Creator and Iphone app
Hi, I would like to know if It´s possible create a form using Zoho Creator and them include it in a iphone app (so it can be part of an iphone app) It is possible? Thanks,
Backup Failed
Hi ZC team, I have tried several times a backup for one of my applications and that is failed all the times, on the description field says "null". Applications Name is: Gestion Comercial CLM Group, I have shared this app with support. Please let me know. Thanks.
How to export as a PDF using the new view?
There were several changes to the layout of the creator view this month and I'm a little confused. (Source: https://www.zoho.com/creator/views3/view.html) I'm trying to export one record as a PDF and can't find the option to do it. Zoho shows its done: and yet...my view only have the option of "Records per page". I also don't have the drop down where "Contact View" is. (The insert image option isn't working now...otherwise I would upload the screenshot). What am I doing wrong?
Live data feed no longer works!
I have a large Creator application that serves data to Excel via your old Export/HTML functionality (using Excel's External Data feature). Since your upgrade, this has stopped working. It seems your upgraded design does not allow me to have live feeds anymore. I tried using Excel's External Data functionality to link to an HTML view -- but this won't work because there's no way to disable pagination and show all records in a single html table. Export to HTML/XML/etc all seem to generate a URL
Passing Parameter to an Embedded View
Hi, Is there a way to pass parameter into an embedded view to display only select records? Thanks! V
Wrong entry populates form when submitted.... Argh!
I'll try to make this brief..... I have an application that has 2 forms (Buy and Customer) and two views (Buy and Customer), and one HTML page. Form "Buy" is filled out and then submitted, which then generates the HTML page from which I can send straight to a printer. Problem is when I have 2 entries that are similar (these are names - Last_Name and First_Name), the wrong entry often gets put on the HTML page. So if there is, say, a "Thompson, Darryl" in my database, and also a "Thompson, Matthew",
New UI seems to adversely affect two column Forms that contain CSS and HTML in notes fields
Hi Zoho Team! I have been using Notes fields to display dynamic data in my Forms using a combination of deluge script, HTML and CSS. Immediately upon trying the new UI for views yesterday I noticed that a number of my forms were displaying their content differently. On forms that used the two column layout (as opposed to the single column layout), Notes fields were dramatically changing the widths of the columns. These columns have always been locked into a 50/50 split of the width...in other words
Need help creating custom invoices
I am using Zoho CRM for my ad sales, but it does not allow me to create a sales order that will work as an insertion order because I need special fields for each entry, like start and end dates. It seems like I should either be able to create a form in Creator and embed it in CRM sales oder or create a custom form with an html view like an invoice. From all Iv'e read this is doable, but I can't figure out how to use creator enough to do it. can someone either give me some tips or point me to a tutorial.
Help Help Help
I'm having a hard time with this simple thing. I want to set the email address according to who the lender is. Can somebody please help me with this simple. If the input.lender is "mary" then the input.lender_email = mary@test.com I cant seem to get this simple thing to work in script.
Write to a third filed based on selection form dropdown.
Hi, How would I accomplish the following task using an ON-Input Script? I have a table where I keep employee Name and info. In the same form I have filed called Roles which have a value of Admin, Employee 1 ext. I would like to add an on imput script that would automatically write a value to a third filed called Rate. If Input.Empoyee is equal to Admin write $40 to the Rate filed. Thank you very much for assistance in advance.
Copying application doesn't copy data
Rather than shut my site down to deal with your new behavior of not allowing public views in private apps, and not allowing to get get an embedded shared link from a view that's in a public app, I thought I'd copy my app, make the copy private, then get the embedded shared link for each of my views and update my pages. But my data wasn't copied with the app so it was a complete waste of time. maureenshea
CAN I PRINT ADDRESS LABELS WITH THIS SOFTWARE AND IF SO, HOW?
How2 do I print address labels?
Order online with zoho creator
Good evening, I asked whether it was possible with ZOHO CREATOR or another application, put on the website zoho a control module online for my clients. Namely, I give a password to each of my clients selected, and when he connects he can choose the product and order online. And I get double the order. I ask because I read somewhere that it's possible but I am French and I do not read English, I use a translator. thank you
new calendar view - display field
The text displayed on the weekly calendar view is very brief and can only be based on one field. It would be helpful to be able to display multiple fields as the display field and show the full text of the field by wrapping the lines when there is sufficient vertical space or otherwise showing them on mouseover when there is not enough space.
Next Page