Additional info input from radio buttons.
Would someone please point me in the right direction? I am looking to use a radio button with yes/no as the options. When yes is selected I would like an additional text box to popup which allows for more information to be input. Sorry if this is a simple question. I am a newbie and have been searching through the help pages to no avail. TIA Bill
How to invite via creator sent email
I have events on a schedule that would be great for people to be able to accept or decline the invitation by email click on link and acccept or decline without logon, any ideas?
Zoho Favicon Appearing
Hello, Due to the issue around the iframe height hard coding I am embedding using the JavaScript equivalent. However, one of the effects of this is the Zoho Favicon is displaying in the results window. Do you have any ideas on how to prevent this, aside from switching to the iframe code? Thanks
Custom schedule on every 5 minutes
Hello, i try to create a custom schedule that runs every 5 minutes daily which is described in this post : Can I lock a record that is being edited, and restrict more than one user from editing the same record at the same time? How can i do this ? I get always errors when i try to create the "execute event"-statement. I found nothing in the help section. Thanks in advance. Horst
Where is the button to create an application?
What a frustrating user experience at Zoho Creator. The form I used to report my initial issue crashed and asked me to fill up another form to report the crash. The new form doesn't work either. I'll keep it short this time because my longer message I tried to submit earlier is lost now. Issue 1: I can't see the button to create a new application on my ZOHO Creator homepage. Issue 2: I can't insert images in your HTML WYSIWYG editor. I just wanted to show you the screenshot of my ZOHO Creator homepage.
Using Google Analytics w/Zoho Creator
Can anybody tell me how i can use Google Analytics to track activity for a Zoho database; Specifically, where do I place the tracking code?
Calling Functions Within Functions
This is my script for my function: void both.AlpineFarm(int Id1, int ID) { ter = Alpine_Farm[Id1 = input.Id1].Id1; tep = Alpine_Farm[Id1 = input.Id1].ID; if (ter = null) { thisapp.add.AlpineFarm(ter); } else if (ter != null) { thisapp.edit.AlpineFarm(tep); } } When I try to save it, it gives me the following error message: Encountered "." at line 7, column 20. Was expecting one of: "(" ... "(" ... "(" ... "(" ... "(" ... "(" ... "(" ... "(" ...
Can you join forms...(adding multiple items and quantities to an order)?
Hi, I am creating an item ordering application which is created by the customer and can include multiple line items. For an example; STEP 1. CUSTOMER A will begin to create an order by providing basic details e.g. NAME and LOCATION. STEP 2. they will then confirm the items they wish to order (from a catalogue of around 2000 items). They select ITEM A and enter the requested QUANTITY. They then might need to add ITEM B to the same order and ITEM C, D, E etc.... These orders can sometimes end up up
How can I make a field Conditionally Required?
I have a checkbox 'Place Order' If this is checked, I want to show and require field 'Payment_Information' if unchecked, I want to hide and not require the Payment_Information field. It's easy enough to conditionally show / hide a filed based on a condition, such as in the show-hide fields wiki example: But how can I also make conditional the required attribute? Thanks! Kenny
does anyone know how to create codes on the submit button with in a system created in zohocreator?
hey i need some help with creating some code that on the submit button that tells me if it has gone passed the date that is required, does anyone know how to do this?
Can not update VISA information???
Hi, Our products(Creator) goes to be expired, In this case we can not revise the VISA information when we deside to update the product edition in China. We want to make a payment,but It is blank! Why?? Urgent!!! Doug
lookup verus dropdown anything to consider
Hi Am building my forms in zoho and i tend to keep using lookup instead of dropdown Good Reasons for lookup so far are 1) With a lookup, one change is reflected in any form that uses that field 2) I can have columns in a lookup which with the advanced display helps a lot 3) I can list alphabetically 4) I can select a default 5) The default entry to the user is -select- stops me from thinking about it so far all good... question, am i missing something which is going to trip me up or another way any
Continue balances from one record to another same client???
How can I continue a balance from one record to another? For example: A client that makes a payment. How can the balance from that payment transfer over to the next payment that the same client makes?
Creating a professional-looking PDF catalog from an HTML view
Hello there! I am currently experimenting with the PDF exportation of an HTML view I created. I would like this PDF export file to look as 'professional' as possible, meaning I would like to be able to print it out or mail it to clients 'out of the box'. This html view displays the result from a search query within the records stored in my form: it shows a list of project references, each one complete with a couple pictures, and a definite set of information. Right now, I am still encountering some
Using year (yyyy) from date field
Hi everyone, I want to know if possible from a date field to take only the yyyy portion and store that into another filed, let say a number field. I have a form with Invoice Date (i.e. 30 April 2011) and want to store 2011 into other field, can someone tell me how to do that? Thanks a lot.
Default entry in field
I created a form in Zoho Creator and imported a .xls spreadsheet with the following fields: telephone number name address city state All of these records are empty with the exception of telephone number. I would like to know how to show the telephone number in the form by default.
Fetching the NEXT record
Can someone explain to me how to do what must be a common requirement (I'm New ) . . . I have a form & View (let's call them the original Form) and want to create a new form that I can 'page' through the records in Original form. So I guess I need a Next & Previous button on a 'Stateless?' form. Then how do I get the buttons to get the Next or Previous records?
Express Editions
Interesting... John M. Whitney
Allowing customers access to read only databases
Hi Please see below, can Zoho Creator do this and what version would cater for it. Also which version would we have to buy while we only have 5 customers One of my web design clients wants to give their customers the ability to log on and view a specific access database in a read only format. They currently have 5 clients that they want to do this for with plans for this to expand to 20 in the coming year. The databases are large up to 1 gb including associated folders . Obviously each client is
Create record from html view
Hello, I would like to know if it's possible (and how ) to add records using a html view as if it was a custom made form using html input elements. Thanks!
Question About Functionality
Hello, My company would like to implement the following idea and I wanted to see if your platform is built for it. The idea: Friday Focus. What it is: A tool that forces people to start thinking about what they need/want to accomplish the following week. Every Friday people spend a few minutes filling out an online form, and on the following Monday morning they receive a copy of it in their inbox. This helps kickstart the week. How we want it to work: - Every Friday an email goes out reminding the
How can you remove only certain items from a dynamic picklist?
Hi, this is driving me nuts and I'm wondering if someone can help me figure out how to make this work. I'm a newbie to Deluge and Zoho. I belong to an organization that provides teams of mentors to mentees. I've created an application with the following forms: Contacts - where the Role can be defined as a Mentor, Mentee or several other fields Mentorship Teams - where you can associate contacts based on their role on the team Mentorship Team Meetings - where we track who attended and what happened
Show .xls data in a form
I need to know how to show .xls data in a form.
Is it Safe to change the "Field name" for a lookup via the form definition
I have a fair amount of info in Zhoho at the moment so thought i would ask I want to change the Field name (refer to another field) on an existing lookup in one of my forms There does not seem to an option via the Edit Field properties but i can see how it is declared in the form definition Has anyone ever edited this directly ? So far i have been creating a new lookup with the new field and deleting the old existing, however as the existing lookup is tied to Deluge actions it can be a pain as you
Customize Forms
Hello, How can I customize the following form? https://creator.zoho.com/gnachtwey/friday-focus-application/# I would like to add my company logo to it and adjust some of the spacing. Is this possible to do?
Zoho Creator is DOWN
Can fellow users confirm with me that their Creator applications are down right now? Thanks!
reports not showing all records in table
Hi, For some reason, looking at a view of one of my tables (MyResponse View) displays "x" number of records. When I access the table via either of two reports (My Studies - Diet Type Frequency or My Studies - Exercise Type Frequency), most records are not displayed. The discrepancy between records displayed when using MyResponse_View and either report is significant. I have deleted any filters the reports were using without success. I have regenerated the reports without success. I have deleted
Cannot see my post about ASP.NET
Hi, I added a new post yesterday and I cannot see it... I am very new to Zoho (6hrs old). My problem is I have to add records to zoho through my ASP.NET application. My Questions are: 1. I don't understand about the ticket... it expires every 7 days? meaning I have to generate the ticket every 7 days with in my app 2. Any sample will greatly help Thanks
Fetch records WILL not fetch Rich text and WILL not fetch URL fields?
It records these but WILL not fetch them back? My form fetches everything but these? Anyone? Please?
The NO - REASON SALE
It's none of the holidays nor is it an occasion to celebrate. But we thought, we didn't need such special occasions to express our gratitude to our loyal old timers.. Presenting the NO REASON SALE at Zoho Creator. Get upto 20% off on plan upgrades to longer cycles. And if you still haven't upgraded your Zoho Creator account.. Now would be a great time to do it. Offer valid till 5th September 2011. Head over here for more details. Its time to ... Up.. Up .. and away Upgrade... Thanks Aparna
Limitations on HTTP Post?
I tested my AWS-SES/ZC app this weekend by attempting to send 200 test emails. After about 90 I got an exception violation as the http response from the post. Querying my Amazon account, I did not see any issues. I'm assuming the fault was on ZC's side. So I'm wondering if I've run-up against some limitation with http post? When I post to my PHP api, the deluge statement is AWS_POST={ "FROM" : input.FROM, "SUBJECT" : input.SUBJECT_field, "BODY" : BODY, "SUBSCRIBERS" : SUBSCRIBERS }; From, subject,
Newbie Question: conditional expressions in zoho creator forms
I am trying to build a form in Zoho Creator that firsts asks the user to choose one of three options from a drop-down menu, then assigns a value to that entry based on what the user chose from the drop-down menu. I am currently using a conditional expression that looks like this: if((DropDown == "Option 1"),10,0) The problem is that if the user picks anything but "Option 1" from the drop-down menu, the value assigned to that entry will be 0. I cannot find out how to use the "if, else if, else"
Script reformatted to single line
I've written a script and it looks fine initially when I paste it into the Zoho scripting tool. However, when I save, leave and come back, the script has been reformatted to be on a single line. This makes it impossible to edit in the scripting tool. Is there a way to prevent it from reformatting the script? Thanks!
How to delete a Form and a View
Hi guys, The title says it all actually. I have one application that contains two Forms and two Views. I wish to delete only one of the forms and ones of the views. Thanks
How do I update a date field within a form when a user modifies another field (example approves the form request)
Totally confused! I'm trying to declare a variable and fetch the most recent record when field is updated. I don't know the fetch arguments in order to update the particular field. (My application has a form to request $ for loans...I need a date stamp when the user approves or rejects it.)
Form validation on edit not working?
I don't think it's me, but knowing me it probably is. The field validation that was working before just stopped, seemingly out of nowhere. When I found it not working I then tried to get just a basic (if this input doesn't equal this number then alert and cancel submit) and still no go. Here's what I am trying to get working: if ((input.Status == "Repair") && ((input.Repair != "Sanding") && (input.Repair != "Lamination"))) { alert "Don't forget to mark who's repairing it above";
Order management
Hello! We have online store and I need online management software. I know that it is possible to do but all solutions are very simple. I need to: 1. make a new order 2. attach new or existing customer 3. add MULTIPLE goods to one order, NOT ONE. There is no problem to add one good to order. How could I add multiple goods to one order? There is lookup form but it's not convenient to manage and edit orders. Are there any ideas or solutions? Zoho CRM is very complicated, Zoho Creator should solve
Creating a "table" form input
Hi, Is there a way to create a table that a user would fill out? For context, I'm trying to create a table that has "Cost Center", "Cost" and "Tactic ID" as the column headers and would like the user to be able to enter multiple lines (i.e. split the cost of a project across several cost centers. Is there a way to do this? Thanks!
Referencing a formula field from another formula field
I am new to Zoho, and building my first app to calculate sales commissions. I understand from other posts and the user guide that you can't reference a formula field in another formula field. However, I need a way to do the following, which I'm sure there is a script or other work-around to do: Revenue (Currency Field) Overhead % (Percent Field) Overhead Rate (Formula Field) = Revenue * Overhead % All of the above works fine. However, I can't figure out how to do the following: Net Margin = Revenue
Very Confused Newbie re: Public Forms...
Ok - I have spent far too many hours creating a multi-page form, but everything is essentially working except - I have spent hours trying to figure out how to allow my customer to fill out the form. If I make the application public, then the customer sees all of the application, views, etc., which is not good. If I make the application private, then the customer needs a login, which they won't have. I tried using the permalink code without login, but then I haven't been able to pass the record id
Next Page