Newbie Needs Help w/ Application
Howdy, I am really enjoying creating applications with Zoho. However, I am finding it difficult to get my head around all of the possibilities because there isn't a manual. Does anyone know of any links or forums that would be good for a newbie to visit? The application I have built has a main form that lists all of our clients, with basic info. I would like to create another form that tracks payments from our clients and would like to import info from fields in the main form (file#, Client Name,
1)Can u import comma delimited files? 2)Can u export them? 3)Can you have related tables (relational dB) ? 4) MS Access
I'm a newbie and have a project I'm considering for Zoho. Maybe some kind soul will give me a little quid start assistance... 1) Can you import comma delimited files into Zoho dB? 2) Can you export your records back to your PC as comma delimited files? 3) Can you create a relational data base with Zoho dB? 4) Can I import a MS Access .mdb file into Zoho dB? 4a) and maintain the relationship between tables? 4b) maintain all the queries & reports? 4c) maintain all the data input forms? 4d) etc 5 -
HTML view and images
I think I must be dumb today. I have spent several hours trying to get a logo to display at the top of my html view. I can display an image that is not in zoho. But I am making an app for someone else and I have a form that they can put in their company info which includes a logo. I can display the logo just fine in my view, I even created a view based on the form and I can display it there. I would embed that into my form but for some reason if I hide every field but the formula field the logo does
Specific database calculation help needed for computer illiterate novice!
I have created a database to calculate the amount of time I spend with patients doing a specific task. I have fields "Time Began and Time Ended". I need for the database to be able to take the time began and time ended and automatically enter another field telling me the total duration of time spent with that patient. I need to know how many hours, minutes, etc I spent with that patient during that visit. I know nothing about functions and scripts and after trying to read about them to learn, I
Printing HTML Views with Passed Parameters
Greetings all... I just spent the last two hours figuring out how to pass parameters to an HTML view with an embedded view only to discover that you can't print that view (using the Print feature in an HTML view.) So some suggestions on the best way to proceed would be greatly appreciated. The view is showing correctly using the code below - I WAS WRONG HERE...the Between function doesn't seem to be working properly. If you have the same date for both start and end dates you get data equal to that
Complex Boolean is Making Me Crazy
This is for an html view I'm developing. for each r in BBPOST [POST_STATUS == "Moderated" && ORGANIZATION == "Birchwood" && START_DATE >= zoho.currentdate] This works as expected. Now, what if I want to also include data for other Organizations AND Birchwood? It's like I need... for each r in BBPOST [POST_STATUS == "Moderated" && ORGANIZATION == ("Birchwood" || "Rosendale" || "Craig") && START_DATE >= zoho.currentdate] But this is malformed script. I tried this, but it does not work: for each
Can a log-in form be embedded in an HTML view?
I want users on my site to be able to log into their Zoho user accounts (so they can access other embedded views and data) **from my own formatted web page** and not by going to a Zoho website login page. The reason is I do not want to my users to leave my own site just to log in. Is there a widget or special form field or trick in Deluge that will allow me to do this? Many thanks for your response. Greg datazen1@gmail.com Santa Fe, New Mexico US
Interaction and editing local file/process
Hi! I need advice how to edit/save a local txt file stored in client side machine and suggestions how to stop/pause a local service. I suppose that this operation could be done only with some interaction with JVM envoirement or other external program...
Authenticated Zoho Users for a Form
I remember seeing some posts on this a while ago, but I cannot find them (this new forum has so much eye candy it's giving me a headache - sorry Zoho!) I'd like to prevent non-authenticated users from submitting a form. Is this the best way? if (zoho.loginuserid == null) { alert ("You need to sign-in to your Zoho Account to submit this form."); cancel submit; }
Record limit help!!!
Im building a simple database and want to set a 50 record limit as the attendants to an event are set to be 50, how could I do so?
How do you know if someone filled out application?
Will I receive an email or do I find it when I sign in? I have had my application set up for a little while now and check it daily but no one has filled it out yet, that I know of. I just wanna make sure I am not missing an potential clients.. Thanks for the help.. Heather
Dropdown to Checkbox
Hello. I'm trying to pass every selection in a dropdown field to checkbox, but I didn't succeeded. Everytime that I select a value in the dropdown replace the first value for this last. This is a task form and I want assign the task to several users. I don't want put directly a checkbox(multi-select) field because the user list is long and I prefer a dropdown selection, and every user input must be added in a checkbox field and selected it. In the dropdown field I want include groups of members too,
Filter lookup field by multiple criteria
Hi Everyone, I am setting up an appointment form that allows the user to select an interpreter, based on several criteria (see screen shot). The interpreter lookup field should filter the list by the following criteria: Language Method Availability (Start Time & End Time) It is quite easy to restrict the interpreters by a single criterion, such as language, as I simply add script to the User Input of the Language field (see code below): //Requery the AsscoLang combo box to show only those interpreters
How to acces Label Name in Deluge ?
Is there a way to access the label name of a field in Deluge Script ? Thanks, Pascal
Insert url automatically
Hi, My form has the following fields Month (Dropdown Choice) Results 2009 URL Link Name Depending on the Month value I need to insert the URL with Link Name EG Month = January Therefore if (input.Month == "January") input.Results_2009 == URL and Link Name = Results. Field "Results 2009"does not appear in script Field Actions Thanks
zc_LoadIn=dialog for existing record.
Hi all, I'm trying to get the ajax-modal window to open for an existing record with the zc_LoadIn=dialog arg and it's not working for me. Form is loading in new window. Here is my code: theDeal = Deals [Deal_Name == input.iDeal]; pathDeals = "/ensobase/home/Deals/record-edit/All_Deals/"; lnk = "<a href='" + pathDeals + theDeal.ID + "?zc_LoadIn=dialog' >Deal</a>"; Any ideas? tt
HTML View and Mobile access
Hi, I am unable to access a HTML view from a mobile device. Before I go any further I want to verify with support that Views of HTML type are accessible from the mobile access point. A pointer to where this is discussed in the Creator help system would be ideal. Thanks, Tony.
Has anyone created buttons that can execute SSH commands
Hi everyone, i would like to thank any responses in advance. I have started to play with the zoho creator and i was wondering if there is a way and if any has any insight to be able to run ssh commands inside the application. We want to be able to control some hardware with our database. Thanks.
A twist on autonumbering
I have implemented the autonumber solution in one of my applications, and it works perfectly, but had a question regarding the duplication of a record. In my application, the user enters a bunch of information about an event. When the user clicks the submit button, the On Add > Validate event will process the autonumber script. But in this application, there are many instances where one event doesn't differ too much from another, so using the duplicate function built into Zoho's list view would
Suppress Custom Action after execution
I have created a custom action on a view for each record ; however, once the user clicks this once, I would like to not show (suppress) this action.
How to use the JSON input
Hi I have a Database and I want to use the JSON stream in my app. However I cant see it working. I am not a JSON expert but after googling it seems I need a key in order to be able to import it into my web app. Please let me know how can I use this.
Newbie looking for help creating "if" syntax
I am creating an activity sorting application. I want to be able to calculate the amount of time allocated to certain categories of activities. I am working with these two fields: Field: Time_Spent (numerical value of hours spent/allocated to a particular task) Field: Frequency (checkbox list that includes: "Daily" "Weekly" "Monthly" etc. What I want to make happen: When selecting a value (checking the box) in "Frequency", if user selects "Daily", multiply the value in "Time-Spent" by 5 and place
Autopopulating Field with Realted Data via email input. (got that? lol)
I thought for 10 min and could not come up with a more descriptive subject. ;-) I have a form that is populated via email from multiple websites. I have a "source" field to track which site sent the mail. (So if the form was on abc.com I know that.) What I am trying to do is populate an email contact field from another (related) form. Example my "Contacts" form for has: abc.com, joe@abc.com 123.com, 123@gmail.com So the goal is: When a mail arrives and the "source" field reads "abc.com" populate
create graph from data
I have an form setup that collects registration-type data (name, address, class). I'd like to create a view of this line graph of this data with the count of names for each class. Can I do this is Creator? If so, how?
Long Private Key Strings
New topic branched from here http://help.zoho.com/portal/en/community?ftid=2266000000321064 Long private key strings are meant for private sharing of individual components to very large number of users. Here you also run the risk of the keys being shared to unknown users and if they are, then you have no control over it, unless you choose to either regenerate it or revert it. We would advise you not to use them in the application logic in the first place. Instead we recommend you to use the authorization
unescape in code
I'm doing some custome html view, and i'm making an external link where i want to provide the parameters unescaped. However, if i do <a href="someurl.com?<%=unescape('a=1&b=2')%>">Bla</a>
The code editor wont let me, saying there is an error. How do i do this?
Importing data via email
Hello, the graphic on the Product Overview Page says you can do it, but I'll be darned if I see how. I have several dozen sites that collect data email it. I'm trying to get ZC to read those emails and put the data in the db. After 30 minutes of looking for how to do this, I give up and ask for a link or other guidance. Thanks.
Filter command needs to let me pass in a string for the <criteria>
Dear Zoho Developers, I want to create a search page for my users where they can search on multiple fields and I am having trouble when it comes time to write the Filter statement. It seems like the only way to write a Filter statement is to hard-code the <criteria> part, e.g. contacts = Contact [ name == input.name && expiration_date > input.exp_date ] However I want this to be variable; if the user only enters something for name, the statement should be: contacts = Contact [ name == input.name
Help with multi select
Just re-iterating this as did not get a response. I have a multi select box in which a number of filters are applied to so that when the final selection is displayed the use has only a few choices. Of the 200 parts, by selecting a site, and then a fault type the list is reduced to 6-10 selections. This work fine while there is nothing selected, but once the incident is edited, the selection is lost, and I want to re-apply the selection (which is often more then one part of equipment) so that it reflects
Link between Forms
Hi, I have created 2 forms but do not know how to link the variables between the forms. I have,eg. - Form A with variables A1 and A2 - Form B with variables B1 and B2 - variable B2 should derive from A1 + B1 Can anyone advise me as I'm confused by the script builder? Thanks lots. Thomas
Multi Select Checklist
Hi, I have a multi select checklist which changes acording to differenct criteria selected within my form. When the form loads on edit, the exsisting selectections, which have been checked, do not show up as checked on load. I figure I need to use the Select / Deselect feature, and fetch the what the current record should be, and on load, check the boxes. Something like: current_equipment_type == Incident_Report.Equipment_Type_New
Equipment_Type_New.select(current_equipment_type) Is this down the
Formula Program Assistance (If>Then)
I am currently using the formula listed below to lookup the previous record and pull data. Altering the formula listed below, how can I write the formula so any number that returns as negative, will be altered to zero? if (count(Main[ID != 0]) > 0)
{
rec = Main [(ID is not null)] sort by ID desc range from 0 to 1;
//fetching the last added record
input.Usage_P1_SQUD7442N4 = ((input.OnHand_P1_SQUD7442N4 - input.Shipped_P1_SQUD7442N4 - rec.OnHand_P1_SQUD7442N4) * -1);
}
else
{
On Submit Mail Question
I am having difficulty with the simple email notification feature once a Creator form is sucessfully submitted. It seems I can only have 1 email address in the "TO" field, and 1 email address in the "CC" field, and 1 email address in the "BCC" field. How can I set it up to send the email notification to 2 users in the "TO" field and 4 in the "CC" field. See code below: sendmail
(
To : "who@who.com"
From : zoho.adminuserid
CC : "who2@who.com"
Reply to : "who3@who.com"
Upload file - Client Side API
Hi all, I'm trying to add a Upload field in a html page using the Client Side API, but it doesn't show up. All other fields from the same form are no probleem. Maybe I am forgetting some special settings, like with a picture field ? code: <td><script type="text/javascript">Zoho.writeLabel("ImageUpload");</script></td> <td><script type="text/javascript">Zoho.writeInput("ImageUpload");</script></td> The label shows, but the input field not. I also couldn't find that
Fetch and display multiple records from stringlist on user input
Hi, I'm a newbie developer. I'm trying to figure out how to write a script, but my brain is hurting. In a form called Add_to_Assignments I have a lookup field called COMPETENCY_A_A that's displayed as multi-select checkboxes. The data is from a form called Add_to_Competencies that has two fields: COMPETENCY and AREA_OF_KNOWLEDGE_C. In the Add_to_Competencies form, the AREA_OF_KNOWLEDGE_C field is a single-select dropdown lookup from a form called Add_to_Areas_of_Knowledge. What I'd like to do is
Deluge: can a field reference itself (instead of specifically referencing itself by name)?
Is Deluge capable of allowing fields to reference themselves, instead of specifically referencing itself by specific name? I.e. User checks a decision box called "iwantblue". The following script would run "On Update": if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose another color."); self = false; } meaning the box would become unchecked after an alert box, instead of: if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose
Newbie question: if statement in a Formula field?
Hi everyone, I'm new to Zoho and am building my first app. I'm pretty excited by what I've seen so far and look forward to learning more. I've got what is probably a simple question. I would like to generate a Formula field called Name Line that displays either the individual's name or the business name depending on the value of the field contact_type. I tried the following but got an error saying it didn't expect an "if": if (contact_type == 'Individual') { name } else if (contact_type == 'Business')
Reference Formula Assistance
I need some newbie help on a formula in Zoho Creator I have 2 fields I need to do the formula on Field 1: Todays_Inventory Field 2: Todays_Shipment I need to do the following formula (Todays_Inventory - Todays_Shipment) - [The entry for Todays_Inventory in the previous record] How can this be written to look into the last record entry and pull the data number for the Todays_Inventory field? Thanks in advance.
Problems viewing X-Axis Labels in a Chart View
I am having a small difficulty with a Chart View of a Line Chart in my Zoho Creator application. If you reference the attached sample image, you will see that on the X-Axis, you can not see the axis labels. The X-Axis is set to match the "Date" field, however, You can not see the dates on the image. One 1 chart, I the labels were drawn at a 45 degree angle automatically, but I can not seem to find how to do tell this chart to do it. Also, how can I set the chart to in chronological order to where
How to get the correct record ID from a selection in a picklist where there are multiple records with the same criteria?
This is a tricky one that doesn't seem to be addressed directly in the Deluge documentation, unless I've missed it. A lookup-picklist displays a list of names to choose from. In that list there happens to be more than one listing with the same value, e.g. "John Doe" and "John Doe". When a user selects one of the "John Doe"s, I want to know the record ID# of the selected "John Doe". But... if I use the method seen below, how do I know that the ID grabbed is to the *correct* John Doe that was
Next Page