Edit iPhone field like you can on Android?
I have a question about field views on the iPhone. I have tried every different way trying to get the fields to show above the radio buttons. Is there any way to change where the question is positioned? This looks bad on iPhone with questions that are this length. I attached an image below.I feel like there should be a way to fix this. This look pretty bad.
Double Column Form with a Subform
My app has a crowded form with a subform in the bottom. When making the form double-column, the subform doesn't peacefully overflow the first column and stretches the 1st column so much that the 2nd column becomes ugly and useless. Is there a way to add a subform to a 2 column form and keep the design tidy?
Import data into url field not working
Thought I had this working in my early testing, but now it's not. Our application compiles customer orders. New daily orders will be collected first on an Excel spreadsheet. Then employees will use the import data function. One field on the sheet is a link to a PDF of their order. I created a new field in our app as URL. When I import data, the link info appears in the correct field in the preview. When I complete the import, however, the URL field is empty. If I then edit the record and copy/paste
How to allow customer to view only records associated to them
How do I allow customers to only view records that are associated to them? They are not entering the records. The records are entered by the company. Thank you.
Tip 20: How to autopopulate values in a subform
Hey folks, We know that many of you use subforms extensively in your applications, as it helps you get the job done more efficiently. In this tip, we'll show you how to autopopulate values in the subform using a special syntax called "row." Let's look at an example. Consider you have an application where you need to automatically display the price of the product in the subform field based on the choice selected when a user clicks Add New in the subform. Let's say you have a form called "Mainform"
Inserting Subform Row via an Action on a Report
Currently, inserting a subform row using an action on a report isn't allowed (see the screenshot below of what I'm trying to accomplish: allowing users to insert a vote into the Votes subform of each record). Can anyone (Damien Cregan?) think of a way to insert subform rows using a button on a report that doesn't require the use of a stateless form? Perhaps by simulating a record edit + On User Input or On Update??
API Failure on Edit
Here is an example of the XML Being sent. I am getting the error: "Failure, Invalid or null criteria specified" I am following from this page: https://www.zoho.com/creator/help/api/xml-rpc-api/xml-rpc-api-edit-records.html This does not make sense as the criteria does appear to be the correct database spelling. Down below is the example I am trying to make work. Only thing I changed from the example was changed the view into form as view was not working. $xml = " <ZohoCreator> <applicationlist>
Zoho creator XML RPC API error code: 2945, INVALID_TICKET
Trying to insert data using php curl request. Response : {"code":2945,"message":"INVALID_TICKET"} Here is the code used: function insert_record($xml_string){ $api_url = "https://creator.zoho.com/api/xml/write"; $post_params = array(); $post_params['authtoken'] = "mytoken"; $post_params['zc_ownername'] = "myownername"; $post_params['scope'] = 'creatorapi'; $post_params ['XMLString'] = $xml_string; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $api_url); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
Is it possible to add conditional formatting to a panel in a page?
I want to change the color of the panel based on the value displayed in it. The panel basically shows the sum of one field from the report and if the value is above zero I want the color to be green, and if below zero, then red.
Checking Values Within Name and Address Fields
I'd like to make sure that both a First Name and a Last Name have a value in them before I save a record (ie. that both are not Null)- but in the Deluge editor, I only seem to see Name. Similarly, before saving a record, I'd like to see that for addresses, there are values in Address 1, City/District, State/Providence, Postal Code and Country - but in the Deluge editor fields option, I only see the whole Address field. How can I test those "sub-fields" of the Name and Address fields?
Default State value in Address Field
Hello, Is it possible to set a default value to the State item in the Address field? See screenshot. Thanks!
Custom API Response
Hi, is there a way to customize the API response? I have a form with two fields (email, username) having no duplicate values validation. The problem is whenever I add a new record with existing values the API status response is always 'Failure, This value already exists. Enter a unique value', it does not specify what field/s has the error.
How to run through each field in a record
Hi All I have a few fields in my record and I would like to go through the value of each field in the current record that I am submitting. The intention is to create a new record in other form if it detects a certain value. Something like: Field1: okay Field2: require attention Field3: okay Field4: require attention For each field, if value is "require attention", add a new record in other form that contain the field value and the record ID. Hope someone can help me out. Thanks in advance
Tally with Zoho creator
I need to integrate the Tally international version with the Zoho creator, would i be able to do? Does Zoho have any default marketplace app for that? If not what is the replacement ? Thanks... Hari
Importing/Exporting data on a custom built Zoho Creator App
HI - new here so feel free to point me in the right forum/direction. I have two issues with the following setup: Main Form with a few fields Subform within the Main form with 5 fields The problems: Whenever I export data, I see all the main form fields, but only the first field of the subform Whenever I import data, it puts all the entries of the subform first field into one row. In other words, say I export the data that has 5 rows (line items in the subform), and then if I take the same file and
Printing forms using a background image
Hi, I am having trouble making a template work as I desire. Its a certificate and I've made a copy of it and inserted it as a background image. On screen I have aligned the fields in the desired locations. But when I print it to PDF the alignment is out. I'm using Chrome as a browser. Designing the form completely from scratch is an option but seems like a load more work.
Display stats from zoho database on web page
Hi, I'm new here just trying to find my way around I'd like to display 3 counts from my database on my public web page. The 3 figures are counts of records for current month; year to date; and all time. There are a couple of filters to exclude some records I don't want counted. I have a simple report that holds these counts - can anyone tell me how I can get my web page to access these figures dynamically so they are always up to date please? Currently we have to update the website manually. I appreciate
Notes Field Deluge Options
I have a form that displays some information for the end user based on their query in the Notes field I simply set the input.lbl_field to be equals to what i want, is there any way that i can make the note bold or change the color from the Deluge script and not the GUI?
Zoho Creator white label via tablet
Hello, I heard from Zoho Sales that the ability to white-label an app created through Zoho Creator is only currently available on Desktop. I was told that the ability to white-label an app through mobile and tablet is currently in development at Zoho, with an expectation that it will be rolled out in the next product update. Can anyone shed some light on this? Is it true that this functionality doesn't currently exist? Is it true that Zoho is working on building that out? Does anyone have an idea
Hide fields dynamically - Record Template
Hi all, is there a way i can hide fields dynamically on a record template?
"&" being converted to parameter in PDF export
Hi, I have a button in a CRM record that passes a string that may contain an ampersand to a ZC Page. The first issue was, if that string contains an ampersand, the URL would then read that as a new parameter and cut off the string when displayed. e.g, "Mr H & Mrs D Smith" gets interpreted as "Mr H " because the & specifies a new parameter. I resolved this by replacing "&" with "%26" before passing the string, and now the ZC Page displays the full name. However, when using Print or PDF buttons on
Built in functions getFieldNames() & getFieldValue() could be improved!
Hi, Would be nice to see both these functions improved to handle sub-forms, also the ability to use within custom functions. Like this would be awesome: map forms.fieldValues(int recID) { record = Form[ID = input.recID]; counter = 0; myMap = Map(); for each line in record.Sub_Form { counter = counter + 1; fields = line.getFieldNames(); for each field in fields { myMap.put(field + " - " + counter, getFieldValue("field"));
Report based workflow
Hi there, I often find myself wanting to create workflow based on reports instead of forms. Here are some examples: - On-Create of a new record from Report A, assign default value to field1, field2, field3. On-Create of a new record from Report B, assign different value to those fields. - On-Create of a new record from Report A, hide field1 and field2. On-Create of a new record from Report B, don't hide those fields, or hide other fields. - On-load of Spreadsheet report, disable field1 and field3
Integrate Zoho Creator with Contact Form 7 (Forms: 3rd-Party Integration Plug In)
Hi there, Has anyone successfully integrated a Contact Form 7 on a wordpress site with a Zoho Creator form using the Forms: 3rd-Party Integration Plug In? I believe it is possible from some comments on the wordpress plugin page: https://wordpress.org/support/view/plugin-reviews/forms-3rdparty-integration I have a paid Zoho account, I have published the form within Zoho Creator & I'm using the public URL link within the Forms: 3rd-Party Integration Plug In. I would like to set set up the form on
Clear subform B particular row when decision-box in subform A is unchecked
Form A has 2 subform's, subform A & B,subform B is copy of subform A except few columns. When successful-EDIT entry is done both have same data.Problem is that when a checkbox in unchecked in subform B onEDIT -> onUSERINPUT , I can't user clear() to remove that particular row in subform B( having same data unchecked in subform A) i tried below example also but it did't work : fetchedRecords = Employees [ Date == today ]; for each rec in fetchedRecords { rec.Job_Experience.clear(); } How can i achieve
Tip 22: How to allow employees to check in and out, and then automatically calculate their total work hours
Hi everyone, Keeping accurate track of employee hours is crucial to smoothly running business. So this week, we wanted to go over how you can automate this whole process using Zoho Creator. With this tip, you'll learn how to set up a page that will make it easy for your employees to check in and out, and help you track their work hours on a daily basis. To do this, let's create a sample application called Attendance App, and show you how you can use it to track the total work hours of each of your
Customize detail view links (click to WhatsApp)
Is it possible to customize the detail view to include links in certain fields? For example having the phone number link to start a WhatsApp (wa.me/phonenumber) chat instead of dialing. Or linking a field like invoice number to take me to a different report on my app. I know it's possible to make custom record templates but these are used for printing and saving to PDF. I am looking for a way to customize the actual detail view while viewing a report.
Sub-Form Entry Sorting
Hi: Is there a way to sort the order in which sub-form records (entries) appear on the parent form by a field other than the modify date? Case: I have a customers form with a contact log sub form that has a date selector date field. By default each entry in this contact log form appears on the main form in order by the date that the sub-form record was entered. Instead, I would like them to appear in order of date per the date selector field. Thanks
PDF file be imported and converted as a report and read as a spreadsheet in creator app?
Hi We have a query from a client, a file they receive as a pdf file be converted as a Report in Creator App and be converted as a spreadsheet? is it possible? if so kindly explain. Regs Sathya
SMS Invoice
Hello, Can i send Invoice template which is generated from Zoho creator in sms using a url?
Creator/Books Integration
Hello! I'm looking at moving one of my Filemaker apps to Creator. The app is a computer repair tracking program. We are going to be using Zoho books, and I want to integrate the new creator app with books. I'd like to have the following: A dropdown in Creator with all of our contacts from Books When a new repair RMA is created in Creator, it creates a new Estimate in Books. Is this possible? From the API, all i've seen for the contacts portion is to search by ID number, or by name. I dont seem
Time is export as 24hr format instead of 12hr
Is there a way to get the time to export as a 12hr format like I have it in my report? In my report the time is entered as 12hr but when I export it shows in 24hr format. Is there a way to change this? Images are shown below. Thanks.
Sprint API (Self Client)
I am currently creating a creator application that will automatically get a Sprint, create a Sprint, etc. from an API of another website. Now, in the developer console, I was given the option to add a client. I selected, Self Client. I then generated a code using this. But when I tried to use it in my function, I get this result. Can you tell me where I am getting this wrong? Provide me an example or any guide that will help me make this work. Thank you.
error on script deleting record of related table
I have two forms: Purchase which logs company purchases, and Cashflow which shows the cash balance of the company. when creating a purchase,if a decision box called "add to cash flow" is checked, a new Cashflow record is created with the relevant details. Purchase also has a lookup table to the newly created cashflow record. when the decision box is unchecked, or the purchase record is deleted, i want the associated cashflow record to be deleted. I know a bi-directional lookup might assist but
Error handling
On occasions, running scripts produces errors (e.g. incorrect email address format in sendmail). In contrast to the Execution error popup, is there any way of trapping such script execution errors and reporting them in a controlled way? Other languages support 'on error' type traps; is there an equivalent in Deluge?
List with Accept reject and details button in Zoho creator
I am trying to create a List in Zoho creator (Form, page) with a details button which redirects to another page. But I cant find how to create a list with buttons. I am a new user so I don't have a complete idea, Please help. Thanks.
How to calculate a "check digit" at the end of a reference number
Hi, please can you assist me with the the following: I want to create a formula that will calculate a "check digit" at the end of a reference number ie, similar to credit card numbers. The algorithm that I'm using is the Luhn Modulus 10 Check Digit and works like this: 1. I need 14-digit reference number (I will create this using the auto number field in Zoho Creator) 2. Reverse the 14-digit reference number ie. if original reference number was 246810 then the reversal will be 018642 3. Double each
Form Email as part of a Google Group
Not liking the random and unfamiliar email address that was assigned to our form (accountname-123@forms.zohocreator.com), we made the form email address a member of a Google Group (easytoremember@company.com) This worked a few times but then stopped. Directly emailing the form works. Forwarding from a Zoho Mail address (easytoremember@zohomail.com) works. But emailing through a Google Group does not. Creator Support is looking at this, but I'm curious if anyone else has tried this and succeeded.
Page Snippets
Hello, Is it possible to create charts using html snippet or ZML snippet in Zoho Creator Page?
List Form Fields API missing data
Using the Rest API: <form method="GET" action="https://creator.zoho.com/api/xml/sample/forms/fields"> returns all the form fields metadata, except nothing is returned for the 'Name' field or the 'Address' field. Is there any workaround for this?
Next Page