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?
Hide/show actions on user input from checkboxes
Im trying to hide and show a few fields based on if checkboxes are checked or not checked. I have the fields hidden initially on form load. I also successfully show the fields when the option is checked. My problem is i dont know how to make those fields disappear if i uncheck that box... what would be the best way to approach the opposite function of input.contains()? ____________________________________________________________________________________________ ON LOAD _____________________________________________________________________________________________
How to show/hide fields on user input?
Hi I'm trying to build a new form for our client where in they can place order. Prior to this I built a database for our product which include price, name & etc.. Now, I want to create a form for our client that every time they select one product from "multi select" field, two additional fields will come out after selecting a product: Quantity Add more product "Add more product" is is also "multi select" field which they can choose among our product list. Then if they select another product, "Quantity"
Round of numbers displayed on graphs
How do I round off numbers on the pivot graph generated on zoho reports? See attachment. Thanks! Vishal
Different logo
Hi, I would like to know if is possible to show different logo for different application. Thanks in advanced, Regards from Brazil, Andre
Apply autonumber with Form Object Function?
I have a form object function that sets the value of a date field in a collection of records (script below). Now I would like to set the value of the ItemNumber field in each record of this collection as well... ...BUT I would like to autonumber those values so that the ItemNumber fields start at 1 and continue with 2, 3, etc. until the entire collection has been assigned an ItemNumber field value. ALSO the order of the assignments is important and should follow the order of a field called Unit which
openURL not executing in function
Here is the function code: void JulDepositDateSet() { JulNextDepositList = Payment [(JulPayment > 0.01 && (JulDepositDate is null))]; JulNextDepositList.JulDepositDate = zoho.currentdate.addDay(1); openUrl("https://creator.zoho.com/rampartcrossinghoa/rcb/#View:Jul?JulDepositDate_op=33", "Same window"); }What I done wrong to not have this openUrl command execute? Thank you for your help.
How to create token in creator?
Hi How to create a api key and token for my zoho account .? Please help me
dialer
is there any way to enable a phone number field to be clicked in a view and trigger a dialer?
Zoho (Files)
I don't know if it is places any elswhere in the great Zoho forums. But now a days there are some cloud hosting programs. Just like to name: Dropbox, SugarSync, MegaCloud, Google Drive, SkyDrive, SkyFile, etc, etc. Like to know if Zoho has plans wiht it. I mean: develop any app so that we can manage the files that we store in our zoho space. I think it would be nice and handy. Like to hear from you.
Open View from Form Link in Popup Window
Is it possible to create a hyperlink on a form to open a popup window to a view? I can create a link on my form to open the view, by creating a plain text field in my form with this code: Calendar_Link ( type = plaintext value = "<br />\n" ) And then using the OnLoad command of the form to create a dynamic link using this code: input.Calendar_Link =(((("<a href='https://creator.zoho.com/carlgifford/vacation-rental/#View:Reservations_Popup?Property="
Alternate "Submit" Button
Good morning, I'm working on a form with a new requirement. I have a set of forms, each form is a "stage" in a process. When one process is complete you either move to the next or the process is closed. The new requirement is depending on the status of the overall process, a user may need to jump from form-0 to form-3. So, I've put a conditional statement in. If "need to jump" == "Yes", then user needs to go to "form-3" else "show the hidden fields to complete stage" Pretty basic. What I'd like
Restrict users to enter not more than one space?
I have a TextBox in which user is going to enter search Criteria in TEXTBOX. Now, i want to prevent the user from entering NOT MORE THAN ONE SPACE AFTER EACH WORD in TEXTBOX. How to do it in zoho??
Zoho Reports to Zoho Creator
Is there a way I can pull data from Zoho Reports to Zoho Creator. ex. On load of Zoho Creator I want feild "Axx" to update to all values in column "Bxx" in Zoho Reports.
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
Radio button selection as a single-line text entry
Is it possible to have a radio button selection be a single-line text entry? I'd like to have two choices: 1. a person's name, and 2. a "write in" entry. If "#2" is chosen, I'd like the user to be able to enter a name other than that presented as choice #1. Can this be done with radio buttons or some other field type? Thanks.
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.
Show Hide for HTML View
I can see that I can't use Javascript to create a show hide button in my HTML View. Does Zoho have another solution to accomplish the same thing?
action on checkbox option selected
Hello guys, I want to send an specific email if in my multiply option check box one option is selected. So let's say if checkbox option 3 is selected I send an email with "x" content if checkbox option 15 is selected I send an email with "z" content if checkbox option 4 and 6 and 10 selected I send an email with "a, b, c" content I cannot find any reference on how to build this code in I have choosen "if" than put input.checkbox optiom_3 = true but it is not the right code. Can you please help
Web Application for multiple clients
Hi, I have a doubt in developing a web application, I want to create a web application for multiple users. Based on user role or region flow is changed User details can be hosted as services Please help me to understand these questions. Thanks, Phani
How to move a lead to converted
Hi Guy's, A complete newbie here so please be patient :) Basicly I want to create a form "new lead" in that form it will have a drop down status with the following options >Contacted >Converted >Not intrested When the drop down is changed to "converted" I would like to move it to another form/view "leads" and on moving it to this new form it will allow me to enter further info. So I have created a form "new leads" and created a form "converted" how do I get the data to move from new leads to
Send email with custom subject to selected records
Hello Zoho team! I want to send an email with custom subject to selected records in a view. I have viewed https://help.creator.zoho.com/Sample-Code.html#Email_Notification but I want that the subject of the message could be user edited. Thanks.
Broken/Missing Links to Forms/Views in Mobile Portals
When I use mobile.zoho.com the shared forms/views no longer are reflected accurately. Some are there and some are not. Also when I use creator.zoho.com/m the links to applications/forms/views are misdirected. I will share my application.
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
Marketplace Trial
I want to create a trial for marketplace and provide a time or record limit. Is there a canned way to accomplish this? If not, is there an "on load" hook for the entire application? Thanks for any help!
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.
update data problem
I am trying to update about 25 rows in my database with data that is generally found in a lookup field. When trying to do this using the edit function in the view it accepts a change and then when I attempt to change the next record with the same value it accepts the change and removes the value from the previous record. This will continue if I attempt to make the change again. I have seen this before and worked around it but have hit an issue here and so need a response. I also attempted to make
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
Enable Edit Record only where login user id is same as added user id
Hi, On a particular view, I want only the user who added the record to be able to modify/edit it. Basically, on the view, I want to write a code which will enable Edit function where zoho.loginuserid is equal to addeduser id. Please help. Vishal
Update - Date Search Calendar missing
Since the update when performing a date or date range search in a view, the calendar no longer appears. Also if you "Click to Add Record", there appears to be no way of closing the pop up box, should you decide not to add a record. You have to close ZC and start again to continue. Regards Mark Australia
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
ReplaceAll dont work?
I have this code: texto = "0.90"; alert(texto.replaceAll(".", ",")); Return to me ",,,," WHy???????????
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.
Simple Dynamic HTML
Hi, I am aiming to make a very simple Dynamic HTML page, do you think You could help me? Basically we're building a Database of Local Work Seekers. The Work Seeker Application form has all the information for that Work Seeker. Upon Submit, we want the App to generate a Resume for that individual based on their data. Below is the link to the App. https://creator.zoho.com/dylanvdb/good-help-employment-marketplace/#View:Curriculum_Vitae (I have opened up the App to Support.)
Rolling Average
Hi, I am trying to calculate a rolling 8 week rolling average for several entries that are made on a weekly basis. Each week the following fields are entered: 1. Date 2. Weekly Revenue 3. Weekly Labor 4. Weekly Spread I am trying to take the 8 most recent entries (weeks), and average them out and display the results... Any help would be very appreciated.. Thanks Nick
Next Page