Function call as a View Filter
While custom filters allow simple filed based expression to be evaluated, has anyone been able to call a function for each record in a view? Background: I have an IT equipment list containing date of purchase & I am trying to create a view called "Warranty Expiring". I have already written a function called isWarrantyExpired() which take in date of purchase & months of warranty included at time of purchase to compute & returns a boolean true/false if warranty is expired. What I'd Like To Do: Create
Print to Word, Print to HTML, Print to RTF
Dear ZOHO, By default, Creator offerts options for an HTML-view to print or to print to PDF. However, I'm actually looking for an option to print to Word or print to RTF or print to HTML. And maybe it is better to say: Download as Word, Download as RTF, Download as HTML. Is there an option to achieve this? Kind regards, Silvester Draaijer
Possible to populate a subform from a stateless form?
Hi Zoho, is it possible to send data from a stateless form to a subform in a 'real' form? The annotated screenshot below describes what I mean. Background I am creating a multi-stage registration process. Currently I've got the form set up using checkboxes to provide a 'wizard' effect: However, my client doesn't like the user experience of this (saying rightly that it's not very intuitive). He wants me to come up with a stateless form approach with "Next" and "Back" buttons down the bottom.
email notification with Advanced Display Option
I have a form that sends an an email notification on submit. This is the option under More Actions. This is a nice simple way to send an email with all the fields from the form. However for lookup fields the link field shows instead of what is set in the Advanced Display Options. Is there a way to change this so the email show the same information that is displayed on the screen and the associated view? Herb Wexler
Duplicate Entry when changing field type
I'm trying to change a multi-line field to a Rich Text field and I get the following error. Is there a work-around? Duplicate entry '218933000003474087' is not allowed as duplicate entries already exist Herb Wexler
How can i display a textbox based on user selecting one of the checkbox option
If one of the checkbox option for a field is Other i want to show a textbox next to it when user selects that option. How can it be done on a form.
Bi-Directional Relationship With A SubForm.
Dear all, I'm struggling with 3 questions for more than 14hrs and still i didn't get solved. So any one can help me on this?? 1) How to fetch records from parent form and update records in subform using Script. Example : Form - Orders SubForm - Products When i select a specific order all the products related to that order has to display in subform and when i save, that has to save to "products form" as well as in "products subform". Even if i add products related to that orders in "products
The number X is not allowed for this form. Only certain numbers are allowed for this field.
Hi, I have a form created with Creator that I use on my laptop and my Android device. The form on my laptop is still working as before, but on my mobile, since a number of weeks, the form does not allow the input of decimal values anymore into an input field. The field is set up as Currency which worked perfectly before, but when I enter a decimal value and press the Submit button, I get the warning: "The number 2.5 is not allowed for this form. Only certain numbers are allowed for this field."
Formula field that calls a function that seeks records from another form does not seem to be working
Here is my scenario (simplified): I have a function - GetCount(string Name) that queries a certain form collection say Form2 and returns the count. I have another form From1 that has a formula field that calls the GetCount(Name) function. When I introduce this formula field, it calculates the count and correctly shows me in the View of Form1 at the begining and then all the values stay as-is even though the records in the Form2 have changed. If seems to be that the formula field in Form1 was just
Lookup Field error
hi please help me what is this error
what system field to use for manager's ID on every entry?
hi i have few managers with separate logins in zoho creator's app. i need mark every creator's database entry with ID of manager who add this entry. what system field i need to add to app's code so that this app will automatically add manager's ID to every entry?
hide/show fields in subform row based on input. how?
Hi, Say I have an invoice form and included a subform that should hold lines of payment details for cash/cheque/credit card. Based on a dropdown field "payment method" I would like to hide/show enable/disable certain fields. E.g. if "Cash" is selected then I would like to hide or disable all input fields relevant to CC or Cheques etc, Kindly advise, Regards, Idan
look up formula
I need to some how set a field so that when a store # (i.e 11193) is chosen from the drop down list, it's populates the district # ( i.e. 222) automatically in the proceeding field. I am not in any way good w/ formulas and need help pulling this info from an excel spreadsheet. and please don't tell me to refer to the help guide like the person on the phone did. :) Thanks!!! -Melissa
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,
Next Page