HTML in Variable
I am trying to create a variable for use in an email that contains HTML (for a dynamic link). The issues I am having is with the quote signs in the HTML. I cannot seem to get the variable to save with the quotes: agreementlink = ("Please sign your rental agreement by clicking the following link:<a href=\ "http://creator.zoho.com/carlgifford/vacation-rental/Rental_Agreement/record-edit/Rental_Agreement_View/" + input.RentalAgreementID + "\ ">Rental Agreement</a>"); Is there a way to do this? Thanks
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
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
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
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);
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.
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.
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..
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.
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
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
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?
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
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?
How do I set the value of a check box field
Hi Guys, I have a field Checkbox_1 which has one option call "Yes". How can I set the value of this in script?
Set field value to field in a different form
FormA contains a string field (Line1). FormB contains a lookup to FormA (Choose FormA) and a string field (Line2). On success of FormB, I want to use FormB's Line2 as the value of FormA's Line1 For example: FormA's Line1 is null FormB's Line2 is "apple" When I hit FormB's submit, FormA's Line1 is now "apple" I have tried (On Success) FormA.Line1 = input.Line2 which gives me Only SubForm related fields can be updated and FormA[ID == input.Choose_FormA].Line1 = input.Line2 which gives me Improper Statement Error
Zoho Creator funtion Report
Good morning, I am generating a report in Zoho creator and need to create a visualization of certain records by status, status is a Dropdown, how do I make the sum of records by Status? EX: cont ("Status_Orcamento" == "Failed")? And another thing, how do I count the number of records in the view. Ex: Number of requests and requests that is a form. Thanks, sorry I do not speak English.
Application Settings - Application Custom URL
Hi all, Would you know how the Application Settings - Application Custom URL field can be used? For example I set it to be: demo.mydomain.com? The Application Link field is set to: subdomain.mydomain.com/admin_user/app_name. My DNS provider yells that subdomain.mydomain.com/admin_user/app_name is not a valid domain name. Is there a help page for this settings? Many thanks,
Cannot modify application URL
By default, the application is accessible at a location identified by a URL like: http://creator.zoho.com/[USERNAME]/[APPNAME] Now, the application was created using the above [USERNAME] which is points to a person. We'd really like to share URL that contain our company's name. Here is what we were offered as an alternative: 1. Create a new user, recreate the application using DS EXPORT-IMPORT. 2. Transfer the application along with the data using instruction at: http://kbase.creator.zoho.com/general/publishing-applications-to-another-account
Date, Selection or Text from Main Form Fields to SubForm Fields
Hello. I have 1 main form which is unique by date, selection (drop down menu) and the name, in which there are about 5 subforms. How to make so that in Subform the report I saw date, selection and the name of the main form? Now I see only records created in subforms, but I don't know to what date^ group of people (selection) and to what client they concern.
Converting a STRING to a STRINGLIST
I have a STRING that was created from a STRINGLIST, but after the STRINGLIST was reset, I need to go back in and turn the STRING back to the STRINGLIST. Here is my code: input.Extra1 = Extra2.toList(); input.Perm1 = Perm2.toList(); Extra1 is a STRINGLIST Perm1 is a STRINGLIST Extra2 is a STRING Perm2 is a STRING I get the following error: The template variable Extra1 is of type STRINGLIST. But you are trying to update it with an expression of type LIST Any ideas?
Subform Add Row any way to not Add Row based on a condition
Hi in the add row script area of a subform is their a way to "cancel" the add row, say for example the user has entered some data which is the same as the row above, i can see how to alert them using a for each loop but i still cant stop them from adding the row so something like if condition == (don't add row) or if condition delete last row added thanks
html script performance
I've seen several old posts about poor html view performance with complex code. My html view has 1550 lines of code - i suppose that qualifies. The first time the view loads, it takes around 30 seconds. After that, with any change in parameters (it's in an iframe to display data based on dropdown criteria), it's near instant with no performance issues. Any ideas what's going on that first time, and if there's anything I can do to pre-cache it or whatever it's doing? All the posts I found were
Button: Rename "Update"
With non stateless forms, I know I can change the label for the "Submit" button. How can I rename the label for the "update" button that appears when I try to edit a record?
Doubt Subform
I have a form called Company, within it I have a subform called that has a field Machines Associate Company, if I add machine within the company it appears in the list of the form of machines, if I add more machines in the form of machines and put the Associate Company the machine does not appear in the Company. How to solve this? Thanks and sorry I used google translator, do not speak English.
Matching records which contain any words from the string
A user types the words "Zoho Forums" in as the Client_Name in my form, when they submit the form it looks for a matching record using the following snippet of code: records = Case_Management_Form [Client_Name.contains(input.Client_Name)] This will only find matches when it comes across records which are "zoho forums", how can I get it to find any matches which contain "zoho" OR "forums"?
Found error in deluge script
HI I am evaluating a ZOHO creator application and stuck here in given code. There are two form: 1)job 2)Service partner once click on link which is at Job form it will go to Services partner form and those job id is appended to url as you can see in given link https://creator.zoho.com/fbriod/copy-of-copy-8-of-job-management/#View:Service_partners_View?Job_ID=1111408000001264149 Problem :Not able to fetch job_id from url please advice Custom Action function Code: void service_partner.JobOffering(Service_partners
3rd Level related fields for views
Is there a way I can have a view that could pull related fields from a Parent's Parent. I have a Client Form - Submission Form - Submission Details Form. Submission Form is related to Client from via a lookup and submission form related to submission details via subform. It would be nice if I could pull client details from a Submission Details view. Any help would be appreciated.
RegEx for Numbers
This script should report "good" but is failing. I need a function that tests if a string starts with a number. string test() { street = "12 yadda"; if (!(street.matches("^\d+"))) { yo = "bad"; } else { yo = "good"; } return yo; } Ref: http://stackoverflow.com/questions/6372318/c-sharp-string-starts-with-a-number-regex Cheers, John Whitney
Script stops working, can't make changes
Hi, I have set up a lightweight learning management system for an educational initiative. In the attendance form, there is script in the On User Input block of one of the fields, that automatically populates several other fields with data when called. This has been working fine for several months, but this morning the script seems to suddenly have stopped working and fields are no longer automatically populated. I can't think of anything that could have triggered this as I haven't made any changes
Next Page