Native App Signature Problem
Good day, Im trying to retrieve the url information of a signature field but I got some problems: Sometimes I capture the signature in native app and sometimes I capture in the browser way. In the On Sucess I have this part of code imagelnk = input.SignatureField; The problem is that when I submit the form in the native app this value takes in the On Sucess 1448464101903_Signature.jpg If I check the Url of the image signature is a png file. I try replacing the string extension to match the png file,
Dashboard page
Hi, I am looking for creating dashboard page with various Pivot charts. But I want the users to see charts based only on their user level. Even if i have to create multiple pages its fine. But how can i give permission levels in Pages. You help is kindly required.
Creator customer portal question
If I use the customer portal add-on in Creator, at what level can I set permissions to view records? I want to be able to only allow access to records the customer created in some forms, but in others I want them to be able to view only records created by others. Is this possible simply by using user groups?
Number of days in this month
How do you find out the number of days in the current month?
Emulating an editable grid in Forms
Hi I would like to show a row of fields similar to a spreadsheet that are editable and if possible hidden and shown depending on another field which says how many rows should be displayed. So if the user enters 5 in the other field, 5 editable rows of roughly 5 cells each should appear. I haven't seen any examples yet of this in my searches so far. Any help appreciated. Paraic
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.
Help with date validation
I am trying to make a validation alert when a user is entering a delivery date which is before the order date, I do however have the issue that I get the alert regardless if which date the user puts in. Any ideas what is going wrong? if (input.Delivery_date < input.Order_date) { } alert("Invalid Delivery Date"); Thanks.
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?
Invalid json for View Records API
Hi, I am using the View records api to get a list of report. I ask for json response, while sending the get api. But in the reponse I get an invalid json. Please let me know what should be done to resolve this error. Below is the code for ref $service_url = "https://creator.zoho.com/api/json/*************/view/Images_Report?authtoken=*************************&zc_ownername=*********&scope=creatorapi"; $curl = curl_init(); $headers = array( 'Content-Type: application/json', 'Accept: application/json'
Integrate ZOHO people into ZOHO Apps
Hello, I would like to integrate Zoho people into Zoho Apps, I want to integrate only time attendance section of Zoho people into Zoho Apps
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.
Combining a date with text
Hi, I am creating bookings and I want to give them a title of 'service type' followed by date and time, for example Cycle Training - 12-Nov-2015 13:00:00 This will enable me to have a clear name going forward as I assign other tasks to it. What is the code for this? Thanks Ben
How do extract email address from subform
I am trying to include the email address from a subform in an sendemail?
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
For update Android app after design changes
When I work on my application in the web browser everything works and looks as expected. Now when I look at the Android version of my app, it often does not use the most recent version of the design. For instance, it shows a field I already deleted. Is there a way to force the synchronisation of the new design to be used in Android?
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
Next Page