I have set a scheduled email for a specific date, tried to execute but I get an error, what am I missing?
The error message is Execution Failed Error details: Error in executing form schedule(Form Schedule). Error. Error in executing Send Mail task. To Address is NULL. The function is below SendMail [ From : zoho.adminuserid To : input.email Subject : "Subscription update" Message : "Hi " + input.First_name + "<br />\n<br />\nJust a quick not to say your subscription is coming to an end and wanted to check that you still need access to the proxy server<br />\n<br />\nRegards<br
First line of code gives error
I have used this code for 3 years and now it gives an error If(input.Owner_Offering_Trade == "Keith”) Error when I try to edit: Error at line number : 1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression What do i do?
quote a column in HTML hyperlink
Here's a part of my code below, <p align="middle"> <a href="<%=y.Map_Link1%>"> <%=y.Name%> </a> </p> <p align="middle"><%=y.Map%></p>An example of expected output, two lines for each of the record, both contains hyperlink XXX school (name ONLY) XXX school map Map_Link1 is a column in my form contains all the Google Map addresses for each of the schools. I don't know what to change in order to make the href part to work. Here's a wrong output I have. 75th Street Elementary
File uploader tool has stopped working
I can no longer access any of my Zoho accounts through the File Uploader tool. Do you know any possible reason for this? Earlier it was working but now i am not able to login into it. Your team has suggested us this tool to bulk uplaod the files from the hard drive via an exe file. You have provided the below given link to us to download it :- http://code.google.com/p/zohoclient/downloads/detail?name=FileUploader.exe&can=2&q=
How to set up a detail Records Count?
I need a quick report of how many records per form I have in database. How do I set this up?
Call Function with CRM
We have a "Product List" app in ZCreator and when we add/edit/delete a line is this app we want this data to push to "Products" module in CRM. I seem to have configured this correctly other than on edit and delete I can not access the unit price field because it is not a string field. I have been editing the app and On Edit -> On Success -> Call Function (Integration Task) with CRM -> Update Recod Thanks for any help
Confirm nessage before executing a custom action
Hello, do you know if it is possible to add a classic confirm message before executing a custom action? Something like a javascritpt confirm "Are you sure?" (Yes or Not). Thanks
Using 1 field to pull multiple fields from another form
Hi, I am very new to this program and I'm hitting a few roadblocks. I'm trying to look up a name on one form, but I need to pull a few items that is in the record into my existing form. For example, in the first form, I am using a look up to find the doctors name that is is the second form. Along with pulling the doctors name from the second form, I want to pull his credentials and city and state into the fields and prepopulate those fields in the first form. Help! Thanks! Trish
Import File Exvel
Anybody know what is the limit of records that can be import from Excel file? I need to import a document with 19000 rows in Excel and I'm not sure if Zoho allow this.
Deleted data
Is there currently anyway to retrieve any data once deleted? Can I become a paying customer and then have this service?!!!!
Deluge Script Disappearing in HTML Views
Hi, First time I have used HTML views was yesterday and I was finding them very powerful and had screens working perfectly, however this morning I have looked and lots of the deluge code is now missing! Seems to be the <%=rs.X%> in the cells of tables. I am using Chrome on a Mac. Has anyone had this problem? Thanks Gordon
Need to combine 2 fields together
Hi, I am trying to merge a date (Start_Date) and a time (Start_Time) field into 1 field (Start_Date_Time). I need there to be a soft return between the Date and Time in the combined field. So, first, what kind of field do I use? I am using a multi-line field so I can create the soft return in the field. Any help would be appreciated. Thanks! Trish
Is this kind of workflow possible with Zoho Creator
I’m currently evaluating Zoho Creator and am just wondering if you could point me in the right direction. I have a process I’m trying to move out of lotus notes. In a nutshell: User fills in a form with a few details: Product name Product supplier Price This form is then sent to a department for approval. If they approve it, they add a code (free type) to the form. The form is then sent on to yet another department, who do something else with it. At this stage, we need to save a copy of the completed
Editing the email contents in automated email notifications
I'm trying to setup a form to notify different email addresses based on the zip code entered in the form. The email notification needs to have the form data in the email body. I try to update the email notification with the HTML code below but it doesn't save. Name: <%=Name%><div><br></div>Email: <%=Email%><div><br></div>Zip Code: <%=Zip_Code%><div><br></div>Phone: <%=Phone%><div><br></div>Contact Method: <%=Preferred_Method_of_Contact%><div><br></div>Service Needed:<%=Service_Needed%>
SMS TWILIO
Hi, I am trying to send an SMS to patients to tell them when their medications will be delivered. I want the message to read: "Your medication is scheduled for delivery on input.Date_For_Scheduled_Delivery. Then I want the message to read as follows. To cancel or reschedule text back. 1= CANCEL 2 = RESCHEDULE TO NEXT DAY AFTER SCHEDULED DELIVERY 3 = RESCHEDULE TO TWO DAYS AFTER SCHEDULED DELIVERY I want all these 3 options to be on different lines. Here is my code below. I don't know what I am doing
"You are not allowed to access this application."
I created an Application with user A. I've shared it with user B. User B can see the application when she logs in but when she clicks on the app it say: "You have logged in as <userBemailaddress>. You are not allowed to access this application." The user is active on the zoho creator settings page. All the forms are shared with the user. I've tried to remove the user and all of her permissions and re-add but still no luck. What is weird that it was working yesterday.
Deleted information
Can I recover deleted information from the database? I deleted 4,000 titles by accident.
default field entry
how can I have a default field entry for a new record be the same as the previous record? Thanks in advance
Beware of Editing the Form Definition!
The form definition is found under a form's workflow. There are two options to view and edit it: without action, and with action. With action shows all the submit code and on-user action code. Without action just shows the underlying form fields. I just discovered that if you edit a form definition's "without action" part and save, ALL the SUBMIT/DELETE code is deleted. There is no warning about this effect nor an option to revert to a saved version. Unfortunately, this has set me back a few hours
Grouping application names by folder
How about making it possible to group applications into folders when they are viewed in your sign-in windows in the iphone app as personal apps, shared apps, workspace apps. If you have created a lot of apps, you have to scroll to see the rest of the apps. The apps are arranged in the order in which you created them. That means that a new variation of a certain app will be placed far from the app it is directly related to, because the original app was created earlier. For those developers who create
Scanning QR codes or Bar Codes to input data into form
Can you load a form, then scan a QR code so it then inputs the data into a field? Please help, if this is possible it would be of massive benefit to our company.
Customizing published report and form to mobile friendly.
Hi. As stated above, is there any where to make published report and form (especially report with long field column) to be mobile friendly. This is because the publish thing is not for us to use and we are aware that most of our customers are using mobile phone to browse alot. Thanks
help on for each
Hello everyone, I need to detect the inserted records a day by a single name. So I have: Form1 : name Form2 : name lookup + another field so , for each rec in Form1 And here ... I should tell him to count me the number of records for a single day but I do not know how many are the days .... Ideas ?
Warning! All your profiles are inactive.
Just upgraded from free to standard and now my users cannot access the app. It is shared and they are Admins. My project has come to a standstill. I see this error dialog "Warning! All your profiles are inactive." and the users see "You are not allowed to access this application. Please click here to login as a different user." when they try to login.
Zoho Creator - HTML view used as a form with javascript
Hello, I'm wondering if it's possible to create a HTML page View that would be used as a form with javascript? I would write in that page: <script> function myFunction() { //send request to external website (or ZohoCRM) and receive response data //if ok then: alert("Your request was successfuly processed!"); } </script> <form ...> <input type="button" onclick="myFunction()" value="Submit" /> </form>
Time and date format
Is it possible to change the time & date format to 24 hours instead of am/pm ?
Overhaul the SendMail Function to Allow for Easy HTML and Templates
I have been using Zoho creator for a while and it seems that the system to send email is VERY clunky. If I want to send HTML, I have to replace every " with a ' and other little tweaks. The Deluge and html do not work well together. Do you have any plans to overhaul this? I could envision an HTML template area where all you do is use your refer fields to add the dynamic content. This would be a GREAT and much appreciate upgrade. If not can I integrate with a transactional email program like Mandrill?
Send One Email for Several Records
Using the scheduler, is it possible to send one email instead of individual emails for records with the same criteria? i.e.: When three records have not been entered by the user yet by the due date, send one email for all those records.
Using the Date field
Hi, This is my first time working with Zoho creator (or any service of the kind, for that matter), your assistance will be highly appreciated. Some of my records have an exact date, and some only have a year. I can't seem to be able to use the "date" field, because it doesn't accept those with just a year as a proper date format. I would very much like to use the date to field for better search options, instead of just making it a one-line field (won't take numbers too, because then it says that
Creating a Relationship Between an App in Creator and CRM
How do I go about creating a relationship between a from created in Creator and Contacts in CRM? I want it so that when I submit a form for a customer, it will be listed under their name under contacts. Thanks
Import Data into Subform
Hello, I've already thoroughly researched this topic within the site, including https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095, to no avail. Does no one have a simple solution to this problem yet? I cannot import data into my subform, only my main form. Note: The fields that are receiving the data in my subform are lookup fields
How do I grant admin rights to another Zoho Creator user?
How can I grant admin rights to another user of our zoho creator? There are two of us who use are currently using it, I am able to edit any of our applications while the other can not. The application is shared with the other user, and they can access it and enter data but they are unable to edit the app. We are currently using the free version of Zoho Creator. Do we need to upgrade, or is there a step I have missed? Thanks!
android
Is there a form of ZOHO Creator for Android ? If so, where may I find a download ?
interaction subform fields
Good afternoon, how to get the index of a row in a subform. is possible in a subform add a field having the conditional in another field. For example: row1 = field1 = 1.1; field2 = computer; field3 = 1000 row2 = field1 = 1.1; field2 = notebook; field3 = 1700 row3 = field1 = 1.2; field2 = brick; field3 = 50 to sum the values in the subform field3 if field1 = "1.1" another query could delete a row subform via script thank you
How can I add a table into a form?
Is it possible to add rows and columns into a form that looks like a table where people can enter text and numbers?
changing spacing between fields
Is this feature available with Zoho Creator? Is so where? If not is there a workaround? If not, is this feature being worked on? Thank you...Allen S
How do I push data from a Creator form to my CRM?
I have a number of enquiry forms on my site and I want them to automatically create a lead within my Zoho CRM. I have been reading through all related posts and can't come up with any answers to this question; is it even possible? I am new to this system so please forgive me if it is a silly question and if possible keep answers simple, I am hoping not to need a translator! Jade:-)
Add new record by clicking the name of record
Hi...i am a new user to Zoho:) I am poor at coding but have some experience with ms access.Ok, i want to ask whether it is posibble to add new record by clicking the name of the record. Let say i have to table Form A: List of services (To show all services of my organization) Form B: Related to the services but it a rating form to the selected service So i make a report base on Form B but showing only item in Form A,List of services so that user can add record to Form B,rating the selected service.Is
Send Mail to Added User NOT Modified User
Hello, So, I'm trying to write a short script where users adding data into our forms can receive an email if it was approved by the administrator. This is what I have, if ( input.Approved ) { SendMail [ From : zoho.adminuserid To : zoho.loginuserid Cc : Bcc : Reply to: Subject : Description + " has been approved!" Message : "Your message" Language: English Content type: HTML Trim tags: true Attachments: ] } The problem with this code is who I'm sending
Backups won't Restore
I get the following when i try to restore any backups com.zoho.workengine.parser.exception.PopulateException: Error at line number : 2560 Number of arguments mismatches
Next Page