How to access individual records of a sub-form in a report
Hi, My report is based on a form which has a sub-form. I am not able to access individual records of sub-form. I can not put any filter nor I can group on any field in the sub-form All sub-form fields are shown together in the report with whatever separator I use. Not able to show them in different columns. Also filters and grouping does not work on the sub-form columns as mentioned earlier. Please help. Milind
incremental search
is there any in built function for incremental search (find as you type). I have a form that has 1000's of names which I'd like to use in a dropdown but prefer not to use in dropdown.
Not able to populate picklist dynamically
Hi, I am new to Zoho creator. Pls. see the script below- proglist = Student_Program [ID != 0]; Program:ui.add(proglist.Program_Details.getall()); I am trying to populate a picklist (Program) in one form with field (Program_Details) from another form (Student_Program) without any filter. However when I run the application, I get ID in Program field and not the name i.e. Program_Details. What mistake I am making ? Pls. help. I have attached a screen shot when I run the application. Thanks, Milind
Report: List 3 last sales in each district. possible?
I have a list report, but want it to only list the 3 last sales (based on a date field) for each district. How can I make such a filter / any functionality for this?
Create relationship between two existing forms?
I have two forms(tables), both with imported data from different sources. Both forms are full with data. Form A Name (Single line) Descript 1 (Single line) Descript 2 (Single line) A_ID (Number) Form B Local (Single line) Descript 6 (Single line) Descript 72 (Single line) B_ID (Number) Now I want to create a relationship between the two forms. One-to-many (from Form A to Form B). Do not really want to add more fields to these tables - if I add a new lookup field to these tables now, I will have
Custom Action to Partly Duplicate a Record
A custom action in a report that partly duplicates a previously entered record and opens it in a new form that the previous record was created in, additionally populating a reference id field of the old records autonumber. I have created custom actions in other reports, its really the script to duplicate a previously entered (Into Form A) record (certain fields) and open Form A with some of a previous records data pre populated. Also a way to copy a autonumber field and populate a reference field
how to add print button to deluge script
I was told that I can't add a print button. Upon investigation I found that you can use a link to create a PDF. So I use: https://creatorexport.zoho.com/USERID/ordenes/print/Generate_Invoice/orderRecId=2769016000000090461 This works great with my user, but if I try this in another computer/user, the link is changed and it removes everything after ordernes/ rendering this solution useless. Any ideas? Leo
Functio to Update Zoho CRM Record from Zoho Creator
Hi, I am trying to create a function in ZC to update the respective Zoho CRM contact Record.But I am getting error and I can't figure out where is the problem in my code void CRM.CRM_Sync(ContactForm rcd) { for each rec in rcd sort by Added_Time desc range from 1 to 20 { srt = rec.Zoho_CRM_Contact_Name_ID.toString(); com = TV_Station[ID ==rec.crm_TV_Station ].Add_TVStation_Name.toString(); dat = TV_Station[ID == rec.crm_TV_Station]; net = Network[ID == dat.Add_primaryChannel].Network_Name.toString();
Stripe button in Zoho form
Hi, I wonder if the below script can be passed into one of the Zoho form or page? It is actually a post request to Stripe server and it returns in json format, including a token and also other data. Then I would like to use these data in zoho forms further. So, the code should be embed into Zoho because the "answer" from Stripe server will return to a page where the code was embed but adding "/charge" <form action="/charge" method="POST"> <script src="https://checkout.stripe.com/checkout.js"
Update records between apps
I'm having trouble trying to figure out how to update records between apps. My end goal is to have a form that will repopulate with information from a previous unfinished record so that you can finish it. There will be two apps. App1 has the original form and databse attached to it. App2 will have the form that will repopulate and allow customers to finish unfinished records. How do I update records in app1 from within app2? Also how do I comment out the code in deluge?
Request: Subroutines in deluge, and hide/show "all fields"
We have some large forms and use hide/show to present the right mix for various cases. As a feature enhancement, please consider: (1) Offer subroutines within the deluge script. This would allow sets of hide/show/enable/disable and any other form statements to be coded and maintained only once, yet re-used within the script. Such as: if checkbox_a = true { sub_hide_fieldset_1; sub_show_fieldset_5; sub_show_fieldset_6; other.... } We are aware of custom functions, but they
IF statement not working (dependent on checkbox field)
I am not sure why the 2nd IF statement is not working... The first one triggers an email to be sent, as well as the third one, but the second one does not. if((input.Type_of_Sign.toString() == "In-Store") && (input.Type_of_Sign.toString() != "Event/Trade Show")) { sendmail [ from:zoho.adminuserid to:zoho.adminuserid subject:"New signage request" message:"Signage request details:<br />\n<br />\nName: " + input.Name + "<br />\nDepartment: " + input.Department + "<br />\nDate: "
How to duplicate columns in creator in one go?
Hi folks, We have built a internal database wherein we wish to duplicate data in an existing column to another field/column. Is there any way to automate that?
Reinvite Cusromer without delete User
Hi, how to Re-invite Customer without delete User in Customer Portal Omar
Hide ALL fields in a very large form
Is there anyway to quickly generate a script that hides all fields for a large form or sub-form....... or is there at least a way to get a text list of fields within a form that appear in dropdowns in the script editor. It would be so much easier to hide all fields on a very large form and just show what you need Any insight to a short cut would be appreciated
possible to create a product configurator?
I need to create a product quoting system for our manufacturing operation, I want the sales people to be able to enter Length Width Which the resulting Length X Width Total would determine the price per foot, depending on: Style Material Brand Material Type Options that have varying quantities at a fixed price, for example 2 units of option A, and 3 units of option B price of option changes depending on Material Brand After all the data is entered I would want the system to display the Retail price,
Cannot create one to one relationship using look up field
Hi all I am new to zoho and database so i need your guidance I have one two forms " JOBS " form where each JOB has unique job number and "Invoice" form where each invoice has a unique invoice number Each job can only relate to only one invoice and vice versa I have linked by creating look up field in JOBS form so that we can look up for Invoice Number. The problem i am having is that one invoice number can be selected in many jobs Please help how can i relate two forms so that one job is only
Embedded Creator output does not display all rows on some mobile devices
I have a Weebly site that embeds Creator output in a standard HTML page: http://www.floridaforcesoftball.com/10u-roster.html <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/bryanduncan/force-player-profile/view-embed/U_Player_Roster1/Q8C7dQRrDXj5FXZWQuMpzMD83Ns7Cy62SdA6CzOW7fDOZZpAr4FZdJ9ymF7ma12uUKq6bnBgNneMTvQFV1mkahAMsCfTO8yW3TQH'></iframe> It displays well on all desktop browsers but cuts off at 10 rows for many
Sending file to form via email, and open form with data suplied in url
Hi Creator Community. #1: I am facing two problems:i am trying to use open url and redirect a user to a form with some data to start with. specificaly i want the form to be opened with his email (which i already have) pushed into the form EMail field. I use this url: https://creator.zoho.comapplicationowner/testapp/#Page:test?Email=testing@hspa.co.il and the form opens with the email address i sent populated into the right fields. The problem is that this way "On User Input" script does not take
How to show filtered child records in parent report
Hi, I have just started using Zoho and am finding a bit of a steep learning curve to really use it properly. I will outline the scenario. I have two forms with column structure as : Form 1 - Id, Name Form 2 - Id, Name, Form1.Id (a relationship is created), status (constant list). Now, I want to create a report on Form 1 which will list the Ids, Names and count of all related records from Form 2 with certain statuses(filtered). The count has to be a link and on clicking the link, it should show relevant
Questions about date/time fields
1. Is there a way to get date from a date/time field? For example - <datetime>.toDate() 2. Is there a data entry control or field to enter time of day?
iCAL Feeds
This has to be my favorite topic! I have finally identified why the ical feed is not fully compliant with many ical subscription services. There's a blog about this here: http://blog.jonudell.net/2011/10/17/x-wr-timezone-considered-harmful/ 1. X-WR-TIMEZONE non-standard advisory timezone property. 2. The iCal feed uses 'floating' time for the events and not VTIMEZONE This is a bug in the iCal feed. A fix would be to use an iCal feed that either does not use X-WR-TIMEZONE and/or uses non-floating
iphone calendar not respecting timezone of ical feed from Zoho Creator
I have been able to subscribe to the iCal feed of a Zoho Creator view in Google Calendar and the events appear at the correct times. (That said, the feed is very infrequently refreshed by GCal, which makes it next to useless for our needs, but I assume that is not something within Zoho's control.) However, subscribing to the same Zoho Creator iCal feed directly in the iPhone Calendar app results in the events all being displayed 10 hours behind where they should be (i.e. UTC instead of UTC +10).
Trigger a Form from another Form (Inline Frame)
I have two key Forms (A) Which is a set of dates with associated prices and (B) A simple form to request a quotation Both forms are displayed on a web page as iframes (one above the other). Ideally I want to be able to select a date form the calendar form, then pre-populate the quote form with the specific data from the calendar form (eg - date, price & location). Whilst I could build a field in the calendar form as a URL to call the Quote form with pre-populated fields, I dont see how I could do
Multiple customers with multiple users at each site
Hello, I am rewriting a program that I have been selling for 20 years and am wondering if I can use Zoho Creator to do it. What I have is multiple sites with each site having multiple users. I need the data from each site to be accessed by only that site but by multiple users at that site. Is it possible to do this using Creator and if needed the Customer Portal? Thank You, Paul
Date validation in a Subform
Dear All, Maybe an easy question but how can I validate, if the date in the first row is bigger than the date in second row then to give me an alert?
Which app to use for Job Applications database?
Hi all, New here, so a real beginners question: I want to build a database to store resumes, which are to be entered through a form (name, DOB, eduction, desired job, etc), so as to search that database later on. My question is which of the available apps should I use for this? Thanks in advance.
URL without any html tags from URL field
Hi, I am trying to extract absolute URL from a URL field. I was trying with below code as refer here. But it doesn't extract exact url but with double quoute ("") in both side like below : -- "www.acrossplatforms.com" expected output should be : www.acrossplatforms.com code : web = input.Add_TV_Website; value1 = web.getSuffix("href= "); value2 = value1.getPrefix((" target")); Please help me to figure out exact code . Thanks Arfater
Do not filter dropdown when Criteria field is Null
Hi, I am trying to create an order form - I have a Vendors, and those vendors offer items, which are stored in Vendor_Items form, using bidirectional (Vendor Items is a subform on Vendors). My subform in the Order Form for Items Requested has Vendors and Vendor Items. I would like to filter row.Vendor_Items by the row.Vendor, but ONLY IF a value is put into row.Vendor. If they have not put a value into row.Vendor, I would like all of the Vendor Items to be available. Is this possible? Any
Order List by more than 1 field in HTML Page
Hello, I have a HTML Page that I am using to generate a report FOR EACH record in my database that match the specified. Everything works fine however I am trying to order the list in by "input.Department " AND "input.Last_Name" Please see below Thank you PaymentList = PaymentDetails[(((Payroll_Period = input.PeriodID.toLong() && Employee.Type = input.Type) && Employee.Work_Location = input.Location) && Employee.Department = input.Department)].distinct(Employee); <-------- this is what I need to
Hide field No working :(
Hi :) I want to hide field when lookup equal specific option. in my case when Account lookup = "Assets" hide "Amount Code in "Account" on user input : if ((input.Account).toString() == "Assets") { hide Amount; } The surprise is No Working
Summary View layout helps resources
Hi Im trying to create an invoice using a summary template. The user help shows a very nicely laid out invoice template but not matter how much i try I am struggling to get things to lay out correctly. Are there alternative sources of help/support that might delve into the layout methods in a bit more detail? Also trying to work out how to create a calculated field so that I can show a invoice total, VAT etc. Thanks
Sub Form Insert code
Hi, I need some support adding subform records through script. would this be the way? motherform_record = motherform [ID=<record_ID to add subform row to>]; insert into moderform_record.subform_name [ Added_User = zoho.loginuser field_1=<field_1> field_2=<field_2> ]
How to pass referer in heading from HTTPS?
I set up some bucket policy in Amazon S3 to restrict access from specific website, in my case from my application in Zoho Creator. I understood that the policy can work properly only from HTTP sites, since the referee cannot be sent from HTTPS as normal behaviour of the browsers. However I'd like to force to open those files at S3 from my links in my App in Creator. Can I pass these info somehow? The below scripts is working if I use my terminal window, so I can say the only thing which is missing
how to take first N characters in each line of MultiLine?
hi there is MultiLine in form for automatic correction of manual input need to check entries how to take from each line first 8 characters? in characters will be text, numbers and " ". these 8 characters will be using in list manipulations - search for duplicates, to correct input data
Mobile Creator
I've been using mobile creator since Pleasanton Zoholics and have a lot of feedback to offer. Where would be best to share with you all my findings?
view filtered by a URL passed paramter
Hi, Is it possible to filter a view with a url paramter for a speciffic field without that field actually being displayerd? for instance, think of a view containing Employee group, Name and Last Name. Say I want to display all the names belonging to certain employee group selected by the user. It is easy to create a URL with the parameter of employee group desired and this way only those names in the desired employee group will show up. The issue is that the employee group has to be displayed for
Change name of choices in a multi-select field without losing data
Hi, I have a multi-select field that I want to change the name of the list of choices, but without losing all of the data associated with the current name. It should just be a "rename" process rather than a "delete and add new" process. Previously, when I changed the names of the choices, any boxes that were checked immediately lost their value. To give you an example, say I have three choices: low, med, high I want to change the names of these choices to: 1, 2, 3 (respectively) But I want all
Problem with subform and ui:add values
Dear All, Let me describe my problem which I have with my subform. As you can see from the image below I have two fields. The first is a lookup field (Excursion_Name) and the second is a dropdown (Optional_Rates1). In the on user input of the lookup field I wrote the following: if (row.Excursion_Name == "Included Excursion Land & People") { row.Optional_Rates1:ui.add("Bus Transfer"); row.Optional_Rates1:ui.add("Guide"); } With that it fills the Optional Rates field with two values. Lets
how to detect duplicates in text lines?
hi need make script which can find duplicates in text lines see example of text in attach there are numbers with dots "344.213.34" and without dots "34421324" at same time and there is about maximum 50 lines in text field using which function can we detect duplicates on validate?
Next Page