Single Item View vs. Letter
Hello, i have created an application handlin a list of users and some infos about them. I do sound sendmail stuff etc. One feature i was thinking about to implement remains unsolved. I can#t find a solution: I would like to have a button per row (like custom actions) where I can generate a Single View of the Item in the List View. For example a Page where I have a Letter with static Text and the (dynamic) infos of the row (person) like address, name etc Has anybody an idea? thx
Autopopulated one drop down and another from the first depending on what is selected
I am new to zoho and to creating db's and view etc, I need to create a nice little way to track all off the loot i get while hunting in my favorite game. Something like this... Application Title - AfterWorld Loots The Form Add Loot Select Zone: this would be a drop down box that is autopopulated with zones that I have added using the "add zone" form Select Mob: this would be a drop down box that is autopopulated based on what was selected in "Select Zone" Select Maturity: this would be a drop down
Page Break in E-Mail
With regard to an email generated by "Creator"... Is there a way to insert a page break for printing? I'm using ZOHO's "Creator" to generate a report, of which I need certain pages to contain isolated data. Any help is appreciated!
Is this Possible
I would like to have a quoting system for my web site. I envision a series of 4 dropdown menus. The client would choose a product from the first dropown. The next dropdown could be color, followed by quantity etc.. I would then like the form to total the cost based on their input and display the quote to them as well as email me. Is this possible... Yes i am a newby
Creating Views Dependent on a Value in another Table
I am wanting to restrict a view based on the client who is looking at the view. I have 2 tables. User Table: This contains the User Name, Email and the Client Name View Table: This contains all sorts of fields including Client Name Any suggestion on how I would restrict the view so only records that match the Client Name are shown? Producing a new view that has a filter for each client is not very workable, as I will have to create a new for every new client. Glenn.
RadioButtonSet.Select() does not invoke RadioButtonSet.OnUserinput()
Hi, I have a radio button set. I'm using the .Select() statement to programatically select a radio button option. I'm expecting that when I do this that the code behind the radio button's field action OnUserinput() will be called. But this is not happening. Once I issue the .Select() how can I invoke the OnUserinput()? Obviously when I use .Select() I'm expecting that it would behave as though the user had selected that option. Any ideas or workarounds? Thanks, Tony.
Shared
Zoho team, I have been invited to an app, twice, but still get the message : You are not authorised to access this application in Zoho Creator. Go to Home Maybe you guys can take a look at this?? Regards, Danny Sterke
please help me..need to disable "View Log Details" on my form
please help me..need to disable "View Log Details" on my form
Dynamic HTML view
Im wanting to embed a view that displays a record based on a field value For example; <div elName='zc-component' viewLinkName='Class_Details' params=' " Where field 'teacher' = 'Mr Baldwin' " &zc_SecHeader=true'></div> This should be ver simple - although I cant seem to make it work - not sure of the sytax However I need to take it one step further... lets say instead of 'Mr Baldwin' being a record in the form the view is based on, lets assume its a related field in another form (related as he would
newbie and reports
Really dumb question but I usually use ms access and thought that I would give creator a go as it gives me much better mobile access. I use reports inacccess how do I achieve that here. I probably need a book as i did in ms access. I looked at the videos but I think there very poor quality
Empty Dates
Dear Sirs, I wish to do a picklist of all the values I have in a field where the date has not been filled yet. However I'm not able to search for null or "" or Empty dates. The Script I'm using without success is: AWB ( type = list values = Control_Valijas[(Fecha_Arribo is null)].AWB ) Do you have any solutions to this issue? Thanks for your help...
Nested
Hi again, I have a table "Tasks". I'd like to be able to make tasks nested. I'd like to have a field that is a lookup on the Tasks form itself. Eg. I'd like the Tasks form to look like this: Task ParentTask Wash all dishes Wash cups Wash all dishes Wash plates Wash all dishes Wash bowls Wash all dishes Rinse cups Wash cups But as far as I can tell, this doesn't seem to be currently possible? When I try to
Clear Multi-Line field
Is it possible to clear a multi-line field using script?
how to create a form that inputs data to another forms database table
Hi, I have a form that inputs data to a database table. One of the aspects it inputs is "team", because there are more than one development team. I have created a second form exactly like the first, but with the "team" field preset that I will give access to one of the teams. When they input data, they don't have a choice to select the team. However, the data does not seem to go into the same table as the original form, because it never shows in the view I created for the first form. Does each
Unable to update Multi-Select field in another form
Hello I have the following code in the "Edit - On Success" event of my frmCountry_Market form: for each recP in frmPlayer [Market.contains(input.Market_WithCCode_before_edit)] { newList = {"item1", "item2", "item3"}; info newList; recP.Market = newList; } One recP record is found (the list newList is displayed in a log message). 'recP.Market' can not be set. This is what the log says: "Unable to update data on the form variable null" I tried updating another field in the same form (recP.Name
More complicated scripting based on Time and Graphs?
Hello, I just discovered the Creator section and I find it really magnificient. I am considering creating an app that is unlike any that I have seen developed so far. I would like to make use of the graphs. I work with groups that I want to support with data that is taken from the forms they fill in. For instance: - So far today your average is 10 (on a ranking from 1 - 10) - Here is your perforance today. - You are less than your average for the past week. - This is your progress over the past two
Reference Fields
I need some help. Zoho is great at editing literal records but I am having a hard time making a useful application that does not mirror a DB record. 1) given --- form PERSON known by ID has Last Name has first Name --- form COUPLE lookup PERSON.ID for man lookup PERSON.ID for woman Now when I build the COUPLE form I want to use a reference of ID back to PERSON twice, but I can only fill a drop down list with abstract IDs. I want the drop down to shown the names (First, Last) but then once I select
Application sharing not working
I have entered the correct email as a user to my account. I have shared 3 views to this email. Still the application does not appear under 'Shared Apps' (Home). If the user tries to access it directly (by clicking the link in the email that was sent to him when I shared the views) it says that he is not authorized. What to do?
Email Notification Based On Separate Date & Time Values
I have a delivery scheduler application and I need an email notification when the requested delivery date is tomorrow and the added time is after 2PM today. I've been trying everything I can and have been unsuccessful. Help please!!!
Help with multiple field lookup and returning a SUM total
Hi all, We are recent ZC converts and we’re trying to build a Job Management application for a creative agency. The application will manage: - Job workflow (Jobs contain different Tasks and Status’) - Track Hours per Task - Track total Hours per Job - Calculate Invoice amounts - Track Expenses - Generate Profit + Loss per Job The Jobs Form/View has these fields: Client, Job Name, Status, Hourly Rate, Actual Hours. The Logged Time Form/View has
Script runs slow
Hi When woring within Internet Explorer, our zoho application is requesting data from a table and is trying to dispaly this data in a drop down box that the user can select from. This was working ok until, to improve usability, we tried to request the data in a sorted [A to Z] list. Now we get a very slow response and this triggers a time out in Internet Explorer with a dialog box asking the user if they wish to terminate the script YES/NO? I have tried this in Firefox and while the response time
Simple navigation from one app to another
I want to have a click-able link in the side bar of my views to send me to another application. Seems like a simple request, but I can't find how to do it. Please help Wes
Trying to Create a Stateless Form
I am trying to create a Stateless form and am getting an error. I am looking up a field from one form and then trying to have it display relating fields that can be updated and then saved back to the other form. The form I am looking up is called Players, The field is called PlayerName. The fields I am trying to display are Team, Position, Owner. I keep getting an error and am not sure what is wrong. Can anyone help? The code I am using is ....form Draft { store data in zc = false
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...
Next Page