Create View showing records for Today and next 7 days
Hi, How would I accomplish creating a view that would display records that occure between Today and the Next 7 Days? This is waht I have, but it's not working. (Start_Date >= zoho.currentdate && (Start_Date >= (zoho.currentdate + '1W:0D:0H:0M:0S') && Start_Date > zoho.currentdate)) thank you.
Remove Null
So I am using html view and I am inserting record variables into the view using the insert expressions tool. The problem I am having is that the drop down menus that have no data/value saved in them are returning "null" instead of just a blank white field. If a field does not have data i simply want it to be blank, not say "null". The worlds null all over my screen looks horrible. Is there a way that the dropdown menus do no return null if there is no data? The text fields seem to be working
One entry per user / Date
Hi All , i have 15 fields , one of the fields has a Name Section and the other date , like the following: Name: Date: .. .. . i want to prevent double entries only when Name and Date are double. e.g. Name Date John 12-05-2013 John 13-05-2013 John 12-05-2013 this should be prevented thank you
How can I add a next button?
Hello! I want to add a new button which opens a form. How can I do it? Thank you
Copy forms into another app
How do you copy a form or a section from one app into another app under the same account? Thanks, Antoine
This is how to display user messages from within functions
I found a useful way to display error messages to users from within functions. This seems to work in all uses of functions except in perma views. 1. Set up a form to store the messages: #Message_Number (Number field) #Message (Rich Text field) 2. Create a view for these messages and call it User_Message 3. Create records for each message you plan to use in your application. 4. Create this function (remember the 'void misc.display_message......' may have to be changed depending where you
API Name for subform rows
Hi From where do we get to know the API names for the fields of different rows in a subform. For example, if there is a subform called "Items" and it has fields "Item Name", "Item Price" and "Quantity", how can i assign the input value of these fields to CRM fields? For example: I have fields in CRM as "Item Name 1", "Item Price 1" and "Quantity 1, "Item Name 2", "Item Price 2" and "Quantity 2", "Item Name 3", "Item Price 3" and "Quantity 3", "Item Name 4", "Item Price 4" and "Quantity 4"? How
Inject parameters in string
Hello to all, May be it will be usefull for somebody. Very ofthen I need to construct string values in such a way: some_value="Bla-bla-bla "+thisapp.somenamespace.somefunction(input.ID)+" sdfgsdf:' "+input.someInt.toString()+...... and so on And when you need to change text - you waste so many time to find and change all quotes, to close them. You can use this function to inject parameters in string value like this (f is a name of application with functions) someValue=f.print("User _1 changed value
Defining contents of a lookup dropdown field
Hi, I have an issue with my application I was hoping to fix. I have two forms: - Client (Has fields for "Client Name", and a Multiple Choice field for "Project Name") - Staffing (Has a list of staff names, and Lookup fields for both "Client" and "Project" fields from "Client form" I want to find a way that if the Client is selected in the Lookup dropdown, then the Project dropdown contains only the projects against their name in the "Client" form. Does anyone know if this is possible? Regards, David
Export Dashboard to excel
Dear all, Where is the export to excel option in Zoho ? is it possible to export to excel.
Lookup Fields of the same form
Is it possible to create a lookup field on a form, to a field on that same form? This is hard to explain... I have an app that I use to log "issues" on a website. Occasionally I have issues that are related... So on my "Issues" form I'd like create a lookup of a field on the issues form that I would then call "Related too". When when adding a lookup field it doesn't let me choose from the form I am working on. Any ideas? Thank you! Greg
Fetch records HTML page
Hello everyone, this is going to be a long one so please bear with me! I am new to deluge scripting and am stuck with a few key principles. Outline of what I am trying to achieve: Use Mail Merge to load a HTML page which i will then print - an example of the page which i currently print from a access database is here How far I have got: Created a HTML page Created a data view with a custom action to load my HTML page. Created a function for my custom action (below) void netbooks.SignOutForm(int
Split Forms similar to Access
Is it possible to set up a Split Form similar to what they have in MS Access. This form would have the following: - On the top half of the form would be the parent record information. You would be able to scroll between parent records by scrolling from page to page. - On the bottom of the form would be the child records. This would be a listing of the child records that were associated with the parent record on top half of the screen. You would be able to scroll up and down through the child
Need a form to send an email to a client, retrieving the email address from another form in another app
I have a form (call it formA) in an application (call it applicationA) in which I register all my clients service requests. And all the information of my clients are located on the client form (call ir formB) on a client database application (call it applicationB). What I want to do is for the applicationA to execute an action, "on add" / "on success", that sends an email to the client with a confirmation of the service request registered on formA, using his email (the client´s) located on the client
Assign Pay Rate to Team members
Hi, I have a workAssingment app that i use to assign tasks to individuals or to Teams. my issue is that not all individuals are paid the same rate and not all teams are comprised of the same people. Also, pay rate per job varies. Thank you.
Can't Use Lookup Fields in Reports?
I have a form with a bunch of lookup fields in it. I'd like to create a report on this but in the report builder non of the columns that are for the lookup fields show up. Do reports not allow use of these fields? Is there a work around for this? Many thanks! G
When ZC can support safari or iPad?
Hi When ZC can support safari or iPad? Thanks Stanleyguo
How can I display a BOOL checkbox field as 'YES/NO' rather than 'TRUE/FALSE'?
KNIG02 - Jacqueline - Knight - 1 - 0 02-02-10 0 false Toothpaste KNIG02 - Jacqueline - Knight - 1 - 0 02-09-10 0 1 false
How do I change the checkbox BOOL field from 'TRUE/FALSE' to display 'YES/NO'?
KNIG02 - Jacqueline - Knight - 1 - 0 02-02-10 0 false Toothpaste KNIG02 - Jacqueline - Knight - 1 - 0 02-09-10 0 1 false
Image default value
Hi, The Image field has no default value available in its settings. I've tried to set it in the validate and success sections so it points to another URL with no good results. Did anyone try this or similar already? This can be used when setting a profile picture and need a placeHolder in case it is empty. Any offers? Thanks,
RSS Feed into MAC OSX Widget
Hello, I have a created a RSS feed widget using the program Dashcode. The widget takes the feed from my zoho application and plugs it in to nice little display of my app info. However the widget doesn't seem to be updating whenever I make a change in my zoho application. Has anyone ever done this before and had it update? I read in the help section that the rss feed could take anywhere from 5-10 minutes to update but that didn't happen. A
Get value from parent form in Add new entry form
I'm using the standard look-up fields with the "Add new entry" option enabled. However, I'd like the add new entry form to grab a value from the parent form it was opened from. Any ideas? Search across the forums and help and just can't work out how to do this. Many thanks! Greg
Form post to two tables
Is it possible to have the fields in a form post to two tables. I have a set of checkboxes come from another table. I sort of want to mimic an "other - please specify" type approach where I have the select boxes and then have say 5 text fields. If the one or more of the 5 text fields is filled in the values of those should update the main table for the form they are on but also update the table where the checkbox values are coming from. Not sure if I'm explaining that ok. Many thanks! Greg
Scheduler and getUrl
I put the following in a scheduler: HTML = getUrl("http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_Stockholm.html?mod=topnav_2_3002_europe") ; where can I view the data?
On submission, can the form go back to the previous website?
Here is our website... www.newlifeinfo.com After someone fills out the forms we have online and clicks "submit", how do we code the "submit" button to make the form go back to the originating website? Right now when you hit submit, the form just restarts again with a confirmation message at the bottom. To go back to the website you found the form on, you have to click back a few times and we would prefer it to just automatically adjust back to the page before it rather than clearing the data and
Select Records valid for a Date
Hi, We have a form which has fields such as From_Date, To_Date plus few more. This form serves as master data which is used by other forms & application. To get the required information for a specific record from master form for any given date i.e. we would like to search for a record in master table for a date which should fall in between from & to date fields. We have tried fetch record command ( Xdate >= from_date && Xdate<= To_date) but it returns a null. The data in master is like We would
Help with script please
Hi. In a form I am working on i have the following requirement. One of the fields in the form is Date Another field is Post_Code Another is Map Now lets say I have 6 records that have say 6/4/2013 Google maps uses the format https://maps.google.com/maps?q=from:sl45sf:to:da81hg:to:me103de Now what I am trying to do is when ever I make a change to the Date field doesn't matter if I am creating a record or amending one I want the map field for each record with the same date to recreate the same entry.
Text Link to Populate a Field
Next to a text field I'd like to have several text links that when clicked would populate the text field with a certain value. Sort of like a short cut to populate the field with a pre determined value without typing. Any ideas on how I can do this? Thank you. Greg
Remember Field Value After Submitting
After submitting a form, I'd like the new blank form to have one field pre-populated based on what the value was in the previous record entry. Any tips on how to do that? Thank you!
Preformance calculator
I would like to make a simple preformance tracking app calculator and would need some help The basic app is like this Fuel entry form - here one enters each time the car is fueled (let's say inserts date and liters) Car performance - here one enters car type, consumption and client charge Daily mileage - here one inserts counter mileage of selected car each day (maybe even inserting empty miles and loaded miles, each having a certain income for the driver / company) Ideally one would need have two
2-Level Conditional Picklists
Is it possible to create two levels of conditional picklists? I've found and successfully implemented the following: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup To carry forward their example, I want to add a third field, City. The new City field would be dynamic and the values would change based on the State. It seems that it should be possible, but I can't quite wrap my head around how to apply the instructions above to this situation.
Auto calculate fields when another is selected
Hi, I am trying to see what I want to do is possible using Zoho Creator. In my application I have a field that has a list of names, a field called Placement Price, and another called Commission. When one name is selected, I want the Commission field to auto-calculate this person's commission percentage from the Placement Price. Is this sort of thing possible in Zoho Creator? Thanks, Elizabeth
Grid View
Hello, I would like to use a grid view in order to allow for a various edits for various records while they are displayed on the same page and without going through editing each record. I realized that I am not able to do a grid view because I have deluge scripts (on-edit and on user input) on the form the view is based on. I noticed that you do not currently support it. Are you going to support it in later version, and if so, when? any suggestions for a work around where I can change the values
Help with button
So in my form I have a check box or radio button (doesn't matter which) that when I click if activates the script sendmail [ from:zoho.loginuserid to:input.Agency_Email subject:"Message from Nigel L Cross (Kent)" message:input.Email_Message content type:HTML ] What I want is to have a button within the form that does this instead of using a check box or radio button. Is this possible please Thanks. Nigel
Running History Information (Change Log)
Hey all So I have a form set which is a project, on the records there are multiple changes happening, for instance costs, allocation of the owner etc. Im trying to find a way to record all the changes; Within the for set I have a Multi line field which ive called history, when the field is first created I would like to enter in the history "project created by " && zoho.loginuser - this returns an error LHS cannot be a constant, not sure exactly what that means but obviously doesn't like having text
Combine data in chart
Hi, I have a table with rows of stores sales each week, example: Week1, Store 1, Sales xxx Week 1, Store 2, Sales xxx Week 1, Store 3, Sales xxx Week 2, Store 1, Sales xxx Week 2, Store 2, Sales xxx Week 2, Store 3, Sales xxx Week 3, Store 1, Sales xxx Week 3, Store 2, Sales xxx Week 3, Store 3, Sales xxx I have a chart showing sales development over time. In this chart i have a user filter to be able to see a single store. Question 1. Can I show the single store develoment in a chart together with
Timesheet Total Time Worked Calculations
I have seen the below forum explanation of how to generate a timesheet where the start and end time are submitted in the following format, 08:30, 16:45 etc and a total is calculated for hours worked. I don't understand how to use the script function yet, could someone provide an explanation on how to do this? I would also like to add a field for Lunch Break which could have entries like 00:30 or 01:00 as in half and hour or an hour and for this time to be taken off the total. a) you could use Single-Line
Splitting date and time help
Hi, In my form there are 3 fields I need help with, Field A. date and time field Field B. Date field Field C. Time field What I want is when Field A is filled Field B is filled with the date part of Field A and Field C is filled with the time part of field A. So Field A = 28-Mar-2013 09:00:00 Field B = 28-Mar-2013 Field C = 09:00:00 Can anyone help please Nigel
Dynamically expanding Checkboxes
Hey guys Im not sure if this is even possible but I though Id throw it out there. So I want to have a list of Checkboxes that are based on data from another table/view. this would be say for instance a list of Vendors that a member of staff can belong to, but if another vendor becomes part of the portfolio then the list would be updated and they can be selected, at the moment im doing something similar with a Multi Select field but it just seems messy to me... checkboxes would be sweet! any suggestions
Need basic help with drop down or multi-selection
Let me start by saying I have zero experience here but I am a learning as I go. I have a small issue I am sure one of you can help with. In simple terms I want to ask customers how they prefer to be contacted. The options are Mail, Email, SMS, and Do Not Contact Me. I want to have a box appear for Email if they chose email as a preferred contact method and then also have box appear for Cell phone if they chose SMS as a preferred contact method. The address is required and we collect it earlier on
Next Page