How to make multiple fields required based on a Check Box selection
I'm creating a credit application form asking the user to check off customers he wants to open accounts with. I created a list of Check boxes for each customer (30+ check boxes). If the user checks off a certain customers, how do to I make other fields on the form required? Example: Check Boxes for.... (user can check off as many accounts he wants to have opened) - Flooring: ABC Carpet - Office: Office Depot - Paint: Our Paint Co - Flooring: Your Floor etc... If they select a flooring supplier
Creator integrate with hardware?
Hi, We are developing an application need integrate with a hardware, so can Creator support integrate with hardware? We need integrate with scanner or voip.... Andy
Function type List
Hi I have a simple function which is of type list. It has the var temp1. In this function I set temp1={"john", "elise", "jake"}; and I return temp1; However ,the above values are not being inserted into the correct form as I have would expected. Please advise. Thanks!
Importing Date-Time from Excel
Is there any date time format that creator will import? From excel, access, or otherwise? Please, I really don't want to enter 1000 time records by hand with your date picker We have a not for profit and need to upload event days to create a date picker
delete record after specified time ?
Just wondering is it possible to build an action that will automatically delete a record or archive a record after a certain amount of time? tks
Form Didn't Load in The Embedded spot !
Dear Zoho Administration From seen many USERS problems, i think RICH TEXT AREA can't work well. For this reason Embedding Form is slow down and can't load properly at the embedding Site place where USER wants to use it. just see a problem below: http://help.zoho.com/portal/en/community/topic/my-form-doesn-t-load-in-my-website#2266000002143250 Please attention on this problem and solve it. So USERS didn't lose stratification on ZOHO. Thanks With Regards NP
Displaying dialog messages in visible area of embedded forms
In Zoho Creator forms, we display success and error dialog messages during data addition. On embedded forms, this error / success dialog message is displayed close to the top of the form only. So, when you scroll to the bottom of the form, this message can be seen only by scrolling all the way to the top. That is, the message is not displayed in the visible area of the form. As a solution, you need to 1. Embed a js file using a script tag as shown in the example below: <script id='zc_external'
Sign-in Issue
I'm attempting to sign-in to my application and it redirected me to this: I tried this on both Chrome and IE. John M. Whitney
Grid View not working
Hi, When I try to edit data in grid view, I get a message that records failed to update. There is a screen to show details of the error, but it doesn't show any details. If I switch to "List" view, then I can edit the same data without problem. Cheers, Katie
data format error
when I hava used import data in the view ,the data format appear alteration. eg:The time is '2011-03-14 22:31:09' ,it display '2011-03-14 10:31:09' how to solve this problem?
Help with 30 limit on view
I need to export my data in one file, and I am unable to do this with the 30 variable dropdown limit. Please help, I can't use zoho if there is no way to access this data in one file. I am attempting to use zoho reports to analyze the data but is seems impossible with the limitations because my data is unable to be read in one table.
data does not update.need HELP pls.
Sir, In this apps, I have 3 form and 3 view. 1.stocklist 2.stock in 3.stock out in "stock in" form I have a field "quantity".each time I submit a value then it should update the value in stocklist view field "quantity stock in".Same goes for "stock out" form into "quantity stock out". Somehow it does not update any value and I've tried it on other record and only certain record is succesfully updated. I dont know which part im wrong but pls guide me to solve this problem.Before this, the previous
My form doesn't load in my website.
Hello Zoho Members, from some days i am encountered a problem with my Zoho Creator form application. At the my Website i am embedded my form, when i am embedding it that time everything is fine, now my form is doesn't load in my website. there is circle which is rounding and rounding but there is no form coming however i will waited for 1 hour. I am doing so many things with it, but it is still happening. Please suggest me immediately, because i lose my customer satisfaction. With Warm Regards Roger
Global Variables
Re-posted idea from http://help.zoho.com/portal/en/community/topic/stateless-fields-and-push-buttons-in-a-database-form There is value in having a programmatically accessible global variable list. It would be similar to our global functions in that global variables can be used anywhere in an application (similar to zoho-defined variables). Here we could define our own variable names, types (numeric, date, string, etc), and optionally add default values that could be referenced in any code or form
Form cannot be edited but only can be viewed
https://creator.zoho.com/ropdata/rop/ I cannot edit this form anymore. Only view is available and data entry can be done. How can I edit this form as I want to add new fields. Dr. Amer
New User with a few questions
1. How does one set up subforms/tables in Zoho? I don't see it yet. 2. How does one set up a "template" for the form data. For example, so that phone numbers appear as (###)###-####? 3. How does one get the "height" control for the field attributes on the form activated? At this point I can only adjunct the width.
count record of form A with a criteria from fom B linked with a lookup
Hi let Say I've got a form Account ID USER + other fields I'v got Also a form Submission ID AccountID (Form Account lookup with ID) + other fields Now I want to count Submission that has the current loginuser has user. How can I do that? I tried: Sub = Submission[( AccountID.UW == zoho.loginuser)].count(); but it doesn't work How can I do that? do I need first to create a list of accountID that is assigned to the current user and then count submission that is in this list. if yes how? thanks a lot
Using / Calling a function to create a global variable to collect a list of records
I have a registration application where I collect Account registrations and each registration has a reseller. So there are many accounts per reseller. I am building another application where when I select a Reseller from a multi-select lookup, I want it to automatically select all accounts in another multi-select lookup associated with it. I created a function in the first application string sample.getAccounts(string getaccounts) { if (count(Add_Registration[Reseller == input.getaccounts]) >
Is it possible for a form input field to span two columns?
I'd like to have most of my form use two columns, but have a large text input area that uses the full width of the page. Is this possible?
How to add labels inside drop-down?
When I view the data entered there is a drop-down box for filtering... It has un-selectable labels in it. I would like to add the same un-selectable labels to a drop-down box in my form. I have attached an image with a screen shot of each drop-down illustrating my question.
CRM iphone App Trouble
Hi, I use this app in the field to set events for appointments as calls come in. That works fine, But I am unable to view events in the calender( says no events even though I know they're there) and the Event selection has options for Today and This week but not Tomorrow. The results come up in a scattered fashion so I am unable just to view scheduled evens to see whats available for the next day. Could you guys please correct this. Or if Im missing something please let me know. Thanks,
Any plans on being able to view time as AM PM time format in views?
Any plans on being able to view time as AM PM time format in views? Hi would like to be able to view a 12 hour (example 10 am or 10 pm) clock on our view that has a Date-Time field How can I do this? Script solution is fine too
View - Not able to be edited. Get error "[ServletException in:/jsp/edit/view/viewedit.jsp] null'"
I have a view that can be viewed, but cannot be edited. I get an error "[ServletException in:/jsp/edit/view/viewedit.jsp] null'". I was attempting to create a custom criteria on a view to limit records to "This week" and another one for "last week". On saving the script I noted that it replaced a criteria formula with null. The original view is still accessible and usable, but I cannot edit the view. It always give this error message. Tried a few different back doors to edit the view criteria to
Custom Action to Print Record
Hello I am completely new to Zoho Creator and am struggling to set something up which I am sure is pretty simple. I have a Form with 20 odd fields. I also have a view set up which displays all the records. What I want is to add a button (at record level) on this form which will allow the user to print the record. I only want to print 5 of the fields and preferably without field headings and in customisable HTML format. I can see that you can use Custom Actions within the View to add the print button.
One of my tables disappeared from "Edit Mode"
Hi I edited a field type in my "Create Invoice" form in my Frozen Foods application and the form has disappeared in editing mode. All I did was add an Initial Value in the field property for the "Country" field, and the form no longer shows up. I can see the view for it though. Can someone fix this? I have given edit access to support. Thanks
Recurring events Creator Calendar
I would like to create recurring events in Zoho creator calendar. I have to schedule nurses to see patients every day and beable to keep notes on the patients. I have created a database already and I need this to work so when the nurses login into Zoho they can see their calendar with all their patients listed for the week, month and maybe yearly. All the help I can get would be great. Thank you
can someone help me with figuring this out?
i'm wondering if there is anyway i can do in Creator what is done at this site http://autosmartky.com/newandusedcars.aspx under the spreadsheet view.
Create recurring calendar events
I would like to create recurring events in Zoho creator calendar. I have to schedule nurses to see patients every day and beable to keep notes on the patients. I have created a database already and I need this to work so when the nurses login into Zoho they can see their calendar with all their patients listed for the week, month and maybe yearly. All the help I can get would be great. Thank you
Adding Multiple Items to an Invoice in Zoho Creator
Hi: I am creating an Inventory Application, which includes invoicing functionality as well. When a customer is invoiced, it will reduce the product stock amounts currently in the inventory by the amount listed on the invoice. etc... However, I would like to know if it is possible, in my Invoice table/form, to be able to add multiple products to an invoice, similar to the "add another line" feature in the Invoices in Zoho Invoice, show in the image attached. As of now, each invoice can only accept
Scheduler Not Working
All my schedules stopped running starting on Dec 4th. I have tested resetting them, but they still fail to start. John M. Whitney
Making changes to multiple items at the same time
I would like to be able to select multipel items via the check boxes and then make a single change that applies to all items. For example, I would like the ability to select multiple 'tasks' by selecting their check boxes and then change the items from 'open' to 'closed'. Or change a bunch of 'due dates' all at once rather than one at a time.
Uploaded Files in HTML view
Is there a way i can have a link displayed to uploaded files within an HTML view for a certain application.?? Any help would be great.. Thank you.
How to send a reply email to a form-fill email?
How can I get my form to reply to the sender of the email that filled it? I can get email to fill my form, and I can get the form to send an email upon being filled, but I can find no way for the form fill to capture the From/Reply-To address for generating the reply. Thanks.
Dashboards and http://creator
Hello all, I ran into an issue this week with Creator. When running Dashboards HTML's with graphs and charts, I found that the dashboards would not generate in http:// mode and partially work in https:// mode. When running the app in "pre" creator, the problem goes away. I have run into various situations where the only way to operate Creator is to run it in PreCreator mode. Things that make you go hmmmmm.............. Bartley
Does "Error occured please contact application owner." in publicly-used app record any details for the owner to read?
Please? II am aware that details are shows for this error in an admin's session, but I'm asking about the public user's session. Thanks.
finance data in zoho creator
Hi, is there any readymade finance related function? such as getting quote from yahoo for given symbol Thanks Sasi sasidublin
How do I tap into my users?
I have an entity in my app to which I want to assign an owner to each record. Instead of creating a separate Contacts entity and managing the users there and linking that through a lookup, I'd rather just assign from the users already defined for access to my app. How do I basically do a Lookup field that references the zoho user base for the app? Thanks Brian
Limit on size / length of string variables?
Hi, I wondered if there is a limit on the size of a string variable in Deluge script? I'm creating a very long string (HTML), and it seems to be erroring out at around 1600 characters. I wondered if this is because I've hit the limit? Cheers, Katie
How do you assign a record to a zoho user
I want to use the zoho user base as related records within my app, essentially just assigning a user as an owner of an item. How do I make the zoho users show up in a lookup or dropdown list?
Looking for a developer to help me build a CRM like database....
I am a publicist for bands. I like certain aspects of CRM (logging calls, events, etc), but it doesn't allow me to sort how I want to (according to city or media type), so Zoho reports seems to be the best fit. When I called Zoho they said I could come onto the forum to seek out a developer that might be interested in building a tool for me based upon my exact needs. Can anyone on here help me? I can be more specific for exactly what my needs are to anyone that is interested. Thanks!! Angie
Next Page