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?
add data into a lookup field by email
Hi Is it possible to add data into a lookup field by email? Thanks Satya NHM
specify action on specific records in list
Hi all, I am trying to take a list and specify action(s) based on specificrecord within that list. Please see example below Let's assume that ListA has 3 records in it I want to be able say For the first record in ListA execute function A For the second record in ListA execute function B For the thrid record in ListA execute function C Notice that each line is not performaning the same function . Any info would be great. Thanks in Advanced
Any Limitations of Lookup field type compared to Dropdown?
Advice needed please... If for some fields we are deciding between using a Lookup field vs. a Dropdown field.... Are there *any technical downsides* or limitations to using the Lookup type vs. the self-contained Dropdown type? For example, would a form with say 10 Dropdown fields perform the same in all respects if they were instead Lookup fields? Such as in areas of: Server performance Mobile version Sheet and Grid views Scripting capabilities Flexibility of display, etc. We are aware that there
Drop Down
I need to add 12000 customer names in the customer name drop down on the form. How do I go about adding this list? Any ideas or suggestions? Thanks
TIP: Can import the URL fieldtype as separate Link, and Link Name
Found that we can successfully import URLs with their Link Names --if the imported URL value is HTML. <a href="http://server.com/path_etc/">Your LinkName</a> Tested with the Excel Migration tool, reading from an XLS file. Works whether updating existing records, or adding new.
Function
Hello, In a form I can generate a purchase order. I've made a custom template which looks like a purchase order. When I submit the form there will be sent an e-mail with the template as an attachment in PDF. I also generated a report which shows all the records of the made purchase orders. Now I'm trying to make make a custom function.This function will be a button in each record in the report. When you press the button it will send the e-mail again with the purchase order template in PDF as an attachment.
Duplicate or restore backups
Hello, I have a real problem with duplicating or restoring applications. I allready asked support but haven't get an reaction yet. Tomorrow I have to demonstrate an application. Can anyone please answer ASAP? Greatings, Erwin
Limiting global search
I have a report that needs to be limited by a company name. To do this I use the userid to fetch the Company name from a table of userids and the related company name. The Company name is then used in an openurl statement to pass the criteria to the report. This works great and the user only sees the records that belong to their company. The problem is the new global search field. This will return records that are not filtered by the Company name. How can I filter records returned by the Global Search?
Accessing subforms in a Report List view
Hi all, I would like to access a form via an "Edit" button, which basically calls a function. I would like to create an Edit custom action which I can access from within Report_A row (i.e., per record), but I would only require a pop-up of a particular subform. The subform is accessing another form, Form_B. Would it be possible to do this, i.e. create a function to access Form_B a a pop-up window, by clicking on the Edit button within Report_A? Any idea what the function would look like? Thanks
Script help on "Page"
Hey I am new to Zoho. I am not seeing how to do this on the documentation but I would like to: (1) pull all the records of "formA" from "today" (2) get the all values from the field "points" (2) for a person's record "Bob" (3) add it up "points" and (4) if it adds to 10 then (5) display message "You got ten points!". Can anyone help? Thanks
Slow SubForm Issue
Good day, I have a Form with a Subform included, in this Subform I add products for purchasing process, the problem is when I have to much products in the Subform and I try to edit the Form open´s very very very very slow, could you please suggest me other way to handle this situation, Thanks,
What do I keep getting this message - unable to connect ...
Hello, I keep getting the message below very often when I am running my Zoho Creator Application Unable to connect to messaging server. Connecting in 22 seconds Try Now Thanks David
forms in mobile app
Some of my forms are now showing in the mobile app. They show and work fine on the desktop. I have double-checked the permissions and nothing is wrong there.
Make an application open to public
I wonder if an application, or at least parts of it can be used by users without Zoho account. Thank You
Import CSV with User Field
I want to import a spreadsheet (CSV file) into a form with a User field. How can I import users into this User field. I tried having a column with the users' email addresses and that did not work, then I tried their usernames but that also did not work.
Possible to create event when new record added in Zoho Books - copy to table in Zoho Creator
When a new "Item" in Zoho Books is created, I want it to be copied to a table in Zoho Creator. (Need similar for when a new "Recurring Invoices" is made) How is this done? Can it be done?
Why exactly are Spreadsheet and Grid views behaving as List view?
Various Reports defined as "Spreadsheet" or "Grid" are suddenly behaving as the "List" type. We did recently add Workflow scripting to the underlying Form, and am hearing that this may be the cause. Can someone verify exactly what is forbidding these views? Assuming it is workflow scripting: Any script of any type added anywhere in the Workflow sections? Or only when added to certain "Form" actions? Which ones? Or only when added to certain "Field" actions? Which ones? Also: when I commented out
Custom function
Hi, I am using below function to update the Website field of a Form from another Form's url field. What I am getting bored that I need to go through each record of the form (clicking on function button). So I am wondering if there is a way that I can update 200 records in a single button click that would be very interesting ans also time saving . Script: void SearchLink.MVPDUpdateLinks(int id) { set = MVPD [mvpd_ID == input.id]; dat = SourceDat[Test_id == input.id]; set.mvpd_website
Other currency field vs chart (2)
Hello, I still have a problem. In a field I have selected the currency "EUR" --> €. When I make a Pivot Chart based on the database with the value of the field with lay-out "EUR" -->€, it will show in the Pivot Chart a dollar --> $. How do I change this? See attachment for a printscreen.
Next Page