On a form, value of a field depends on the selection of a data in a drop down list
In a form "Session Location" I have a single line field "Location Name" and a multi line field "Location Address". Each location has a unique address. This form allows me to record an address for any specific location. In another form "Sessions" I have a drop down list to select the location name and a multi line field to display the corresponding address. When I select a location in the drop down list, I want the muli line field to display the corresponding address. How can I do it? Thank you for
Can you show/hide edit record fields based on which report calls the edit record?
Is there a way to detect which report the Edit record command came from, and use it in the Form Actions - On Edit - On Load to show/hide specific fields?
Populate Multi selection Look up field
Hi, Is it possible to populate a multi select lookup field in a form? Main form: has a date field and a Orders multi select lookup field Here is the behavior i want: 1) User selects a date. 2) On User Input, the script populates the Orders multi select lookup field based on the date selected. input.Orders.add(orderID) doesn't seem to do anything.
splitting records in report equally to no. of users
Hi, I want to assign the no. of records in a report to the number users after the equal division of the records. say, I have 500 records in a report i want to assign it to the 4 users. so I will do the division of 500/4. When the no. of records divisible by no. of users (i.e.) when remainder is 0, then the code is working for me. But when it is not divisible (i.e.) remainder > 0 then my code not working. the remainder no. of records is missing for me during assignment to the users. Please help me
Currency Field
How to add a currency which is not listed out in the Currency Field (LAK for instancen which is the Lao currency)? Thank you for your help.
Change "This report is not accessible." page
Hi all, I have a public form that, on edit, will send an email notification. This all works fine. When I click submit, though, I get sent to the "This report is not accessible" page. I don't want the user to see the reports, but I also don't want them to see this page. How can I direct them to a page that just says "Data Entry Successful"? Thanks in advance! Levi
Fetch SubForm data from another Creator app
I'm looking to pull data into one Creator app from another, I have successful pulled in individual fields from the Parent form using a Function. But I also need to pull in data from it's SubForm and I'm having trouble getting it working The Function code I am using for the Parent form fields is: string arAccess(int Ar_Lu) { fetchAr = Area [ID == input.Ar_Lu; return fetchAr.Ar_Name; } Any help much appreciated. Thanks
Retaining variables after form submission
Is there a way to retain variable values after a form has been submitted? I have an evaluation form where a supervisor evaluates various people. I need them to be able to select a subordinate from a drop down, complete the evaluation, submit it, and then select another subordinate. The subordinate list is a lookup that is filtered, and is dependent on a previous field for the filtering. It works ow, but you need to re-authenticate each time to see the list of subordinates. Thanks!
Are Note (plaintext) fields supported in subForms?
I do not see the Notes field as an option for a subForm field. I was able to add it to the form field definition in code without error but it ignores the new field of type plaintext. I could not find this listed in the subForm known issues and limitations paper, is this documented? Also here is a forum entry from support saying there is no restriction on subForm fields. So there is some confusion. thanks, tt
Embed a stateless form more than once in the same in a page, is it possible?
Hi, is it possible to embed the same stateless form more than once in a page like the example below? when I try, only the first one loads, and the other two never load... thanks Luis htmlpage Page() <%{%> <table border=1><tr> <td> <div elName='zc-component' formLinkName='MyForm' params='zc_Header=true&field=1'></div> </td> <td> <div elName='zc-component' formLinkName='MyForm' params='zc_Header=true&field=2'></div> </td> <td> <div elName='zc-component' formLinkName='MyForm' params='zc_Header=true&field=3'></div>
Formula referencing date entered on form.
Hello, I am needing some help understanding how to write a formula that references a date entered into my form so that a report can be generated. Please see the attached snipit for a better reference. Thanks in advance for the help. Ryan
updating from background Paypal subform
There's limited access to the paypal subform, it doesn't appear I can pull any of those fields into the reports, so I'm trying to update a form field, this seems simple/easy but isn't working, any thoughts? On Edit - On Success if (ZC_Payment.payment_status == "Completed") { input.Payment = "paid"; }
Inventory Item to Unit relationship (many to many)
I'm creating an application in which I have- 1. a list of inventory items 2. a list of units of measure Now want to create a Sub-form in the Items Form, where I can define one Base Unit of Measure, and as many Alternate units of measure For example I want to define 1 LITRE of Oil = 0.8 KG = 1 CAN. Here LITRE will be BASE UNIT Can anybody help me do this? The units should not be repeated, and once BASE UNIT is defined, it cannot be changed
Logic problem
I have three fields: Login - which uses a single line field that will take a value and evaluate it using the if condition; Association Selected - which will be populated, based on the Login field if statement; and Candidate - that will filter a database list from another form and only show those records that meet the value of Association Selected. The first half works (using a login value to set the value of Association Selected), and the second half works if I type in the Association name in Association
Why Subform is not showing User field type and Notes field type?
In my simple task management system, i have a subform that has the following fields and types: Service (lookup) Assignee (users) Notes (Add Note) Due Date (date) In the actual subform, only the Service and Due Date show up? Why? Where can I find documentations of the subform limitations? If these are indeeded limited, what's the recommended workaround?
Subform Shows No Records [ Resolved ]
My main for, "Lots", has a subform, "Residents". I created them both from an Excel file at the same time. I later decided that I wanted "Residents" to be a subform. Getting things to link up properly was difficult. At first, the subform showed no records. Using Deluge, I can fix this by editing each of the Lots records. This is a painstaking process. I have more data I want to bring in to make additional subforms. How can i do this so the linking works right away?
limited to 50 published forms/reports
I started building a custom CRM for a new client using a subscription at Enterprise level, but just learned that it's limited to only 50 published forms/reports (but there's nothing in the subscription pages that will tell you so) I've built similar apps for other clients in the past, without this limitation, so not sure when that change was made, but pretty crazy. I guess Creator is now being oriented for use by babysitters and softball teams, rather than businesses. Checked with customer support
Null displays on pages in phone app
I am having a problem where a page I have that display correctly through browsers on both desktops and phones, only displays as (null) through either the Creator app or the Creator Portal app. I'm not sure what is causing the problem because other pages seem to display without a problem in the app. I've tested it by taking the page down to it's bare bones with just the work 'Test' and it still displays as (null) in the app. The only thing I can think is that it has something to do with the location
call function during onclick of button in page
Hi, I am trying to call the creator function say example thisapp.func() during onclick of button or anchor tag. I have tried the below code which is working automatically on page loads instead of onclick of button. <a class='zc-formbutton' onclick="<%=thisapp.divideTelecaller()%>">Wanna Split up and assign Clients to users?Click here</a> Thanks, ITKES
SUBFORM IN ZOHO CREATOR
Hi, Is it possible to fix the number of rows in subforms by giving the number in number field. I know that it is able to fix the number of rows by it's field properties(set default entries and limit maximum entries),But my requirement is based on the value which is given when the application is on live mode. kindly help me. Thank you.
Showing images on a form
How do I show an image from the database on my form? I'm able to load all of the other data but I can't get it to display the image. I'm able to load the full path to the image.
You may only fill this form out one time --- message?
Hello, would somebody please let me know what this message means? You may only fill this form out one time I have created one form, intended to ulpoad files that only allows me to enter one record regardless of the sisze of the record. Even with empty fields! what does this mean?? thanks a lot
API form submission - retrieve & use response status on website (callback)
We have a html/php form on our website that submits data to our creator app via the https://creator.zoho.com/api/xml/write API URL. When the form is submitted, we want to retrieve the status response from the Zoho app and use it on the website i.e. "Success" or "Failure, enter a valid..." I can't find any documentation on this, can anybody share the simplest way to do it. Many thanks
how to send creator data to google spreadsheet
how do I send some data from my creator app to a cell in google sheets?
API - Create Google Calendar event when record is added. Without G suite
Hi, I dont have G suite but I know that it is possible to create/update a Google Calendar event when a record is added/edited via API. How would I go about this?
Drop down
In a form A we have a drop down field based on a form B with 2 fields: location name and location address. When we select a data (location name) in the drop down field, how to display the location address in form A in a different field? Thank you for your help.
Text() Function
In the Help system under Built-in-Functions there is one named text(). I cannot find it elsewhere or get it to compile.
calculate the age of a person doesn't work
Hi, I want to calculate the age of a person, so I tried this formula(I found it in Zoho Creator Help) in formula field. ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2) but it's doesn't work properly. for example Today is 30-Sep-2017 BOD of the person is 02-Oct-1973 Age of a person : 44.02 (It must be 43!) I live in Japan, but I've set Japanese Time Zone in General Settings. I have no idea...Please Help me... I'm sorry for my poor English. Thanks.
Forms and sub-forms
Suppose we have a form and a sub-form. The form has a drop down field with, for instance, two different data, A and B. A refers to sub-form a and B to sub-form b. Is it possible to show only sub-form a when A is selected (sub-form B being hidden) and sub-form b when B is selected? Thank you for your help.
Fetching data from another application
Hi Zoho Forum! Please can you help me :) I want to use the Aggregate Records code to fetch data from another application in my account and use the data on a "PAGE", but I don't know if this is possible.. Example below (which doesn't work) <variable> = [Application name] formname[criteria].sum(<fieldname>); Best regards, Rob
Count records which have had a subform record added this week / month / year
WeekCallcount = Company[Call_Logs.Time_of_call in this week].count(); MonthCallcount = Company[Call_Logs.Time_of_call in this month].count(); YearCallcount = Company[Call_Logs.Time_of_call in this year].count(); Company = my form with Company records and subforms for contacts / Call_logs Call_logs = subform within Company, used everytime customer is contacted The functions above list total amount of calls in the time periods, however I want to add another set of functions which contains
Pivot Table doesn't work in smartphones
Everyday I have issues with the pivots of my customers whom use smarphones because some pivots NEVER, NEVER are synced. I was informed that a pivote takes 10 to 20 minutes to be synced but that doesn't work. The last solution suggested was to use the "Regenerate" button but it doesn't available for smartphones. My customers are very dissapointed with the Zoho Solutions because we can't trust on pivot table reports. Are we the only business with this issue? We have reported this situation 2 months
Any ideas to improve the screen display speed of Zoho Creator’s form that has lookup fields.
Hi, I need design ideas to improve the screen display speed of Zoho Creator’s form that has lookup fields. Some lookup destinations has over 400,000 records. I think that the lookup fields automatically read the records of the lookup destination at the timing before the lookup fields is displayed, but is there any way to disable the reading or control the number of records to improve the display speed? We'd tested to investigate what is the main reason to slow the screen speed as follows: Testing
How can I submit eMail data from a service account.
Hi, Before the restriction on 'public sharing', I was able to set up a form for eMail data import, and I would be able to have our SQL server use a service account (email address) to send data into ZOHO. Now the restriction is in place, I cant do that, and I will have to set up the SQL Server account as a user in Zoho, however this is not an email box that accepts incoming emails. So I cant authorise the Zoho account. How can I achieve email posting of data, as I used to with the applications that
Sending Email to Collection of Records
Hello, I need to send an email to the collection of records, where collection of records belongs to the single contact no or email. So I need send a single email to those collection of records. So, I tried with schedule by added time, there i have given the criteria but it was also not working for me, it is sending email with collection of records for collection of record's count times. Say example, if i have 10 records as a collection belongs to a single contact or email, it is sending 10 emails
Using Deluge to programmatically insert a URL into a URL Field
Hello. I'm evaluating Zoho Creator and have a question about using deluge to programmatically insert a URL field on a form. My URL looks like this and works when I paste the URL portion of the href into the address bar: <a href="https://app.zohocreator.com/<myusername>/<myapplicationname>/#Report:MyReport?Jobs=DBA&TheSkill=Innovation" target="_blank" title=""><Innovation></a> To insert the URL, I'm using the Add Record deluge task which uses INSERT INTO <formname> URL_FIELD = my_URL_shown_above.
Function calling a condition
I'm trying to set up a function to set a variable based on the current logged in user. void fuction_name() { if (zoho.loginuser == zoho.adminuser) { path = "path_1"; } else { path = "path_2"; } } But I'm not sure how to invoke this function when loading a form. The form will need to do things with the variable "path" but after invoking the function, it errors saying "variable path not defined". thisapp.function_name(); Single_Line=path; What am I doing
Changing Field Name value
Hi Everyone, Is it possible to change the field name on a form base don the value of another field ? So I have a drop down where I select the account name and then based on that account name I would like a particular field name to change. Field deluge is "Reference", can you change the field name So for account 1 the field name would be "REQ#" For account 2 the field name would be "TASK#" Thanks Matt P
Brain Fart - Simplest way to update many records in another form with my current form?
I feel like I should know how to do this, but my brain mapping of how to solve this just isn't working, or maybe I'm overthinking it, or probably both. So I have a form for my products, called "Add_Product". This is where data is stored about each product, like its name, size, quantity on hand, etc. Then I have another form for quick inventory updating called "Add_Inventory". In this form, I have a field for each product (I know this probably isn't the best way to do this, but it seems to work
How to insert records in a HTML Page/custom created HTML Form in Creator?
Hi, I created a custom HTML Page. I have 3 fields namely name, email and contact number. Using this custom page, I want to insert records. Basically, I want this page to mimic the behavior of a standard Form created in Zoho Creator. I tried to put the Deluge scripts to insert, however it is not working out. Also, tried to use a function with parameters, did not work out. Please let me know if this is possible in Zoho Creator or not. Unfortunately, the documents to create custom functionality
Next Page