ZC automatically close my window!
Hi I have an application where I have the following script on input: if (input.QMCreate_Change_Notice_based_on_this_QCS == "Yes") { openUrl("http://www.creator.zoho.com/xxx", "popup window", "height=600,width=750"); } When I set "QMCreate_Change_Notice_based_on_this_QCS" to "Yes" it opens a new window correctly, but unfortunately it also close my already open window which is in edit mode, and close it without updating. Why does it close the existing? this does not make any sense! Br Skouboe
Public permalinks are now asking users to login at zoho
Hi Team, For over an year, we have been using the "permalink without login" link to ... link to our forms at ZC But, one fine morning, the same link is displaying the zoho signin box. ( after signing in, the expected form is shown) When I login to the application & view the form permalink ( permalink wihtout login) I find that the link-string has changed... Is it just with me, or others facing the same situation as well? Regards -Deepa Govind
OpenURL and targeting frames question.
I have been unable to set the target attribute to the name of a frame in the OpenURL() statement and have it successfully load my frames. Are the only two options 'current window' and 'new window'? I hope not. openUrl("http://creator.zoho.com/ensobase/home/form-embed/Task_Manager/DealPreLoadHidden=" + input.Deal, ("dealInfoTarget")); tt
Record ID Field Out of Order
I am having a recurring problem where new records get created with and ID field value that is lower than older records. I thought ID was always supposed to go upward. This has created a big headache for for numerous scripts and formulas that retrieve data from the previous record. Is this a known bug, or have I misunderstood the ID field?
Can't delete formula but can't find reference in code
I have a formula that I want to get rid of, but when I try to delete it, I get the following message: "Function can not be deleted This function is reffered [sic] in the following places Please remove the reference,then try deleting the function In action script-->" I have searched the full scripts with actions for all my forms, and can't find any reference to this function. Might it be hiding somewhere else? If this message is in error, is there a way to force deleting the function?
Home page for Creator & Reports
Can I have 1 page that displays links to applications in Creator and Reports?
Button: Link to external Page
Hello, is it somehow possible to place a BUTTON to an external page in an app? Use Case: I make an html view for printing stuff but have to much "overhead" i.e. header and stuff so i decide to embed the view in an html page and so want people have this html page in their app for quick acces! thx
Custom Action Function with ID from the "looked up" form
Suppose I have employees and departments. My departments form has a lookup field that points to a unique field in the employee form (such as email address) to define the department head. So, the department view will show me all department data, and also the employee data for the department head. I want to define a "Custom Action" on the department view that will take me to the Employee form, and show me the data for the employee (department head). So, the custom action button appears on each row
Creating Country Name Field in Zoho Creator
Is there a way to create a Field for Country Name and have it populated (via a list or drop down) with the names of all countries? I'm hoping to avoid manually typing in the names of all counties to create this drop down field.
How do I create a limited overview and a more detailed entry when they click view?
So I am working on http://proaccessconsultants.com/new/ and I have about 20 different columns for each entry. I only want to show the ones currently up, but when they hit view I want them to be able to see the other categories. Is there a simple way to go about doing that?
Subheading
How do I create subheadings in online forms. This way I could make my form a bit more userfriendly. Cheers, Daniel
My forms don't work in Safari or IE 7
http://creator.zoho.com/kevin.audleman/naam#Form:Contact_Edit This form works just fine in Firefox. In Safari it loads, but clicking Submit does nothing. In IE7 the form doesn't even load. Help! Kevin
so confused
i don't understand "accounts" and "contacts". Where are "Clients"? We have a lead, our sales team follows up on the lead, then we close the deal. They are now our Client. But I can't sort out how one would enter Clients.
Trying to create a somewhat complex summary view from multiple views...
Hi all, I was hoping i could get advice from the forum concerning a View i'm trying to create. I understand conceptually what i need to do, but am running into a wall when it comes to the details. Currently, i have a template form that asks for the following: Current Date: [response is date] Member1: [response is a, b, or c] Member2: [response is a, b, or c] That form is duplicated several different times. It's split into multiple forms because the form is input by different "leaders" for the
calendar view, change record identifier displayed in calendar
I have a calender view. It currently shows the surname of a customer that we have made an appointment with. We would like to change the calendar view to show two fields for the event (in this case surname and suburb). How do I do this? Thanks Paul James
Cross frame domain targeting.
Hi Gang, as you probably know a Frame cannot be targeted from the zoho.com domain unless the first frame referenced in the Frame was from the same domain, i.e. zoho.com So the easy solution is to include a Creator view in the original src of the Frame so that all subsequent loads will work. My question is: What is the smallest, fastest, Creator resource that can be used in this original Frame src? I'm using a empty view but it is not fast enough and a work around. We need a blank.htm or something
Select Dropdown form ?
Hi all, I need to create a form like that: 5 dropdowns with 5 items for each one. for example: dropdown 1: 1, 2, 3, 4 and 5 (if i select the item number 2 this item should not appear in the next dropdowns...) dropdown 2: 1, 3, 4 and 5 (if i select item number 3 this item shoud not appear in the next dropdowns... ) dropdown 3: ...remains the same Can anyone help me with a clear example?? Thanks! ...
We are unable to fetch this data, sorry! Please note that your data is SAFE.
Hi I can to that dynamic view using search Form a couple of days ago,but today can't to that and got the "We are unable to fetch this data, sorry! Please note that your data is SAFE." (((("/" + zoho.adminuser) + "/") + zoho.appname) + "/html/view2/rw_rwzxr=") + input.cx_name ,"same window");I don't know what's happen,coul you please tell me how to solve this problem . Thanks Stanley Guo
Function code not loading in Edit mode
Dear Zoho team When I click on the tab 'Script' (https://creator.zoho.com/<username>/<bmpm>/edit/function), Firefox gives me a blank (grey) tab. In IE the "loading..." never stops. I have deleted cookies and cache in both browsers. Thanks for your help Filip
Defining a formula field that updates daily
Can anyone tell me under what circumstances the value in a formula field is updated? I would like to setup a formula field to calculate a value which is dependent on the current date. This in itself is easily achievable but what I need to happen is for the value in the formula field to be automatically updated each day. Is this possible?
Is it possible to concatenate fields when displaying information in views?
When I look at a view definition, I see a listing of fields from the form in the following format: field1name field2name as "[custom title for this column]" Is it possible to setup the view so that the content of field1 and field2 get concatenated into 1 field for display through the view? Thanks
Column Widths
When I change a column width of my Creator list, I click "Done' and expect that to save the new setting. It does not save. Any ideas why this is not working for me? Barneypo
Sendmail command not servicing BCC Recipient ...
ZOHO Creator Support team: I have my sendmail command scripted like this ... sendmail ( To : input.Client_Email_Address From : zoho.adminuserid BCC : zoho.adminuserid Subject : ("blah blah blah") Message : emailMessage ) ... ZOHO Creator only sends the email to input.Client_Email_Address. Please explain why this is happening. Gaev
Passing criteria to a View (Embedded)
I just cant seem to make my view display records where a field has a specified value - should be sooo simple! For example; <div elName='zc-component' viewLinkName='Garage_Details' params='Ref=1'>Loading View...</div> Where Ref is my field and 1 is its value what am i doing wrong :-( ? (have tried ref=<%=1%>) & many many other syntax Help!
how to export data from created db app
Hi all So I created a database app that I am hosting on my server... When I use it straight through zoho.com it allows me to export data to various mediums including excel...(which is where I need it to go...) However, when I embed it in my website, the view page does not have an option for export or anything... Am I doing something wrong or is there a button I may not have checked... Any help would be greatly appreciated Thanks Ed
About search fonction on mobile
Hello, i start to use this beautiful app. When i am on my mobile, i can't search on colum it's work on PC. Thank you
How many users can I add to my database
Hi, I am setting up an online database where users would be able to upload their contact details. I am aiming at more than 20,000 users to register. I also want another type of users to consult the database to book these first users. Is this possible with Creator? Regards, T
Subform issue
There is a subform issue now... To put it simply, using the meeting - meeting attendees application example: when adding Attendees, the Meeting ID does not populate automatically.. Please contact me for clarification if needed As the screenshot shows, the "add attendee" link on the popup form is not there. It used to be there. I want to look at the list of attendees, and if it's not there, I will add it -- that's what I want.....
Lookup of Employee within the Employee form
I am building a form for entering employee data. One of the data elements on this form is for each employee, select an employee that is their Supervisor. The trouble I am finding is that it doesn't allow a lookup of Employee data within the Employee form. My only thought is to on input of an Employee's name have that data copied to another view (table) -- let's call it Shadow_Employee -- in Creator and then do a lookup of the entities in Shadow_Employee. Does that work? If so, can you provide
Creating Relationships
I am entering individuals into Creator and want to be able to link folks that are married. My hope is to be able to place the data into Reports and analyze both as individuals and as a household/couple if needed. How is this best accomplished? Do you have any sample applications I can reverse engineer?
Form not functioning on iPhone Safari - requiring cookies
we have a form that we've embedded on a web page. we had been accessing the form successfully for some time using Safari on iPhones. Now, suddenly, when we go to the page on the iPhone, the page renders, but the form does not. The message in its place is: "Note: Cookie is disabled in your browser. Please enable the cookie to continue." 1. cookies are enabled. 2. nothing has change in the application/form. we haven't touched it. 3. we get the same result from multiple phones. any idea what could
Cannot open the attached document
Hi Suddenly I cannot open the attached document in my application " AFB System 2.0". A new windows apear but it is empty. Please see attached. Br Skouboe
Record locking
I developed a team collaboration application. In the application each task is a record and can be routed amongst different people. The problem is, if both people have access to the same record, they can both edit it at the same time. One solution is to assign different record sets to different people; but a better one is record locking, which means, if a record is being edited it is locked and displays a status message "being edited" , so other people can't edit the same record. When will
Very Untechnical User need to do a couple of Very Simple Things
I found Zoho through Google and am a complete front-end user. No knowledge of code etc at all. Have tried to stumble through various help, tutorials, forums and blogs but am clearly out of my leauge. I am secretary for a sporting club and have put our membership database on Zoho Creator - mostly fantastic. The main thing I need to do but cant figure out is to send bulk emails to selections of the dataase (ie filter on the basis of Membership Category then bulk email). Tried to set up a function
generate PDFs
Hi, Is it possible to generate PDFs from Table Data through Custom Actions? thx
form letters
Hello, I am new here and i searched quite a while but didnt find: Ist there a form letter function in Zoho Creator?
Re How get records number
Hi Could you please teach me that how get interact times(numbers) from this code like this m = 0 fetch each r in form[fieldA == fieldB]; m = m+1 (don't work) .... --------------------------------------------- fetch each r in form[fieldA == fieldB]; fieldC = fielC + 1 (still don't work) but I try many times is failure,so hope get help from you and thanks Stanleu Guo
Accessing state of multi-select picklist
I have a form to record orders taken in which a sales type has to be selected (Retail, Trade, etc). I wish to summarise this information in a scripted form, whose only purpose will be the presentation of summary information from other forms - i.e. not a data-input form. I have added a lookup multi-select checkbox that looks like this: [ ] Retail [ ] Trade [ ] etc I have added an unbound numeric field for populating with the number of matching orders taken. I have created a script which correctly
cancelling on load actions
I have written a short 'on load' action which alters the value of a field in another form. If I 'cancel' the action the altered value in the other form remains altered. Is there a script that can run 'on cancel' to put things back to where they were?
Zoho Creator security roles assignment/copying a user
I have a user whom I assigned access to some forms and views. I am adding another user who is going to have exactly the same roles and views as the first user. I want a "copy" function to realize this menial process.... can this be achieved?
Next Page