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.
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
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
FORMULA
I have this formula in my spreed sheet and wanted to know if there was a way to put in zoho Creator for a form i am creating thanks =SI((E85<=24,99);(E85*0,12);SI((E85<=100);(2,5+((E85-25)*0,08));SI((E85<=1000);(7,75+((E85-25)*0,04));(52,75+((E85-1000)*0,02)))))
Another issue with hidden fields ....
@ZOHO Creator Support Team: In order to dynamically filter the record in a List View ... so only records where fieldX=abc are shown ... I append ... /fieldX=abc ... to the url for the List View. This works ... but ONLY as long as the List View is defined with column for fieldX being visible ... if it is left hidden, ALL records in the Table are shown. This is yet another case of a hidden field causing unexpected results ... similar to the previously reported case of the hide fieldX command causing
Is there a way around this ?
I have an HTML View that contains an embedded (via iframe) List View (so I can dynamically filter the records displayed in the List View). Each record in the List View has a Row Button ... the function associated with this Row Button navigates the User to another View within the Application ... this is done with the openurl command. When I use "same window" as the second parameter ... no navigation takes place ... the current View remains displayed. When I use "new window" as the second parameter
picklist update
I have a form that contains a picklist element as defined below: must have firstChoice
(
displayname = "First Choice"
type = picklist
values = weekends[activeWeekend].label
)
As you can see, the values are populated by pulling from another form with a criteria. Here's the thing, this is exactly how I want it to work when the data is originally submitted. However, I've noticed that if I want to edit this info after it's been submitted, the same criteria is being applied.
Unable to select view fields for use with custom action
Hi, Here is a view I've created, with a custom action I've just added. I've had to add the custom action using the view definition free-script editor, because I was unable to select the field "FullEpisodeNumber" as argument for the function in the "create custom action" wizard. Why?? list Subs_a_bajar { displayname = "Subs a bajar" show all rows from Capitulos [Sub == false] ( Serie FullEpisodeNumber Title Filename DateAdded ) filters
How to translate "user submitted data" ?
email notification with user submission data works perfectly well, but zoho creator writes "user submitted data" in the email body before data : People I write to are french, I'd like to write them in french. :-) Is there any way to remove or translate "user submitted data" ? THX. -- Nina
dropdown menu displays in alpha order even though box not checked
Hi, the dropdown menu in my applications is now displaying the items to select in a strange order, instead of the order in which they are listed.They are not even displaying in alphabetical order. They are displaying in a random order.By the way, the "display in alphabetical order" box is NOT checked.here's one of my applications which has been shared with supporthttps://creator.zoho.com/cindychoi108/form/1082/edit/
images not displaying in view
Hi, I have a view that displays the result of the formula below: "<img src='" + Image_URL + "' title='" + Image_Name + "' alt='Display Uploaded Images in Zoho Creator' />" This had worked for weeks without any problems until I checked it today. Now, instead of seeing the images, I see only the alt text. I know this isn't the result of any changes I've made because I haven't edited the application in over a month. Any ideas why this would happen? Thanks!
Any Help?
Hello, Basically I am developing an application on zoho creator its quite simple, its a holiday booking system and basically the user shouldn't be able to double book a cottage,I have 2 date fields in the reservation form one for date in and one for date out. I have selected no duplicate entries so they can't book for the same day, but this doesn't stop them overlapping e.g. one person stays the 22nd april - 25th and a second person stays from the 19th- april to the 23rd the system will still let
Lots of bugs in firefox.
I've found many bugs using firefox - I recommend that you ask clients to use IE only. Dan
embed the entire app
1 when I access the application, I can embed in a website. But, in facts, only the current form is embedded. I would like to embed the whole app, with the layout and tabs as designed in the design choosen. 2 When a printing button will be added to the app ?
Zoho Creator
Can i create forms in 'Zoho Creator' that adds records to 'Zoho DB'? Right now they seem like 2 completely seperate products. If not, this would be very useful.
Dynamic picklist clears at start of action
Hi - I'm trying to build a dynamic picklist from the selections in another dynamic picklist using a custom button on a stateless form. Here's the scenario: 1. Picklist1 is populated based on the selections in other fields. (Works great) 2. User selects entries in Picklist1 then clicks on Add button to add entries to Picklist2. (Works the first time) 3. User can then change entries in Picklist1. (Works great) 4. User selects entries in Picklist1 then clicks on Add button to append entries
Vanity URLs
Does ZC apps support vanity URLS? i.e., could I have www.mydomain.com/appname/formname/etc.? Ramin
Applications list is not displayed
When opening Creator, the list of My application is not getting displayed 50% of the time. The list below My Applications is empty. I need to reload the page number of times (sometimes close to 10 or 20 times) to make it appear. This seems to happen with Chrome -Jag
Best way to link to another form
What is the best URL to link to another form within an application? Does it change if provided to outside users?
Newbie here needs help.
This is my first post to this forum. I'm pretty new to Zoho, and I've created a few forms to help track members to my group, as well as RSVP's to my group's events. However, I can't seem to figure out how to have Zoho keep a running tally of how many "yes", "no", and "maybe" responses I collect from my form. I found something called "iterate data in radio buttons..." (my form collects RSVP's via radio buttons) but I'm still having a hard time understanding the scripting language. Can anyone help?
timesheet
I want to make an application to fill timesheets. How can I easily fill-in a time variable (starttime for example 08:30) , end-time (16:45). As a result the the worktime has to be calculated. I don't want to use the date/time widget but just want to fill in as stated above. any ideas.
Extended browser support
I'd propose ZC team to focus on browser support, now limited to Firefox 3.0+ and IE 7 + . I was in situation to ask a client to put a notice for the visitors of his website to use only IE or Firefox, knowing that almost half of his visitors use Chrome or Safari, and this because the solution I provided in ZC does not work with these browsers. More than that, Firefox will be upgraded in a few months to the version 3.5, it will be a major upgrade, and if you are a developer and use latest beta builds,
fill in textboxes with url
Hello, I've been using zoho creator for some time now, but what I like to do is getting a variable string from the url. Meaning I can create a url with 2 variable which opens my form on the zoho website and automatically fills in 2 Single Lines. Is this possible? I've been fiddling with the deluge script, but can't seem to get it to work. Can anybody help me, or direct me in the right direction. Thanks
Wish List
This follows on the very long post here: http://help.zoho.com/portal/en/community?ftid=2266000000241253 With the advent of a community-driven voting system, I thought to post my wish list just for fun! Prioritized... Fix ZC bugs iCal feed ZC Scheduler Time-only input field (customizable 12/24 w/option to not include seconds) Basic rich-text editor in multi-line input field (must include hyperlink editor) Scripted views for On LoadHappy Earth Day
Creator: redirect to another form
Is there a way I can redirect to another form. This should happen once I am able to verify user credentials on my page...
How do I access the data collect by this form?
Hello, I want to export the data collect by the form. How do I access it.
problem on Zoho Marketplace
Hi! One week ago I wrote a message to support using "feedback" link. In that message I asked for an urgent solving of a problem on Zoho Marketplace. I did not receive any answer, probably my message was somehow missed by ZC support. But the problem seems to me a very serious one, and I want this post to be a as a warning for the developers who published application on Zoho Marketplace or intend to publish there. What is about? I discovered that the Deluge script code of any application from Zoho
From HTML view to pdf
Hi, I have created a nice invoice for my application, based on a HTML View that combines data from various forms. I have discovered in the process that HTML Views are incredibly powerful: congratulations on the 3.0 version, which is truly a major improvement. Problem: how do I actually send the invoices to our customers? I was hoping to just print them on paper or print them into a pdf file, but this is much trickier than I thought. The HTML View in question is triggered through a Function, so I
A Message for Senior Management ...
ZOHO Creator Team: My client had a simple request ... To be able to view a list of records within a certain date range that is specified at run time ... group them by a another field (defined in Edit Mode) ... and for each Group show the count of records for the group as well as the Sum of another field (also defined at Edit time) ... something mundane as this should be possible without resorting to HTML Views ... but not with ZOHO Creator ... so the workaround was to setup a Stateless Form for the
Next Page