How I Can take only the time portion in date-time field??
I¡m trying to develop a form in order to book rooms, I creadte 3 field date-time, one for the date and the others two the idea is to set initial an end hour for that reservation. Problem is that I just want to show time only. Thanks a lot Regards
How to not show all the possible decimal digits?
Hi, I need your help for this little problem. I have a decimal field which must have six decimal digits. The problem is the following: if, for example, the number is 123.0 I see 123.000000. How can I show only the significant decimal digits? Thank you very much!
Good way to map an application?
I have a fairly complex application, built in Creator. Over time this application took on a much larger role in our business and has been changed quite a bit. Does anyone know of a way to build or extract an application map to document the relationships between forms and various references to html pages. Many pages have conditional url links to other pages/elements/forms and unfortunately we don't have all of this properly documented. Is there anything like a site crawler that would work with a Creator
Showing return type message as alert
I have created a custom action for selected records in the report. I am calling a custom function which is returning string message. Now how I can show the returned string as an alert message to the user. I am not finding any solution, Please help. Thanks
Big data in Zoho Creator
Can Zoho Creator support a very large database? Like 5 millions records being added each year would the app work efficiently? What about concurrent users, can it support 1,000 users at the same time?
Custom schedule is not working
Hi guys, I scheduled a task to update daily with below code: start = "2018-08-12 18:15:00" frequency = daily on start { actions { on load ( thisapp.jobready_integration.jobready(1); ) } } But its not running daily.
extract a data from a multiselect lookup
The case is as follows: In a lookup / multiselect field I have the data "Acc" and "Price", I need to store the data "Price" to total it in another field. how can I extract or store the "Price" data from the lookup / multiselect thanks for the support regards from Panamá City
latest Date entry Field automatically shown
Hy, Have 3 Forms in my Application. In 1st form have three fields-> single_Line , Multiline_1 , Multiline_2 In 2nd Form have two Fields-> Date_1 , Note_1 In 3rd Form have two Fields-> Date_2 , Note_2 when i put entry on single_Line Field then automatically Multine_1 filled with Note_1 and Multiline_2 filled with Note_2 Needed In between Multiline_1 and Multiline_2 whom have Latest Note(Note_1 ,Note_2)Shows only which is sort by Date desc, and Other Multiline field will be hide Automatically
Custom portal add on licence and apps
Hi, Can I use several apps (or customers portal) with one custom portal licence ? Regards,
Possible to submit partial data if form is closed?
Hi all, Does anyone know if you can 'force submit' the data entered into a form if the user closes the url part way through filling in the form instead of clicking the submit button. This partial data that they've entered (and the point at which they dropped out) is really important for me to know about for my project. Thanks! Lindsay
Count number of of comma separate values
Hi all, I'm wondering if there's a way of counting the number of comma separated values in a field? My report looks like this. I would like to count the number of 'participation dates' for each person and keep a running total in the 'Number of attendances field'. The 'participation date' is a bidirectional lookup field whereby when a person is selected from a lookup in the 'participation form', the date that they participated is shown here. So Bill Smith = 0 John Day = 4 etc. Is this possible?
Hiding Fields depending on the input of a lookup field
I am trying to hide or show two fields in a form called PPE _Distribution. I have hidden the two fields on load and that works but then I want theform to show Select_Employee field when the Select_Location field is "Employee" and to show Select_Job_Number when the "Select_Location" field is Job Numbers. The Location field is a lookup field (drop down) from the form Location and that field is called Stock_Location. I am pretty new to coding and deluge script. I have tried several examples from
Using a Barcode in a order form
Hi I have a form where customers can select which product they want to buy. There are 4 different products and for each a dropdown where can select 0 to 20 as quantity. I want to be able to generate an unique barcode for each product. For example: item1barcode1 item1barcode2 item2barcode1 item2barcode2 .... So each time a customer buys products the barcode should be unique (sort of increment) Is this possibe and how? Kind regards
Popup Area Calculator
Hi All, my first post here, relatively new to Creator. I would like to create a popup calculator to help calculate the area of a given space. Ideally, the popup will have inputs for width and length, and then will return the area back to the form in the required field. I have played a little with this, and my questions is what is the best way to do this, or is there already a widget like this floating around? I have tried creating another form, with width and length fields, and a calculation field,
Import records from CSV with lookup fields
Hi, I want to import a list of Customers from CSV file. The problem is, Customer has a lookup field to Salesperson. Therefore, before the import, I manually modified the CSV file to include a column to reference the Zoho ID of the specific Salesperson I want each Customer to be associated with. I map the Sales column property during the import process but the import failed. See screenshot. So, what's the proper way to import records with lookup fields to other forms?
Creator 5 - Error Reports and Many Bug, unfinished product
Have you guys never heard of Beta stages? There are so many things lacking in the new creator and it is so buggy it is unbelievable. Don't get me wrong, I am really looking forward to the final product but trust me guys, you're not there yet. Trust me, If I was just starting a trial of your product I would have walked away by now to try something else. Here some of what I have noticed so far: First, Support Live Chat is not working at all, I presumed you've just turned it off as there must be many
Zoho Creator Image API Access
Hi all, how can i access images from Zoho Creator with an API Login? Do i need to setup a proxy that login and get some cookies until i can grab the Image or do i miss something? best, Daniel
error message in Zoho creator from a link to form on our google site
The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. The link to the form is on a google site. The error happens from time to time and is inconsistent in the circumstances. I will get one or two calls and then nothing and then a couple of months will go by and it will happen again. It is usually accessing using a phone (android and iphone). Can't pinpoint the issue.
Create a field to track time
Hey, Seems like this should be easy but can't get my mind wrapped around it. I want to create a field that tracks how long my workout took (actually, its how long until I couldn't go anymore, the Max Out Time if any of you are familiar with Insanity Max 30). I want a time field so that I can eventually do some reporting to see how much I've improved, time-wise, in my workouts. Yet, I can't seem to figure out how to properly build a field that can track time... or if it's just a number or single
Reading subforms values related to specific record from another form
Hi all, I have the form A which has a key field "K" and also there's a subform "A.1" In a different form "B" I need: 1. Select the field K 2. Based on the selected record by the field K, allows me to select in a subform, records from "A.1" subform from A. This applied should be. Job candidates are entered on Candidates Form "A" when they register into a job search process. They have an unique name (K key field) and also there's a subform for Job references (A.1) In form "Reference validation" "B"
Embedded form doesn't work in internet explorer
Embedded form doesn't work in internet explorer 11. It just keeps loading. Here is my site https://www.mello.com.na/request-a-quote Thanks in advance.
Form Design and number of columns
I need to have 4 fields horizontally across the page. It seems Creator will only handle 3. Is there any workaround for this? I also noticed that when using the Integration field that there is alot of extra space after that field. I have attached 2 images. One is the Form Builder and the other is the live app page. Any tricks would be helpful to correct this issue.
Reports stopped exporting in landscape
Hi - My scheduled reports recently started exporting in .pdf portrait instead of landscape. Is there a setting I need to adjust to get them to export in landscape again? Thanks.
custom look and feel?
On the Zoho Creator website. They have a section that shows someone using Zoho creator to customize how the fields are displayed on the Zoho creator mobile App?? Is this actually possible, I can't find it. Also for the website, can you only select themes? nothing else?
Incomplete expression Else If
I'm stumbled. Please help ! Why "Error at line number: 12 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression" (Line 12 is at the Else If) { } sendmail [ from:zoho.adminuserid to:input.Email subject:"Confirmed" message:"Your message" content type:HTML ] else if(input.Assessment_Status="Not Successful") { } sendmail [ from:zoho.adminuserid to:input.Email subject:"Not Successful" message:"Your message" content type:HTML ]
TLS v1.2 upgrade
Hello everyone, We(Zoho Creator) want to let you know that we are upgrading our TLS standards to the latest version 1.2 which is more secure and meets the updated PCI standards. We will be retiring the support for TLS versions 1.0 and 1.1 on 31 August 2018. After this date, all our users will be required to update their processing solutions to TLS v1.2 for the secure transfer of data with us. What is TLS? Transport Layer Security (TLS), formerly Secure Sockets Layer (SSL), is the old security
Number field + stepper
Hi, any chance to have a Number field with stepper? Example: Number field, default is 100 and I would need to add or remove step 1 by using (+) or (-) "buttons". Ja
Stateless form
Hi, how to create stateless forms and how to customize the button in creator5.
SubForm field updating form field record and Auto Number
In the below Workflow, identifying re update the filed is not working well for each row in SubForm info "Add Stock in Inventory" + row.Part_Name; rec = Add_Item[ID == row.Part_Name]; rec.Stocks_in_Inventory=rec.Stocks_in_Inventory + row.Number_of_Items; } I want to use Auto numewber to fill the Form Field but it is getting generated only on submission. I want to add Text + Auto number for some filed. What is the option
Zoho Creator - Dynamic Lookups
HI There, I have read multiple threads around using sub forms and looking up certain data in the sub form but I'm struggling to get anything to work. My problem is as follows: I have a main form called Service_Request and in this form I have a filed called "Account1" and a sub form called "Service_Address". The "Service_Address" subform pulls through several fields from the "Service_Address form including the fields, Site, Building_Name/Number, Address_Line2, County, Post_code. I also have a field
portal do cliente
pessoal, tenho uma aplicação no zoho creator, construída antes do creator 5. ontem instalei uma nova aplicação, sendo que utilizei um modelo. na primeira aplicação (antes do creator 5) não aparece uma tela relacionada ao portal de cliente, inclusive ela remete para a versão anterior. na segunda aplicação (após o creator 5) aparece uma tela relacionada ao portal do cliente. Isso tem prejudicado meu pojeto, porque não consigo vincular ao meu domínio.
Detail View of Report on Zoho Creator 5 not showing 3rd level subform data
Hi all, So I want to show on a detail view of a report data of a subform which belongs to a form that's a subform on the form in which de report is based on. Form 1 (Report based on this one) Form 2 (Subform on Form 1) Form 3 (Subform on Form 2, this one has the fields I want to show on the Detail View of the report) The thing is that I select the 3 fields of the subform that I want to show, delimited by a space, but when I go to the report, the fields that I selected are ignored and it shows me
Zoho Creator - Salesperson Login
Would Zoho Creator allow each salesperson to login through a portal and enter their own sales order and not be able to view other salesperson orders? Thanks
Events in mobile's own calendar
Hello, Is there a way to send events to my customer portal users to their cellphone calendars? For example, when you have a flight to take, you recieve an email with the date and time and then it automatically appears in the cellphone's own calendar, (not Zoho calendar) I would like to send events and post them in the user's cellphone calendar, (not Zoho calendar), through my app which runs under the customer portal
Point of sale
Hello, I have tried to put this point of sale for one of my clients, integrating the entire zoho one suite, but the point of sale fails and fails and fails again, we have made it from scratch three times, and in the end it fails, I can recommend a point of sale that is from another brand, but that is integrated with Zoho inventory, because we can no longer waste time with this app my case is 1093529
POST request to attach file
Calling on ZOHO Creator gurus! Can anyone tell me if it's possible to post file attachment using Deluge? I'm developing app that works with ZOHO Books sales orders module. When client 'accepts' quote, application generates PDF file and attaches it back to a Sales Order record in ZOHO Books using API: https://www.zoho.com/books/api/v3/#Sales-Order_Add_attachment_to_a_sales_order
customer portal - different permissions for different users
hi in customer portal there is same permission level for all users how can i make different permissions for different users? oк make to see different sets of views and forms for different group of users? group1 - set1 (view 1,2,3, form 1,2,3) group2 - set2 (view 4,5,6, form 4,5,6) "You can share select components of an application (forms or views) or the entire application with the members of your portal. All your users will have the same level of access privilege. Access privileges can be revoked
Ask the Experts 3: Live Q&A: Find out all about sharing your Zoho Creator application with other users.
Hi everyone, As you might already know, every application that you create on Zoho Creator can be shared with other users — be it people within your organization or even outside. As an admin of the app, you can share the entire application or specific components of the application with your users. You can add users and permit them to access, edit, and modify relevant data and app components. In this month's Ask the Experts session, we would like to address all your questions related to sharing your
Calculation errors in formula to compute age
I'm using the suggested formula to compute Age from DOB, but random errors are occurring in a View. Manual update of DOB fixes individual Age fields. Given that a formula should be updated when a dependent field value changes, Using 'zoho.currentdate ' - since it changes daily - would be thought to cause recalculation. Do I need to perform some process to force all records to recalulate (for instance, sort on Age)
Report-Pivot-Chart - View underlying data
HI, when the "View underlying data" is flagged a view related to the specific graph element is opened. This is a very cool function. Is there a way to select what columns let to show and what column hide? tks, Pippo
Next Page