Automatically record the site URL which contains my stateless iframe embedded form
Hi not sure if possible but lets see I have 20 Sites each with the same contact form (name, email phone etc ..) I am using a stateless form embedded in an iframe The only difference in the form is that i hard code in a hidden field the url of the website, this is so i can determine which website sent the user submission So at the moment i have 20 forms. Would be nice to cut it down to one form, if only i could write some script that would allow me to determine which site the form is on and have that
Making search results selectable
After creating an html-view for a search form, I want the user to be able to select one of the returned results, which will then be passed as a parameter to the next html-view. But I don't have a clue how to do this. The attached codes is for the currently working html-view. It currently returns an ugly table showing each record matching the search criteria - so user can enter any data he has (phone, zip, name, etc.) and see which records might be the one he's looking for. Now, I need to be able
Unsure How To Structure This Search
I'm trying to make an app that will allow me to input information from a card, then allow me to search the results based on multiple criteria. This is what I have so far: Card_Input Form Name: <value> Type: <value> Cost: <value> Card_Search Form Search By Name: <value> Search By Type: <value> Search By Cost: <value> I've got an HTML view that displays the results. Right now, I have it working for one variable, but I'm unsure how to take it further. I'd like to be able to search for one or all
Need help sorting before output to html view - List()?
I am trying to fetch data from one table based on entries in a second table. The fetched data needs to be sorted after collection and before output to my html view. Here is an example of what I am trying to do: I have a form/table called Enter Genotypes. The table contains 12 fields that each represent a specific gene and each field has a dropdown that displays the genotypes that relate to that gene. The user selects the appropriate genotype from the dropdown. Each gene (field) can have a unique
Update Record error
I have a task form that contains DueDate and also a Priority field. What I'd like to do is to arrange it so that when the DueDate is approaching within X weeks or days, it will automatically update the Priority field to "1-High" Ultimately (which I'm not sure if it can be done) my employer would like the form to auto adjust the priority not only based on the DueDate but also on the EstimatedHours for the project. For example, if it will take an estimated 100 hours to complete a project, the project
Functional URL "OR" constant operator
I'm trying to filter down a view via a url params like so.. #View:<view_name>?location=<Need to pass 2 locations> in PHP, Python, etc. To pass multiple values you go.. #View:<view_name>?location[]=a&location[]=b which get's turned into location = array("a","b"); I REALLY need either an "OR" operator or an "IN" operator. You already have the "BETWEEN" operator that uses the semi-colon. #View:<view_name>?FieldName1=<StartingRangeValue>;<EndingRangeValue>&FieldName1_op=58 Is there an unlisted operator
Tooltips do not display
None of the tooltips in my applications display. I'm using the following browsers: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.5; en-US; rv:1.9.2.19) Gecko/20110707 Firefox/3.6.19 and Safari Version 5.0.5 (5533.21.1) Any advice? Thanks,
How can you limit number of registrants to 100 only?
How can you limit number of registrants to 100 only?
User selects 1 record out of search results view...
I painstakingly built a search form with html view as follows: user enters whatever piece of data they have - such as partial phone number, zip code, business name, etc; view then retrieves a few fields from each matching record and displays them in a table (super ugly at the moment, but functional)Now I want user to be able to select which of the matching results is the desired record - select that result - and go to a new html view or form displaying all of the data for that record.
Changing Field Types
There is a restriction on changing a field type if that field is referenced in a script. In most cases this is a very useful restriction. However can the restriction be removed if the script is only Show/Hide or Enable/Disable. Herb Wexler
Cant delete applications....?
I gave shared a zoho applicaiton with another of my creator accounts as a test. Problem is now i cant delete the application from zoho. What happening and why? Well actually i get this long error message. i dont want to go through the application and make all these modifications just to delete the app. What can I do? There are actually 3 apps I want to delete all giving the same type of message. The applications are as follows and they are all installed on this account. Copy of Art Inventory
Login Page
Hi I'm new to Zoho, I need your help to create a Login Page for my website. I've defined a of User names & Passwords in excel. I want the same database to be used for login. Basically a Login page for my website. Kindly advice.
Converting a payroll workbook in Excel to Creator
I have a payroll spreadsheet that we use for our business, as I have been unable to find a software package that does things how we need them. We pay our people "by the piece" doing electrical work, and we use vlookup, drop down boxes, and various equations to calculate payroll. Love to find a way to do this online with Creator and have it export info in a format acceptable to Quickbooks online. Any recommendations? What should I budget for something like this?
iPhone GPS and Zoho Mobile
Hi: We are using Zoho Creator a like it a lot. However, the one thing that we cannot figure out how to do that we need is to get GPS coordinates on iPhone using Zoho Creator Mobile. Does anyone know if there is a way to do this? Thanks!
Function for returning date after adding x number of business days (no sat, sun)
I have a customer that wanted to let a user schedule 4 BUSINESS DAYS out. I couldn't find a saner way to do this so here's my function. date helper.bizDays(int days) { iterator = helper.iterator(); time = zoho.currentdate; for each n in iterator { if (input.days > 0) { time = time.addDay(1); if (time.getDayOfWeek() == 7) { time = time.addDay(2); } else if (time.getDayOfWeek() == 1)
Can I change My zoho id?
Is there a way to change my zoho id? My business name has changed and my current zoho id must change or I need to somehow move all my applications and records into a new account! Any help on how to make this move without too much pain would be great.
Problem during Sign-in
Dear Helpdesk, I am based out of Mumbai and work for Aqua MCG. Have previously used Zoho CRM and was impressed with the features. Been trying to login to Zoho Creator since yesterday and have not been able to do so. After the user name and password is typed in, if there is a wrong password given, it does mention that the user id and password do not match. If the right password is given, it reverts back everytime to the home page. Also why am I being asked for a new user name and password everytime
Relative criteria searching
Is there any way we can do a relative search from within the view of a data base. This is available in the reports - how can we do this from within the views ? For example - I would like to search on things like: all records for THIS week , LAST week, or NEXT week - same for the month time period. I realize there is last 7 days etc. but these are not the same. The relative search query is very powerful as shown in the reporting function. If there is a work around please advise. Thanks
Multiline in a Form or Application
Hi, I would like to know how to add a Multline Entry for Example, Multiple Line Items in a Purchase Order or a Invoice. For Example a user should be able to keep adding multiple lines if required. If this Possible in Zoho Creator. Regards, Rahul
Update Record from Stateless Form
Hello, I have an application (https://creator.zoho.com/jpiajr/compost-tracker) that I woudl like to do the following As it stands now, the first stage of the process is when a user fills out the Phase I form Once that form is submitted it creates a records in the "data_form" (which is the master form that the stateless for feeds feeds into) what i would like to do is have the buttons i created on the "View_Data" view to be able to open the a certain stateless form that is relative to the ID. so that
Email notifications activated...not receiving email notifications
Hi, I created a simple form that I'd like to use to capture data and then email out to a variety of email addresses. I've gone through the instructions and have done the Set Email Notification section. Everything looks fine, but when I go and test the form by submitting some info, I never receive an email. Any thoughts why that is? Thanks
Challenging Task: How to prevent double bookings
Good morning zoho crew! My new task is how to prevent double bookings. Stateless form Guest_Reserve form Test_Reserve holds the table fields date time Zoho date/time start datetime Zoho date/time end number Number_of_Riders number Current_Seats_Available picklist Status (Reserved, Waiting, Available) is there a way for zoho to check for times that are booked ? maybe something like count Zoho date/time start between Zoho date/time end if input.Number_of_Riders is more than Number_of_Riders mark
Using Creator to build quotation database
Hi Has anybody used Creator to build a quotation database? ie tables with products and pricing (potentially by customer) that can be used to generate quotes? If so, do you have any tips on what has worked well? Thanks Isis
changing text to other symbols
Hi. I've read some forums around regarding the lack of support for creating password fields in Zoho Creator. I noticed they were dated back around 2009 or so. I was wondering if there are any improvements about that as of today. In addition, what I really want to know at the moment if there is any way in Zoho Creator to change whatever is on the text field into something else, like how a password is like for example. Well, through coding... Like... my password "12345" will instead show up as "*****"
Suggest add a Function for string loop
Hi Suggest add a Function for string loop, such as spinning off a string one by one， for example "1234567", ripped out the results of cycle "1", "2", "3" ... until the get finished, there is no such function in ZC? Thanks! Stanley Guo
Unable to Rename a Form
Dear All, We regret to say that there occurred an issue from our side in renaming the Form from the application edit mode. We will fix this issue at the earliest. For now, change your form name form the form definition which works fine without any error. Please find the below detailed workaround steps and Screenshots. Go to the edit mode of your application and select your Form from the Forms tab. Click on More Actions -> Form Definition. You will now be in the script tab with the form script definition.
Aggregate Sum function
I am using the aggregate sum function <variable> = <Form_Name>[criteria expression].sum(<Numeric Field Name>); First issue is if there is only one row then I get a null variable. Second issue is when there is more than one row I am getting incorrect results.
Get property of record using only ID
Hi there, We have a Project form, a Job form, and a PO form. The Job form has a lookup field that links to the Project form's ID but displays the Project's Name. The PO form has a lookup field linking to the Job, but I'm not able to have it display the Project Name associated with the Project ID that is referenced in the Job form rather than the ID itself. Any way to do this? One way to do this would be to create a formula where it finds the Project where ID == something and then get another property
newbie question re: lookup fields & form/view
Hello: I have a form with perhaps 50 fields, which describe a new contact and various attributes of their business. Now I want a second form that allows me to look for a record in the first table optionally by various fields, such as 'BizName', 'LastName', 'ZipCode'. So I can find the record by whichever piece of data I have. When I select the correct record, I want to see many of the other fields from the original form displayed on this new form - so I can update them from here if needed, and so
More info and print buttons
I there ! I'm trying to build a simple online database but i'm having some problems dealing with Zoho. I'm stuck in the following problems.... i need to do something exactly like this and i don't have a clue how to do it! I need also to know how to format HTML Views to make nice database lists and be able to print them. Please, point me at the right direction ! Thanks.
Is it possible to set a custom schedule to run only on weekdays?
I have a daily custom schedule that reminds users to return items they have borrowed. Currently, if a user has an item due on Friday, and they don't return it, they get reminders on both Saturday and Sunday. I would like to skip the weekends, so they only start on Monday. This would be a great option to have in the Frequency GUI drop-down menu...
Email a single record
I have a purchasing form and for certain purchases, they will need permission before the purchase can be made. So I would input the information then put it on hold, email the info out, and then once given permission place the order. I know you can email a record upon submitting a new record or changing/updating a record. What I want to do is email a record from the List View by creating a custom function because not every record will need to be emailed, only certain ones will need emailed. Or
Creating Apache ESME messages using a Zoho Creator application
We have created a Zoho Creator application that creates Apache ESME messages. The application includes a very rudimentary UI to create the message. Note: Please remember that currently, the information entered in the form is also be stored in the internal application database so that anyone can see the tokens that are being used. It would be pretty easy to add a small routine to the script to delete the data after it has been sent to Apache ESME. The code to create the Apache ESME message is very
Cant convert list element STRING to LONG
htmlpage Recorrido_Attn(okID, Soc) <%{%> <link href="l1t1c2sda.css" rel="stylesheet" type="text/css" /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <%okList = input.okID.toList(); for each l in okList { StL = l.toString(); StL2 = StL.getAlphaNumeric(); StL3 = StL2.removeAllAlpha(); StL4 = StL3.trim(); StL5 = StL4.toLong(); %> <%=StL5%> <%}%> <%}%> Error details: Error occured while executing
Add New Record -- Display Fields Side-by-Side
Can I create an HTML view to allow the user to input data with the fields side-by-side... rather than the traditional two column presentation? I confused if HTML is only allowed when viewing data... or if it can be used to create a user input screen. Can you show me a sample app on how to make an user input (add-new) screen with three input fields side-by-side? Year of Mfg Mfg Brand Car Model __________ ___________ _____________ [__1972___] [___Ford___]
Related views or forms
hello, I know that it is possible trough deluge script to show a view with for example companies and when you click on a button you see all the employees of this company and if you creat a new employee he is automatically assigned to the company above. But I do not find how to do that. Are you going to work on forms including subforms (like access) ? Thanks for your help.
share 1 application to another zoho account multiple times?
Here's the scenario: I have created an application in my account. I have shared it with another zoho account so that when i update the application on my first account it will allow the other accounts it has been shared with to update the application. My question is, can I share the same application to the same zoho account multiple times? I would want it to have a different name for each share and each application would have different data. Also, when i update my single application in my first
[t_811321000000024029_PIDX] Exception occured while inserting rows Failed to update data.
Hello Zoho Creator Team: I have the following error while trying to update data [t_811321000000024029_PIDX] Exception occured while inserting rows Failed to update data. :( I'm in the middle of something here and needed fixed as soon as posibble, hope you can help me :) My app is: https://creator.zoho.com/andrea.gmcr/sistema-producto-mango/#Form:Sistema_Producto_Mango_Form I thinks its related to this posts: https://help.zoho.com/portal/en/community/topic/critical-error-t-734872000000029031-pidx-exception-occured-while-inserting-rows-failed-to-update-data
ongoing numbers...
I would lige a field that automatically creates a membership number when a new member is entered, how do I do that?
Syntax error: function doaction(recType).....
I receive this error when running an HTML view called Start Here in my application. The error message is: function doaction(recType) { } $(document).ready(function() { doaction(); }); I have shared the application with support. The easiest way to recreate the error is to select the tab Show Preview while Start Here is open. The script will prompt for an email address; enter a dummy email address (xxx@yyy.org will work fine). The script will display the correct form on the screen with the error
Next Page