Form View not showing column
I have added a new date field to my form, and even though it is showing in the Column Properties edit columns, it doesn't actually show up in the view itself. I have tried deleting it, and re-adding it from the right hand "store" of columns, but it's still not showing.
Map ZC data to Adobe Acrobat PDF form fields
Any ideas on how this could be done? Can a Acrobat form be embedded somehow into a Record Summary? Maybe Zapier could do this?
How to disable Radio Button choices/values
Hello, I am working on a registration form which has a set of 3 radio buttons for class selections Radio_set1: Class 1 Class 2 Class 3 I would like to disable Class 1, Class 2 and Class 3 individually when certain requirements are met. I do not wish to disable the whole Radio_set1. May I know if there is a way to do this? Thank you very much.
Changing default orientation of record summary to landscape
Hi, Is it possible to change the page orientation of a record summary to landscape? Also, if I try and print a record summary, the zc orientation paramater does not work with this url: zoho.appuri/record-print/View_Invoice_History/ID Regards, Shaheed
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.
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
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
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
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.
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,
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
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
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
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
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.
Error Handling Best Practice
In a large and complex ZC app with functions often being called 2 or 3 levels down, is there a best practice for error handling? I think there are at least 3 requirements: 1) A status message - text to describe any warning or error condition [or indeed success]. Because the message may be produced 2 or 3 function calls down, it must percolate back up and be displayed properly to the user. 2) A status code - that can be tested to see if the function status is anything but 'Success' and may dictate
"Set Filter" works in it's own form but not when it is a subform.
I have a form called Accounts_Form which includes subforms created from existing forms: Add_Edit_Sites (bidirectional link to Accounts_Form) Add_Edit_Contacts (bidirectional link to Accounts_Form) Add_Edit_Contacts has a Lookup field called "Sites" which looks up site names from Add_Edit_Sites and has a "Set Filter" (see screencap) to filter out only sites with the same account name from the Accounts_Form. When adding a new contact from the Add_Edit_Contact and selecting an Account from the lookup
Version?
I am working with the user amaio1968@hotmial in the instance of leandro@addtarget.com and I can not see the types of fields: file upload Subform Autonumber Formula Signature Is this instance an old version of creator? Thank & regards
Creator Form usable on IMacs
Hi I've recently had a creator form created for our client brief. It works perfectly on a computer, tablet etc but when I try and look at it on my 21' imac its almost impossible to use. Can someone please give me a couple of suggestions.....
sendmail attachment
Hi It is posible to send pageas pdf as attachment in sendmail function?
Creator down again...
I assume you are aware that creator and other services are down again. That's two days in a row... Also the whole status.zoho.com thing is never correct im not sure the point of that site. Whole office sitting on their thumbs again... ETA?
Feature or Solution Request: A non-cubersome time field
Hello I created a simple time clock app for a client that allows them to enter and clock in and clock out and then auto calculate hours worked. Currently using the date/time field. I am getting so many complaints on the hard to use time entry (i.e. clicking and or dragging to get hours and minutes) Does anyone have a more elegant solution? Dear Zoho: Please consider fixing this, hardly usable in my opinion.
Next Page