how would i set up a searchable database.
hi i have a website and i want to have a function on there that users can use a form to select certain colours and sizes and have a button to search. i would then like for a results page to show up (not looking like a spreadsheet) which has results from the spreadsheet on there. i would then like users to be able to select a result and click it to see a results page which shows all information about it and has a picture. i would also like to have a form that users can update records in the database
Greater Than and Less Than nuisance
Deluge script is replacing "<" and ">" with "&lt;" and "&gt;", respectively. Is there a way to stop that behavior?
Reports to Creator: Iterate Records
Currently I keep employee information in Creator but what I am trying to do is pull it from Reports. What I have currently is the following: for each var in Harvesters [Team = input.Team] { insert into Harvesters_Daily [ Added_User = zoho.loginuser EEID = var.EEID Harvester_ID = var.Harvester_ID Id1 = input.ID Name = var.Name Team = var.Team Team_Position = var.Team_Position ] } ^This creates a new record for each harvester for
Basic question for selecting and Updating records
I'm new and know very little about programming or code. I want to create a very simple form that manages contact info that I can update from the form view. For instance, if I had a form that was simply Name, Address, and Phone number, I would populate the info and submit it. However, I would like to have a drop down list above the Name field to search for an existing name that I can select and have all the existing information populated into the fields. From there, if I modified the phone number
wrong developer permissions in new layout views
In the new views layout, if the application is in my account, I have access to the following menu But if I am developer and I built an application for a client, the same menu looks different. I think that this should not happen, as long as I have full developer rights, I am not a simple "shared user" - so please fix this. I can't even get the embed code. Regards, George
Creating a report which aggregates count for multiple fields based on substring
Hope I'm describing this correctly, fairly new to this. I am in charge of weekly schedules for my group of 14. I would like to be able to generate reports which count how many times a specific group member is at a specific location, for a defined period of time. Currently, each record is based on a day, the fields for that record are the locations, and I select the group member who is assigned to that location through a drop-down box. I can create a report which aggregates one location by placing
Upgrade to new interface and Save with selected records is missing
Hi, I upgraded to the new UI last week and Save with selected records command is missing. What I've got is the whole recordings. Where is the command right now? David
"Access this application" window is blank
I am a first time user of creator. I have created a simple app named app1 with a form called form1 to test with. I added a single line object called field1 and hit "access this application". The resulting page is a completely blank white web page. What am I missing? It seems odd to me that I can't find whatever options are needed to show the form. Perhaps I am missing some fundamental concept....
I want a site where users log in... can I do this?
Hi. I want to build a real estate site, where sellers log in to create their ad, and then buyers can search/query the data to find the properties they are looking for. Is that possible? Thanks. Maryanne
Block form for Weekend
Hi, I need some help in a code. I´m blocking the access for this code if (((hr >= 19) && (min > 0)) && (sec > 0)) { hide Nome; hide N_de_Colaborador; hide Email; hide Data_de_Registo; hide ideia; hide Tipo_de_Ideia; hide Descri_o_da_Ideia; hide Benef_cios; hide Coment_rios; alert("Este acesso só está disponível no seu local de trabalho"); } But in case of Saturday and Sunday I want the forms to be blocked all day, the schedule only applies for weekdays
I made function for money number convert to Chinese words
Hi I'm exciting made the function for money number convert to Chinese words. I want to say ZC it's powerful so let me share the code and get your further help for optimize the code more.. string sz.num2rmb(float je) { vzf = {"0-零", "1-壹", "2-贰", "3-叁", "4-肆", "5-伍", "6-陆", "7-柒", "8-捌", "9-玖"}; vws = "万仟佰拾亿仟佰拾万仟佰拾元角分"; rdw = formqj [cat == "小写大写"]; vje = ((input.je * 100).round(0)).toString(); vcd = (vje).length(); vwszf = (vws).subString((15 - vcd));
My Document is saved successfully but problem is same document opened again but previous changes not show.
My Document is saved successfully but problem is same document opened again but previous changes not show. Please refer below link: http://www.servicebasket.com/zoho/
Backup Process and Approach?
I'm contemplating upgrading from the Basic ($15/mon) Plan to the Standard ($25/mon) Plan in order to get backups, but I'm not sure exactly how backups work. Here are my questions: Does the backup download a DS file to your computer, save a backup with Zoho, or both? Is there a limit to how often you backup? If I am comfortable with backing up only once every 6 months, could I conceivably upgrade and then downgrade twice a year and thus simply pay $20 for my backups instead of the $120 marginal annual
Why check boxes remain if no bulk permissions?
Why do the record check boxes remain in view even if there are no bulk permissions for the user? Is there a way to remove them?
ZOHO CREATOR DOWNTIME
Dear Users, We apologize for the inconvenience caused. We are having a downtime in Zoho Creator due to some maintenance issues. We will update you on this as soon as Creator is up and running. Regards, Harsha.
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.
Next Page