Creating bi-directional relationship through lookup
Hi, We are building our inventory module. We currently have a challenge. Will be helpful if some one suggest a fix. Overview of the process. 1. An order for an item gets booked. Here order booking is form, and list of items booked are through a form embedded as a subform. 2. List of items to be ordered is a lookup field from inventory master form. 3. When list of items to be ordered is booked by customer, each part ordered quantity is to be updated in the inventory master forms field Order
Iterate over Leads
I am trying to write a script which will need to find a particular lead OR contact (by email). My current approach is to get all leads, then iterate over the collection until the appropriate one is found. Here is my code: //get the appropriate category loc = zoho.crm.getRecords("Leads"); //leads or contacts if (wasContact) { loc = zoho.crm.getRecords("Contacts"); } //find by email oldItem = null; for each assoc item in loc { if (item.email == old.doctorEmail && item.pr_account == true) { oldItem
Pick the topic for the next Ask the Expert Session.
Hi folks, We hope you enjoy our monthly Ask the Expert sessions! We're eager to host our next ATE session, that will be held at the end of this month. Below are a few topics that you'll find useful. Which one would you like us to cover next? Go ahead and pick one!
How to configure Zoho Creator and CRM
I am trying lot of time to integration of zoho CRM and Creator but it is not successd result. Already reported to team and emailed but not positive response. Please help me.
Can not see live chat support and can not add developer.
Hi, I am using Zoho Creator Premium plan but I don't see the live chat system and I cannot add the developer to my application. Please see the attcahed file.
How to create schedule for every 30 minutes
Hi guys, I need to execute task for every 30 minutes. How can i achieve this? Regards, Termcon
Adding Customer Information to Form
I am trying to create a check in form and use the serial number of a piece of equipment we have received as a way of automatically adding customer information to the form. We work with the same customers and equipment over and over and thought using the serial number would be the quickest way possible to identify the customer rather than typing it in every time. I assume it will be a lookup field, maybe a sub form? I have a customer list that has the serial number on it. Any help would be appreciated!
Creating a Workflow with a multi-select field
Question 1: Who was involved in the incident. To achieve this I have a lookup field (Names) being displayed as a multi-select field. Question 2: For each of the people involved, were they properly licensed. There is not a definite number of names that will be selected each time. I would like to have a workflow set up where I have a response option for question 2 for each of the names selected in question 2. For example: Who was involved in the incident: Jill Bob Fred Was/Is Jill properly licensed?
Problem with iframe alignment
Hello - I have a page with 2 iframes. The problem I have is that I cannot seem to get the two iframes to align the content the same way. The first iframe is correctly aligning content to the top, but the second iframe is aligning content to middle (the content being displayed inside the iframe has a smaller height than the first iframe, but the two iframes themselves are set to the same height attribute). I have tried using height:xx% instead of pixels, but this doesn't alter how the content is displayed.
Sort SubForms
PLEASE allow records that display in a subform to be sorted by the field of our choosing. There are numerous reasons this should be allowed: e.g. sort by item #, date, alphabetically etc. Thank you!!
Adjust label width in Detail Record View, 2-column layout.
When I add additional fields to the Detailed Record View and select the 2-column layout, I seem to be stuck with the label extending half-way across the screen. This isn’t very useful as the labels are usually very short but the field content can be long. Can the label width be variable? Or provide an additional template with the labels only extending 1/4 way across?
Relationship scenario
Form LR is used to capture details from the user. Now we have to create an invoice for this LR so we created 2 forms: Invoice & Invoice LR. One invoice can have multiple LR associated with it. And while creating the Invoice we have to choose multiple existing LR that's why we created another form Invoice LR which has lookup field to LR. Check "Invoice Creation" file attached. Now upon successful submission of Invoice, we are linking the selected LR and Invoice with deluge script (not found any configurational
ZOHO TAKES FOREVER TO HELP!!!
We have been having sandbox issues for days, we have also had multiple issues in the past and ZOHO never gets back to us. They also say there "technical team is working on it" "its in the que" "its a trouble shooting ticket" Its becoming ridiculous that we aren't getting any help considering we are paying so much money to use there service. I wish someone would help us.
Built-In Function Prefix
Good day, I am facing the strange behavior of Zoho. I do have two almost similar scripts that run on different forms, but on the same subforms. At first both script were working fine, but later it just stopped and was giving errors. I opened the script and see that strange prefix(APPNAME) for built-in functions such as isBlank and isNull. I guess it started treating them as custom functions, but still couldn't find the bug. And every time I rewrite and save the script, functions get prefixes.
Things that used to work no longer do
I suppose I am just venting, but I am furious and need to blow off some steam. I spend several months last spring developing an app for the next school year. Debugged it and it all worked fine last May. Now that the school year is starting I have found three things that used to work fine that no longer do. They are Zoho bugs, not my code. - A from is configured to redirect to another form when done. Works fine in a web browser. iPad app says can't open url. This used to work just fine. Why
MY CHARGEDESK Deleuge Code to integrate with zoho application
Dear Folks, i build for my application a function that make the basic api request of chargedesk a powerfull tool for handling payment ( like braintree) . I build the code for my purpose but give an idea exact to how to make the calls (POST/GET) and how to proper parser the JSON response , i'll attach the response from my test https://chargedesk.com/api-docs Please ignore all reference to my application and focus on how to parse JSON few thing to remind: 1) in the basic auth chargdesk release one
extract data from a lookup field
Good afternoon, I have a problem, we currently have a quote form that has a field lookup that shows in a multiselect way the form data called Accessories, we want to know how we can extract the data from a field lookup the price to add it? Regards
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
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
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"
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.
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 ]
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.
Next Page