How to open /import data from an .mht file
One of my respondents has, rather than submittig the form, attached it as an mht form and sent it to me. Do you know how i can open it to access the data? Thanks
Populating a form input box
How do you populate the input box of a form with the text that is already in an existing record and field?
Override View Criteria
I have a view sorted by a date field. Normally I want to show records from the last week and all records in the future. The criteria is Input_Date > (zoho.currentdate - '1W:1D:0H:0M:0S') Once is a while a user needs to see records that are older than one week. Is there a way to start the view at a specific date but allow teh user to reset the date? Herb Wexler
Field references: Named and Ordinal/Index
Is it possible to refer to a field via it's ordinal number or index? Common use of field reference is by field name. I have the need to access records filtered by a field unknown until runtime. I plan on passing in the field for which I need to filter/fetch records. Put another way: Is it possible to pass in a field identifier at runtime and then use that identifier to fetch records? example (field name): void example(string FieldName, string FieldCriteria) { var = fromname[FieldName == FieldCriteria];
One form - Many permissions
I have a database and many many users. I need to give each person or at least each group of people access to edit certain fields of the form. Right now, when a user clicks on a record in a certain view, they are allowed to see the entire form and edit whatever they want. I know I can use stateless forms to feed into the main app and give each user access to certain stateless forms, but how would I make this particular differnt form come up when they hit edit, rather than the main form?
Grouping does not work in Calendar view
Hi: I have setup grouping in calendar view, but even if the value I ask to group by is identical in all the rows, it still shows me several rows with the same value (the column I group by is the first column as well). Is this a known bug? How can I fix it?
Auto generating reference numbers on form
I created a form and the first field on the form when form is opened I would like the field to auto generate a number 'Case1234' Each time I would like a new number to generate. how can this be done? See screen shot.
iCal feed - filtering
I have a view which I am pulling into iCal - which works beautiffuly. I am wondering if there is anyway to filter the data by the URL. I have a bunch of staff, and I would like to have the iCal feed on their iphones show up with only things involving them, rather than the entire schedule. So each person would have a different URL in their iCal with something like http://....user/app/ical/view?Staff=jsmith
Can we get rid of the new Terms of Service after viewed once??
I keep getting this thing every time I log in: Zoho Announcement Terms of Service and Privacy Policy update ... Isn't once enough? -k
Decimal places in Decimal Field
Hi All - I am trying to use the Decimal Field in a form and have set the number of places to two but I have noticed that on entering data into this field, it accepts numbers with a greater number of places. (Eg, I can still enter a number like 5.35676). Can't find any similar issues in the forum so I think I'm misunderstanding something on this. Is there some way in the script for on input of this field that I can limit the number of places perhaps? If so, can someone provide a copy of the code.
please help!
Actually I was looking for something like this. Choose an option from a dropdown list and then auto populate fields with names in a table format. Each row will update a separate entry in the view. see below Dropdown field - choose your option and then fill the rest of the fields below. Thanks, depalca
I Get an Error Every Time I Try to Use .getMonth()
Why do I get this error: Either the left side or the right side of a bolean expression must refer to a form/view field When I try to use the following code in a "For each record" script: HarvestDate.getMonth() == zoho.currentdate.getMonth() The left side of this expression (HarvestDate) is clearly from my form. I get the same error if I try to use .getYear() Please enlighten me.
I'm Locked out of my Form Script
I'm not able to edit my form script as it freezes on loading. The form is called "WardKeyIndicators" and is in the application "WML Tracker". I have given you full access to the application. Thanks.
Accessing view from public website on the free plan
Hi I have used the Zoho free evaluation plan to create a simple view. I want to embed this view in my website page to allow users to search my database. When I tried using the share option, I got the message below: "Due to security reasons, enabling public access is disabled temporarily for the trial and Free Edition users. If you need this feature, contact support@zohocreator.com." Could you help me with this? Thanks.
Report Formula
I want to calculate projected revenue by using "opportunity" data, stored on one form, and "pricing" data, stored on another. Is this possible?
No access
We are no longer able to connect us to our application. The login page is blank!
Cannot import anything!! AT ALL!!!
I am trying to import some data into creator. It is created in Excel. Not too much data, only about 20 lines into 10 fields. But this is something that I need to do daily, so I need the import function to work. I have tried this in Safari, Firefox, IE, on Mac and Windows. I have tried to import using the Excel file, and pasting data in XLS, CSV, TSV format. I hit submit, get the Importing data message, the view reloads, but nothing has been added. I tried importing using the migration tool
Adding/Editing fields in the database after uploading
Hi, Is there any way to add/edit fields of a database once i had uploaded the database while creating the application? Thanks
Display thumbnail of file upload filed?
Is it possible to display thumbnails of a file upload field if it's an image?
Proper() string function
I would really like to see the "Proper()" function implemented in Deluge Scripting. This function would force the first letter of a proper name to be uppercase and the rest lowercase. Also, this type of formatting could be implemented at the field level; perhaps with a generic input mask string.
Pulling data from other forms into current form
Hi all, great program! I am new at Zoho and scripting (i do understand the process, but limited knowledge of script language) i would like to pull data from another form in to a current form. i am making a job list data base. i have form called "add company" that collects customer company names and i assign a "company code" to them. i want to build a form for adding jobs that automatically adds the "company code" after the "company name" is selected in the form. The process as follows i would like
How to link to a form to change an uploaded file
Hello, I have created a form where a user can upload a file. What I now would like to do is list those files in an HTML view and provide a link to go to that file's form to change the file. It's simple to show a list of all the files from the form, but I don't see how to create a hyperlink to that form for a specific file. I have tried with using the filename as a parameter but that didn't work. Hope someone has a suggestion Rob
Help using > operator
Can I add to an operator. Meaning, I want to have a script that says: if zoho.currentdate > input.Added_Time +10 So that would mean... March 26, 2010 is greater than input.Added_Time plus 10 days. How would I set up an operator like that?
Get field names through a function
Is there a way to get the field names through a function? For instance you can use getFieldNames(); to determine the names of the fields in the current form, but what if I want to get the field names if I'm not in a form? So can I use something like the following: frmEvent.getFieldNames() I appreciate the help. Leo
enlarge field
Hello, Is there a way to enlarge the fields of the form ? I have embedded zoho creator in my website, but I find the fields too small. If I adjust the embedded code, there is no difference in width of the fields. So I guess there must be a setting in creator to have larger fields (ex. multiline) Thanks, icetea
Mass update table by import
Can I mass update a table by an import file? I tried but instead of updating the records, the import created new records, ignoring the "ID" column. thanks guys.
Link to Website
I am trying to create something so when my users get stuck they can "click here for FAQ's"...linking them to a website... I tried doing it as a note, but it keeps opening in the same window. Is there a way I can force it to open in a new window?
Actions on User Update
Hi there, I am trying to see if I can get a better explanation of this feature. I am completing something for my school.. If a student checks the box next to "9" on grade.. that being my if field, I want another question to appear saying, please select homeroom teacher.. then list my 7 9th grade homeroom teachers. and so on for grades 10, 11 and 12. Am I using the right feature and can some body please provide some guidance. Thanks
Calculate number of business days ( weekdays)
Hello, I am trying to calculate the number of business days between the current time (date) and the Submit Date I have on a form. Is there any built-in weekday options for this? Thanks!
Lower case doesn't work when trying to retrieve records
I use a secondary form where people write their e-mail and my application then searches on my primary table for a match. If a match is found, then all other fields in my secondary form are automatically populated using data from the primary one. The only problem is that when I do the comparison between the sumbitted e-mail and the ones that I already have, there is a distinction between lower case and upper case e-mails. So myemail@gmail.com is actually different from MYEMAIL@gmail.com. I thought
How to use for each element deluge?
Okay so I need a code to where it fetches all records: fetch = Add_Subcription[Employee1 == input.Name1]; { fetch.Date_Cancelled = zoho.currentdate; fetch.Staus = "Cancelled"; } like this and updates the fields, as in the code above, but I need to do it for ALL records and I don't know how to write the for each element in deluge or the script writer. Can somebody write one for me? Thanks, Michael McNeill
parsing text from email message
I would like to parse a text inserted to a form by email. The text may have several lines and I would like to insert each line separately to another form. Is there any method of tokenizing text by lines. I tried getPrefix with \n but didn't get anything.
How to create relation subforum?
Hello, im new to Zoho and wanted to ask how can I create this type of form: I have a main form with users. I need to add the family members of each user, father, mother, and so on. I tried to create this using the so called "subform workaround" so I have created something similar to the Meeting Tracker Application but in the "Add Meeting Attendance" part, you see all the Attendees in the "Pick Attendees" List, for all Meetings. In my case where "attendees" are "family members", I'm seeing a huge
display image in email attachment
i have created a form (form 'A') with an on success script that sends an email to the recipient with a link to form 'B'. some parameters from form 'A' are currently passed via the email to populate form 'B'. if i have previously uploaded an image to form 'A', is it possible for that image to automatically display in the email body when the recipient opens the email? (preferred) Or, as an option, could the image be displayed in form 'B' when the recipient clicks on the link? thanks, mike
HTML & Internet Explorer
Hi, I've a script that allow print an HTML view on success. With Firefox browser it print very well. But when I access at the form with Internet Explorer print result cutted on the right for 20% of the page. Anyone have experieced the same issue? Any suggestion? Thanks Mig
Clear an integer field from a stateless form
Dumb Question... How do I clear a value from a BIGINT on a stateless form? I've tried setting the field to: "" and null but I get the following error messages: Error in statement at line number 30 The template variable intEventID is of type BIGINT. But you are trying to update it with an expression of type STRING Error in statement at line number 30 The template variable intEventID is of type BIGINT. But you are trying to update it with an expression of type NULLTYPEand clear and reload don't
Trying to eliminate spaghetti code
Hi, I have been using the following code to generate an autonumber field for various forms, just changing the values as required depending on what I have named them in the forms (e.g. intClientID, intContactID, intVenueID, etc.) varMaxValue = frmMaxValue [ID != 0]; input.intClientID = (varMaxValue.intClientVal + 1); varMaxValue.intClientVal = (varMaxValue.intClientVal + 1);I would like to get rid of the spaghetti code, and simply call a function, but am having issues. The form where I store
Work-around for lack of ability to add a new item to a picklist field while in the form
I've read a many threads and sent a help request to zoho support about the ability to add a new entry within a Creator form for a picklist field. The only response I've got or seen is that it is not an available feature. It seems that there could be a way to at least add a field under the picklist that allows the user to enter an "other" or "new" entry. If upon update, that field could write the new data to both the picklist look-up table (so it would be available next time) and the data field it
Grouping of fields
I find myself needing to hide/show multiple fields of a form quite frequently throughout the user experience in a form. Instead of this: hide Field1; hide Field2; hide Field3; Can I do this: hide Field1, Field2, Field3; Or, better yet, perhaps something like this: Group1 = group("Field1", "Field2", "Field3"); hide Group1; show Group1; Thanks! Stefan
Zoho creator+google maps
Using Zoho Creator ,Yahoo Pipes,and Google maps to Build cool mashups. Note:I will upddate links and Images for your Reference shortly please check for my blog mesporatitech.blogspot.com/2007/11/using-zoho-creator-yahoo-pipesand.html Intro: Integrating Data (overlaying in developer terms) onto maps (Google, yahoo) has become a fad these days, the applications range from trivial to Interesting. By opening up their Mapping platforms Google and Yahoo, have given Interesting framework on which developers
Next Page