How do i add my php form values to my zoho creator form database.?
Hi I need help for adding records to my database. I have a form in zoho creator , need to add records using php script.My script is below : <form method="POST" action="http://creator.zoho.com/api/xml/write/apikey=***&ticket= *** "> <!--<input type="hidden" name ="authtoken" value="f56cbf6659ad8573e42ff5db6a8f76be"> <input type="hidden" name ="scope" id="scope" value="d2989b6ecd1f76eba063fc1c063bb497">--> <input type="hidden" name="XMLString" value="<ZohoCreator> <applicationlist>
How do i add my php form values to my zoho creator form database.?
Hi I need help for adding records to my database. I have a form in zoho creator , need to add records using php script.My script is below : <form method="POST" action="http://creator.zoho.com/api/xml/write/apikey=***&ticket= *** "> <!--<input type="hidden" name ="authtoken" value="f56cbf6659ad8573e42ff5db6a8f76be"> <input type="hidden" name ="scope" id="scope" value="d2989b6ecd1f76eba063fc1c063bb497">--> <input type="hidden" name="XMLString" value="<ZohoCreator> <applicationlist>
USER Access -
Currently all Users have access to everything. How can I limit which Views and Reports each User has access to?
Round of numbers displayed on graphs
How do I round off numbers on the pivot graph generated on zoho reports? See attachment. Thanks! Vishal
How to create token in creator?
Hi How to create a api key and token for my zoho account .? Please help me
Is something changed for new Zoho Accounts?
Dear zCreator Team, For new Zoho accounts, even the basic features does not seem to be available. Anything changed? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/ http://www.linkedin.com/in/deepakvasudevan
Multi Views & criteria
Hi Guys, I have created a status drop-down, and I want to be able to create views based on status. I have managed to do it for one status but not another! So fo open leads I Have.. ((Lead_Status is null) || Lead_Status != "Converted") For converted leads I have... ((Lead_Status == "Converted")) What do I need to do to the code so that a status for "Contact_Later" wont show under Open Leads and show under "View Contact Later" view.
Aggregating data in a view
Hi, I am new to Zoho Creator. Need help solving a simple issue. I have so far worked in SQL only, so here is what I want to achieve in Creator. In the usual employee and department database, I need to find the name of employee in each department who gets minimum salary in his department. I would have written this in SQL to do that. select ename,deptno, sal from emp where sal in (select min(sal) from emp group by deptno) I figured there is no SQL here in Creator. Could anyone help me on how it can
import data from dropdownlist
Hi, I would like to import data from a filed configured as a DropdownList on Form A to a filed on Form B. When I attempt this action I don't get presented with the option to select the field configured as a dropdown list My dropdown list contains street names which i would like to import inot a Field on Form B and have them presented as a dropdownlist as Well. Can this be accomplished? or is there a better way to do this?
Freeze header row
How do I freeze the header row on an embedded database so that users can scroll up and down and still see the column names? I'd like to apply this feature here: http://juiced.gs/index/
Left justification of Search, Add, Print links
How do I make the Search, Add, Print, etc. links left justified. I am constantly scrolling right to find the search link. I've attached a screen shot of my Creator app.
New Interface filters - problem with advanced display options in lookup fileds
I like the new interface and the way filters are displayed is a great thing in the new application. However, there is one aspect which needs to be fixed. If in a form we have a lookup field which references to ID field form another form and we use for it Advanced Display Options to display for example First Name and Last Name. The values coming from that field are correctly displayed in views. Also, filtering is possible, because First Name and Last Name are displayed in the built in filter instead
How to read the upload xml file datas using deluge script?
Hi All Hope you all are doing great!!! I need the way are script anything whatever u know about this topic. Please share with me.It's very urgent work for me. Because am new to zoho ,if anybody help me it will appreciate. and i will tie up with you for my zoho projects. My questions are below : How can i read the xml data using deluge script using zoho creator? And how can i store the xml date to the database? How to create the database and tables in zoho creator? How to validate the file extension?
Usage allowance
I understand that to access an application for FREE, I cannot have more than 2 users, and that the amount of data I can store is 400 Mb. Is that correct? I would like to track the data usage, so I can know if/when I am getting close to the 400Mb limit. Can you please tell me how I can do this? Thanks Kevin Murray kevandglenny
One entry to update multiple records
Hi .. I am setting up a database for a dog rescue. I have a list of dogs and a list of foster carers. I have a field in the dog form to assign a foster carer to that dog. Is there a way to automatically update the foster carer records to show the dogs name in their records. At the moment I have to go into each record individually to update them.
Getting an image out of the field
Before Zoho's API changed a few days ago, it used to be that I could right-click on an image (in View mode) that is in a record to save the image. How can we export or extract images that have been uploaded into the database now?
password policy
This is probably asked in the past, but I could not find solution to that question: 1. Is it possibly to enforce password policy : expire in number of days, or have mininum number of characters set. 2. Is it possible to integrate system authentication with Active Directory, LDAP, Shibboleth, or other SAML-based service for user authentication and password management?
Parameter passing
I am new to Zoho, can any one help me out in the concepts of "Parameter passing". Can any one share the link were do i get the concept clear. I am stucked up very badly.
Printing Current Date With View
Hi, I am wondering if there is a way to add the current date to the title or header of a view. I would like to have the current date appear at the top of a number of my views when they are printed. Thanks, Emma
Dynamic Form Embedding
I join the request for RTL support in Zoho Creator - especially critical for me in form embedding. Another possibility is to allow users to add ANY html code before and after the form is embedded, this will allow us to change direction (and also fonts, css, etc).... This would allow us to insert a <div dir=rtl align=right> before the rendered code, and </div> after.
How to send a filled form in my own email
Hello, I am new to this so all help is welcome. I have succesfully created a form and posted it on my web site. How do I get the filled form into my email and not into the Zoho creator Contact View. I trired changing the set email notifications, the TO: email in to my own but I still do not get the filled form into my own e-mail. What am I doing wrong? Thank you for taking time helping me, Erja K
Counting Checkbox selections?
Hi, I'm trying to count the checkbox selections in a form and then use the result to calculate a currency amount and populate another field with that amount. I have a checkbox list and in its On User Input event I have: NumSigs=0; for each r in Members { NumSigs=(NumSigs + 1); } input.Total=(input.SIG_Fee * NumSigs); This works a little, meaning intermittently, but not consistently. When I put an alert on the NumSigs=(NumSigs+1); line, I consistently got an alert that said NumSigs was "1," "2," and
View
Hi, Can a "View" be customized based on user's login id? Basically, I want a user to see info related to his user id only on the view and not about other users. Thanks! V
Schedule criteria not saving
Hi, I have a decision box on a form for sending out a task reminder 10 days before the event and the schedule code looks like this: Task Reminder { Execute on 10 days before of Tasks[day_reminder == true].Due_Date at 01:00:00 } It saves fine and no errors appear but when you reload the schedule page it changes to this: Task Reminder { Execute on 10 days before of Tasks[day_reminder].Due_Date at 01:00:00 } Need to get it run the script only when the decision box is ticked..... Any ideas? Thanks
CASE INSENSITIVE EXAMPLE PLEASE
I don't know coding and i would like someone to post an example of the contain() functions. i want the search field of my stateless form to be case insensitive.
Creating full-fledged app with Creator
I've set up a basic Creator application, with several tables. It's intended to keep track of application specs, functional tests against the specs, and defect reports. However, it's unclear where I go from here. I'm used to doing database apps using C# and SQL Server. I realize that one option would be to keep using C# and the Creator API to manipulate the tables. But I'd rather do it all in Zoho. So I'd appreciate help in getting started. Maybe there's a tutorial I've overlooked. Anyway, here's
Excel formula to Zoho
I'm trying to adapt the next formula from Excel to Zoho but, it changes the formula: This is the formula what I'm trying to insert: 4.6 + (0.182258 * (Kilometers * 1000) / (minutos + (segundos / 60)))) + (0.000104 * (Kilometers * 1000 / (minutos + (segundos / 60)) * (Kilometers * 1000 / (minutos + (segundos / 60))))) And this is how it channge: (4.6 + 0.182258 * Kilometers * 1000 / (minutos + segundos / 60)) Please, someone can help me, I've tried everything.
Report based on date range
Hi, I have created an application to track jobs performed by each individual. I would like to generate a report based on how many jobs a particular person performed based on a date range and get a total amount of jobs for example: Example. ......DateRange: 06/29/2012 - 07/02/2012..................... UnitSize: QTY: Rate: Total: 3 Bdroom 8 $10 $80 4 Bdroom 10 $20 $200 GrandTotal
Messages section error
When I enter in my account - Messages section, I can see the following Regards, George
concatanated Fields
I am new to zoho Creator and I am trying to join two fileds to make one filed. Example: firstname, lastname= fullname.
Update one field from another Form.
I want to Update Form C using (Form A and B). I had tried stateless Form(Form B) which enable me to update Form C . But I want to update Form A also. I needed to keep the records or history of changes made. For example, an Item may be transfered from one to three sections in a year. From Add Item Form (Form A), I had added the current section the Item is used. When an Item is transfered to another section, I will need to Update Item Movement Form(Form B). Form B is to enable me to track the
What constitutes a 'user'?
I have the freebie account which allows 2 Users, but does this include a person who can only view the file, but not edit? Thank you.
Toggle radio button to show/hide responses
Hi, I'm trying to create a form that has a series of yes/no radio buttons in response to questions. I want to hide/show a specific response to each question based on which radio button is pressed. Getting the form with the questions and radio buttons to work is easy, but I can't work out how to set up the answers to the questions and then 'call' the correct answer to display. I'm thinking there are two ways to do it: 1. Have the answers hidden in the script of the form 2. Have the answers in a separate
Calculating Averages problem for use in Reports
I am hoping that someone can help me with a way to accurately display information I am capturing in Creator into Reports. The just of my form is that the user fills in the number of safe and unsafe observations of a given activity. The sample data would be as follows: 1. 3 safe, 2 unsafe 2. 90 safe, 10 unsafe 3. 1 safe, 1 unsafe I have built in formulas behind the scenes of the form to calculate the total number of observations and then also the % unsafe of each record. So for these records
Amazon SES Now Offers SMTP
I'm using Amazon Simple Email Service as the backend part of my ZOHO Creator app to send thousands of emails per month (see buzzable.info) - way beyond the email allotment from a native Creator app. Just today Amazon announced SMTP support. So I'm wondering if ZOHO Creator's email service could be configured to use another SMTP service? I'm not familiar with how SMTP works, so also comment on the server resources. John M. Whitney
Calendar view: if StartDate = EndDate, event not displayed ?
Hi, in the new calendars, we can choose StartDate and EndDate. But if we have an event on one day, means StartDate = EndDate, it's not displayed at all in the Calendar. It works with 2 days minimum. Any suggestions ? Thanks ! Cyril
Short circuit boolean evaluation
Good evening... I was wondering how creator handles boolean evaluations, does it use "short-circuit" evaluation? What I mean is if I have the following statement: if (a || b) { ... } Then if a is true it will NOT evaluate b and execute the if block (a or b could require counting records that meet certain criteria or other complex operations). Similarly, if I have: if (a && b) { ... } The if a is false it will not evaluate b and skip the if block. Thanks,
Lookup Function
Hi, I am using lookup function to pull a field from another table called "Info Part1". The field that I am pulling has many records in it. Some of the records are duplicate. Now the lookup function is listing all the duplicates on the drop-down list. Is there a way to just list unique records in the drop down. Please see the attachment for details. Thanks! Vishal
Cannot delete records from a view
Hi, I'm trying to delete all records from a view (we're developing and all data is wrong). I do from views, checking all records and clicking Delete option. But, the system keeps thinking all time, showing the "Loading" message, and nothing happens. I've tryied to remove all possible relations (has zoho creator something like "cascade delete"?) but, nothing. Please, are there something else that I have to keep in mind? Thank you.
Slow iframe
The iframe form loads very slow on our website (it's a non-US site), compared to the rest of the page. The script is very basic so that does not slow down the application. Is there any alternative to using an iframe? Some online database systems offer a javascript code to embed as opposed to an iframe which seems to be much faster. Is this possible?
Next Page