Currency type in Report incorrect
In one of my Forms I have a Currency Field using GBP £ however my reports show the dollar sign $ in this field. This is very confusing to our users. How can I fix the report so that it shows the correct currency type? Is there a script that I can use? Kind regards, THarrison
PayPal Integration in Creator
Is there any progress on the PayPal integration with Creator? I have a project that is dependent on it. Thanks.
Retrieving various fields from another app
Hello, I have 2 Applications and I want to lookup some information from Form B (Country; Skill & Señority). I have proved a function with one value and that works fine, my question is how can retrieve with a function more values for an selecte employee? Actual Function is: base_de_curriculums.pais.PaisdelConsultor(input.Nombre_y_Apellido); string pais.PaisdelConsultor(string Consultor) { if (count(Alta_Consultores[Nombreyap == input.Consultor]) > 0) { country = Alta_Consultores
Too many emails being sent automatically
Recently i had a user create an application for me. When creating this application i wanted an email to be sent when an account is overdue for service. It works however it is sending me the same overdue notification over 200 times in 200 different emails. Can someone help me fix this, all i need is one email to be sent letting me know an account is overdue
Creating new applications
I am having a difficult time creating new applications. I have created 2 already but now it won't work. I have to copy and paste my spreadsheets because it appears that Zoho does not accept "xlsx" files.
How come openUrl won't open in new window?
Hello: Upon clicking submit, I want to open several google search windows to compare the results of similar searches. Using the code below, ZC will open only one new tab in firefox, and perform each search in the one window, so I'm left only with the final search result, rather than having separate tabs or windows to view each search result. Am I doing something wrong? How can I get openUrl to open multiple different windows, rather than displaying all results in one? Thanks Kenny Google_Search
Creator, Quickbooks and CRM
I would like to create a work order application and integrate it with Quickbooks and a CRM. I have not decided on a CRM yet. My question is how can I get this accomplished? I searched some old posts but haven't gotten any solid information, maybe because I am "programming illetrate". I would also be willing to pay to get the right application in place. Thanks in advance.
Selecting record ID causes type mismatch
I'm trying to have a lookup field with record ID as values; When I go to fetch the record based on input ID selection, I get a problem of left side is type BigInt, right side is text. How can I reconcile this? Thanks, Kenny CampID ( displayname = "Campaign ID:" type = picklist values = {"812592000000125615"} width = 206px on user input { rec = NewCamp [ID == input.CampID];
On success error
Hi, I'm a newbie trying to get one form to update a date list in another on success. The form I'm trying to update is a Vendor form. The form I'm submitting from is our monthly meeting form. We can use multiple vendors at each meeting (Vendor 1, Vendor 2, etc). I want the Vendor page to include a list of the dates that we've used them (so in the Vendor view I can link back to the monthly meeting view for that date to get more details), but I only want one date in that form, no matter which vendor
Can a form query be a variable?
a user inputs desired search query field (Search) (ie. RefUSA_Data[((!Company_Name.contains("Envy") && State == "CA") && Website != "") ) Now I want to execute the search - something like: rec = Search; or if (count(Search) >0); { } Can anyone please tell me the syntax to make this happen? Thanks! Kenny
Major Problem with Form
I had spent a very long time on an application form and was about done when I decided to change the color of a multi line field. When I typed in the HTML code, I made a small mistake. This is what I typed in: <font color="blue>question</font>. I pressed enter without noticing the mistake and the entire form got messed up. The question seems to have split into multiple fields and is seemingly connected to all the fields below it. If I try and move one of the connected fields they all move at the same
Error occured please contact application owner.
While trying to edit one of my entry I am getting pop-up Error Invalid entries found. Please correct and submit again. The above error general comes when I missed out any mandatory field but when I recheck I haven't found any thing wrong. In addition what ever changes I do in form, it gets applied (when I refresh and look in the view form) and the error pop-up comes, how is it possible?. I have trigger email while editing, I'm not receiving the email. This issue only happens while editing the
Cannot modify forms or import data!
For nearly 2 hours, I've been trying to import a single row into a new form with no success. If I create the form via import xls, upon submitting it goes to an error page stating 'something went wrong, we'll look into it' If I create the form and attempt to add my fields via free-flow-script editor, it looks like it works, but when I return to the form, none of my fields are there! I've tried creating a new application, and a new form, in case that would work. But it doesn't. I'm shut down :(
Assigning font color to users???????
Is anyone aware of how to (or is it even possible) to assign a colored font to each of my users so that when looking at comments I can see which one typed the entry if multiple users are using the same box?
Font Size in Multi Line box
Hello, how do I go about changing the font size in a multi line or single line box so that it is larger in grid view. I'm aware of the ability to change themes etc, but the font size option does not seem to effect these said boxes. Thanks Stephen
How to create a picklist from a multiple select lookup?
I am using two forms. Contact form with the usual fields and an invitation form. I have a two fields in the invitation form. One field is a multiple select lookup field so I can choose the related contacts for a particular invitation. The second field I want to pull all the addresses of the respective contacts of the first field and be able to select just one address to send the invitation to. I tried using the following script but run into an error saying the the left expression is a string
How to make a new view from selected records??
Hi to all. Can anyone tell me how can i make a new view from selcted only records within a view? I have made a booking system and i need to seperate selected records from a full list of bookings and make a new view from them.The new list has to also give me the totals of some columns as in the full booking view.Those selected records i need them to get erased automatically from the old view then when transfered to the new view. Our company makes transfers with coaches to selected destinations and
Please help newbie - easy question re: why can't I display my list data?
I'm trying to identify duplicate records in a form. If I run the sample dup finder htmlpage as below, it runs with no problem. But, if I add any way for me to know the resulting duplicate records, I get the following error: Error occured while executing the script.The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. Here's the version that runs fine, but gives me no access to the results: htmlpage test_dup1() displayname
How to create automatic email for interview in which I can customize the date, time, and location of interview.
Hello everyone. I would like to implement an automatic email that allows me to quickly send a customized email confirming the date, time, and location of interviews. What is the best way to do this? Please advise. Thank you!
Need Help Fetching Records between a range of Last Names starts with Letter
Hello, I want to use the Bulk Mail example script but convert it to sendmail to a range of start with letters. For example: sendmail if records fetched Last_Name startswith A through L. Example Bulk Email Code: emp = Employees[(age > input.age_1 && age < input.age_2)]; users = ""; for each x in emp { sendmail ( To : x.Email From : zoho.adminuserid Subject : "welcome" Message : "" ) users = users + " -------- " + x.Email; } info
Activity view in Count summury
Hi, it would be a great thing, if, in the summury's count, i could choose colomns i want to display. At the moment, colomns : Objet Type d’activité Statut Date d’échéance Date&Heure de début Date&Heure de fin Nom du gestionnaire Heure de modification are display, which is to much in order to be effective.. :/ Isn't it possible to delete some colomns for the display ? Thanks, and sorry for my approximative english level. Nicolas
can't save as script / can't duplicate
I must have something in my code or configuration that is making it impossible to save my application as a script or to copy my application. My priority is to save the application as a script (.ds file). I have a second app under the same account and everything works fine there...save as script and copy my application both work - so it must be some corruption in the other application. I have already shared the application with support. Here is the link.http://creator.zoho.com/skittlebiscuit/copy-of-lice-happens/#
Hide url form path
Hi, I would like to know if it's possible to hide a URL of a form. ex : https://creator.zoho.com/misca/c***********/form-perma/R*********e/ID=10006375 i want to hide ID parameter. Thanks a lot! Rafa
Find & Replace Bug
NOTE: I changed this topic from a question to a bug report: Read on... An http post response returns the following example XML <ListVerifiedEmailAddressesResponse xmlns="http://ses.amazonaws.com/doc/2010-12-01/"> <ListVerifiedEmailAddressesResult> <VerifiedEmailAddresses> <member>bsmith@example.com</member> <member>charles@example.org</member> <member>david.williams@example.net</member> </VerifiedEmailAddresses> </ListVerifiedEmailAddressesResult> <ResponseMetadata>
My Deluge commands automatically changed ...
I was editing a code section (in free flow mode) when I noticed several Deluge commands of the form ... thisEnvelopesColor = ifnull(thisOrderDetails1Record.Envelopes_Color,"");I did not code this command ... I believe I used ... thisEnvelopesColor = if(thisOrderDetails1Record.Envelopes_Color == null,"",thisOrderDetails1Record.Envelopes_Color);a) when did this change take effect ? ... I do not see any notice of this change in any of the documentation. b) what is ifnull ? ... I searched
Manufacturing Database
We are a small workshop needing to replace our paper based order tracking system. This would ideally link to excel, or have a downloaded excel database from which it could draw records etc. Does anyone know of a solution that is similar, or can help develop one. Thanks.
Convert Text to Number
Ok, what I need to do is this: I am grabbing XML data into text fields. Most data is text, but some is actually numbers. I need to be able to take two fields, which are text, but are "decimal text". By this I mean the data is stored in a text field, but its stored in decimal format. For example - in my field called "text1" the value is 907.52 - in my field called "text2" the value is 925.72 I need to convert those text fields into integer fields, and remove everything to the
Record ID and Stateless Forms
I have an application that has a couple of issues, The application has 1 regular form "Data_Form" and 6 stateless forms that report back to it ( "Alpine_Farm" "Kennet_Farm" "M_J_Farm" "Phase_1" "Phase_II" "West_Grove_Farm") there is only one view "Compost Batch Records" there is 6 custom action buttons in this view, 5 of which are used to edit the corresponding farm section in "Data_Form" ("Edit P2" "Edit KF" "Edit AF" "Edit MJ" "Edit WG" ) what I need to happen is: 1.when the custom action
Additional info input from radio buttons.
Would someone please point me in the right direction? I am looking to use a radio button with yes/no as the options. When yes is selected I would like an additional text box to popup which allows for more information to be input. Sorry if this is a simple question. I am a newbie and have been searching through the help pages to no avail. TIA Bill
How to invite via creator sent email
I have events on a schedule that would be great for people to be able to accept or decline the invitation by email click on link and acccept or decline without logon, any ideas?
Zoho Favicon Appearing
Hello, Due to the issue around the iframe height hard coding I am embedding using the JavaScript equivalent. However, one of the effects of this is the Zoho Favicon is displaying in the results window. Do you have any ideas on how to prevent this, aside from switching to the iframe code? Thanks
Calling Functions Within Functions
This is my script for my function: void both.AlpineFarm(int Id1, int ID) { ter = Alpine_Farm[Id1 = input.Id1].Id1; tep = Alpine_Farm[Id1 = input.Id1].ID; if (ter = null) { thisapp.add.AlpineFarm(ter); } else if (ter != null) { thisapp.edit.AlpineFarm(tep); } } When I try to save it, it gives me the following error message: Encountered "." at line 7, column 20. Was expecting one of: "(" ... "(" ... "(" ... "(" ... "(" ... "(" ... "(" ... "(" ...
Can you join forms...(adding multiple items and quantities to an order)?
Hi, I am creating an item ordering application which is created by the customer and can include multiple line items. For an example; STEP 1. CUSTOMER A will begin to create an order by providing basic details e.g. NAME and LOCATION. STEP 2. they will then confirm the items they wish to order (from a catalogue of around 2000 items). They select ITEM A and enter the requested QUANTITY. They then might need to add ITEM B to the same order and ITEM C, D, E etc.... These orders can sometimes end up up
How can I make a field Conditionally Required?
I have a checkbox 'Place Order' If this is checked, I want to show and require field 'Payment_Information' if unchecked, I want to hide and not require the Payment_Information field. It's easy enough to conditionally show / hide a filed based on a condition, such as in the show-hide fields wiki example: But how can I also make conditional the required attribute? Thanks! Kenny
Continue balances from one record to another same client???
How can I continue a balance from one record to another? For example: A client that makes a payment. How can the balance from that payment transfer over to the next payment that the same client makes?
Using year (yyyy) from date field
Hi everyone, I want to know if possible from a date field to take only the yyyy portion and store that into another filed, let say a number field. I have a form with Invoice Date (i.e. 30 April 2011) and want to store 2011 into other field, can someone tell me how to do that? Thanks a lot.
Default entry in field
I created a form in Zoho Creator and imported a .xls spreadsheet with the following fields: telephone number name address city state All of these records are empty with the exception of telephone number. I would like to know how to show the telephone number in the form by default.
Fetching the NEXT record
Can someone explain to me how to do what must be a common requirement (I'm New ) . . . I have a form & View (let's call them the original Form) and want to create a new form that I can 'page' through the records in Original form. So I guess I need a Next & Previous button on a 'Stateless?' form. Then how do I get the buttons to get the Next or Previous records?
Create record from html view
Hello, I would like to know if it's possible (and how ) to add records using a html view as if it was a custom made form using html input elements. Thanks!
reports not showing all records in table
Hi, For some reason, looking at a view of one of my tables (MyResponse View) displays "x" number of records. When I access the table via either of two reports (My Studies - Diet Type Frequency or My Studies - Exercise Type Frequency), most records are not displayed. The discrepancy between records displayed when using MyResponse_View and either report is significant. I have deleted any filters the reports were using without success. I have regenerated the reports without success. I have deleted
Next Page