Preload permalinked form based on record id
I need to be able to pre-load form fields in a permalink'ed form based on record ID. How do I do this? What I'm looking for is something like: http://creator.zoho.com/USER/APPLICATION/form-perma/FORM_LINK?recLinkID=1234567890&viewLinkName=VIEW_LINK I've done a lot of research in the help docs and forums and keep running into dead ends.
search box
Hello friends are there anyone who can to help me , I have one form where there is some dialog boxes : Name, Website, Login, Password , Mail reference and type and I,m putting more one dialog box " search name " where the person put the name of site and with one enter find the name of this websites . it´s inside this form just that I had read tutorial about to create on Search form but it didn´t work .
Zoho Creator Application Runs on the Mobile Device
Hi there: I put the script on the form (on User update), so when a user select a account name from the drop down menu, the forms will pull out all the information, and fill in other fields, like phone#, address...etc, in the same form. It works perfectly in the PC workstation, but nothing happens after selecting any account name when I access from the mobile device. PS : I went to mobile.zoho.com, and from there I go to my application. Any solutions for this?? or just zoho creator doesn't support
Can I create an Auto Import Function
Our business collects many business cards and I use a card reader that exports the data into .cvs or .xls format. I would like my Zoho database to auto import from that form. Is that possible? Thank You Jason
Assigning auto generated numbers (not sequentially) based ona criterion
Guys, Please help!! Runner Ranking System Objective: To rank runners in India based on Speed and Distance across categories (distance run, age and gender). Current format of application: Timing input form: this form takes in data from the runner. Fields trapped: · Name · E-Mail · Date of Birth · Gender · Distance run (5 kms, 10 kms, 21.1 kms, 42.2 kms, 50 kms, 75 kms, 100 kms) · Time taken (hh) · Time taken (mm) · Time
Auto assigned values to a new record based on the values input in otherr fields
hey guys, new to Zoho (and to the tech world, i am a mechie!). Here's the entire outline (attached) of what i am trying to do. Any help (in any area) will be much appreciated! Thanks! i know its a lot to read, but i didn't know how to express the problem any better! Bear with me
Opening URL Function
When I enter data into my form I add an image from a URL. I would like upon success for the new image url to open in a new window. When I try to create this function I get an error. I can not get it to just open the iput field image... it opens the window as https://creator.zoho.com/web864/client-database/
Can you get your data out of Zoho if you want later to migrate it to your own dB ?
OK, so you develope your database using Zoho... and later the decision is made to put your own dB online... say with... MySQL, SQL Server, Orcal, or whatever... or migrate to an inhouse dB like the pre-mentioned or MS Access. Can this be done easily or will it be a large project... or so hard that it wouldn't be worth it... I'm trying to help someone now who is "trapped" in a product that is no longer supported... they have years of data for their very small business... and thousands of records...
Is a "user" anyone who can view the data? (Can you create a public 'view only' dB with Zoho?)
Would someone be kind enough to advise me of the Zoho definition of a "user"... More to the point... can you use Zoho to create a data base that... 1 - unlimited people (public users) can search and view the data? .. club, or community, public database online... lookup whatever and/or... 2 - unlimited people (public users) can key in new records or key in designated fields defined as 'public data' fields ... register on a website ... entering whatever into a web form or dB... 3 - For the terms "Administrator"
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
Next Page