On Add -> Validate issue!
What I am trying to do is the following: I have a form where people can register whether they are coming to the game or not... They have to fill in there name and they have to enter a date. Now I want to check if a user is already registered before submitting the form. Because duplicates are restricted. I use the following piece of code: if(count(Attendees[name == input.name]) > 0 && input.Date == '26-FEB-2011' || input.Date == '04-MAR-2011') { alert "You are already registered for this date."; }
Zoho Creator getURL hangs and does not return
Hi, I am trying to use getURL to integrate with a bulk SMS provider. The following URL (with actual password etc) works fine from a browser http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=xxx&password=yyy&sendername=Rentoys&mobileno=9199999999&message=Hello+World However when I use it with getUrl, the call hangs and never returns. I have tried passing headers (User-Agent etc) and I have tried simple and detailed response. But none of the options return. Is there any way to debug
IF statements and Email
Hi, im just having a issue with the below bit of code. Recipient=input.Email; Kaituna=false; Rangitaiki=false; Wairoa=false; Tongariro=false; Ohau_Channel=false; Hot_Pools=false; Pickups=false; if(input.Raft_Trips.contains("Kaituna River")) { if(!(input.Pickup.contains(""))) { sendmail [ from:zoho.adminuserid to:Recipient subject:"Booking Confirmation" message:(((((((((((((((("<div style="text-align: left; "> <div style="background-color:
Scripting :)
Okay... how would I limit a number of selections in a field? I got the limit of records in an application but having difficulty figuring out how to script a limit to a certain selection: If I am running a clinic and have multiple clinics to chose from in a drop-down menu, how do I limit the number of applicants to one of those choices in the drop down? Learning to script... slowly Thanks for any help
Rearrange the fields in a column chart view
Hi, I'd like to know if is possible to rearrange the fields in the chart view. For example, I have a column chart with 3 columns: Ex, Cx and FO and I'd like to show the columns in these order: Cx, Ex and FO. Is it possible? Thx
Field Notes Suggestion
I would like to see a new option for each field for programming notes. Information would be entered that reminds the programmer how that field is used. This would be next to the Tooltip but does not show on any other screen. Herb Wexler
Is there a way to set a field to hold only Time and not Time & Date?
Is there a way to set a field to hold only Time and not Time & Date?
[t_483991000000106907] Exception occured while setting value in PreparedStatement for the Column
here we go again! WHY DOES THIS KEEP HAPPENING?!?!?!?! Application = Admin Form = Account [t_483991000000106907] Exception occured while setting value in PreparedStatement for the Column [Origin_483991000004844461] Check whether the datatype for this column is given as specified in the data-dictionary PLEASE FIX ASAP!!!!!! We need a way to refresh the form ourselves when this happens...
Group Lookup Field List records
I am using the lookup field (Student Name) on a form that is based on another form that has multiple records for each student. Thus, I could have five records for the same Jon Smith student. In the lookup field it will list John Smith five times. How do I get the lookup field to group the like records so only one record for each student is displayed in the list?
Change nextURL on an embedded HTML form?
Hi, I am trying to create an embeddable Zoho form that collects a user's data and creates a lead before serving them the file they request in the form. I've written a php script that serves the correct file based on a php variable at the end of either nextURL or openURL, but I can't figure out how to change the nextURL parameter with information from the form, and I haven't been able to get openURL to work at all. I would really appreciate your help getting this to work. Thanks!
Set Criteria based on the input of a form field
1. I have a form that I want to restrict the "Lookup" data to that the user is authorized to view. 2. I typically will "Set Criteria" as Distribution_Center == "GLRC". 3. I want to "Set Criteria" as Distribution_Center == input.Logged_in_User; 4. When I do this the Set Criteria deluge script states that "Variable 'this' is not declared. 5. I basically need to figure out how to declare a variable in the "Lookup" field. Any thougths?
Is it possible to add a link to a view in summary form?
Hi Everyone, I've created a view in summary form and I need to find a way to add a link to it. For example, my view is as follows: Candidate: Amy Renoulds Location: London Experience: 3-5 years What I then need is a link underneath: Candidate: Amy Renoulds Location: London Experience: 3-5 years Contact this candidate On selecting the link the client would be taken to our webpage contact form, so the same link would be suitable for all candidates. Thank you!
script not working for regular users
why are my scripts only working for admins and not regular users, i'm finding even the most rudimentary scripts failing with regular users but working fine for the admin?
embeded view open with filter
I am using embedded Creator forms for my site. I know how to add filters for a view and I know how to embed forms. My question is this: is there a way to open an embedded form view which allows you to pre-select a filter, but also allows you to select the other option of the filter while using the view. An example might be better: I have an application that tracks customers and their associated tickets. Tickets are either Active or Closed. From the main form, I would like to add a custom action
RSS feed problems
I'm trying to create an RSS feed from a Zoho Creater spreadsheet, but it's not working. According to the W3D Feed Validation Service (http://validator.w3.org/feed/), the feed is invalid. And, the feed won't appear on my desired reader: http://feedostyle.com. The application is public. Here's what Zoho gives me as the feed: https://creatorexport.zoho.com/westdepere.se/data1/rss/data1_View/ Please advise.
Can not figure out where I'm going wrong.
Trying to follow your Getting Started with Deluge Scripting But I can't find the More Actions as the first screen shot tells me to do. The second (2) screen shot show what I have. I'm thinking it may be the liscence I'm under (Free) but could not find anything about that. Thanks Mike
Zoho Creator + IE8 = SNOOOOOOOOOZZZZZZZZEEEE
Hey everyone, Do you find IE8 runs real slow compared to Google Chrome? Any way to set IE8 to run faster? Thanks, Bartley
Roles for setting permissions
Is there any way to set Roles, so that form and view permissions can be applied quickly across each role, rather than having to do it individually by person?
Form help - Importing data from Client Database form into New Job form
Hi guys, I'm new to Zoho (as of today), so please be gentle... I run a graphic design business from home, and I've created a Client Database form without any problems. However I need create a "New Job" form so I can manage the jobs that come in. One of the most important pieces of information in the New Job form is of course who the client is - so I need a drop-down list that contains all the names from my Client Database form. Is it possible to extract data from one form to another? I was
Help writing a deluge script to store variable based on date and frequency conditions?
Hi everyone, I have a form that tracks participants in a treatment program, and depending on what phase they're in would like to filter a view that shows which participants are scheduled to report in for the week. Phase 1 = every Thursday (every week), Phase 2 = Every 2nd and 4th Thursday (every two weeks), Phase III = Every 3rd Thursday (once a month) I was hoping to see if there's a way that I can create a formula to calculate who will be on calendar for the week, something that would result
How do I aggregate line totals in one file and send that total to a summary field in another file?
Hi, I have two forms, Enter_Transaction & Add_Distributions. The ID field in the Enter_Transaction form corresponds to the Transaction_ID field in the Add_Distribution form. There is a one-to-many relationship between the data in Enter_Transaction and Add-Distribution. Enter_Transaction stores header information about financial transactions (e.g., a payment for 100 USD). Add_Distributions stores line detail of distributions (e.g., 80 USD goes to a rent account and 20 USD goes to a utilities account).
Record not found error
I keep getting this error and I can't figure out why. Can anyone provide guidance? The requested URL /myusername/print-on-submit/Print/Print/recId=659058000000034799 was not found on this server.
Dynamically Change Initial Value in Lookup Table
I would like to display the current lookup field selection as the initial value for the next form data entry. As an example this would be useful if entering multiple time entries for an employee (selected from a lookup table of all employees). This initial value would continue to display until a new employee name was selected. Is there a way to do this with Deluge script?
iframes work in Google Chrome but not Internet Explorer.
Hello All, I have embedded iframes in my website. The website opens well in both Google Chrome and Firefox but not Internet Explorer 7 or 8. Has anyone else had an issue of running iframes with Internet Explorer? Note: we did not have this issue until we tried using precreator. Any thoughts out there in the big world? Bartley
Error in saving the script: null
When trying to save a script (scheduled) I get the following error: Error in saving the script: null. My code is as follows: Entrees_Lexicalisees = Ricci_Droit_Form [Lexique_FR1 != ""]; for each Entree_Dico in Entrees_Lexicalisees { Champ_Termes_Fr=Entree_Dico.Lexique_FR1; Liste_Termes_Fr=Champ_Termes_Fr.toList(); Terme_Chinois=Entree_Dico.CHN; for each Element in Liste_Termes_Fr { if (Lexique_Francais [Terme_Francais == Element && Termes_Chinois.contains(Terme_Chinois)])
Problem with my sub form
I have a function named VerAnimais like this: void animais_do_cliente.VerAnimais (int ID ) openUrl("#View:Animais_view?clienteID=" + input.ID + "&zc_Header=false&zc_Footer=false&zc_DelRec=false","popup window","height=300,width=550") ; But when i call it doesn´t call de Animais_view View with only that clienteID records. In custom actions the argument name is ID and the field name is ID too. When the view opens it shows all the records, but i wanted only the records with clineteID selected. What
How to send an email when a public user submits a form?
My app allows a public user to create a profile including their email address. How can I get the app to send a welcome email to that user? Sendmail seems to be prevented by the restrictions at https://help.creator.zoho.com/Send-mail.html. Thanks.
Adding form by mail no longer works on our service?
Hello, Adding form by mail no longer works on our service? Eric
How do i take a value from an ending value from a field and use it as a starting value the next time i open a record?
Yes, i want the ending volume of the previous record to be the beginning volume of the next record. i have also provided edit access. in our winery every action starts with a beginning volume (bvolume) and ends with an ending volume (evolume). by way of example: Chardonnay beginning volume = 1000 gallons chardonnay filtered Chardonnay ending volume = 980 gallons The next time i open this field, i would like the beginning volume to show the ending volume (980 gallons) from the last action. Can
URL field does not update on deluge script
Hi, I'm trying to use the URL field in a form (in order to access an uploaded file) as stated in the kbase, I'm trying to put On Add & On Edit: input.link = ("<a href = http://www.amazon.co.uk/exec/obidos/ASIN/44764967 target=_blank>Link to Amazon</a>"); But the field stays empty for the user. On updating or saving, the field is still empty (on view). Am I missing something or is it a problem in the system? Thank you, Tal
Automatically populate a field based on previous field's data?
Hi, I am wondering if it's possible to automatically populate a field based on the previous field's data? We are looking at creating a Library Check-in/out system for the students that come in and out of the library at our school. So for example, we would scan the student's id card and the id numbers would go into the Student ID field. Then we would like the student's name to then appear in the Student's Name field - the name would be based on what the id is. I'm assuming we would have to import
new Bug: Validate script on Update does not Run!
In "On Edit" --> "Validate" i have the following test script: alert "nice"; From View I edit a record (same for all forms) press the update button, and the user does not get any message, Please help
How to fix report shows different horizontal alignment for fields?
My report shows different horizontal alignment for different count values: Anyone know why, and how to fix? Thanks.
My forms not appearing in mobile.zoho.com
Hi, Not all of my forms are not appearing in mobile.zoho.com. Forms and views from one application appear correctly, but they don't from another. I built the other application yesterday, I built the new one today. Do I have to do something special to make them appear on mobile.zoho.com? Thanks!
Can I expand/collapse a field in an HTML view?
It seems that javascript isn't permitted. With javascript, I could make an HTML View which allowed the user to hide or show a large field by clicking on a button. Is there another way to accomplish this?
Function not saving even though the code was not changed
When i try to save one of my functions ('ViewMatchingAssets') without having touched the code, it throws an error (a variable is supposedly not declared). The apps name is 'BMPM'. I have granted edit access to Zoho. Thanks for your help. Regards, Filip
html viewでのzoho logoの削除方法
zoho createrで伝票作成のために、html viewを使っています。 html viewの表示をそのままプリントして伝票として利用したいと考えているのですが、右上のpowered by zoho creater の表示が書類に載ってしまうのを消せないかと思っています。 このzohoのロゴを消す方法はないでしょうか？ あるいは、別の方法で、伝票等の作成をしたほうがよいでしょうか？
Have field populate data automatically from previous field data?
Hi, I am wondering if a field can populate data automatically based on what was entered in a previous field? We are looking at creating a Library Check-In/Out system at our school for the students that come in and out of the library. For example, we want to scan the student's ID card which their ID number would get put into the Student ID field and then I am wanting the Student's Name field to then automatically get populated with their name. So when I scan in their ID and jump to another field
Serious issue with Rich Text Fields on embedded views
ZC Team: I've found a serious problem related to the rich text fields, which may lead to data loss in some situations (actually, I've lost some data from a rich text field in a record from an application). Look at the view here (by the way... I saw that the permalink now contains a number instead of the Zoho username - was this an intended change?) It has an embedded (using div tag) form and an embedded view (whcih is a view related to the form above it). Try to edit a record in view. You'll see
Criteria Restriction is not working in Views
It appears that the criteria restriction option is not working for views. I have tried this across several applications and all give me the same error message: "Adding criteria failed. Please try after some time or refresh the page and try again." I have refreshed, closed my browser, and even tried using another browser, but nothing is working. Without this, I am unable to add criteria through the script builder or free flow scripting modes.
Next Page