Disabled field on grid view
Hello, Is there a way to disable a field under the grid view? On the guidance (grid view section) there is an example, please see picture below, on this example one column (category) seems disabled, like a read-only column, this is exactly what I would like to achieve. Can you please tell me how I can do this? Many thanks
Differente Information Form Application and Form Edit
Good day, I have a bug in my app, the name of some forms displays other name than the edit app. Support is enable App Compras e Inventario Form Subformpadd Fields "Requerido" "Enviado" "Pendiente" Form Shipping Field "Tipo Envio" on live mode it duplicates two times "Colaborador" Always in the App Bar Menu "Almacenes" should be displayed as "Crear"
Adding Doc/sheet links in Creator Dashboard
Hello, Is there a way to place links in Creator Dashboard to Docs and Sheets? For e.g. supposing I've created 2 docs & some sheets, I'd like them to be placed in the Creator Dashboard to make it easy for my users to access them without opening separate browser windows. Is this possible? Thanks.
Trying to Auto Populate error message
Hi I get this error message while trying to create an autopopulate - the SKUUnformatted is a alphanumeric string, I am not sure what BIGINT is. Thank you for your help in advance
Publish Report View - Public can still edit via "View Record"
Hi All, I have a report view that I have published so that it may be viewed by anyone I share the link with. I'd like there to be no edit capability from this view so I have set all options under "Record Permissions" to Hide in the publish menu of the report settings. This removes the edit/delete/duplicate options from the record menu however the "view record" option is still available. If a public user clicks "view record" a new window is displayed that now has the edit/duplicate and custom actions
Re-arranging forms in Zoho creator
I had a quick question about re-arranging forms for creator. I find now that the forms we have created should exist in a couple of sections to make the workflow cleaner. If I go into creator and create a new form I can place it under an existing section. However, I can't find a way to re-arrange forms which have already been created either into existing section, or under a new section. Is this possible and how it would be done? Thanks
how to do this
I am wanting to create a database to show the following: top 100 sales consultants, top 100 in points, show stats of order history, each level completed and moved to the next one, active or not active depending on criteria, Total commission earnings. Do I need to setup the forms according to the info on the webpages? Then it will pull the data from their when connected? As for the product displayed on the website, do I need to create a form that lists all the products according to how they are
Filter in a view embedded in a HTML View
Hello. I have a main HTML view that include some views. I pass in the url a filter to the html view (something like https://creator.zoho.com/....../#View:NEW_Week_Report?dateFrom=03-Mar-2013&dateTo=21-Mar-2013). Using Script Builder I embed some views in the html view. For example: <div elName='zc-component' appLinkName='myAplication' sharedBy='myUser' viewLinkName='myView' params='zc_Header=false&zc_SecHeader=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Filter=true&zc_Search=false&zc_Paging=false&zc_SumRow=false&zc_ColMenu=false&zc_Summary=false&zc_RecSelect=false&zc_AltRowClr=false&zc_SaveRec=false'>Loading
Employee Database with Skills
Maybe someone can give me an advice here :) I would like to know what is the best way is to do this. I am creating an employee database with forms: One form has all the employee basic data (name, birthday, join date, ...). In addition every employee has certain skills: java, c++, Windows, Linux, ... Each skill should have a different rating for each employee with 1-5 (1 = poor knowledge, 5 = excellent knowledge). Example: Employe 1: java 2 Windows 4 Linux 5 Important is: Finally there will be so
Uncheck how data is stored in creator
I created a form using creator. I used the default to store the data within creator... How do I change this option to save it in a reports table? I am trying find a way to uncheck the store data option... Can anyone help? Thanks
mass adding / registration users
hi new users add in next manner 1) register user as new user in creator.zoho.com via their email 2) each new user add in my app via share access how can i automate such operation for prepared list of users (more than 100)? for example, operation of registration of users
Search all forms
Hi, is there a way to search all forms to bring up details of a specific registration. Let me explain. I have 8 identical forms that each contain the same fields. There is vehicle make, vehicle registration, driver, mileages, service due etc. Each form has a different name. I would like to have the facility to search all the forms for a specific registration number without having to open each form. Can someone help me please Thank you very much
Automatic report sorting by hided column
I would like to sort reports by columns what are not showing in report.. is that possible.. How?
create relation between 2 forms on existing fields
Hi, I imported two forms from excel (table1 and table2). Now I need to link the two tables using existing fields but I do not understand how to do. The table1 and table 2 has field "id" to be linked. I've read this, but don't run: https://help.creator.zoho.com/Creating-relationship.html#Creating_relationship_from_existing_relations Can you help me?
Get data from reports into creator
Hello, How can I do a query on tables or views in my Zoho Reports account in deluge (from Zoho Creator)? Thanks David
Fetch Product list inside a QUote in zoho crm to zoho creator
Is this possible?
input text to search box
Hi, I am trying to create a URL link so when user click on the link it will open a specific page and input the respective field entry to the search box of the page automatically. Here is the details what I am looking for - - In the above screenshot you can see "FCC MVPD" link which redirect the user to the below link https://apps.fcc.gov/coals/forms/search/cableSearchNf.cfm So in the above link you can see several search criteria where I just want to enter the MVPD name ( here comcast) in the
Can you pass field filter parameters in embedded Form/Views in HTML Views?
Is there a way to pass field filter parameters to <div elName='zc-component'...> embedded forms in HTML Views? I thought it could be passed in the params property, but it seems to ignore anything but zc_ parameters. e.g. <div elName='zc-component' viewLinkName='Tasks_Dashboard' params='Project=parProject&zc_Header=true'>Loading Tasks...</div> Thanks, Walter
Lookup field returning strange values
Hi there, I have a lookup field drop down, pulling values from another form which are displaying simply as 1, 2, 3 etc. I want to use a deluge script to do certain things based on the value of the lookup field. However, when I get the value of the lookup field in a script, I'm not getting the visible value of the field (1,2, 3, etc) but getting another strange number eg. 1365899000000572499. Can someone advise how I can get the displayed value of the lookup field rather than this strange number?
Format of LookUp field in Record Summary designer
When I drag in a LookUp field, I can't get the label to format correctly in the Record Summary designer. Even when I select "Without Label" it leaves the Related Field label in--but on a different. Tried various formatting, playing with HTML, etc. Can't get this to look like "regular" fields dragged in.
maximum number of fields that can be used ?
I have built an application called questionario with many fields of different types. Now I have added 3 fields of type " radio " . If I try to insert a quarter the process remains blocked by displaying the message adding . Is there a maximum number of fields that can be used ?
nightly batch data jobs
How do I schedule nightly data batch jobs for updates? I am trying to use the scheduler but it does not allow an interval .
Update dropdown list with new value
When creating a Lookup field Creator provides the option: "Show a link to add new entry in Field01" This option allows the user to add new values which will subsequently be added to the related table and therefore show up in the dropdown the next time the user enters a new record. I want to create the same functionality for a Dropdown field using an on input script. My problem is I am totally new to this and don't really know where to start. I am starting to understand Deluge but I haven't written
Zoho Creator Reports
New to Zoho Creator. I'm testing things out right now to see if it meets my needs. I don't want to have to mess with a separate Zoho Reports App to import it all into, but I see you can do basic reports and filters within Creator. If I have tables of expenses or payments for services from clients...i basically need amount totals for all the rows in a report. I basically want totals of records and currency totals. Is this available in report settings? Please help with basic instructions. Again
Pívot report from different forms
Hello, I need to create a Pivot report that includes the items from various forms, I mean, let's say I have 4 forms: One Called "Store" with 2 fields: - Single Line -> called Ref - Single Line -> called pants Second called "Employee" - Single Line -> called worker Third called "Shifts" - Single Line -> called hours Fourth called "Company" - Lookup field from the form Store -> called RefLookup (display the field "Ref") - Lookup field from the form Employee -> called workerLookup
Next & Previous buttons/actions in a form
I'd like a Next and Previous button on the Edit screen. I'd like them to have the same action as "update" Sometimes we want to change several records with different information. I'd like to pull up a view, click edit on the first record, then make changes and hit "next" and have it save the changes and bring up the next record.
Zoho Creator Form - 3 things I need help with..
Hi guys, I'm using Zoho Creator for forms - now it's been a while since using it - but wanted to see if these things are now capable. - Make my forms responsive (so that they resize in any device) - Make my forms being able to work on mobile on tablet - as with the current site I have: http://www.newslinkpromo.com.au/footballfever/ Even though it works on desktop computers - with mobiles and tablets no matter what it keeps saying my verification code is incorrect - (even though it is correct) - Anyway
Lookup and if statement issue.
I have an On User Input script that is checking the contents of a lookup. Depending on the choice, I want to show a new field. The dropdown lookup has device categories, tablet, smartphone etc, upon the choice of smartphone I want a new field to pop up where they can put what the device is. if (input.Device_Categories.Device_Category == "Mobile Phone/Smartphone") { show Mobile_or_Tablet_Type; } I keep getting the following error: Improper Statements/Expressions found java.lang.NullPointerException
urgent - iphone mobile app url field
hi using zoho creator's apps for iphone and for android in app there is url field. when use android - all works well when use iphone - in url field link do not appear. see screenshots urls - in application how entry looks in zoho creator in android (all works well) how entry looks in zoho creator in iphone - url link do not appear & link is not clickable
Zoho creator iPad
When using the creator app? I receive this message "This form cannot be displayed" when I try to open a form on my iPad. The form loads on the iPhone fine.
Nested lookup for data entry
I need to implement a lookup value to include an item in a form. However, I need to use a sort of nested lookup. This involves two one-to-many relationships. I give an example below. I have a table called Car. I want to characterize that car by its attributes or fields in a table or form as we say in zoho. On the Car form, I need a means to choose a make, then a Model within that Make. I need to retain the information within the form that will allow me to later reference both the make and model
Nested Form Creation Questions
Hi everyone! So this may have been covered (couldn't find what I was looking for in a few different searches), but I'm new to Zoho Creator and completely confused at this point. I need to create a form that has 'nested' (which may or may not be the right term) options. I hope this example provides more details as far as what I am trying to accomplish. Example: Drop down list has 3 different statuses Loved it! Hated it! No Opinion User chooses #2 "Hated it!" On selection of that choice I want/need
Update form A according to values in form B
I have form A with about 300,000 rows; Form B has about 500 rows. Form B column1 has 500 distinct values , used as foreign key in one of the columns in Form A. Now, I want to update Form A column2 if column1's value is found in Column B. How should I go about this? This is very easy with any RDBMS but with Zoho scripting, how should I do it? Thanks.
How can i add a page break on an html page
I have an application that pulls pictures into a html page in zoho creator. I am looking for a way to add a page break so the pictures are not sliced in half when the end of the page comes. Any suggestions?
Embed Form Iframe align
Good day I have a form embed in a page inside an iframe, but I cant align to the center, I use this code but nothing happens, on reports it works pretty well. <iframe align='center' height='300px' width='100%' name='Edit' frameborder='0' align='right' scrolling='auto' allowTransparency ='true' src='<%=Edit_Iframe%>'></iframe>
Zoho creator: daily schedule to update form per a list of values
I have a special situation. First I need to generate a list/array of values from a form, let's call it List A of 100 values....... Then from the same form, for each row/record that satisfies a condition, let's say Collection B..... for this collection, I need to loop through each row, checking one field from each row against List A....... if the value is contained in List A , then another field is updated to "True"..... how can this algorithm be coded? Also wonder how to get comprehensive
Can't Add a New Field in My Form!
I have added lots of different fields in my form in Zoho Creator in the app builder. Now all of a sudden, when I try to add a new field, it says its 'adding' but never actually does. What happened? How can I fix this? When I create a new form, it works fine even past the number of fields I have now in my original form.
Mass-update one form using data from another form
so, is there a way to mass update one form using data from another form? I need this so I don't need to code the data into the function to update data.
Decimal input trim
For text-string input, I can do STRING1.trim() on user input to trigger a trimming action.... for for decimal numbers, how do I activate trimming on user input and before submit? Thanks!
zoho creator view data -> google spreadsheet
hi how to make automatically and regularly sync (push?) data from creator's view to google spreadsheet?
Next Page