One record to converted to many
I have an import from a parent company that delivers data like this. Example Import (today, this import shows a record = week of sales) Store ID, Item #, WeekofYear, Monday Sales, Tuesday Sales, Wednesday Sales Thursday Sales, Friday Sales I would like to convert as the records load to another table as a Record = Daily Sale. Store ID, Item#, WeekofYear, Monday Sales Store ID, Item#, Week of Year, Tuesday Sales Store ID, Item#, Week of Year, Wednesday Sales etc etc.. Therefore a record = day. Any
Set Default Gateway when creating an invoice
Is there a way when creating an invoice from Zoho Creator into Zoho Invoice and setting the PayPal Getway to Checked. We are currently creating 300 invoices at the first of each month and I don't want to open each invoice and Select the check box to enable a paypal payment for each invoice.
Subform script not working correctly
Hello! We are having some difficulties with the subforms script in some of our apps. The subforms have 2 or 3 lookup or dropdown fields. Sometimes they work correctly, but if we add some code in the other subforms fields (on user input) they stop working correctly, even if they are very simple tasks. E.g.: "Products" form contains all the products available with prices and category. In the "Order" form, there's a "Order Details" subform. Subform fields are: Category (We tried dropdown and lookup
i how do you create workflow with the forms?
i see how you can build a form. how do you add workflow? how can you move the user from one screen (form???) to another screen (form?) how can you add navigation buttons and link a form(workflow) to a particular navigation button? thanks
Using CURL to Edit Records
When trying to edit records with REST API via a CURL POST I receive a 2900 error. I am however successful when adding records. Here is the code I am trying to use in PHP to edit a record. I am convinced the issue lies with reloperator or criteria. $url = 'https://creator.zoho.com/api/xml/myApplication/myForm/update/'; $fields .= '&authtoken=<authtoken>'; $fields .= '&raw=true'; $fields .= '&scope=creatorapi'; $fields .= '&reloperator=AND'; $fields .= '&criteria=field=92';
HOW TO DELETE RECORDS IN ZOHO CREATOR?
hi how to delete all records in zoho creator by using Deluge Script, is there any help link pls send. thanks hareesh
Selecting Dropdown item to display relevant Fields
Hi to all i have one Dropdown in a Form ,the dropdown have two choices one is LAND another one is HOUSE.based on above two choices if end user select the LAND choice to display relavant fields and hide HOUSE relevant fields. is there any way to implement. Thanks Hareesh.A
Set Criteria for Lookup field
last_name == input.last_name Gives me error "Variable 'this' is not declared" Can't the Set Criteria under Zoho use an input from the current form as a Criteria?
Scheduler script stops if it encounters an email address it thinks is bad.
I have sever custom scheduler scripts that are supposed to iterate through and send emails to our staff. If the script encounters what it thinks is a bad email address it errors and stops. The additionally troubling thing is the error logs aren't detailed enough to figure out on which address the script stumbles. Below is a streamlined version of the script. How do I get it to keep running if it encounters an email it doesn't like? for each e in Staff[((Email_Address is not null) && Notice)] { eml=e.Email_Address;
How to apply styles to ZOHO Form.
Hi, How to apply styles to ZOHO Form. Please help me out of this.
How to send a customised email
Hi I am new to Zoho and am trying to build what is probably a relatively simple application.... I have a View embedded in my website, that contains a list of people records. The email addresses of these people are purposely hidden from the View but are still part of the record. I am trying to create a script that allows you to select a number of these records and then send out a message via the website. The message has to be customisable via the website and the email records have to still be
on validate performs only the first check
Hi, I need to perform several checks before the datas are stored. To do this, I have a script on when validating - submit. The problem is only the first "if" seems to be evaluated, not the following "else if" When the first condition is true, the datas are added... Any idea ? Here is the code: Submit ( type = submit displayname = "Valider le projet pour enregistrement" tooltip = "Cliquez sur ce bouton pour enregistrer votre projet
Remove Decimals
Does anyone know how to remove decimal places in a expression? I'm trying to calculate the amount of nights a clients stays. ((Stay_End - Stay_Start) / (1000 * 60 * 60 * 24)) this will come up with 7.00 I would prefer it display just 7 Thank You, Phil
show multiple fields/rows from one form in a Add note field in another form
Dear members, How can I fetch some fields based on a selection from a form (FormA - normal form) and show them in a Add note field inside anther form (FormB - stateless form)? The story is this: FormA = contain fields: User_acc (single line), User_link (single line) FormB = contains fields: User_acc (single line), Note (single line) In FormA is saved all the links (User_link) associated with a User account (User_acc) ... so we will have a database like this: User1 | Link1 User1 | Link2 User1 | Link3
Please ! urgent... Update a total after deleting a row
Hi, Thanks to you folks, I'm now able to have a total in the main form that sum values from a subform. This part works fine. But there's still a minor problem I can't solve: if the user delete a row with a value in it from the subform, the total is not updated. It seems logical, given that there's no "user input". So I tried to apply the same script on "on delete row" but nothing happens. Any idea ? Here is my script: temp_total = 0.0; for each x in FPA1 { if (x.Montant != null) {
How to hide/show forms based on user selecting "Accept" on terms and conditions page?
Hi, We have the following requirements: 1. User (Not Admin) visit our site and will show the terms and conditions tab only each time 2. Once he click the "Accept" radio button and click "Submit" button then shows other forms (which are tabs) to him/her. 3. If Admin login, it should show all tabs. Please let me know how to implement it. If having code snippet that will be awesome. Thanks, Winson
Submit through mail
Hi there, I have a doubt. When I fill in a form it sends a mail with the information to my client, is it possible that if he replies to the email then it fills in back to the form with the rest of the information? It´s like the submit through mail option but it has to fill back regarding the ID. Thank you
Populating Subform through Deluge Script
Hi, I have looked extensively through the support section, and while accessing subform data is relatively easy, I have still found no way of adding subform data through Deluge script. I am trying to automatically generate invoices when a booking is made, but the line items for the invoice are in a subform. Any pointers in the right direction? I have already inserted the non-subform data into a new invoice: Customer_Invoice_ID = insert into New_Invoice [ Added_User = zoho.loginuser Address_1
Email Notification When Someone Updates a Form
How do I get an Email Notification When Someone Updates a Form. Right Now I only get Email notification when someone submits a new form.
How can I test for no entry in an RTF field?
The test ... if (input.RTF1 != "") will not evaluate as false when RTF is left blank. The test ... if (input.RTF1.length() > 0) will not evaluate as false when RTF is left blank. No matter what I try, a Rich Text Field will not let me process ONLY if it has user entered content. It always passes the tests i try to apply and acts as if there is data in the control. What I am left with is entering some generic data such as "n/a" and then testing if the field equals that generic data and using that
public form how to generate a "one time" view of the data ?
Hi, I have a public form and I'd like the user who fills in to have a pdf version of the data submitted. Sending via email is not good here, because I'v several subforms and those datas doesn't show up in the mail. I manage to open the view via "on success" script, but I don't want this view to be public, only one shot to allow the user to have a proof (record the pdf, print it, ...). How can I do it ? Thanks Sam.
Play video in popup
Hi, I have a requirement to play the video on popup when user clicks on the link in Zoho form. But currently its playing in the same form.The problem is once user click on the link ,it plays the video.Once its done the user has to go to other form means,the user has to select the browser back button.That should not happen for me. And while playing the video on popup , i should not get the tabs/menus to popup.Only video has to play on popup. Please help me out of this.
Zoho Creator - integration with crm - set crm-user lookup field
Hi, I have a requirement that I must set "Zoho CRM"-field value "On Load" of a form. The field gets its choices from Zoho CRM Users module. It would be something like this (let the field name be "selectedUser"): selectedUser = someID; This code sets value of the field correctly but text of the field remains empty - when I select paticular user using UI the field gets populated with "UserName". How can I set field's text value using Deluge Script?
Urgent Need help
Hi, In zoho form,how to place anchor tag/hperlink(Visible link name should be "Click Here",not the actual link). Please help me out of this.
Zoho Creator for HP TouchPad
Any plans to develop an App to use Zoho Creator on the HP TouchPad? We use Zoho quite extensively and would love to be able to use it on our TouchPads. Thank you!
Require/Check for Entry in Prior Field
I have a reservation form with a property field (dropdown) and a check in date field. The user enters the property and then the check in date and the system looks up the available rates. The issue occurs if the user skips the property field and then enters the check in date, the system then crashes with an error (as it is trying to look up a null value). Is there a way for me to check if the prior field (property) has an entry upon entry of the second field (check in date)? I am thinking this
htmlview [calendar] in an iframe/htmlview issue
Hey, I was trying to reference htmlview [that includes e.g. a calendar] in an iframe. The result of this looks partial, e.g. only the secondary-header appears in the iframe. Using views/form have no problems. Did anyone manage to have an htmlview within an iframe section? any examples? Many thanks,
relating date field to a view
i have two forms. one is for adding participants to the database. the other form is for adding "events" that participants have attended, which includes the event name, participant list, and date of event. within "events" there are several types of events to choose from that will be repeated over time, including "tutoring", "lunch meeting", "ski retreat", etc. ideally i would have used a dropdown for this field, however since dropdowns are not available for lookup fields it is simply a single line
Charts issue
Hi, I have an HTML view,where i have created 2 iframes.In the 1st Iframe i have placed one bar chart and in 2nd iframe another bar chart. By using openURL iam trying to access the HTML view in the form.While accessing the application its showing the 2 IFRAMES along with the tabs.But i dont want the tabs.I need only 2 bar charts to display. Please help me out of this.
Bug with subform interaction
Hi, I've found a bug that comes up when I'm pulling data from one subform into another. Please review the two screenshots below. ============================================================================ Case 2: I enter a name in the Child subform It seems like there's an error that occurs in the Event Location On Input function because the row.Debug updates don't work. However, I can't debug the function because Zoho doesn't let me use info commands in OnInput functions. No error messages appear.
calculated field requirement
Hi My database contains amongst other things a table of owners and a table for assets. I would like to be able to create a field in the owners table which adds up the capacity field of those assets and displays that in that owner table. I've looked around but can't see any documentation which explains this. I would also ideally like to be able to pull that information into a third view which is contacts and partially made up from the owner table displaying related fields. Please help Many Thanks
how can I change the "add +" button in a subform ?
Hello, Is there a way (I guess there is !) to customize the "add + / add new" button in a subform. I need it in french for a public access form. Thanks. When you access the application, the Subform will be displayed within the main form, as shown below. Here, the "Order form" displays the "Items" subform to add the items ordered. You can use the "Add +" or the "Add New" button to add entries to the main form from the subform.
Scripting Problem
I'm having trouble getting a simple Hide/Show script to work. I keep getting this error when I try to enter the script to the "On User Action" section: Error in statement at line number 3 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here Here is the script I'm using: if(input.projectType=="Print") { show Quant_Print; } Please help.
Chinese interface
I need to used a Chinese UI for my users in China. Can Zoho Creator do this?
Send Mail when Dropdown field is changed
How would I create a script that sends an email when a dropdown of an existing record is changed/updated to a specific option. For example: a database record has a dropdown with three options (a,b,c) when it is changed from option A to option C (and submitted) I would like to send a notification email to a user. But specifically from A to C, not A to B. Is this possible?
Formula Field & Aggregate Record (Count)
Are there any plans to allow a formula filed to support the aggregate record function? The use case is a vacation day application. Users can see the number of days they can take and the number of days they have taken (via record aggregation). I'm using an html view to do all this now. Cheers, John Whitney ZOHO Creator Developer
Data not populating fields in form
Hello, I am having an issue where data from my stateless form is not populating the fields in the form it is supposed to be INSERT INTO. Please see code below. What is supposed to happen is this. 1. In the STATELESS FORM The user enters data into "input.Lateral_Vibrations_Bin_One" this value should be multiplied by 0.5 then the sum should be loaded into "input.Lateral_Vibrations_Bin_One_Weight" 2. When the user submits the data the value from "input.Lateral_Vibrations_Bin_One_Weight" should then
Cannot provide admin rights to my developer
I cannot provide admin rights to my developer. Can someone help? When I go into my application settings I don't have any option to add admin rights. See image attached. Please help as I'm wasting time with my developer and they too are getting pretty frustrated with the lack of access to help build my forms and capability.
Links to Zoho CRM
Hi, I am developing a Cretaor App for a client that is to tie into their CRM, I have yet to work on the integration (phase 2) and it may all become cear but my concern is about publishing. The CRM link help implies I need to do the integration work in their own account(s) so it links through to the correct data. Is there no way to link to their data in my dev area and then share to the client via the developer Zone so I can continue the development whilst they use the phase 1 system. Thanks
Set the view group back color?
Would love to be able to change the default back color for group rows from the default yellow (list view with a group set). Looking through https://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html#6._View_Customization there doesn't seem to be a parameter for it?
Next Page