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
Creating an email list to use in Google Mail?
Hello, I'm trying to create a simple contacts database for a supporters club to include our current and past members, and to use it to email our newsletter or letters in PDF. I would like to set up an action after filtering the view to create a list of email addresses that I can copy into Google Mail. I've read the "Create Action" and "Functions" help/support, but I cant get it to work. Can anyone provide an idiots guide to create a list of email addresses separated by commas that can be copied
In View -- How To Group Similar Fields Together
How can I group (mark with frames) similar fields into a group on a View? I have attached a picture showing in other software the use of a frame to indicate the purpose of 2 or 3 fields. My second attachment shows similar information on a Zoho Form. How can I group these fields together logically and cosmetically? I would like to use a frame or what have you to show the user that the fields (3) are related in purpose. Thanks, ppD
PDF as background
We use graphically intense PDF forms where users hand-write info into fields. In MS Access you can use the PDF image as the background and float the data fields (controls) over the background. Is there any way this can be done in Zoho?
Hide certain fields based on what view the user is coming from
I have a fairly large form with a lot of information on it, so quickly filling out a small section is a bit tedious. I am wondering though if I can use "hide" or "show" commands for certain fields based on what view the user is coming from. I know I can do this based on the user's ID, but since all users need access to all the fields this is not an option.
Multiple tabs in forms
Hi, This has been a reoccurring question over time and I'd like to pose it again. I have many fields in my form and there is currently no good way to group them. Are you considering offering multiple tabs in forms? I know you offer stateless forms but this is not suitable for my requirements. It is purely a presentation issue, I need to be able to group information on one form, with easy, quick access to all. Multiple tabs across the top of a form would be the IDEAL fix for this. If this is not on
Drop Down List: Hide -Select- from choices
Can I hide the listed choice of -Select- from my Drop Down list? I have a form drop down control which I set to a default value for new records. If they click the the drop down, they see my alternate choices along with Zoho's -Select-. Can I remove that from the drop down list? Thanks, ppD
Cannot Download Zoho Creator Marketplace Files
I can no longer download attached files to marketplace projects. Is there an issue?
What we really need is easy search forms and real customization tools
For almost 4 years I paid near 2,500 ($) waiting for the promised and then forgetted way to create a search form in an easy way. I did it a lot of times, but each time I had to learn it again and I had to use a tutorial where you have to fill with imagination the blanks left by unaccurate information. I speak 4 languages, I have a master degree, in the interim I learned English, html, css, a little of javascript, jquery and ultimately MySql, that at the end saved me from the waiting stuff, all by
Library Database?
I am looking for a online database to catalog DVD's, CD's, books and the like. I stumbled across this website, and I was wondering if this program is designed for that. This is my first time maintaining a database, and I was looking for something that was easy to use and flexible to fit my company's needs. Thanks!
Auto generating a field scripting error
I have a subform on my Equipment View that when you hit will open up an html view in a new window that shows additional information for that particular item. I have it set up so it will automatically fill in the Asset number (Pick_Asset) based off the meeting application. That works fine. What I'm trying to do is then auto fill in the Asset Description as well so when you click on the subform it will pop up with the Pick_Asset and the Asset_Description already filled in. However it's not working,
can i stop multiple log-ons ?
to my database i would prefer users not to share a log-on without my knowledge by stopping simultaneous log-ons would require a user to ask for their own username i find that users who use someone else's logon do not contribute thanks in advance D
Problem with coding 'Actions on user input'
Hi, I am a bit new to making this kind of thing and would like a bit of help with making a bit of code to make my form look better. I have a question with a drop down box with lists of towns in. At the bottom I have added the word 'Other' in case the town they live is not listed in the box. The next question is 'If other please specify' which is always viewable to everyone and I would like it to pop up when someone clicks on 'Other' instead. I have this kind of situation around 5 times through my
View Column Width???
I have done some searches and not found an answer. The width of the columns is too wide in the views. Is there a way to make them more narrow?? I already set the width to a lower number in the forms. That does not change the view. I do not mind doing it in scripts if I have to, but see no way to do it. Thanks
Migration problem tool - can't upload any Lookups
I had an XLS I wanted to upload; I used the migration tool, so I could set up the handful of data relations between tables. However, any time I created Lookup columns, the upload would fail with an error that I had no values for my picklists. (Looking at the .DS file, the picklists were the lookup columns.) I had to change the columns to generic Number fields to get it to upload. It's my impression that I should have been able to define these relationships prior to the upload, even with no data.
Dynamically adding items to a picklist
Hello, We are planning to migrate our data from dabble to zoho. Im still new and studying the features here. I'm testing and following instructions from the help topic: shows you how to build an application with dynamic picklist, with the help of an example. This is my case: select a "Program" from the Program list, only the activities belonging to the selected program must be dynamically displayed in the activties list . I constructed the script below and pasted it in the free flow script editor:
Auto complete function in google chrome
I've just switched to using google chrome and now my field auto complete doesn't work. Can anyone tell me if there is a fix for this? Thank you
Variable Questions
I need a variable that can be accessed by multiple 'on user input' things. I don't seem to be able to declare the variable in the onLoad section and then access in the onUserInput sections, is there any way to make this work? I don't want to have to make a form to store a variable in a database. It seems like such a waste.
Sending information from one form to another quit working
Sending information from one form to another quit working I set up a form called Test_Reserve and a form Called Test_Cal_Form Was having great luck sending information from Test_Reserve to Test_Cal_Form so I could create a google cal feed. It quit working after I changed a field, but I looked up all the fields and as far as I can tell they match up fine...help? insert into Test_Cal_Form [ ENDS = input.real_end_time_date STARTS = input.real_zoho_start_date_time DETAILS = input.Riders_Names_Ages_Weights
Deleting Repeated Entries
Is there a way to delete an older record when a new one is added with a specific field repeated?
Access database in on web server from zoho creator?
Hi I would like to make a zoho app that talks to my database stored on my webserver, eg when i add a new customer it is added to my database on my webserver and when i read the info bacK it is reading the web server. Is this possible with zoho creator and if so, where can i go to find out more? thanks Adrian
Perma-view problem
I am having a recurring problem with perma-links, which results in this error message in Firefox: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. In Explorer it's the HTTP 500 error: The website cannot display the page. There are no frames involved. Cookies are allowed. Going back onme step, what happens is that I set up an app, then get a permaview for it and create an HTML link to this. Then I share the app with
Refreshing a view embeded in an HTML view
Hi, I would like to create an an HTML view with two main areas, one with a embeded view and the other with a embeded form. And then I would like to add records through the form in the embeded view. How can I do that? Thanks, Fidel
Easy Styling of Forms and Views?
Is there an easy way to customize the way my forms display? I'm specifically interested in having more than one field per row per column, and allowing more than one checkbox/radio button per row. Instead of: Field | Field Check | Check | Check | I'd like Field Field | Field Field Check Check | Check Is this possible?
How to Combine two Databases in Zoho Creator
How to Combine two Databases in Zoho Creator. I have two database applications and would like to combine them. Can not fined out how, please help Loub55
Cannot sign in to Creator
I am just trying out Creator and initially linked my account to sign in through Facebook. I got in once but now I cannot sign in at all. I delinked my account from Facebook and still cannot sign in to Creator. I can however sign in to other modules.
Routine to Update Existing Data in Forms
How can I run through existing data already in a form (100's of records), and update a field value based upon some criteria? For Example, In Sample Employee Manager application, and the Add Education Details form... how can I set the Percentage to 100% for all records where the the Year of Graduation contains a date (not blank). I'm sorry to bother you. I'm still learning if you offer action queries or if we need to use code to make such changes. Thanks, ppD
script execution tracing
Is there any way to do this? I'm getting an ambiguous error on a user function and it would be perfect to be able to trace through it, even without a full breakpoint capability.
Next Page