Having trouble with email rule
I have a checkbox set up, I will give an example of 3 options for a field called "Drivers" Jim Sue Thad I want each selection to email a notification to the specific person included. This works if you only select 1. Unfortunately if I select more than one it seems to break my rule and doesn't detect it. For instance....If I set up a task for emailing Thad when it is selected and the form is sent, if Thad is only selected it will work but if I have Sue and Thad selected it wont. I'm sure I'm just
Is it possible to have validation on insert of record that checks if field value exists in another form?
I want to do something like have a validation that on insert of record into a form of field for email address checks if the email address value exists in another form. If the same email address does exist in the other form, I don't want it to consider inserting the new record. I've been doing some research but still not quite clear if this is possible? Would appreciate any insight. Thanks
Page is pubished and so is the report that it uses but can't view it without login
I've been struggling with this all day, I have a support request open too but haven't gotten any traction. I have a page here that can't be viewed without login even though it is published: https://creator.zoho.com/rickdane/stacksavings/view-perma/testpage The report that is in the page is also published. What is the issue?
Is there any problem with the Sendmail and HTML?
Dear All, Is there any problem with the sendmail in Zoho Creator and the HTML? One of our HTML templates is shown like plain texts in all our mail accounts clients. We test it with a simple <div>Hello World</div>...It shows it as plain text in Zoho mail. Please check it URGENTLY!!!!
Responses from Creator API Changed in the past 8 hours
Hi There, From what I can see, the responses from the API have changed recently. The following example should illustrate. If I make a request to the api that does not validate I get the usual response see: curl --data "authtoken=<yourtokenhere>&scope=creatorapi&First_Name=test&Last_Name=test&Email=test@test.com&Mobile_Phone=1234567890" https://creator.zoho.com/api/zoho_beth3/json/talent/form/Appointment/record/add/ response: {"formname":["Appointment",{"operation":["add",{"values":{"Email":"test@test.com","Last_Name":"test","First_Name":"test","Mobile_Phone":"1234567890"},"status":"Failure,
Email notification on success
Hello, I would like to send an email notification for the Sales Person Assigned, once a new Quote Request is submitted. The email notification would be with the Customer Name, Project Name, Job Type, Additional Information data, as well as link to the relevant record view in the App. I tried to wrote a script on the New_Quote_Request Form Actions > On Add > On Success: quoteURL = " https://creator.zoho.com " + zoho.appuri + "#View:All_Quote_Requests?quoteRecId=" + Quote_No.ID sendmail
[SOLVED] Send Report Summary not possible anymore?
Hi, I tried to follow your instructions, but it seems as the function to send a report summary has been removed? I have a Record Summary (on a list), I should be able to select it as a template. I dont even have a template button. When I try to add it manually it wont allow me to add templates on edit, function or as a schedule (even though the instructions seem to say it should work). Has Zoho removed the function of sending a report summary by email that is not on create? /V
[SOLVED] Create a report based on form and subforms
Hi! How do I create a PDF report from a form with several subforms. Do I use a HTML view with "for each"? Or is there a better way? /V
Using Google Forms with Zoho Creator
I have a client that has created an extensive Google Form, with many fields consisting of radio buttons or drop boxes. Currently the data goes to an Excel spreadsheet, but I have convinced them to use Zoho Creator instead. My question is whether i can use their existing Google Form and have the data go into a Zoho Creator database. Would appreciate any feedback on this. Thanks, David
Forms that contain Subforms will not save on Edit
I have contacted Zoho by phone and email regarding this issue, but still have not received a response (despite having an Enterprise subscription!). When I try to Edit a form that contains a sub form, i get the error message "Invalid Entries found. Please correct and submit again." The form does not have any mandatory fields and I can create new records using the form just fine. I spoke to the gentleman at the Zoho Helpdesk who was able to reproduce the problem and confirmed that this is a back-end
Can I display record summary "On Success"
Hello, Can I display record summary after clicking Submit button? I have Auto Number field which is basically tool serial number in the system. Unfortunately it is not visible in ZOHO form, only later in report view. I would like to display that field with tool description after clicking Submit button. Or is there other way to display auto number field in form view? Thanks, Pawel
Dynamically fill subform
Hi, I'm building a rental system. In this system orders are created of the rented items to a customer. Each order also has a project. One project can have multiple orders. When the items are returned, a project is selected and then a subform should be filled with all the items on orders in this project. In this subform the returns will be entered and saved. How can I dynamically build this subform? Kind regards, Johan
OpenUrl called from a web link
Hi I have an HTML page which displays records from my database. I want the user to be able to edit individual records by clicking an 'EDIT' link alongside each record. I would like the form view to open as a popup/modal window above the HTML page. Once the edits are done I want the popup to disappear and the HTML to reload (updating the data). To this end I am trying to display a web link which will trigger: #Script:page.open(url, popup) I have a function which generates these weblinks for each
How Do I Upload a File from an HTML Page?
I am struggling with how to upload a file through editing a record from an html page. I have a page called: Driver Dashboard. On this dash I want the driver to be able to edit one single field on a form called Order_Form. That field is a file upload. Here is what I have tried so far that have not worked. Stateless forms. Doesn't work as stateless forms don't support the file attachment field type. Embed Report: I have not been able to embed only the field I need from the form. I can only get it
Populate subform field from On Add Row event does not work unless value is selected manually
1. I have a form, MyMainForm that contains a subform MySubForm. 2. The lookup field, Application_Number_Text in MySubForm is a dropdown. 3. A script in the MySubForm's On Add Row event populates the Lookup field in MySubForm field: row.Application_Number_Text = [blah blah blah] 4. When I add a subform record, the Application_Number_Text field appears to be filled. 5. When I try to save the subform row, I receive an error. This is because Zoho Creator thinks that Application_Number_Text field is empty.
Decimal number of a letter
Is there a function to get the decimal number of a letter? For example A is 65 and a is 97.
Count lines in a Multiline field
Can anybody tell me how to count the number of lines in a mulitline field? I have a subform (B) within a form (A) that has a string field (row.Unique_ID) that I capture in a Multiline field (input.UID_List) as a summary of the unique field records using the following code: 1. if (!input.UID_List.contains(row.Unique_ID())) 2. { 3. input.UID_List = input.UID_List + "\n" + row.Unique_ID; 4. } What I want to do is then count the lines in the field to calculate the number of different entries in
Error - There is no such view in Zoho Creator
I have a application that is created in Creator: I would like to use the REST API's to download from the view/report. It keeps giving me the following error: <!-- $Id$ --> <div style="text-align: center;vertical-align: middle;font-size: 14px;margin-top:150px;">There is no such view in <a href='/'><strong>Zoho Creator</strong></a></div> ****** end of error The URL that I use: https://creator.zoho.com/api/zoho_bob191/json/t3/view/GoldMine_Web_Import_Report What I send to the URL: <input type="hidden"
[SOLVED] Create new subform entry from main form
Hi! So, I want to do the following. Form A = Missions Form B = Messages Form B is the subform of form A Im trying to create a function in form B (not as the subform, but as the "add" form) which allows you to answer a question which was generated in the subform. Basically, when the user clicks on "answer the question" button on form B, it should be seen in Form A as a subform entry. I have managed to create the following function (and it doesnt complain, but wont work). Form B has a lookupfield (exisiting
Migration tool - Please specify valid criteria field name
I'm trying to use the Zoho Migration tools to upload a CSV into a form, but everytime i run the command i get: Please specify valid criteria field name the command is: zohocreator.exe upload.csv -authtoken *********** -e AppName -au FormName Asset_Serial Asset_Serial the first Asset_Serial being the deluge field name and the second being the CSV column name. at this point i'm stuck because the documentation on the migration tool is mediocre at best so any input here would be great. Thanks.
Fetching Data problem, Number of arguments mismatches
I could use some help on determining what is wrong with this code. I get the following error message: Error at line number : 1 Number of arguments mismatches if(Time_Sheet_Entry [ID == input.Employee].count() > 0) { x = Time_Sheet_Entry[ID == input.Employee ]; //input. refers to fields in current form input.Employee_Name = x.Full_Name; input.Status = x.Status; input.License_Level = x.License_Level; } Thank you in advance for your advice.
Zoho creator showcase
Hi guys, Just wondering if there is any place where some cool Zoho creator projects can be showcased? Or maybe there is some material out there that I haven't seen, on Youtube or something? I am building away at Zoho creator but I would really like some inspiration from others and to see what is really possible in terms of layout, functionality etc...? thanks Dave
How to create a printable invoice
Hi guys, I have been using zoho creator for the past week and I find it amazing! I have build a simple time tracking app and a project management app for my own use. I would like to use zoho creator for invoicing as well - at the moment I just use a word file, edit it and save/print each time a do an invoice. All I really need is a set layout that automatically fills in invoice number and allows me to add a few details and then print. What is the best way to do this in zoho creator?
PDF functionality on published report links not working. Forcing Zoho log in
Hello I am using published reports in a separate website. I want to use the PDF functionality to export record summary's as PDFs. I have tried two methods, and they both redirect to the zoho log in page. First in the "View Record" option where my users can view their record in a record summary template, there is a specific PDF button and this leads to the log in page even after published. Then I tried to use an open-url custom action to open up a record as PDF and automatically save the file. This
Record Summary doesn't appear in the Schedules feature
Hi, I have a question: Why when i want to send an email with the record summary template attachment through the form schedule, i don't see the relevant template in the list? The form chosen in the "When to Do" is the same on which the record summary report is written. Also, what is the difference between the send mail and send report tasks, when i want to use the record summary attachment? Thank you
Error while following tutorial
Hi, I'm following this tutorial https://www.zoho.com/creator/help/tutorials/advanced-app-building.html When I do this and enter the script mentioned in the tutorial: Click on Workflow tab on the left to go to the script builder. Select Field Actions - Products - Product - On User input and add the following code in the editor box I get the following error: Error at line number : 2 Variable 'row' is not defined Any ideas in what I'm doing wrong? Kind regards, Johan Boerema
detect popup blocker
Is there a way in Creator to detect when an openurl is blocked by the browser? The browser may only put a small x in the upper right. The user may not notice the small x. If deluge can detect if the blocker is on then a message can be displayed on the screen alerting the user to the problem.
Hide Subform fields On Edit ??
FormA has fields: FieldX, FieldY, and Subform SubformB with Fields: Field1, Field2, Field3, Field4 In the On Add, On Load for FormA I have the following script: hide FieldY hide SubformB.Field3 hide SubformB.Field4 and it all works fine while I'm entering a new record. In the On Edit, On Load script for FormA, I have the same script: hide FieldY hide SubformB.Field3 hide SubformB.Field4 But when I Edit that new record by doing an 'Edit' from a Report/View, only FieldY on the main form is hidden,
Code generating application (returning values of new entries based on count function of existing records and display automatically)
I am currently working on a way generate codes for items. I have two main questions concerning my application, which are: - How can I have zoho automatically number based on existing records and a specific criteria - How can zoho automatically display a code which is based on another field AND a count function Let me explain in detail... My application has two forms: Items & Product Code Generator In a first step I will add an item to the Items form. The form has three fields which are Item Name,
Do I need to pay for Customer Portal?
Just so I can have a site where visitors log in and edit information about themselves into a directory?
fetch data from subform in page
Bit of newbie question here: I'm working on an app where there are two forms: form name: section_builder field1: letterTitle field2: textSnippets There is a subform: form_name: text_snippets field1: snippetTitle field2: snippetContents Field 2 in form 1 is a multi-value selector which corresponds to field 1 in form 2. What I want to do is create a deluge script in a page which will simply output a list of all the text snippets that correspond to a single letterTitle. I have read the article https://www.zoho.com/creator/help/script/fetch-records.html,
Firewall issues with published links
Hi there I am having troubles getting around the firewall for one of our clients. They have whitelisted all the Zoho links used, even those opened by openURL commands, and they are still not working correctly. This includes published forms and databases. Is there a list of IP addresses or generic URLs I can give them to whitelist?
Function - custom action - fetch and use - I don't succeed in assign a date to new record
Hi Please hava a look at the attached document. I’m trying to create a function. When pushing the button (that triggers the function) in form Cluster, a record should be created in form Planning. Fetching the ID’s of the relationships seems to be working. Creating a planning record goes ½ well when I hardcode the content of the fields. Assigning a date fails. Thanks for helping me out.
Function for REST API
Hi Guys, I would appreciate if anyone can guide me a little bit on how do I create Function in Zoho Creator to be able to POST API to 3rd party. I know this cURL works, but I just not sure how to build function around it - any help and guidance would be much appreciated I am OK with someone helping me out for a fee as well Here is an example with cURL: curl https://api.signable.co.uk/v1/envelopes -u d41d8cd98f00b204e9800998ecf8427e:x -X POST -d "envelope_title=My envelope" -d "user_id=1234" -d 'envelope_documents=[{"document_title":
Viewing attached files
I have a few fields that are file attachment fields. It appears that the only way to see the files once uploaded is to download them. Is that correct, or is there a way to click on the file name and view the file in the browser? Thanks
Web based forms
I have created a Zoho Creator application wherein I would like to be able to direct applicants to my company to a website where they can fill in a form that results in the data populating my application. I assume this is possible, but would appreciate direction on how to do this. Thanks
Next button click is inserting new record on click
I have five forms.On each form I am accepting data and on next button click.For all four forms i have only one table.I am passing the DocumentID as query string and on next button click i am inserting that data in table and opening new form. While opening new form i am passing that DocumentID as query string .But when i click next my record in inserting as new record.Its not inserting in exsting row.I want that all data of four forms should insert into only one row. How can i do that?
Multi language support
I am using a trial version and have added data in multiple languages, as well as have fields in multiple languages. Will this feature still be available to me after the trial period is over?
triggering a beep/tone/sound as an event
When filling out a form, I'd like to provide the user an audible confirmation during certain events (for example, On Edit/On Load). The user is entering data away from the monitor and the tone will indicate a new record is loaded and ready for inputs. Is there a method to provide an audible indicator that's triggered in an event?
Using Form and Note field to display images but the images will not work in published links
Hello I have a custom action that opens a URL to a Zoho Form that my clients use to edit and approve reports. We use a note field to display images, but it has come to our attention that the images do not display. We have recreated the problem and it seems the pictures only display within Zoho and not in published links.
Next Page