>= zoho.currentdate
hello! I am trying to figure out how I can have a calendarlike list showing entries that are after the current date, but also up to 2 days before the current date. this is the closest I get .... (my_date_field >= zoho.currentdate) best Flo
Function Does not Work From View Header
I am using a the openurl within a function to create a link to a "Full Record View". The function works when I use the button from any individual record. It does not work when I select a record any use the function from the custom actions drop down.
Asynchronous loading in HTML View
Does anyone have any suggestions on how to "emulate" asynchronous loading of information in a view? I have created many css accordian boxes right in a comment field on a form. (works great by the way for data you don't want edited and want to take up less room). Just hide the fields you don't want people to edit. Example of box here.... Code Example: // style for statbox stat_stylevar = "<head><style type='text/css'>.holder {width:260px; margin:0px; padding-left:1em; padding-top:0em; padding-bottom:0em;
Difference Between null, "", and "-Select-"
If you have a dropdown menu, what is the difference between using: if (input.dropdown != null) if (input.dropdown != "") if (input.dropdown != "-Select-")
Keyboard Shortcuts
Ok . . . hope I'm not monopolising the forum! Are there any shortcuts? For example, if you're running your app (to check it does what you thought it should), is there a shortcut to go straight to Freeflow Scripting? It's just a bit tedious stepping through . . . . . Thanks - Graeme
discontinued the support for javascript
Hi I have received an e mail regarding the above. Please help me defining if AND WHERE I use any javascript in my application AFB System 2.0. This is a very vital program to us. BR Dennis Skouboe
Giving a label to a grouped total in View?
I have a grid view of time entries, grouped by the Date field. When I tick the "Sum" option for the "Hours" field, i get a handy sum at the bottom of each date grouping. The only problem is that there is no way to label that total, so i get the number with no context. Is there any way for me to add a label to the total row? Thanks!
Print Button
Any ideas on how to create a print button in Zoho Creator, window.print() doesn't work in the script.
HTML View - Embedded summary view
Hi, When I make an HTML view and embed another view in it of the summary type, the "Edit" and "Delete" links remain visible and functional even when I disable them in the embedding dialog box. Any way around this? Thanks.
When a criteria is reached in an if statement
How would you go about ignoring the rest of the script in on user update field once a certain criteria is reached? For example" if (criteria) { run script } else if { run script } else { } if (criteria) { run script but stop all other script below } //Is there a way to ignore any script below here else if { } else { } if (criteria) { { else { }
Bug in CRITERIA
When I have two criteria connected with an AND (&&) the related VIEW doesn't work. When I have the two criteria seperately it does. THIS DOESN't WORK show all rows from Data [(Confirmed == "No" && Zoho_User_Name == zoho.loginuser)] THIS DOES show all rows from Data [(Confirmed == "No")] AND SO DOES THIS show all rows from Data [(Zoho_User_Name == zoho.loginuser)] The View just shows "We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com.
Hiding Fields
I'm wondering how I can hide a field on my form. It's a Stateless form currently with just a 'Next' button. It cycles through the records of another form. I can't use 'Hide' and 'Show' except in 'On Load' and 'User Add' I think. I want to Show a field that says 'Last Record' when on Last Record, and Hide it any other time. I've been able to remove the label by editing the Form Definition, but can't remove the Text box outline. Any ideas would be welcomed! Thanks - Graeme
Freeflow Scripting Syntax
Ok - Very basic question . . . where can I find some documentation about scripting. What I'm looking for is just exactly how/when to use {}()[] etc. What has to be enclosed in what & when. Sorry - it's got to be the most basic question I could ask but at this stage it would be really helpful! Thanks v much
Question about User defined variables
I've declared a variable in the 'On Load' section . . . viz: nextIndexField = '01-Jan-2000 17:04:16'; if (count(Workshop_Job) > 0) { //get First record myCollection = Workshop_Job [Added_Time > nextIndexField] sort by Added_Time range from 1 to 1; input.Customer = myCollection.Customer; nextIndexField = myCollection.Added_Time; } else { //this is last record ... now what ? } But then if I try to use it in my Button Click code . . . viz: //get 1 record ... whose Added_Time
Log-In Problem
The system won't list my applications.
Can't figure out lookup
Hi, Lets say for example I have an Employee form. Most employees have a boss (who is also an employee). How can I have a lookup field (a dropdown box) that lookups from Employee.Name ? Lookup fields appear to only be able to reference other forms, not the form they are in. This is pretty common stuff in Access or any other SQL database, but I cannot figure it out on Zoho. Please help!!! Thanks
About Latha's Blog ...
In her Blog of April/30 here ... http://blogs.zoho.com/creator/functionality-based-urls ... Latha (of ZOHO Creator) refers to "Advanced URL patterns for Zoho Creator Forms and Views" ... and describes the ability to "To set criteria for a view" via URL parameters. It goes on to link to a page in the ZOHO Creator Wiki ... http://zohocreator.wiki.zoho.com/Functionality-based-URLs.html#criteriaconstants ... which lists all the op-code values that can be specified within URL parameters in order to filter
View criteria: "date" before...
I try to set this criteria: Show Restricted records Criteria: "date" BEFORE 01/01/2009 The date format is the format I you use for my appl. I confirm with "Done" but the result is always Criteria = none Can you help me? Thank you in advance Lucia
My Form won't Submit
When I 'Submit' my form, it just says 'Please Wait' and never says it was succesful . . . and doesn't appear in my views. It's pretty simple as I'm just starting to learn this stuff . . . it used to work. I have shared it with support. Appreciate your help.
Zoho has no affiliation with www.zohocreator.com ?
I was logged in my account, and I tried to open in another tab www.zohocreator.com. The following message appeared: Access Request www.zohocreator.com is asking you to grant access to your Zoho account details. By clicking "Grant Access", you give Zoho permission to enable www.zohocreator.com to access all your user data available with Zoho Services. At any time, you can revoke the access permission to this site. To revoke access, go to "Authorized Websites" page in My Accounts Note: The Zoho privacy
Creating REALLY dynamic views.
Hey fellow Creator Zealots. Another great find for me and I hope this helps you. Subject-How to: Open an html view with MULTIPLE conditional embedded views by passing parameters to those views! Clarification: So instead of just having say ONE edit form open you can pass those record ID's to multiple embedded forms or views creating a whole page full of conditional information on the fly! It starts with the following code COURTESY OF RUBEN! He's great! <div elName='zc-component' formLinkName='Test_Form'
css background
So I'm trying to add a background to an HTML view using the css background code and it won't let me display the background in a #View. Only as an html/view URL. I have tried both a style script in the <head> tag. Is the <head> tag supported? I have also tried an inline style as well! I can't seam to figure out what is going on!
List manipulations
Hi, I am trying to check whether an item from one list exists in another list. Example: LIST1={"John", "Alex" , "Paul"} ; LIST2={"John", "Alex"} ; for each ITEM in LIST2 { if(ITEM not in LIST1) { } } When I try to save this script I get an error message on the If-statement: "Left expression should be a field name for 'not in' operator" What am I doing wrong? Best regards, Ivan
Can I create an Outlook Task from ZoHo Creator
Hi All, We currently have an app built in ZoHo Creator for people in our office to submit a request for resources. Currently the request comes in via email and I have to manually add a Task for it. Is there a way I can automatically make a task in outlook from creator? Thanks Ken
Speed
Hi, Creator team, I have some issues with my app TradeMaster. I believe I have shared edit to support. If you run, for example, the MASTER SHIPMENT TRACKIGN View under MERCHANDISING VIEWS section, it often takes over a minute to run the view. Sometimes an error is generated when running it. Is it normal? Our users are complaining and I would like to see if it can be improved. Thanks.
Voting Procedure for Cycle #1
Here, I would like to make suggestions and get input from the community about the process of Voting for the very first Cycle of the Community Driven Feature. While we can refine this process in subsequent cycles ... after learning from the experience with the first cycle ... I suggest the following simple process ... a) The voting be conducted openly and transparently. b) We deploy this forum for the community to vote their preferences ... I will start a new topic for this purpose ... community members
Update records on loading view
In form A I have the numeric field "Total" I will like - to show in this field the total number of records in form B where field "Status" in form A == field "Status" in form B - to update field "Total" every time I load the "form A" view (on Custom Action?) Is it possible? Thanks again for your precious help! Lucia
Script help
Hi! I will like to show in a field in Form A all the value (string) that I have in a specific field in form B. The main idea is: if field1A in Form A is == field1B in form B show in the field 2A all the values find in field2B of each record of form B I try with this script in Form Actions > On Edit > On Load x = FormB [(1B== input.1A && ...other conditions]; input.2A = x.2B; (Field 2A and 2B are multiline) On edit Form A the result is that I see only one value take from only one record of Form
Really tired of character encoding problems
Hello, I am really tired of having my concatenated URL strings (that were working) destroyed by my character encoding getting switched around. This adds tremendous amounts of time doing tedious revisions. How can I avoid this or when will it be fixed? Thank you!
html view not yet implemented?
I like everything about creator so far, except it doesn't seem to want to acknowledge any of my created forms when I try and make a html view. Seems easy enough. I make a form then make a html view based on that form. The walkthrough seems to indicate that I can select a form when I choose to make an html view, but that doesn't seem to be the case. Instead of the ability to select a form, I only see a blurb about mixing html and deluge scripting with a link to the help section. If I make a html
Time Tracker
Ok so im trying to take a list of people and give them hours, it should be simple to do you just check the box's of the people that you want and then it should total that persons hours for the week. the only 2 things i dont understand is how to make each check box create a diffrent record vs. putting them all in one since its a list of check box or total them from the list of multiples -TechIsCool
iCal Feed
Suggestion: iCal Feed Purpose: Enable an application to push event-oriented data to an external calendar (like Google calendar) via the iCal standard. Motivation: The built-in calendar view is simplistic and has many limitations compared to other calendar applications. Building a custom html view may be possible, but would entail large complexities. While there may eventually be programmatic connectivity between Zoho Calendar and Creator, providing an iCal feed would be a logical first step AND significantly
Add Images
How to add (attach) images and use them in html code?
newbie: script builder hangs on loading?, on update action not executing?
I'm new to Zoho Creator and was playing around with it trying to learn its features. However, I'm running into problems. Problem 1: script builder hangs I tried playing around with writing my funcition, and now the "Functions" tab no longer works. I get a little box saying "loading ..." that never goes away (even after several hours, and logging out). Nothing on the page works, and I have to close the web browser. HELP!!! Problem 2: update action not executing I created an "on update" action
Search and Fetch Error
I get this error - "We are unable to fetch this data, sorry! Please note that your data is SAFE". This is when I search on "Printing Press Name" in "Production Detail Master View" in my Job Ticket System application. Also, when I fetch a record in a collection, the values for the "Printing Press Name" field return a null. Please let me know how this error can be fixed. I have shared my application to support. Regards, Vasu
Are there any change aroud character encoding settings?
The other day, I add Japanese Character entries to my form by using attached Python script, and it succeed. But I tried same thing today and the Japanes charactors are broken, it transformed to question marks like "????". I tried also tried get method from Python but it failded. I tried get method add api from Firefox 3 Location bar and it succeed. Why the characters were broken? The number of characters equals to the number of question marks, so I think the query strings are recognized as UTF-8
support@zoho.com
Creator: I am trying to rearrange a form I've created in Creator and it is not saving the placement of my boxes. Any suggestions?
getDayOfWeek() confusion
I am having some trouble with the getDayOfWeek() function. In the "set variable" screen the "tip" for getDayOfWeek() states that Sunday is 0, Monday is 1, etc. However, in the documentation at http://zohocreator.wiki.zoho.com/Built-in-Functions.html#date, it says that Sunday is 1, Monday is 2, etc. However, when I try to use the function in my HTML view, I am getting Sunday is 6, Monday is 7, Tuesday is 1, etc.
subform workaround?
ok, so subforms are on the roadmap, but still a long time until they are implemented on Zoho Creator. In the meantime, I was wondering if any user/developer has a workaround he/she could share with the rest of us? If you know how to "simulate" a subform functionality, please post the link for your app so that we can play and learn... thank you so much. something like that: you see a list of purchase orders, you click on one, it takes you to the details where you can see all products included in that
DUPLICATE ERROR FOR KEY 2
What would I do if I see this error "DUPLICATE ERROR FOR KEY 2"? Appreciate if you could give us a feedback. Thanks, dcsanjuan777
Next Page