View column positions
I have added a new view(Sales Activity) of an existing form and no matter what I do or what the script says, fields from a linked form always seem to display at the back end of the view. You are shared What is going on here? Cheers Roy
Warning if field names are reserved.
I found out the hard way that if i have a field called COUNT and then try to use this field in a formula i get an error. Changing the field name to ItemCount and my app worked fine. Perhaps a simple pop up warning if a user as silly as I tried to use a reserved Deluge name for a field name?? Thanks Mark
Scripts and fetching not working!!
Hi In my appl. AFB System 2.0 I have a form named "Change Notice" where the fetch is gone in field name "EGName" It seems as if something is quite wrong in this form. My if scripts does not work anymore either Can anyone please help me! BR Skouboe
diffrent & repeat from view edit to scrit and wrong orde
View edit GUI order is not same to script order. And some view script,there are repeated order term.
Obtaining automatic email replies
I have a form that clients will use to confirm they have posted data in an application I am developing. To do this I had planned to automatically generate an email to give them the data they had posted and to ask them to hit reply to the sender and so post data in a form to receive the data. ie. peterl-xxx@forms.zohocreator.com However, I am getting an error message, even when I put the following code in the from line FROM zoho.adminuserid + ";" + "peterl-xxx@forms.zohocreator.com" How can I get
problem with my app
hello i have changed my display form names to my native language hebrew, and now the application seems not to function. i would appreciate if you could look into that to see what the problem is. i have revoked access to support and shared my app. this is the address http://creator.zoho.com/talshani/expenses thanks tal
Help needed in scripting
hello i am using the expense tracker app from the zoho market place http://creator.zoho.com/talshani/expense-tracker-tal/share/edit/ i would like to upgrade, i have looked in scripting faq and have not found what i was looking for. i would like to : 1. create several sum cell who will count my spendings by the category i have spent and will make it equal to zero each month. 2. have a scheduled email for those sums thanks tal
Lookup fields in forms for larger DBs
Suppose I have a "child" form (with ID and name, say), and a "visit" form. A child may have multiple visits. In the "visit" form I want to refer to the child, so I add a lookup field to child. I'm already puzzled here. I think the user would like to refer to the child by name, but I need the ID to unambiguously use it for links and such. So lookup ID or Name? Also (see below) I might want to hide this lookup field, but it is required. It looks like I can either make it required or hidden, but not
Grouping broken
Sometime in the last several days, the way Grouping works has broken. :( In the default "Owed Books" view of our database at http://creator.zoho.com/cheriepie/bookobsessed-owed-books , we group the records by the following 2 criteria: Swap Date (Descending) Swap Name (Ascending) Thus, the groups should be sorted FIRST by date (most recent on top), and then within a single date, by the swap name. This has always worked as expected up until a few days ago. Now, it's no longer paying attention to the
What's been edited in sendmail notification?
Hi, I know how to setup email notification for database entry additions/edits, but I'd really like to know how to include some information relating to which fields have been modified. Any ideas would be much appreciated, thanks.
hide fields on "Null" values on radio buttons!
Hi I would like to hide different fields, depending on the choice in two radio buttons. It is important to me that all fields are hidden when no choices are made in the radio buttons. Is this possible? I tried to make an example of this in the below; if(input.EGType_og_material == "null") { hide EGAction_perfomed_by_Purchaser; hide EGPurchaser_action_performed_date hide EGAction_purchase_description; hide EGRequest_finished_by_Purchaser; hide EGForwarded_to; } else if(input.EGType_og_material ==
How does "image" field work?
I created an image field in my application, where I would expect we can upload product images. However, when I run the application, the image fields doesn't have an upload button associated. Instead, it functions more like a text field, where you can enter text. So, how can I upload an image in the application? The Help doesn't help - in the "field types" section, there is no mention of the "image" field. Please enlighten. Thanks. cambridgemta
Simple formula error
Hi, I am making an app that allows for order creation. One of my forms allows a remote salesman to create a new order, with a unique ID for a customer. When products or services are added to the order they are pulled from the parent Products/Services tables and their Value in GBP is added to a hidden field. Another field allows the salesman to specify the number/count of each item on the order. So if product A is chosen, the value of �100.00 gets added to the hidden field and I want to multiply this
If statement based on the view that form is launched from
Greetings all.. I have two views based on the same form. Is it possible to have an if statement on in the on load script when the form is launched to add a new record that executes based on which view the form is launched form...i.e.... If launched from view #1 then show this field and hide that one Else show a different field and hide a different one Thanks for a great app. Joel
How to set criteria on value in checkbox
Hi I am trying to set up a criteria based on the mark in a check box is this possible? Cannot find it in help document. What do I have to write in the box for the criteria? BR Skouboe
Filter & search options don't appear in view
I am using the Open URL feature with the OnClick of a stateless form to retrieve specific records from my DB. Any idea how to get the resulting view to appear with the option to filter or search the view further??? I have my view set independently the way I want and it allows for further filtering...however, with the OnClick, this exact view seems to disappear...
Append values to Text Area
I have an application with say 2 fields: Single Line Text: Name Multiline Text: Notes Here is a simple task. I update the Name and press submit. I need the notes field to be updated with: Name updated by <zohouser> on<date> And if I again update the name it should append another line That way I have a simple history of changes. Ofcourse even better could be if it had values. So my Notes field will look like this: Name updated from AURN to ARUN by user John on OCT 3, 2008, 3:00 PM Name updated from
Form view different between IE7 and Firefox !!!!
why the views are different between IE7 and Firefox ?? how can I resolve this problem asap ??????
"On Load" code does not execute for public form
Dear Zoho support, I wrote some Zoho code back in June, that worked reliably for 3 months, but lately it has not worked reliably. It works fine when I am in the Zoho environment, but not so with the public form - then it only works the very first time the code executes. After the first time, the fields are blank. Below is the code in question. It is supposed to fill in the field TheDate with today's date and fill in the AdCode with a 4 digit number that is incremented each time the form loads. Here
Mail / Print html view.
Hi Team, I have a form that 'asks' for unique ID this is passed as parameter to a HTML view. & a dynamic report is generated collecting data from other forms. -- (so far so good) Would it be possible for me 1. Invoke the "print" dialog box from html view ? 2. Send this html view (the report) as email Please advice, Regards, Deepa PS- email notification for replies is not working for some posts. Please do look into it.
column width in creator
I have tried unsuccessfully many times to change width of columns by changing pixel and % . how can width of column be changed vijaikumar
On Load, does not execute reliably
Let me try again - sorry for the duplicate posts. I have two fields that supposed to be system generated using the "On Load" functionality. The On Load works the first time the form is used, then stops working. It was working consistently when I wrote the program back in July, and for about 3 months was fine. Here is the form posted publicly http://www.freemedads.com/submitad.php AdCode is supposed to be filled in with an incremented 4 digit #. TheDate is supposed to be filled in with today's date.
On Load code not executing reliably
Let me try again - I have two fields that supposed to be system generated using the "On Load" functionality. The On Load works the first time the form is used, then stops working. It was working consistently when I wrote the program back in July, and for about 3 months was fine. Here is the form posted publicly http://www.freemedads.com/submitad.php AdCode is supposed to be filled in with an incremented 4 digit #. TheDate is supposed to be filled in with today's date. Here is the problem code: i
How to set Checkbox to true
Hi Is it possible to set a checkbox as marked automatically, based on input of radio buttons? BR Skouboe
Can you pass a parameter to an HTML view through a URL?
If I'm embedding a view in my Web site, is it possible to pass a parameter to the form through a link in a URL? So if I had a URL like www.mysite.com?category_id=3 then the HTML view would know that the variable category_id is 3? Or can you only pass parameters through forms? If you can only do it via forms, can someone point me to a good example of such a form? Thanks very much. I'm trying to do a page where someone selects a category, and then sees results from the database based on that category.
How to access another application to read and write database
Hello People I like to work with Creator. You can do a lot of nice things with it. However it is not always easy to get answers from the documentation, therefore I turn to you to ask for answers. I've several applications that all can make use of a 700+ records database. It seems natural that I want to have only one copy instead of having a copy for every form I use. I've imported this data in a form let's call this form 'baseform' Let's call the application 'baseapplication' . Now how can I know
Submitting form one after the other
I have a form that the user needs to submit one after the other. They input data, submit, then input data again, then submit again, etc. The current form won't allow that. Is there a way to do that? Thanks.
How long is the ticketID valid for?
How long is the ticketID valid for that is used for API queries?
Date/Time functions
Are there any Deluge scripting functions that are not listed in the help file? I need to be able to evaulate dates to determine what day of the week they fall out on. The only date function that I see allows you to add or subtract an interval from a given date. Is there anything undocumented out there? thanks.
Edit record not working properly!
I have a view with only Edit permission for the users it's been shared with. When users (other than the owner) try to update a column, everything happens normally except the new value won't apply. For the owner user it's ok and to make even weirder those permitted users are able to Bulk Edit rows (even 1) but the Edit is not having any effects on the value! I'll share the app for support and you can see for yourself.
Submitting form one after the other II
I can't seem to post a reply, so I'm trying it this way. I'm trying to have a form in which the user can submit data on a form, then do it again, and again without closing the form out. Open url was suggested. I did that, sending the form back to itself. That seems to work. Now, though, send mail and success message does not work. Can you help with that? I have to be able to send confirmation emails. Here's the script as done in script builder: openUrl("http://creator.zoho.com/ewyrick/advisement-2009-appointments/form-perma/advisement09appts/Y37jMKRMNuxtQU2z35s1uHSRY4B9V6dgNGY3GN6ApEaPxRZjd5SOT75TmVHyXWr38A6HXWYujAWJ721BuAKNS9tPy41nvgvgKXMj/",
email notification still does not work
Hi , Email notification in forms still does not work for the last few months . its still does not work, no one is solving this :-) erezx2
All Set with New Application...
Hello Friends, This is Paryush Sanghvi, one of the Zoho Developer. You guys might have seen my application posted on Marketplace. Application Name: Debt Lead Management. Category: Sales That was my first application which i posted on Zoho Marketplace. That application was quite simple with 1 Form & Different Views according to different user of the application... So i thought that is not going make much difference... But now i thought to add some more features in it with some more html... So in order
Help needed in scripting
hello i am using the expense tracker app from the zoho market place http://creator.zoho.com/talshani/expense-tracker-tal/share/edit/ i would like to upgrade, i have looked in scripting faq and have not found what i was looking for. i would like to : 1. create several sum cell who will count my spendings by the category i have spent and will make it equal to zero each month. 2. have a scheduled email for those sums thanks tal
Sendmail script help needed
I am trying to create a contact form which allows the user to select a person and have the message be sent to the selected person only. I know how to send a message on success, but I don't know how to write the if, else, etc. to have messages go to a specific person. I talked to one of y'all on the phone and he was going to send me a sample script. Perhaps I missed it. Could you direct me to a sample? Thanks.
View of fieldnames!
Hi Is there an easy way to get a list og all fieldnames within a certain form? BR Skouboe
Password not working
I logged in to the Forums using my password (typing it afresh). So, clearly, I do KNOW my password. Then I tried to change my profile email, carefully confirming, etc. I got either 'passwords do not match' or 'the password you entered does not match the password in the database.' Well, I've tried around 20 times, and I can't get the system to accept the password. It simply won't. I applied for a new password, logged in with that, entered that in the 'change email' box , and it didn't work either.
Shared ZC application not viewable
Hi, A friend has shared ZC application with me (primary email id) but i see "no application has been shared" in the dashboard. When i acess the ZC link of my friend's application, i am able to see the list of forms and views -- on the left & .. the masg " You are not authorised to view" Go home Can you please help fix this . Thank you, Regards PS - tried sharing twice.. but with no luck
tell-a-friend
Hi! Is it possible to configure a tell-a-friend form by zoho? I need a form in which a person (Gigi) write its name, its mail, email of a friend. When he submits a message is sent to its friend (Hi, i'm Gigi. visit this site because it is very intresting!). How can i do? Tx! :D
Help Neede In Scripting
Hello i am using zoho creator quiet frequently and i like it a lot, i wanted to upgrade the known expense tracker http://creator.zoho.com/demo/latha/expense-tracker/zsdemo1/# i would want to have email updates as my budget reaches certain defined limits as i predefined for each different expense category i have looked at the help api and could not find any reference if it is possible to do the following : 1. receive scheduled email when a certain criteria has been passed 2. create sum fields that
Next Page