warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
How to create function that returns all the selected fields in column "Email_Address" in a view?
Hi, I'm strugling with this one - I have a form where one column is "Email_Address". Now I need the user to be able to select appropriate rows in a view and on press of a button get all the email addresses to copy&paste I've been experimenting with the following code: string Get_Email_Address() { x = i.Email_Address ; Info x ; } return x ; This just lists of the email addresses in the log, but obviously returns only the last one. How do I make it to return all of them? and how do I narrow it down
URGENT! Script no longer working
Hello, I have the below script on my application 'KiwiOz Childcare.' For some reason it has stopped working and consultants are not receiving their emails: /*if (input.Item == "7. Interview (KPI)") { sendmail ( To : zoho.loginuserid From : zoho.loginuserid Subject : "Interview booked" Message : input.Item + "<br>\n" + input.Client + "<br>\n" + input.Candidate_Name + "<br>\n" + input.To_complete_by + "<br>\n" + input.Comments + "<br>"
Dynamic List Reference
I am creating a multiselect dynamic list and would like to include specific information from the records in the picklist. For example: Deposit: $300 Payment #1: $500 Payment #2: $600 The payment amount would come from the id reference. I am able to do this using the following code: Reservations = Rentals [ID == input.Reservation]; paymentlist = List:String(); if (Rentals[ID == input.Reservation].Deposit_Balance != 0) { paymentlist.add("Deposit: $" + Reservations.Deposit_Balance);
On Add / On Success Error
I've got an issue with On Add / On Success script in "NECATNetworkDatabase" - "Show_Times" Form I can't access it. Any help is appreciated.
Custom Action to edit a with less number of fields
I am trying to create a custom action which opens the edit window for the view record. But I want some fields to be hidden in this edit window. How can this be implemented?
Due Date for Form
I am trying to create a form script in which a "due date" will be automatically populated based on the day of the week I select in a date field. For example if I enter a date that falls on a Monday the "due date" will add 11 days. If I enter a tuesday it will add 10 days, etc. Any help would be appreciated, thanks.
changes to formla triggered by update to drop down
Hello, I have a drop down list of shirt sizes and a text field for quantity of shirts. The size ordered determines price. I am using a formula field to calculate the total cost of the order (quantitiy of shirts * shirtcost). It works well the first time (user selects size and inputs quantity). But if the user changes the size of the shirt without changing the quantity of shirts, the forumla is not updated. Is there any way to force the formula to check for a new value from the drop down? Sonya
Form Printer Add-on for Creator
I need a way automatically fill out the fields on a paper form with data from a Zoho Creator report. The goal is to auto-generate and print a completed paper form that looks exactly like the original blank paper form, but with all the fields filled in with Zoho database data which was extracted from a Zoho report screen. This is important, because many applications require the filling out of forms where you must use the exact layout of the original blank form for the completed form. The basic steps
Is there a way to get data out of backup version of app, without restoring the backup?
Since zoho support still can't tell me why duplicate application doesn't work, I decided to just work on the original and backup. Seemed sufficient, till I realized I needed the original data from a previous backup.
Duplicating or Deleting An Application
I get a "Duplicating...Please Wait" window that never goes away. Also my database never is duplicated. Same for Delete chris
Refining App
I am trying to refine an app I developed. I would like to Build an opening Dashboard for ease of use, but unsure if it should be a stateless or not. I would also like to add some other buttons to my existing forms. Any suggestions? Still Learning this..
Allow users to save a partially completed form and then complete it later?
is it possible to allow users to save a partially completed form which they could then complete at a later time?
Unable to duplicate a form without data
I have a long, complex form with sub-forms. Attempts to duplicate the form according to the "How can I coppy/duplicate a Form?" knowledge base instruction lead to a "null" error (old builder or new). (I have already tried deleting formula fields which Zoho says can't be duplicated.) Suggestions? Thanks.
Joining Applications
I have multiple database applications for parking permissions for different developments within a city, is there a way I can add the applications to one application with multiple tabs so the officers can access all the developments in one form. Any help appreciated.
Back Botton Script Not Working - Dialog Box
I have a page that has an openurl(#) pop up script in it. This allows me to open a form without navigating away from the current page. the problem I am now having is that when I hit the back button it loads the dialog pop up box instead of taking me to the previous page. Is there any way to fix this? I have tried the following: #Script:page.back #Script:page.parent.back But both of them reload the dialog box instead of loading the previous page. Again, if i have opened any dialog boxes it will
Any issues with Zoho Creator and Java update 25?
Some users report data entry issues beginning this weekend. Trying to figure out if this is a Zoho issue or related to Java 7 update 25 which was released this weekend. Data bases which were working just fine as recently as Friday are not now and we did not make any changes this weekend to our tables or Deluge scripts. Wondering if the new Java update is not compatible with Deluge?
Formatting Record in view
Good morning, I need technical information and I can not find an answer. By inserting a new record, I can ask for a verification of those already entered and make them change? Example. I put the record name (single line) double (decision flag) I already have a record (1) entered: name = "Andrea", double = false I insert a new record (2): name = "Andrea". The system can understand that there is already a record with field name = "Andrea" and enter on (1) Double = true? Or write the name field in the
Export field definitions from a form into an excel spreadsheet
We are trying to rationalize two databases into one. I would like to take my primary data entry form in Zoho Creator and export the data definitions including field type, length, drop down choices etc. Is there a quick and dirty way to do this? Thanks
Default Report Page displays Unwanted Records
Hi, can anyone assist me with this one please? When I open a Report page, it by default displays some records, even though it hasn't been specifically searched for. Because people will pay for viewing the records, I would like them to only see what they have searched for and nothing else. I would really appreciate any assistance on this.
dynamic form fields?
Hi, I'm building a form with Zoho Creator for users to register. Users might be from all around the world, so I want the form to offer different pulldown menues to chose from depanding on their input of the My Country field. E.g. if a user chooses USA another pulldown field shows up to select a state - for UK a pulldown menu shows up to select a county etc. It all gets stored in the form data table. I was able to achieve this functionality by the "On User Input" script for Country where I hide or
How can I combine multiple databases into one view
How can I combine multiple data views into one view.
Problems Sharing Application
Hi I shared the forms and tables with users but when they click on the email with the link they received the get a message "You have login as XXX. You are not allowed to access this application" Why does that happen? Help please! The application is ready but I cant use it! Raul
Lookup Import 2 or more fields
Greetings Community, I am having 2 forms , 1 form is customer form that contains 1) first name , 2) last name 3) Autonumber ( unique value ) Data is already imported to this form. The tricky part now, the product form contains lookup field from customer form that contains 1) last name , 2) first name 3) Auto number ( unique value ). No matter what i tried, i can't import anything in the products form when i am using more that 1 fields on the lookup field. When i am using ONLY last name its working.
OnLoad Get Url Variable
I have a view that is filtered using a url variable. Example: https://creator.zoho.com/app/app#View:Contacts?Contact_ID=1159827000001018003 When I click the "add" button from the view header I want the add record form to pop up but also call an "onload" script that uses the Contact_ID that is in the parent window url. Is this possible? All i am trying to do is grab the url variable before the new form loads and pass it to the new form.
Read More Option on Blog Creator
Is their a way to do a read more option on blogs or any type of other features.
More buttons on regular forms
When a form has lots of field I break it into multiple stateless forms with Prev & Next buttons to move from form to form using the openurl statement. Each form reads & writes the data to a Master form. This does work but is complicated. There has been discussions about being able to create buttons on regular forms similar to what can be done with stateless forms. This would give us the ability to use show/hide to mimic several pages. When the user clicks on Next then all the fields from page one
Compare two views, to find an offer to match for a demand
Hey, my name is Jo and I am from hamburg, germany. Thats my first topic in this forum ... At this point I am trying to create a database with zoho creator. I have created 3 Forms: 1. Offers 2. Inventory 3. Demand with the same attributes and the current views. BUT: I want to create a View (or Report? ), which find the best "offer" (offers plus inventory!) to match for a demand and propose this one / show it. I would say, the program has to compare attribut per attribut and try to find accordances -->
Compare two views, to find an offer to match for a demand
Hey, my name is Jo and I am from hamburg, germany. Thats my first topic in this forum ... At this point I am trying to create a database with zoho creator. I have created 3 Forms: 1. Offers 2. Inventory 3. Demand with the same attributes and the current views. BUT: I want to create a View (or Report? ), which find the best "offer" (offers plus inventory!) to match for a demand and propose this one / show it. I would say, the program has to compare attribut per attribut and try to find accordances -->
Zoho Creator to SQL DB
This might be a dumb question but, Is it possible to submit & pull data to a SQL DB hosted at my company headquarters using Zoho Creator. I want to be able to create an application in creator, and then submit data to my SQL database automatically, without having to export/import manually. Also, When i view the report, I would like to pull some data from the SQL database and display it in a custom formatted view (HTML view) Can i do this?
Change text
Hi, I have a field in a form called job_ref. I cut and paste the job_ref from an email. the ref would be say HYG287/1/101 When I paste it into my form I want the / to be replaced with a - can anyone please help. Thanks Nigel
Permalink in new application builder
Hi, how can I get a permalink with no log in required? it seems that this feature has changed with the new application builder. When you follow the "publish" link you get to a new window where you have a check box for a no-login option however this seems to do nothing... Going back to the old builder does not help either as this option seems to be disappeared?... Thanks Luis
Need some information/assistance
I want to know whether there is a way to access Zoho CRM database through Zoho Creator ?
Is it legal to copy a form from another application?
Is it legal to copy a form from another application ? I am thinking that contact form it's a common form widespread across multiple websites and we can create a contact form in our website without to have copyright problems, this thing is applying on any form existing in any application ? I want to copy only the structure of the form and reproduce in my web application (which it's not a Zoho Creator Application) without to take code, style (look & feel) and to add/remove fields after needs. More
Restrict users
How do I restrict users from changing certain fields in a view, while allowing them to change other fields in that view. Any help much appreciated.
JSON API Ignoring filters
I have a view that presents some data to an external software client as json. On the url we filter the returned records using a named column in the view. As of this morning the column we provide is no longer filtering the records and returning EVERYTHING in the view. I've raised a support call but the customer who is using the software client has now had the remaining confidence in Zoho blown out of the water (we had BOTH of the creator outages during the pilot) this morning. The view hasn't been
disable subform
I have a CHANGE HISTORY subform on my TELCO ORDER FORM at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder/ I have disabled the subform disable CHANGE_HISTORY; I want users to see the CHANGE_HISTORY but not modify it However, when I tested it, users can Add New rows & delete rows. How can I prevent them from doing that but still see the change history?
Create windows folder
Hi, When I create a record, there is a field called job_code. lets use the job code "axg101" For each record I create a folder within windows and call the folder the job code which in this case is "axg101" Is there a script that will automatically create the folder for me and name it whatever is in the job code for that file? Thanks Nigel
view criteria help
I can't figure out the logic to create a view that would show me records that have an ArrivalDate and a DepartureDate that occur on the same date. I need to be able to show Units that where the Guest will depart and another guest will arrive on the same date to the same unit so I can mark them with priority. Example Fieldnames: | ArrivalDate | DepartureDate | UnitNumber| | GuestName Thank very much.
Requirement of Developer Edition (User Edition) in Zoho Accounts.
Dear Zoho Support Team & Developer Community As a Developer, I want to explore my idea in front of you; It is required that Zoho should be start a Developer (user)edition for the Developers, By that way it will be a good support and inspiration for the Developers and also Zoho will be more popular and affordable by the Developers/Enterprises. This same trick is also used by the SalesForce Corp, and today you will be seen that where they are, they have a large community of Developers, and also they
Next Page