Integration of Zoho Apps on facebook
Hi All, I have a requirement for which i feel i can use Zoho creator as a database. Then my application will actually accessed from facebook. Do you have any integration facilites with facebook like some Facebook UI enables forms or at least simple communication with facebook. Thanks and Regards, Saurav
passing a single recordset to hmtl on form validation
on clicking the button of my form I would like to open a new window with the result of the same record in a Html ( just because I need to print with a specific Layout as a report ) How can I pass the last record parameters in my new html window ? What is the code ? thanks in advance
creator down ?
creator does not work ?
cannot login to zoho creator
Tried to log in as usual, and got the following message. Error 502 - Bad Request The server could not resolve your request for uri: http://creator.zoho.com/ Any suggestions?
Creator is down - can we get some information on what's going on?
Creator went down about 20 minutes ago. This is fundamental to my business now. It's the busy time of the day here in Australia, so any chance of getting some feedback on what's up & how long it's going to take to fix it? Thanks Anna.
Dynamic function reference
It would be nice to have the option to create a function reference on the fly. Now the reference is fixed: "application.namespace.function()". However it would be nice to be able to assign the application name <application>.namespace.function(). Example: Application SysAdm has a table with two fields: "Application" and "RecordCount". It retrieves the number of records of two other applications App1 and App2 stores them in the table. Both App1 and App2 have a function sendNoRecords(). If you want
I am not able to Drag and Drop
HI, I am a new user and when i am creating new form and trying to Drag and Drop , it says "Undifined" Mani
"Duplicate entry" validation response fails to identify field name
When the user enters a duplicate value into my "No duplicate entries" field Name, he gets Duplicate entry 'John Smith' for key 2 whereas I would like Duplicate entry 'John Smith' for Name Any solution? Thanks.
Fetching Record by passed ID
I have a special field on a form for html code that passed the record ID to a stateless form. The stateless form is receiving the ID (675380000000086075) But the fetch statement does not find the record. Here is the html code input.View_Details = "<a href='http://creator.zoho.com/dmpeltz/values-dev/#Page:View_Details_stateless?Passed_ID=" + input.ID + "&Called_From=" + Type + "'>View Details</a>"; Here is the fetch statement Patient_Rec = Patients [ID== input.Passed_ID]; Let me know if there is
Drop Down Questions
I want to create a form for registration for a website. The problem is I want the answer to question 3 to be a drop down selection of answers (not a problem) . However i then want question 4 to have a drop down selection of answers. (not a problem) the problem is i want there to be a different choice of answers to question 4 depending on the answer the user chose for question 3. PLEASE HELP
Can I create "Rolling Balances" in Zoho Creator
Hi, I am trying to develop an accounting application. I have a form for Transaction Entry, which works great except for my Rolling Balance field. I would like the Rolling Balance field to show the balance by account at each record. For example: Record 1: For Account 123, Transaction Amount equals $100; Rolling Balance equals $100. Record 2: For Account 123, Transaction Amount equals $100; Rolling Balance equals $200. Record 3: For Account 123, Transaction Amount equals $200: Rolling Balance equals
Registration limit problem
I'm trying to create a script where I can limit the number of registrants for each session (dropdown menu selection). I'm trying to copy and paste a script from another discussion (modified for my fields), but it's not working. Please help. The script error within add - validate is: Encountered "18" at line 1, column 41. Was expecting one of: "]" ... "*" ... cnt1 = count ( Meeting_Time [ October 18, 6-7 p.m. == input.October 18, 6-7 p.m. ] ); cnt2 = count ( Meeting_Time [ October 18, 7-8 p.m. ==
Quarterly or Monthly Script
is there a way to break down billings by quarterly in the script, i know i can do it in a view but i need it done in the script
Usage limits
you could increase our capacity because we have this message? Error details: Error occured while on Load script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. You can view your usage limits here.
My permalinks are not working !!!
Dear Sir, Permalink, which I posted on my website online Database Solution are not working. When we click on the links, the relevant page on zoho does not open. While the link get open when I logged in to zoho. Please help me on same. Waiting for your response. Abhinandan Sharma zoho2aps@gmail.com www.zoho2aps.wordpress.com
Would like empty fields to not display in Form View
Any way to make empty fields hidden in Form View? Thanks! Val
Hide empty fields during sendmail - or before?
I was curious if I can hide fields in any way that have a null value so that they are not sent via email. Here is an example: What it currently is: Location: New Mexico Product 1: 6000 Product 2: null Product 3: null Product 4: 1500 Product 5: null What I want it to look like: Location: New Mexico Product 1: 6000 Product 4: 1500 Any ideas?
Scripting :)
Okay... how would I limit a number of selections in a field? I got the limit of records in an application but having difficulty figuring out how to script a limit to a certain selection: If I am running a clinic and have multiple clinics to chose from in a drop-down menu, how do I limit the number of applicants to one of those choices in the drop down? Learning to script... slowly Thanks for any help
[t_483991000000106907] Exception occured while setting value in PreparedStatement for the Column
here we go again! WHY DOES THIS KEEP HAPPENING?!?!?!?! Application = Admin Form = Account [t_483991000000106907] Exception occured while setting value in PreparedStatement for the Column [Origin_483991000004844461] Check whether the datatype for this column is given as specified in the data-dictionary PLEASE FIX ASAP!!!!!! We need a way to refresh the form ourselves when this happens...
Change nextURL on an embedded HTML form?
Hi, I am trying to create an embeddable Zoho form that collects a user's data and creates a lead before serving them the file they request in the form. I've written a php script that serves the correct file based on a php variable at the end of either nextURL or openURL, but I can't figure out how to change the nextURL parameter with information from the form, and I haven't been able to get openURL to work at all. I would really appreciate your help getting this to work. Thanks!
Set Criteria based on the input of a form field
1. I have a form that I want to restrict the "Lookup" data to that the user is authorized to view. 2. I typically will "Set Criteria" as Distribution_Center == "GLRC". 3. I want to "Set Criteria" as Distribution_Center == input.Logged_in_User; 4. When I do this the Set Criteria deluge script states that "Variable 'this' is not declared. 5. I basically need to figure out how to declare a variable in the "Lookup" field. Any thougths?
Is it possible to add a link to a view in summary form?
Hi Everyone, I've created a view in summary form and I need to find a way to add a link to it. For example, my view is as follows: Candidate: Amy Renoulds Location: London Experience: 3-5 years What I then need is a link underneath: Candidate: Amy Renoulds Location: London Experience: 3-5 years Contact this candidate On selecting the link the client would be taken to our webpage contact form, so the same link would be suitable for all candidates. Thank you!
script not working for regular users
why are my scripts only working for admins and not regular users, i'm finding even the most rudimentary scripts failing with regular users but working fine for the admin?
Zoho Creator + IE8 = SNOOOOOOOOOZZZZZZZZEEEE
Hey everyone, Do you find IE8 runs real slow compared to Google Chrome? Any way to set IE8 to run faster? Thanks, Bartley
How do I aggregate line totals in one file and send that total to a summary field in another file?
Hi, I have two forms, Enter_Transaction & Add_Distributions. The ID field in the Enter_Transaction form corresponds to the Transaction_ID field in the Add_Distribution form. There is a one-to-many relationship between the data in Enter_Transaction and Add-Distribution. Enter_Transaction stores header information about financial transactions (e.g., a payment for 100 USD). Add_Distributions stores line detail of distributions (e.g., 80 USD goes to a rent account and 20 USD goes to a utilities account).
iframes work in Google Chrome but not Internet Explorer.
Hello All, I have embedded iframes in my website. The website opens well in both Google Chrome and Firefox but not Internet Explorer 7 or 8. Has anyone else had an issue of running iframes with Internet Explorer? Note: we did not have this issue until we tried using precreator. Any thoughts out there in the big world? Bartley
Adding form by mail no longer works on our service?
Hello, Adding form by mail no longer works on our service? Eric
How do i take a value from an ending value from a field and use it as a starting value the next time i open a record?
Yes, i want the ending volume of the previous record to be the beginning volume of the next record. i have also provided edit access. in our winery every action starts with a beginning volume (bvolume) and ends with an ending volume (evolume). by way of example: Chardonnay beginning volume = 1000 gallons chardonnay filtered Chardonnay ending volume = 980 gallons The next time i open this field, i would like the beginning volume to show the ending volume (980 gallons) from the last action. Can
URL field does not update on deluge script
Hi, I'm trying to use the URL field in a form (in order to access an uploaded file) as stated in the kbase, I'm trying to put On Add & On Edit: input.link = ("<a href = http://www.amazon.co.uk/exec/obidos/ASIN/44764967 target=_blank>Link to Amazon</a>"); But the field stays empty for the user. On updating or saving, the field is still empty (on view). Am I missing something or is it a problem in the system? Thank you, Tal
How to fix report shows different horizontal alignment for fields?
My report shows different horizontal alignment for different count values: Anyone know why, and how to fix? Thanks.
Can I expand/collapse a field in an HTML view?
It seems that javascript isn't permitted. With javascript, I could make an HTML View which allowed the user to hide or show a large field by clicking on a button. Is there another way to accomplish this?
html viewでのzoho logoの削除方法
zoho createrで伝票作成のために、html viewを使っています。 html viewの表示をそのままプリントして伝票として利用したいと考えているのですが、右上のpowered by zoho creater の表示が書類に載ってしまうのを消せないかと思っています。 このzohoのロゴを消す方法はないでしょうか？ あるいは、別の方法で、伝票等の作成をしたほうがよいでしょうか？
Have field populate data automatically from previous field data?
Hi, I am wondering if a field can populate data automatically based on what was entered in a previous field? We are looking at creating a Library Check-In/Out system at our school for the students that come in and out of the library. For example, we want to scan the student's ID card which their ID number would get put into the Student ID field and then I am wanting the Student's Name field to then automatically get populated with their name. So when I scan in their ID and jump to another field
Serious issue with Rich Text Fields on embedded views
ZC Team: I've found a serious problem related to the rich text fields, which may lead to data loss in some situations (actually, I've lost some data from a rich text field in a record from an application). Look at the view here (by the way... I saw that the permalink now contains a number instead of the Zoho username - was this an intended change?) It has an embedded (using div tag) form and an embedded view (whcih is a view related to the form above it). Try to edit a record in view. You'll see
URGENT- Creating multiple records unsolicited
We encounter a major problem on Zoho Creator. Whenever you add a record by mail,data registers 10 or 15 times in the database. That created duplicates and much more.Can you see where is the problem?
Creating a database contractors
My question is: I'm creating a database for contractors to advertise to there services on a website. The contractor input there information ( kind of like a small yellow pages) How do I make it so when a contractor enter our website, they click on tab, enter there info, and then it displayed on our website under a selected State or profession. ie. roofer in Florida, painter in Ohio
Parsing JSON export feed from application
Hello, I am trying to parse a JSON feed from my Creator application so that I can use the data to make a JavaScript/HTML widget. It would appear that HTTP GET requests to the feed url return a content type header as "Content-Type: text;charset=UTF-8" and not "Content-Type: application/json;charset=UTF-8", so I am not able to parse it correctly (e.g. my JSON object is null). The feed URL I get from going to the production side of the application, going to the form list view for the data I'd like,
Allow non-developer user to edit records
At the moment we are using the free account but plan to upgrade to a paid account. If the following is available in the paid account than this is irrelevant. Is it possible in Creator to give the user role rights to edit existing data? I have figured out that the developer role can edit existing data. I want to configure a role that can edit existing data from a view but cannot edit the application. Is this possible? If not, is this a feature that is being considered?
Fetch
How can i fetch records from other applications? And what other applications can i fetch from?
How do I link forms
I am creating an application and cannot figure out how to have it link my forms. I have a main form with 3 checkboxes. If one is chosen I need the form "Tables" to come up. If either of the other two questions are chosen I need the form "other" to come up. How can I do this?
Next Page