Subform: Criteria rules not working correctly
Hi, Background: I have a PROJECT form that has a relationship with CUSTOMER & AGREEMENT. The AGREEMENT field has criteria where CUSTOMER_ID == input.CUSTOMER_ID. This works fine in the form. Eg When I select customer 123, I can see agreements 12 & 22. Problem: I have a PROJECT subform in my CUSTOMER form. When the user adds a new project, I expect the Agreement dropdown to show the relevant filtered agreements. However, I do not see any agreements. Eg When I view customer 123 & add a new project,
Urgent: task zoho.crm.searchRecords don't works
the taks zoho.crm.searchRecords don't works anymore in my app, i try to see crm response with this functions list test.test() { crmResp = zoho.crm.searchRecords(("Accounts"), "(CIF|=|XXXXXXX)"); return crmResp; } and show me this: [{4834=Invalid Ticket Id}]it was working 2 days ago
Sum of 3 fields depending on user login??
Would love for someone to help me out with this. I can't think of a solution and have spent SO many hours.... I am using a form, where up to 3 users can split a commission on a team. The main agent adds the file, then they add one or two agents to share commission. Then, 3 fields are calculated that shows the commission for agent 1, agent 2 and agent 3. Now, I want each agent to be able to see their commission in a view or report form. I would prefer it to show as one field only, that represents
HELP!!!! Setup form in Zoho creator, but don't know how to automatically send invoices or attachments to clients?
Hi, I have a question for anyone. I have setup a form in zoho creator but from that information that I collect I would like to send invoices and contracts to my clients. How do I go about doing this? I need help. I don't know how to write script either, so I think that is what is stopping me. Do I use Zoho crm to do this all or what? HELP!!!! Tess
Update for the whole application
fetch and record for update from one form to other form is fine. However, my application need to be very relative together. For example: Form A: a cost of something (I will call A) Form B: fetch A * with a user input num = B Form C: a cost of something (I will call C) Form D: fetch C * with a user input num = D Form E: fetch B + fetch D = E Fetch and Update record will work when I update value in update Form A --> auto update to the fetching A in form B. But can not update value B update Form C
Subform calculations
I’m having trouble adding a column of numbers in a subform. As an example I created a form with the new builder. It has a subform with one numeric field, a separate number field for the total and a decision box to calculate the total. I added two rows to the subform. The number field on row one is 1, the number field on row two is 2. The calculation gives me a total of 5. If I add a third row with a value of 0 then the total drops to 3. The last row is being counted twice. Here is the script for
hidden fields
Hi, How do I unhide fields depending on whether a particular field has been selected on a drop down list?
Federated Login Improvements
This is related to my application context post. The changes Google made recently make having both a Google and Google Apps login irrelevant. I tested out signing in via my Google Apps account using the Google login and it works just fine. Support can remove the Google Apps login option. Using the Facebook option, the logo looks rather unprofessional. Please fix that. After federated login for new users, Zoho asks for a user name. Note that the instructions mention the zoho email address which should
How to create a view which self filters using user information from one form and displaying the filtered information from another?
I have two forms. One which has all the data I wish to display on our work, the other is a list of the users and their specialities and location. I want to create a form so when they log in it will show them information on all the items that are linked to their speciality and location. Both the location and the speciality apear in both forms. In the user form has the users email. I have created similar view to display for individuals who have their name on the item, this is done with the below
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
Next Page