� Character in email import
When I am populating a form via email, Zoho is translating a space to �. Is there any way to remove this using a string function via a deluge script?
I am unable to edit an applicaiton installed from Zoho Marketplace.
Help me! I installed a few apps and I can't edit any of them, I haven't gone over my limit or anything, I just have no idea whats going on! Help! The Application is Timesheet-Management (English) and it has edit access to support.
Help Documents Are No Longer Working!
You get this every time I attempt to go to the help documents: Whats going on??
How to restrict the date from being overridden?
Okay, so if I use zoho.currentdate, how do I restrict that so once entered it cannot be changed? Any help would be amazing. Thanks, Michael McNeill
How to combine these two fetch requests?
fetch = Add_Group [Name == input.Group]; input.Group_Manager = fetch.Group_Manager; fetch = add_contact [Name == input.Name1]; input.username = fetch.username; I need to combine those to so that I can acutally script them as I can only define one "fetch" task. Thanks, Michael McNeill
How to restrict duplicates in a Field?
How can you restrict duplicates in a lookup field? I need this to be restricted! Thanks, Michael McNeill
Calendar View
I wanted to create a simple reservation database using the Calendar view. Trouble is that the calendar view can only be based on one date. It does not support a 'date range'. Hopefully this feature could be added to make this calendar view just a little more useful. Thanks, Shane shanepresley
Significant Excel Importation Problem
A client for whom I'm using the paid version of Creator is frustrated to the point he wants me move to DabbleDB– a move I'm reluctant to make because I think Creator is a better long-term solution to his needs. Our problem is a two-day old inability – even with Zoho’s very courteous support – to import into an existing application a two-thousand row Excel file. I've tried both the file import and cut and paste options of the web interface, as well as the migration tool. The excel file is good, because
UK Postcode Field
Hi Zoho forum gurus, I am very new to Zoho (signed up today!) and have been learning how to use the creator. I am currently developing a test form that has supplier information fields. I would like to include a UK postcode field which only accepts uk postcode entries. Is there an if/else statement or snippet of code that is already used to solve this problem, ie an error message comes up if there is an invalid entry?? Thank you, V
Looping on Fetch existing data on add
If a key field value already exists in the database I want to populate my form with the existing data. The form is populated correctly but apparently the system goes into a loop. The rotating arrow next to the key field never disappears. When I type a new value in one of the fields it is immediately reset to the value from the existing record. I am using the following code on user input for the key field. if (count(temple_main_input_form[Policy_Claim_Number == input.Policy_Claim_Number]) >
How do you dynamically change the subject of a send mail task?
Okay so I have a form where on success it executes a send mail task. But with that I would like to change the subject with the different type selected. Is it possible to make it dynamic or does it have to be one set thing? Thanks, Michael McNeill
Problems with restore
I have two restores proces in progress till 2009-09-08 04:15:46.0 !!!!! I need to stop these restore process and know why every time I try to restore it didn't work. In the other hand, I cannot backup my apps. When I try to backup one of my applications the process finished with failed status. Please I need to make these backups and stop these restore process. Thanks. Sergio Galiano
Missing 10th of the month in Scheduler interface
ZC Team: I suppose that the image below is enough to see the problem. I'm using FF 3.6 . Regards, George
How to display related records in an HTML view
My view currently displays one record from one table. x = Purchase_Order [ID == input.PurchaseOrderId.toLong()]; where Vendor_Account is a field in Purchase_Order I want to include other records from tables that are related via look-up fields on the original form but the only fields that appear in the script builder window as a collection variable is the name of the lookup field, not the id of the corresponding record. ex. y = Vendor_Account [ID == x.Vendor_Account]; but of course
Problem saving a view after hiding a column
Greetings, I want simply to hide a column and then save this change. But there is no way to do it. I always get the message: "FAILURE:Error occured while saving the view" And it say me to refresh the page, but it neither works on this way.... I've tried saving with and without the option "Saving as a new view".... Any idea about it? Some permissions problem, maybe? Thanks!!
Possible Bug when using openURL ...
Hi: I encountered what might possibly be a bug. If I place a cancel submit command in the Validate section of a Form, it works just fine. However, if I place an openURL command (to display a web page in the same window) immediately before the cancel submit, the contents of the Form are added to the Table ... i.e. the cancel request is not honored. Gaev
Problem with Saving View Changes
I am having a problem changing and saving views in Zoho Creator. In my Startup Company Input Form Pipes View, I am selecting the More Actions / Show/Hide Columns option. I then am Showing the column 'Display Logo.' The column then appears in my view. However, after I select 'Save Changes' the column disappears again! It does this over and over. Any ideas about how to fix this? Here is the link to my view: http://creator.zoho.com/startuphouston/houston-startups-database/#View:Startup_Company_Input_Form_Pipes_View
On user Input - show alert
Hi, I cannot save this script on On User Input of a field: if (count(Matr_cula_Consular[C_digo_Fisca_CPF == input.C_digo_Fisca_CPF]) > 0) { input.C_digo_Fisca_CPFerror = “Warning...”; show C_digo_Fisca_CPFerror; } I write something wrong? Mic
Reporting in ZohoCreator - Preview
Dear Users, Continuing with our efforts to integrate the powerful reporting & analytics functionality of Zoho Reports into Zoho Creator, we are providing the ability to create reports within ZohoCreator. We're opening this up as a limited preview so we can get early feedback and constructive critisism from our eager developer community. Pretty soon it will be open to all Zoho Creator users. We are working on a full blown support document. Meanwhile, you can find your way around the reporting feature
How to make batch notifications?
Okay, so is there anyway to create batch notifications to an RSS feed or an email. So that basically all changes to the application are either sent to that RSS feed or an email is sent, every week at a certain date or time. I have the scheduler preview enabled on my account, so please help! Thanks, Michael McNeill
Due to security reason - i now cannot get my form to go public - what is up with THAT???
All of a sudden - my form asks for a login - and I want it to be public - however I try - I get an error telling me that I cannot go public This must be new???? How to resolve ???? thanks karla info@darocas.com
Stateless Form Email
Is it possible to generate an email notification upon submit of a stateless form? Can I include the data from the stateless form. I am just trying to use a stateless form embedded on a web page to update a contact information (contacts) table that has more fields. I get the data into the contact form from the stateless form using the "insert into", but want to send a confirmation email to the user. I tried to do this from the contact form (based upon the Public added user field) but it does not
Add new view columns, lose previous view columns in display.
I added 3 new columns to one of my forms. I then went to an existing view to add those new columns to the view. Now when displaying that view, only the 3 new columns appear in the view. All the original columns no longer appear. If I go in to the show/hide columns feature while the view is displayed, all of the original columns are listed but only the 3 new columns have their boxes checked. If I select all of the original columns to show them, they all appear in the view. If I edit the view
Remove Line Feed from String Entry
I need to write on Add Success function to remove some text and line feeds from an input field. For example Line 1 other text Line 2 I would like to convert this to Line 1 Line 2
Import function doesn't work
I can't make the import data function work at all. It is just loading empty records, or nothing at all. Completely frustrating. Help please!
Next url to show View with filter
Hi all, I have a script, containing a : input.SelectItem = (((("<span style='font-size: small;'><a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=#Form:Reserveringsitem?ResID=") + otmpRes.ID) + "&zc_LoadIn=dialog&zc_NextUrl=#View:Reserveren?ResID=") + otmpRes.ID) + ">Reserveringsobject</a>"; which creates a href, working great. Also, the nexturl works, but is doesn't the ResID. In the browser, it shows : http://creator.zoho.com/dnjs/hotel/#Form:Reserveringsitem?ResID=38685000001024261&zc_LoadIn=dialog&zc_NextUrl=#View:Reserveren?ResID=38685000001024261,
Is it possible to detect a user's screen resolution and use that in the script?
Hello, Does anyone know if I can detect the screen resolution and then use that information in my script? Rob
Is it possible to rename my account
Hello, I have a Creator account. Everything works perfect. Thanks for this great app! The only thing is that when I have registered i used my own name and now all my apps use a URL that contains my name. That doesn't look good and is confusing. So in stead of url's such as creator.zoho.com/myname/appname I would like it to use something else. Is this possible? And / or can I have the name of my account changed? It would seem that it has impact on everything I have built so far? Greetings, Rob Bastiaansen
"Loading..." Message
I am using the following command at the end of a script in a stateless form to call a view conditionally (On Click action for a button): openUrl("#View:Register_View?Report_Date=" + input.Date_field, "same window"); The view opens correctly, but a box displaying "Loading..." appears in the middle of the screen and does not disappear even if I go to other menu selections in my application. This also occurs if I take out the reference to Report_Date, as follows: openUrl("#View:Register_View", "same
Only can access 4 of 314 records. Please help!
This is an urgent problem: I'm unable to access all the records in my database. When I open the database, I only see 4 records. These are records that I previously queried using the word, "etiquette" in the search field. Now I can only see these records. I checked my account settings and there are 314 records in my database, so I don't think they were erased. Please help! I'm very disturbed that I cannot access my entire database. Thank you in advance for your prompt attention.
Error in Creating Custom Filter
One problem and one question, if I may. Problem: when I create and save a custom filter, and then press the Done button, I frequently get an error message saying 'Setting Filters Failed'. Why is this happening? Question: how can I set a filter to show records where a checkbox field is blank? Thanks
Export as XLS is not working correctly - dates change half way thru the file
Dear Sirs, From today when I export as XLS in Creator the format of the file changes half way. The date values come as numbers and this issue is giving me problems while updating my files on zoho reports and also when I download the file to keep my local database up to date. I am attatching a sample file that I've just exported and you can see that it suddenly changes all dates to numbers. This is probably due to a current update you have made to your system. Please let me know if this has a solution.
Edit this field box disappears when clicking the criteria-box
Dear Zoho-team, When I wish to change the settings of a field and add criteria to it, the box simple disappears when I click the field to start writing in it. This means that I cannot at the moment add any criteria to any fields in my form. It specifically concerns the fields organisation_skole and organisation_ikkeskole in the form "kontaktrapport". Here I only wish to show the items where "organisationstype" == "skole" and "ikke-skole" respectively. Could you please fix this for me? That would
HELP !!!! How Do I Resize An Image In Deluge Script?
Hi, I am trying to write in deluge a defualt size for automaticly having an image when submitted be a certain width and height. Is this possible?
Reporting of Shared Components is erroneous ...
@ZOHO Creator Team: In one of my Applications that I am developing for a Client, I have given the Client's (2) ZOHO User IDs access to all my Forms and Views ... but it keeps showing 11 Forms and 18 Views for both Users. There are more than 11 Forms and 18 Views in the Application ... and as far as I know, they can access them all. In other Applications, it usually says All Forms and Views Gaev
old.
I saw this old.FormFieldName can we use this reliably to get to a forms saved values? I ask because it does not seem to be documented. tt
Issues hiding colums in view
I created a new view for our form in order to better serve our reporting needs. Although I've been able to show and hide columns in the other view we have set up, this one, no matter how often I go into "Column Properties" to take out columns and deselect certain columns, it never is affected in the view. Is there any suggestions on how to be able to hide columns successfully?
It is not possible to add a lookup field criteria
ZC team, If you are using the drag and drop interface and you need to add a criteria to a lookup field, it's not possible, because the text box for criteria suddenly disappears if you try to put the mouse cursor into it. So, an existing basic functionality is broken. I hope that you'll fix it soon. This happens both in FF 3.6 and IE 8. Regards, George
Unable to access functions
Hi, I am currently unable to access the functions tab on the Script tab in my application NVSF. In Chrome, only the name of the first namespace appears. When I go to create a new function, I get a message that a required resource is missing. In Firefox, the names of all of the functions appear, but the page never finishes loading. I've shared this application with support. Any thoughts about what is the problem? Thanks.
Adding and subtracting fields in a FORM
Question, I need to add all the following and display, total hours for the days of week that are updated with the total value to be polulate in a emtpy field some thing like = Total_Hours, what is the best way i should do this? Here is What I have for days of the week, i want to total up the days by hours then if the total equals 4hr i will send a out put of free text: Sunday_Hours ( displayname = "Sunday Hours" type = number width =
Next Page