Fetch Parent and it's Child records
Hi Need some urgent help. I have a lookup relationship from cases(child) to potential(parent) Once I associated a potential to a case, I need a script to trigger which will fetch all the related child cases for that particular potential and count them. Any help is appreciated.
Need help with "for each ..." when using list() function.
I want to collect data from Zoho Subscriptions via the Zoho Creator/Sub interface. I can see that I am fetching the data, but I am unable to insert the data into my creator table. My guess is simply because I do not know too much about the list() function. Any help on this short piece of code? I get the error in the line "for each ....." ======================================================= vRespons = zoho.subscriptions.getList("Subscriptions", "xxxxxxxx"); vtext_Subscriptions = vRespons.get("subscriptions");
How to find some data
Hello, I created one Userform1 Date : 15/11/15 Panne : Abcde Machine :15 Now i creat a userfom2 : Date : Lookup > Userform1> Date Panne : Machine : I would like on Panne and Machine.. when i select the Date i creat on userfom1 to see the data automatic In Panne and Machine on userform2 Sorry for my language i'm french ;) Thank for your help Kemel
Zoho creator does not import
Hello Zoho team, I am having problem importing an application without data. I am using a .ds file that i took from my friend that he is using zoho without problems. The application is called: Safein-Dimitris and it's under the account with the username: jimtek. In general i get error "null" so i cannot troubleshoot much. Any help is appreciated. Thanks in advance.
Dropdown List Value from different Form
Hi, I have two forms FormA & FormB. In FormA there are field called Email & Country(Multi Check box) In FormB there is field called Email (Lookup to Email field in FormA) & Countries (Dropdown box) What I wanted to achieve is, when an email is selected in FormB, field Countries should populate the list of values we selected in FormA for that email. Please let me know if you need more clarification. Thank you in advance for your support.
RTF no longer has On User Input
Rich Text Fields don't have an On User Input section. I need to check the word count and display an alert warning if it is not appropriate. Without the On User Input how do I trigger the logic?
Google Sheets Script
I am trying to get my Zoho Creator form to change values in my Google Sheets file. I've been trying different scripts but cannot find any clear direction as to how to go about doing this. What I want is to have the ZC form with Work Order Number & Hours Worked fields. When the user clicks submit this will send these 2 fields to a Google Apps Script - which finds the row with the Work Order Number and then edits the Hours Worked entry. I can execute the change on scripts but I cannot figure out how
Make a date with a parameter box date
As I get to make a date parameter a date box. Example: Fecha_on_sale "Date": 14-Sep-15 Fecha_on_sale in "Date" Month Fecha_on_sale in September "Date": 14-Dec-15 Fecha_on_sale in "Date" Month Fecha_on_sale in Dec
field name
i create new form but when i tried to change the file name to another name it is saved but not change the file type " decimal" i want to change name to " input " what is the problem because before i used it and changed easy
Mobile Zoho Creator - Upload Image Already On Device?
I am running into issues where an image may have been taken earlier with a smartphone camera and is currently in the "Photos" location on the phone (iOS). Why is there not a third option to select a photo already stored locally on the smartphone? In my particular application, a user may capture a photo that will later be used in the Zoho app, when it's convenient (but not necessarily while the user is actually running the app) i.e. the user would have to go back and do the photo AGAIN, just to
Multiselect Field in HTML Page causing "UnPredicable exception, Invalid statement found Line:(#)"
Hi, I'm trying to use a multi-select field in a HTML Page but it is always returning the following error. Error details: Error in executing assessments_page UnPredicable exception, Invalid statement found Line:(246)Edit access is still enabled, page is https://creator.zoho.com/appbuilder/oliviafox/promanagers/page/assessments_page/edit Line no 249 is commented... Field name is 'Applies_To' in form "Assessments" ********* Workaround - Created a hidden multi-line field that is populated with the multi-select
Include Report Template in email On Delete On Validate or Success
Including a Report Template in an email when a record is deleted can be useful as an audit trail. I understand that all the fields can individually be included in the email but that is a lot of work when a template might already have been built.
Page Breaks in HTML View/PDF
I want to create page-breaks in my "HTML VIEW" for PDF printing purposes in my application. I tried adding CSS: <div style=”page-break-after:always”></div> But this has no effect. Is there any way to make it page break in the PDF output of the HTML view?
Help creating a contact search form, similar to the one available in zoho crm campaigns.
Hi, I'm looking to create an interface where i can select existing contacts. Essentially, exactly the same as you do in zoho CRM under the campaigns tab. Near the bottom is a "Contacts" heading and upon clicking "Add Existing contacts" you get a form you can search your existing contact base with and select them. I looked into the documentation, specifically towards search forms, but that example seems very complex. It also doesn't do as much as the search i previously spoke about. So, is there
zoho creator app
How can i display this type of question in zoho creator? Statement 1.Yes 2.No, Why?............ and table filed to get data?
Email masking and tracking
Hi, We have set up our CRM on Zoho Creator so we can manage our enquiries and bookings of sports bookings for football pitches, tennis courts, etc. We want to be able to track when a sports venue responds to a user. We've tried making links that go to a Zoho form for venues to accept or decline a booking. However some venues have restricted access to the internet, so these links dont always work. We also dont want the venue to get the real email address of the user, and vica versa. Like Holiday Lettings
how can I show scripts from this sample http://creator.zoho.com/sampleapps/send-pdf-link-in-email/#
how can I show scripts from this sample http://creator.zoho.com/sampleapps/send-pdf-link-in-email/#
Send Mail
Hello. I'm using the "Send Mail" function to notify my clients when a work order is generated. In the email message I'll have info from the work order fields such as: Contact Name: <%input.Contact_Name%> I have several fields and they don't always have data so in the email it would show "Contact Name: null". Some of these fields are related lookup fields and such. I know how to pull related data by using something like "a = Contacts_List[ID == input.Contacts_List];" so no issues there. What I would
Display Records in HTML Page View
I am beginning to discover more about Creator - Pages. Right now, I am attempting to develop a simple page that would show information related to projects. Below is the code I am using. The issue: I have three different projects in the form it's pulling from. It is showing the same project on three rows instead of a new project on each row. htmlpage Search() <%{ projects = Project_Information [ID != 0]; %> <table width="200" border="1" align="left" cellpadding="1" cellspacing="1"> <caption>Test</caption>
Creating a new entry in one application based on field values in another application
Hi There, I have a BAU application we use for tracking delivery and collection requests, I also have another application that tracks the repairs on any returned devices. On the BAU application we can select the service request and select "Faulty Device Collection" if we have a faulty device coming in. What I would like the BAU application to do is raise an initial entry in the Repair Tracker application, copying a numbe rof field values from the BAU app to the Repair tracker app, when I complete
NEED DEVELOPER - Have created a custom application however need help with the reporting.
Hello, we have developed a custom application for our business however when we try to print any type of report the formatting is a mess. We need help figuring out either how to handle the formatting or how we can export to Google Sheets or a different alternative and or map data to a premade report.....etc. Please help, we will gladly compensate.
Need detailed instructions on how to use relational database functions with already imported files
I am new to Zoho, and am struggling to set up our basic system. I work for an educational nonprofit and I have no real coding experience, though I had maintained databases in Access and Excel. I have two major forms imported from excel files. One is our alumni records/contact info, etc. The other is a list of college records for these alumni, by term (so one line would be for one student one term at one school). It is a basic one to many relationship, and the records are linked with a long
Populate a PDF form with data from a ZC Report Record?
Any ideas on this functionality?
Track Work in Progress
A couple questions...very grateful if anyone can help. I want to track where an item is on our factory floor. The general process is we start with an item in Receiving, it goes through QC, Inventory, Benches and then Shipping. The primary identification is the Item #. Ideally, someone creates an Item using the Item Creation Form, for examploe product number 1ST1066. Each time it enters an area an employee checks the product in to the new area. In my dreams, they open the Item Location Form,
List contains function, does it work?
Does the contains function work for lists? for instance Fetch_Records = Form1 [multi_select_lookup_field.contains(Record_ID)]; It seems this script statement is not functional. if it doesn't work, what would be the simplest workaround? The help section on this topic (see below) is not clear. According to it, we need two parameters, list.contains(str1 , str2) ? thanks for the help. ---------------------- List Function - contains This topic describes the syntax and usage of the list - contains function
Connect Creator to Invoice
I have a Creator database that has client information. Is there a way to connect this information to Invoice so that I can create invoices by looking up the clients?
cURL to add record error not a valid form, but form exists....????
I am attempting to add a record to a form but I keep getting an error stating that the form does not exist, although I know it does, and yes I'm using the linkname, not the form name in my URL. $data = array( ‘authtoken’ => xxxxxxxxxxxxxxxxxx, ‘scope’ => creatorapi, ‘names’ => bob, ‘total’ => 12.50 ); # Create a connection $url = 'https://creator.zoho.com/api/xxxxxuser/xml/test/form/this_form/record/add/'; $ch = curl_init($url); # Form data string $postString = http_build_query($data,
Send mail from report
Hi everyone Is there a way I can send a mail directly from a report? Our company organizes students, and I would like to be able to send them a mail directly from the report generated. I am aware of the sendmail-function, but that seems to be a function sending only predefined messages. Grateful for your help. Regards, Gulli Ovesen
How to integrate zoho security with a custom user form
I have a 'Add Employee' form with Name, email and role fields.Is there a way to tie these to the zoho security thats under myapplication setting. I do not want my user going to the 'ApplicationSetting' to create users to access my app. Thank you Anand
Publish page with embedded form + privateLink parameter added
Hi there, I need to embed the same form on 3 different websites, all with different styling applied. I figured the best way to do that is by creating 3 html pages and embed the form in each. Problem: Can't get the form to show public in the pages. When not logged in I am getting login form on the place where the embedded form should load. I tried following these step: https://help.zoho.com/portal/en/community/topic/embedded-form-layout-changing-the-styling#2266000006278456 So I published the form.
Custom action button in HTML view
Hi, I have a HTML page where I embedded a view .I want to show the custom action button on that HTML view but I can't figure it how to do that. Could any one please help me what parameter I should use ( style based url ) . below is the code I htmlpage TV_Station_Report1() displayname = "TV Station Report" content <%{%> <div elName='zc-component' viewLinkName='TV_Station_Database' params='zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true&zc_Summary=true&zc_RecPrint=false'>Loading
Auto populate form from a custom module in CRM
How do I auto populate a form using Zoho Creator from a custom module in Zoho CRM. I know how to do this using the default modules but changing the module name to custommodule1 does not sem to work.
How do I add an ID to a subform longlist?
Hi, I have a query relating to subforms and how the data is stored and accessed. I have created two forms, A and B. Then I insert B as a subform into A. Now: 1) I add a record A1, with subform entries B1 and B2. The subform entries are stored as records in form B. 2) I add a record A2, with subform entries B3 and B4. They are also stored in form B. 3) When I view A1 or A2 the subform magically shows only those B records in the A record in which they were originally entered, i.e. B1 and B2 show up
How to redirect value from form to external site by using post method in zoho creator.
Hello I need to redirect data to external site. I am using OpenUrl function to redirect to external site. But it expose the data in Url. I want to send data by using POST method like in php. Please tell me how can I redirect to external site with parameter should be encrypted.
Custom Function / Action Button - On Report View
I am looking to make a custom action / function for setting the status of a task as done on a decision field on my form, i know there is a way to do this and that there is a sample application for it, but i cant find it to install it to my acct . can someone help me find it or post a link ?
Reports. Group by/ count. Show "out of stock if count(item)=0, "In stock" if count(item) > 0
Basically have a report showing something similart to this: ID Type 6524 A 8472 A 2145 B 3254 B 1254 B 2158 B 6528 B 1235 D Want to alter it so a get a report likt this: Type Count A In Stock B In Stock C Unavailable D In Stock Is this possible, anyone done something similar? If I use pivot table, I can get the following: Type Count A 2 B 5 D 1 But I do not want to show the actual count. Want just to show "In stock" (or "more than 2") Thanks.
Maximum Capacity check
Hi, I build a script that was supposed to check a field value on a related form (Maximum Capacity) and then compare it to the count of specific records. And show an alert if it was reached. See below if (input.Britcham_events != null) { Cpct = Britcham_events[ID == input.Britcham_events].Maximum_capacity; Trgt = Britcham_events[ID == input.Britcham_events].Target_nr_of_participants; cnt = Participants[((Status == "Attending" || Status == "Confirmed") && ID == input.Britcham_events)].count();
Accessing the identifier for getRecordById to work
In a workflow custom function I am looking to access the Contact ID from a CustomModule record. Here is what I have coded: ToDoCrm = zoho.crm.getRecordById("CustomModule4",input.ToDoId); controlid=ToDoCrm.get("35-Control"); client=ToDoCrm.get("35-Client"); contact_id=ToDoCrm.get("contactid"); This is where I start have problems contactinfo = zoho.crm.getRecordById("Contacts",contact_id.toLong()); This line fails email=contactinfo.get("Email"); account=contactinfo.get(("Account Name")); dos=contactinfo.get("Date
Channel Partner app
Has anyone used Zoho Creator to create any type of indirect Channel Partner management application/portal, of course, integrated with Zoho CRM? Thanks.
How to get users email id
I have configured Zoho signing with gmail. I have a 'Employees' form which has a users filed.I have the appearance of the field to display the email address of the uses. How do I get this user id field in other forms? I am trying to get the email address tied to the user in other forms. When I try to display Employee forms user_id, by default it displays the username and not the email id tied to that user. Thank you Anand.
Next Page