Date Field in Zoho Creator
Hi, I have been using zoho creator for creating many application. I always feel that it is nice to have a field for Time. I dont know why you guys are not allowing the "Time field" alone. It will be helpful you do so. Or provide any options for setting the time format criteria for single line fields.,
Download a CSV file but with semicolon as separator
Zoho offers a built-in CSV Download, but unfortunately it uses only "commas" as separator. Some systems requires a "semicolon ;" as row separator. Does anyone knows a solution for that ? e.g. programming the download based on a list from deluge ? Or does it Zoho has any plans to offer the "semicolon" version of the CSV Download as well? Thanks Alex
bug: matches function is not work in fetch record.
matchedRecords = formName [Single_Line.matches("abc.{4}d")]; matches function is not work in fetch record. abc.{4}d is regular expression can anyone help?
How to calculate business days between two dates ?
Team, I need to calculate working days between two dates for Task management . Two dates : ticketAssignedDate , ticketClosedDate . Need to achieve this without loop and recursive
Ask about records
Hi Team, We purchase EXPRESS account yearly: Unlimited User 100 Apps 250,000 recordsMy question is: If I already have ten thousand data/records and I deleted five thousand of it. Is the five thousand records will going back to 250,000 records? 250,000 expected records 10,000 records of my application 240,000 remaining records 5,000 deleted records Is 5,000 deleted records will add in 240,000 records? like from 240,000 it will going back to 245,000? Hope you get my intention.
keep the active session
I have a question, Could you help me or tell me the best way to connect to a REST API which requires to keep the active session? It means, First I have to call a login method to access other methods in the API. My code is: //CREATE THE HEADER PARAMETERS THE REST METHOD NEEDS mapHeaderParameters = Map(); mapHeaderParameters.put("Content-Type","application/json"); mapHeaderParameters.putAll(mapParametersRestMethod); // //CALL TO METHOD REST // // LOGIN
Need Help Hide / Show based of Checkbox entry
I am trying to shorten a form of unneeded fields by using a check box. On load of the form I am hiding the fields and as the Choices are made the appropriate fields are added, or subtracted if unchecked. I can easily get the first fields to unhide and re-hide based off the checking and unchecking of the "Roof" checkbox in this case, but I run into problems as I add more selected choices. Here is the code that works for the first selected choice: if (input.Exterior_Repairs_Needed.toString() ==
ID Field Required for Showing One Record In Report?
I use a link in an email to notify users that a new record has been added. The link is to the Report and I only want the new record to show. As far as I can tell, this only works if the ID is shown in the Report. Is this so?
Best Way to Filter Records by Field that Corresponds to Users?
So, I am trying to figure out how to filter records in reports based on the current user. I also have a field in these reports that corresponds to the user, but it's the initials and not the Zoho username Basically, I want to be able to filter the records so that only ones where the initials field is the one that corresponds to the current username. I had a bit of difficulty with syntax when I tried to create a formula to do this, so I am not sure how to go about this.
Copy data from one application to another application
Hello, Is there a way to copy data from one application to another application On Edit the record entry? e.g. I have two applications, 1) New Stock. [form name = Invoices] 2) Old Stock [form name = Invoices] Note: All fields are same in both application forms. I am going to edit the record and doing some modifications in "New Stock" app. When click on update button, I want to copy that record to the "Old Stock" application. Is that possible? FYI: In modification process, there may be some conditions,
Configure Menu Item
When I click on a menu item, I would like to go to a Form or Page based on where I was when I clicked it. Is that possible? Is it possible to tell the target Page where I came from?
Eliminating duplicates on import
Hi, I need to regularly import data from a supplier into Zoho to keep my records up to date. The supplier data contains a unique reference. The data will be sent to me weekly and may contain records already sent the previous week. I need to import all the new records, but discard the duplicates. My question is therefore how do I do this? My assumption is that I need to create a new table to hold the imported data, then to run a function to compare it to the "master" table, adding new records before
If statement to send email
I created the following if statement to send an email based on the input of a selection field. I keep getting an error on line one missing a ";" The code is as follows; if (input.Location_field == "Day Support") { sendmail ( To : XXX@xx.com From : xxx@xxx.com Subject : "Test" Message : "Test" ) }
Zoho Docs Integration
I would like to create a document from a Zoho Writer template and then populate some fields in the document with Zoho Creator data. Is this possible? So far, I am only able to create a blank document. If some documentation exists, please point me to it! Thanks in advance.
Account is inactive
I am paying since months, presuming that my secretary is using the system, i got to know that it is inactivated, my i know why Access all my information through Request Id: #19234682, i am really surprised how are you deducting the money on monthly basis and you decided to desactivate my account without even informing me
Calculate a currency field based on current manufacturer
I have an Inventory form where I store all my part info. I need to adjust a field to automatically calculate when a certain Manufacturer is selected from the drop down field. I was thinking about a Fetch Records to do this. example; Inventory Form Manufacturer Drop-down field three pricing fields (A, B, C) If Manufacturer(Big Int field) ="Apple" Calculate Price in "A" times.3 and place amount in Currency field "C" aep=(Inventory[ID=Input.manufacturer].count()>0) if Input.Manufacturer.toString()=="Apple"
How to set the Title on the PAGE View
Hello, How do I set the title of the html page in the PAGE View? It looks like the default is "Zoho Creator - Page Name" Is there a way to change that? Thanks David
Converting date-time to date on a report display where date-time is the side effect of a formula subtracting days from a date
In some of my reports there are columns that look like this: "30-Oct-2017 12:30:00". I think the source of the time element is that I started out with a pure date on a form and performed some date-arithmatic on it (subtracted 30 days etc.) using a formula in the form. So the base column displays as a pure date but the derived columns display as date-time. Is there a way to fix this? To display (or fundamentally do the arithmetic) on dates instead of date-times?
To display contents of lookup form with a subform
I have a Form A with a lookup field from Form B. In Form B there is a subform C. I want to display contents from Subform C when entering data in Form A, sometime with one entry in Form A corresponding to like 5 to 10 rows from Subform C. How can this be implemented? I was looking for a field type like "Array" to display all records found in Subform, but the "on validate" action can't pull up Array values to populate such a field.
Rtl option creator
Hello Freinds, Does zoho already have a creator interface in rtl? I want to change it especially with forms and main bar. As far as I know zoho crm has an option for rtl
How to delete all rows in a table
I am looking for a way to delete all data from a table through the GUI. Currently I can only delete 200 rows at a time which is not efficient when a table has 8,000 rows in it. If there is a programmatic way to do it that would be helpful too.
Please support reverse alpha sort on lookup dropdowns
Built a time logging app for technicians out in the field with dropdowns to log their time against a fault or job reference. Since the list of things to select from just keeps growing.. and reference numbers with them, the current implementation of dropdown lookup field with a fixed ASCENDING sort order puts the most recent at the very bottom of the dropdown. Pain in the a**** Please please add an option for descending sort order!!
zoho creator and google map
I have a form where I can insert information about my customers like name, telephone number and address. Is there a way to verify if the addres exists? Can I use google Maps API (how)?
autofill subform
how to autofill subform using details from another form. Help me with code.
Foreign key relationship - how to lookup records based on foreign key (parent key)?
Hi all, I'm modifying the Order Management application that comes with Zoho Creator. In the New Product form, I added an Add Items subform that captures individual serial #s along with a status field that captures the location of the the item. That all works well. Each time I go in to view or edit the product, it lists the associated items in the subform. Next, I modified the Product Subform that's included as part of the New Order form because I want it to pull all the related Items records for
SAML Authentication - Is this only available for ZohoMail ?
I read that SAML authentication can be implemented for ZohoMail, but no mention of it's implementation for other Zoho Apps, namely Creator ? Why is this feature not across the range of Zoho Apps ? I have a customer who insists on using a Microsoft Enterprise Sign-On, which is not available on Creator, which has forced me to start investigating Knack.com which does offer it. Any updates or a definitive answer would be appreciated. Neil The diagram online, indicates it is across Zoho Applications,
getting { "message": "Invalid Portal" } in response.
Hi, I have been hitting the below API GET method url = https://desk.zoho.com/api/v1/tickets?include=contacts with authtoken and orgid as headers like mentioned in the API documentation. But I am getting { "message": "Invalid Portal" } in response. I am sure my request format is correct. What would be the problem? when do I receive this response. Please revert back ASAP.
Zoho Creator integration with Books
I have created custom applications in Zoho Creator for billing customers, and sending purchase orders to vendors. Some of these orders have more than 1,000 line items each order. I need to reconcile the credits/debits back to Books. So some integration is needed. Has someone done this and/or can I get some directions on where to start? Thanks.
Linking two forms imported from Excel
OK, new to creator but have some database experience. I have imported three sheets from Excel that are related, i.e they have the same unique column index in each sheet. Had to split my data into three since I had too many columns for Creator. On importing into Creator I want to link / join the forms together so that I can create a report that has all the information in one view. (From reading the help sheets I need to create a relationship to do this. Lookup or Subform.) So, on the Members form,
Email link to record
I'm trying to create an onSuccess email. I want the email to include a link to the record that was just created. How do I go about getting that url?
Add signature to different records at the same time or with deluge
Is there a way to add the same signature to different records at the same time on Zoho Creator, or add signatrue with deluge?
Subform row heights - anything to do about it?
I would like to change appearances of subform rows in Creator Forms. There is a lot of space around the subform fields, which may look good on simple forms. However on large forms this is not practical. My client is looking to move the spreadsheet below to zoho forms. Additional options for columns would also be a blessing! Are there other means to achieve my goal?
Open Google Maps mobile from an application
I am a new user of Zoho Creator and my skills are low I want to be able to open the Google maps mobile when my application is opened on an IPad Using the URL from google maps does not open the google maps app I have tried using Google maps URL scheme but it does not work Overview A URL scheme allows you to launch a native iOS application from another iOS app or a web application. You can set options in the URL that will be passed to the launched application. The Google Maps for iOS app supports
new topic posting problems
why my new topic is not getting posted?
Web Site embedded Dynamic Reports
I have an APP that takes User Input data and does a calculation & queries a database table. When it finds a Record in the database that matches the Query criteria, it generates an Output Report. I have embedded the links for the "User Input" form and the "Output Report" into my Web Site and they appear on that web page. The User Input form works properly accepting data entry from a user, and performs the calculation & query when I click the Submit button. My problem is that the "Output Report"
How to zoho creator create, update o manage variables of XML? Could you give a example?
Good afternoon everybodye, How to manage the XML response of a webservice? For example: <response><result><application_list><applications></applications></application_list><application_owner>Public</application_owner></result></response>
Ideas for Script Editor
I am not a big fan of the script editor adding parentheses. It often makes the code hard to read later. I would like to change the color coding of the text. Thanks,
Quick question
Hi, Need to import data from an Excel file, I have a column related to the checkbox field in Zoho, what do I need to put in the excel column to show in Zoho that a checkbox is checked/not checked? I've used decision boxes for the checkboxes
Change Primary Contact
Hi Team, Good day! Can i possible change the "Primary contact" of my application? see attach picture for details: picture name 123.jpg How can I change the email address send after invitation of the application? see attach picture name 1234.jpg Regards, Jee
CRM lookup not working for some users
Hi! I made a form that has a CRM lookup field (to the Contacts module). When I access the form from the application creators account the lookup field works fine. However, when I access the form as a different user the lookup field doesn't work - it just says "No matches found". Could this be a permissions problem? If so, how do I resolve it? If not, what is the problem? Thanks! Rob
Next Page