Error message with an embedded form
Additionally, I would like the information from the website form submitted to go directly into a particular view, but not sure how to make this happen. Can you help ? ------------------------------------------------------ Hi I've made and embedded a form in one of my webpages. I tested it and it came back with... " Error details: Error occured while executing on click script. " Can anyone tell me what it means exactly and how to put it right ? Struggling to see, having followed the set up instructions
Alert not working
This is not working since your update if (count(Customers[Address == input.Address]) > 0) { if (input.Input_Type = "From Job") { alert("This address is already in the database, click ok to go back to the job form"); rec = Customers [Address == input.Address]; input.Address = rec.Address; openUrl("#Form:Job?Lookup_Customer=" + input.Address, "same window"); } else { alert("This address is already in the database, click ok input another
postUrl not working
I always get internal exception from postUrl,can anybody help me?the script work well several days earlier. helloworld = map({ "Airway_Bill_Number" : input.Airway_Bill_Number }); result = postUrl("http://vytalhost.com/zoho/shipmentValidation.do?Declared_Value=" + input.Declared_Value, helloworld); I'm sorry,but I,m dying to solve this problem,please help me.
Report's Problem
Hi! My reports don't function. I see the message: An page's script cold be stop answer or in exec... Script: https://js.zohostatic.com/db/Jan_27_2012_1/compressed/ZDBGridView.js:1578 All my reports don't function since 26/01/12. I Can't create a new report too. Can you help?
Custom Actions - Select E-Mail Notification
Hello Zoho Community, How To Have A Custom Action in View That Sends E-Mail Notification Where You Can Pick The Column Range Like 1 - 50? Looking Forward To Your Help. Thank You.
ALERT MESSAGES "http://www.zoho.creator.com" and your message goes here "bla bla bla"
Enclosed are pictures of my desktop. You can see in Picture 1 regular ALERT MESSAGES where "http://www.zoho.creator.com" said something DOESNT appear. Also, you can see in Picture 2 in ZOHO ALERT MESSAGES, that claim: that "http://www.zoho.creator.com" said your message : " bla bla bla". This wasn't like that a few months ago. Zoho suppport and zoho sales will always reply: Yes great idea, we will consider this in further updates.
Urgent! I can't direct my survey results to our e-mail gruop
I've created a survey with creator, when candidates submit the survey i want to see the results on my hr mail group. How can i forward to my e-mail account. Previous admins of this account did that, but i can't do it. Can you help me please? Berna A. Kartaca
Lost all my Content
Help. Logged in a few days ago and all my database content is gone. Forms are still there but data is missing. Has it been compromised or is it a technical issue? In Canada. Lost important data. ------------------------------------------------------------------------------------------------------------------------
Displaying PDF files in a view
Hello, In my application the user can create a drawing and upload a .pdf file that has the technical data on it. Is there a way I can view or create a view that shows all the different drawings in a grid form, so the user can browse all the drawings easily and then select the drawing they need? I have seen a sample application using JPEG images but unfortunately I need something that works with PDF files. Many thanks Ben
No response from ZOHO Creator's Support Team to repeated email enquiries
Latha: 1) On Jan/16, I emailed you with a follow up question to (Yoge's long delayed) response to my original enquiry of Nov/23. 2) On Jan/24, I emailed you again ... asking for a response. 3) On Jan/30, I emailed you yet another reminder. There has been no response from you to any of the above emails ... why is that ? ... and when can I get a response to my enquiry that my client is waiting on ? As mentioned to you before, the client whose needs originated my original enquiry in November, already
When do these options become available? or never?
Hi, for one thing i dont understand why Zoho CMS not yet include 2 basic things: 1. Lock Record To lock a record, i now use the Lock ID form. but if a user clicks on Edit, and click cancel, the record is still there in Lock ID form, meaning the record is still locked. b/c there is no Action on Cancel. this work around only works with Action on Success. so a work around is to have custom schedule running to delete records every interval needed. now i have to come up with a bunch of lead time for bunch
Latha ：Urgent need of help..
ZC team: I have a business application needs: 4s in China's auto shop to read specific data in their databases, ZC have a way with their database docking? Have any suggestions or solutions? The means is ZC is there a way to get data from external databases? Thanks and waiting your reply Stanley Guo 2012-01-31
Similar script produces error
The application in question sends an email "on success" to the end user. Subsequent follow up emails are sent over the next few weeks using an "on load" script. I have been trying to add a script which continues to produce an "on load" error. This is the script just before the new lines I am attempting to add. It works fine, as do the scripts above it. (NOTE: I have removed the email content so that this post doesn't exceed character limit). else if ((lead.Added_Time.addDay(30) < zoho.currentdate)
Fetch data independent from capital and accent letter
Hi, anyone may suggest how I can use a capital and accent letter criteria when I fetch data to prevent duplicate in my database? Here the topic whit criteria suggested. Thanks Mic
Re Chinese version of the synchronization
Hi Latha Hope to the creator of the new features with the Chinese version of the synchronization, for example, create a report directly to thecreator, etc. Thanks Stanley Guo 2012-1-29
Urgent help! Changing a field type from 'Single Line' to 'Import Data'- will I lose previous entries?
Hi everyone, I'd like to take advantage of the new search and auto-complete function in creator. I have a 'Single Line' field that I'd like to change to an 'Import Data' field. Will I lose the data from previous form entries if I do this??? Thanks!
On Load View - Check Fields & Input Value
Hello Zoho Community, On Load View I Would Like To Check Fields & Input Value. FOR EXAMPLE: When I Click On The View. It Will Auto Check Each Record If Current Date Before 1 Month > Membership Expiry Date Then On Input.Status Show "*" On Load View For Each Record If zoho.currentdate (BEFORE 1 MONTH) > input.Membership_Expiry_Date { Input.Status = "*" } Looking Forward To Your Help. Thank You.
Custom Action - E-Mail Notification + Input Current Date
Hello Zoho Community, Custom Action To Send E-Mail Notification + Input Current Date. void email.EmailNotification(int toaddress) { sendmail ( To : zoho.adminuserid From : zoho.adminuserid Subject : "Subject of the email" Message : "Your message" ) input.Sent_Date = zoho.currentdate; } Looking Forward To Your Help. Thank You.
Sub Form Field Validation ?
I have a subform where I have set a script for converting the contents of a field to 'Upper Case' input.Product_Description = input.Product_Description.toUpperCase(); And when I access the form directly, it works really well - and I can add the script to On Add, On Edit, Validate etc..doenst seem to matter... But when I enter data through a master form, that has the first form embedded as a subform, the field criteria are not inherrited, so the data entered does not get converted to Uppercase....
select criteria query
I have a form for a 6 month period, January-June. If a student comes in January, I mark the appropriate dates with a '1'. If the same student is absent all February, for example, I mark the dates with '0'. I set the criteria for all months to read 'display if date columns equal 1'. Of course, it displays the student for January, but I expected it would not display that student in February, however, it does. Is there a way around this ? Thanks for any advice.
Field Actions - On User Input
http://help.creator.zoho.com/Field-Actions.html "The On User input script will not be called if there is no change in the value of the field (i.e if the new value being set is same as the old value." This implies to me that I should be able to make a change to a field On Load and expect that field's On User Input to be called. Through all of my testing I have not been able to make that the case. How can I make On User Input code be called as a result of changing a value in the form On Load?
see only selected records (updated)
I have 3 forms the first form is called "Car " single line "Automobile Make", single line"Model", single line"colour" single line"unique ID" (database driven) Each Automobile has 5 wheels and tyres hence 2nd form is called "wheels" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile Make" single line" Wheel1, single line" tyre 1, single line"wheel2, single line"tyre 2, etc etc Form 3 is called "emissions" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile
Update with ' symbol
Hello I would like to update a field with ' symbol Here is my request : <FL val="2ème ligne d'adresse"><![CDATA[${sdme_ligne_d_adresse}]]></FL> Zoho response shows that the update is succesfully done but nothing is done in zoho Can you tell me how to add a ' (apostrophe) symbol ? Thanks for your help Regards
No hyperlink for underlying data in ZOHO creator report / chart
Hello i am a ZOHO creator enterprise edition user i have created some reports / charts for my colleague but only the Admin user can use the hyperlink to see the underlying data could any one show me how to share charts with underlying data enabled thanks regards, Matthew
Custom Action showing on clicking on view
I love the new feature of being able to put a custom action in any location on a View. However when I click on the view button to the left of the record the custom action shows as a field label. Apparently it pushes the other field names down on the list so the data associated with the field label is offset by one. If the view is: Field1 Field2 Custom Action Field3 Field 4 Field 5 Data1 Data2 Button Data3 Data4 Data 5 Then the view is Field1 Data1 Field2 Data2 Custom Action Data3
Why not provide "break" keyword in Deluge scripting?
Hi there, Why not provide "break" keyword in Deluge scripting? In many cases, I've to imitate "break through out loop" function like this: for each r in form { processed = false; if ( !processed && conditon ) { processed = true; process(); } } If Deluge scripting provides "break" keyword, I can just implement it concisely as following, just like other high level languages, such as Java for each r in form { if ( conditon ) { process(); break; } }
Field Number
Hi, anyone may suggest how to display in the number field the zero (0) at the beginning of the number string? And also, anyone know if exist an option to format the number as this example: 000.000.000-00? Thanks!! Mic
Testing Scheduler?
Is there a button to test the scheduler? In other words once I've created the schedule is there a way to cause the event to trigger without waiting for the clock to roll around to the time of the event? Herb Wexler
Need help with null values
I have two fields that I want to add. Deposit 1 + Deposit 2 = Total, however one or the other might not contain a value. How do I get it to add to give me a total if both fields are not completed?
Update Links in Help Center
Am hoping that by reporting these it will help others also 1) https://help.creator.zoho.com/Deluge-Reference.html Cant find the link from the help center, the only Deluge link goes to https://help.creator.zoho.com/developer-guide-home.html 2) https://www.zoho.com/creator/help/script/aggregate-records.html not in the table of contents for Zoho Creator Help Center > Deluge Developer Guide > Statements > Data Access >
will the ical feed work with 30 boxes?
Unfortunately, Zoho doesn't have a robust calendar for scheduling, so it has referred developers to Google Calendar. I (and a number of others) am very unhappy with the Google Calendar and am trying to find an acceptable alternative. I have heard 30 boxes is a much better calendar that google, but I can't seem to get the Zoho generates iCal url to work in 30 boxes. Do you know if it will work with 30 boxes or not? If so do you have any tips on how to make it work with the zoho generated ical feed.
ZC there any way to get SQL or ORACLE data in these databases?
Hi ZC there any way to get SQL or ORACLE data in these databases? Thanks Stanley Guo 2012-01-29
Stateless buttons not wrapping in IE 8 & 9
When I embed a stateless form in a website Internet Explorer does not wrap the form to fit in the space. Firefox & Chrome will wrap to fit in the space on the website. In IE 8 & 9 the buttons do not wrap and the form is truncated. I attached a document with screen shots. Is this an IE bug or is there some code I can add to get the form to wrap to fit the space? Herb Wexler
Add calendar by URL to Google Calendar Failing Again
I read the previous discussion and resolution regarding this problem this problem, which apparently occurred about a year ago. I am having the same problem today. I suspect the problem has come back again. I am using the example provided by zoho. The iCal url posted in Google is as follows: https://creatorexport.zoho.com/acalver/mycal/ical/CALDATA_View/DTSTART=STARTS&DTEND=ENDS&SUMMARY=TITLE&DESCRIPTION=DETAILS&ZC_FULL_DAY_EVENT_VAR=ALLDAY Google returns the error: The address that you provided did
Lookup field doesn't update the value
Hello Team, After that migration of Lookup Field there are few records in which the Lookup field value doesn't seems to be update. Application: Penta CRM 11 Form: TO DO Form Record url: http://creator.zoho.com/piju2111/penta-crm-11/To_Do_Form/record-edit/All_Records_of_TO_DO_Form/190193000006486043/ When you open the above url it show the CallStatus feild as "Scheduled" rather we tried twice choosing "Closed" and submit the form. * Edit access given to support
Sub-forms in sub-forms
Hello, I have 3 forms - Machines, Drawings and Works Orders Works orders has a look-up field to drawings so you can select the drawing number for the order (as well as other fields in the Drawing form). But the Drawing form as a sub-form which links to Machines. This is where information is store for how the part is made and times, etc. Under my view for Works Orders - I can't get it to show up the relavant fields from my Machines form (the sub-form in the Drawings form). Is there a way to display
Lookup Forms Issue
I'm on my trial and I have an issue that is a kicker to determine going forward. I'm setting up a business process that each form will build on a previous form's submitted data. Form 1 - initial input to start process Form 2 - management form, to be used to accept what is in Form 1 - this form uses a lookup field to get "Name" from Form 1 Form 3 - is the next set of criteria that "Name" will need to go through. (HERE IS THE PROBLEM - see below) Form 4 - another management form to determine going
Adding links to Edit Form and Pass Value
I have a relatively simple DB schema. I am building an application for a charity auction. There are multiple bidders, each of whom will likely bid on and win a number of different items. We won't know the price they will pay for an item until the auction is over. At end of the auction, we need to list all of the items that each bidder won and total up how much they owe. There are 3 tables: (1) Bidders. While there is information here like name and contact info, we are concerned with 3 fields:
Need to fetch a record from another application
I understand that ZC does not support fetching records from another application. Sadly, I'm new to ZC and don't understand the nuances of building functions. I have an application called Common Lists that contains multiple forms populated with common data for an organization (e.g. Employees, Departments, Accounts, etc.). I want to build a suite of applications that share the common data in the Common Lists application. For example, the Purchase Manager application has a form called Requisitions.
I created a form. How to prevent people from viewing the database of records?
Hi, thank you for this useful tool. I just created a form and made it public. How do I prevent people from viewing the inputs made by other people? Currently the records can be viewed when the people clicked the database view. All advice will be greatly appreciated. Thanks!
Next Page