Bi-directional Multi-Select Lookup
I am trying to add a multi-select lookup field to a form by selecting the bi-directional relationship check box in the related form. I select ID as the related field and select multi-select as the display type but the field that appears in the other form is not multi-select. I have achieved this without problem before; what am I doing wrong?
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"
App wont duplicate
Hi I cant duplicate the following app, i have enabled support Thanks https://creator.zoho.com/mrcomputer/signedfast P.S. this is urgent
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
can't receive emails !!!!
hi there ! is there any one know or simply help me with that thing... i had setup every thing in my zoho domain email and sometime i try to send an email from my gmail and outlook, i receive those email some time but whenever i try to send the verification code from mailchimp to my email i receive nothing... please any one know how to fix, i have done this for more than 48 hours & still unable to receive verification code from mailchimp... thanks in advance
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
New ZC Variables for the iCAL Feed
I have tested various popular services that support ical subscriptions by url: Google Calendar, ZOHO Calendar, Famundo, PHP iCalendar, and k5n Webcalendar. Google, ZOHO and PHP iCalendar adjust the displayed events based on a selected timezone. Famundo and Webcalendar take the timezone from the ical's feed. All services use the original Creator view name for naming the calendar. For greater compatibility, I'm proposing two new ZC variables for the construction of the ical's url. ZC_timezone overrides
Support Specified UTC Timezones for iCal Feeds
ref: https://help.zoho.com/portal/en/community/topic/new-zc-variables-for-the-ical-feed ref: https://help.zoho.com/portal/en/community/topic/support-named-calendars-for-ical-feeds Please add a new user-definable variable for constructing an ical url that enables the definition of a calendar's timezone. Currently an ical's feed value for X-WR-TIMEZONE = UTC. I understand this offers the possibility of portability for the ical feed, but I have found a number of ical parsing calendars that fail to
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).
Always show record count
Hi, Is it possible to change the default view in any report to always show the record count? Right now it says "1 of Many" and I have to click on it to get the full number of records in a report. This makes no sense to me - why do I have to click to get the total number of records currently in my report? I'm a new Zoho Creator user with little to no coding experience, so I appreciate any help or explicit instructions! Thanks!
Error in Add Record Script
I am trying to create a record automatically in a form 1 by looking at records in form 2 that don't exist in form 1. I wrote this function (CreateClientIfNotExisting): Which is called by another iterator form called UpdateClientsFromKYCs as below. But I keep getting the following error: I don't get any additional info on what the error could be. Kindly help. Piyush
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
Some Organization Users See a Different Home Page
My home page looks like this: Some of my users not see the "shared with" dropdown. This is what they see: I think they accidently signed-up to the free creator version rather than thru my group invites. Support: If any users under the domain @siigroup.com have a free creator account, please terminate the trial subscription. This should give them the normal homepage above. It's causing lots of confusion about where our application links are! Thanks John Whitney on behalf of SI Group
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
Create Pivot Table rpt always displaying specific date range
Hi, is it possible to create a pivot table report that always displays a date range between days of the week? I would like to create a pivot report that always show the records between Friday of last week and Thursday of this week without specifying date Ranges. I would like to embed this report along with other summarized data in a stateless from as a Dashboard. I have the dashboard configured the way i would like it so I just need help figuring out how to automatically display Thursday through
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?
Oho Creator Image Size Limit
We have a real issue, our Zoho Creator form can only allow images to be uploaded that are less than 1MB in size. No one notified us of this, yet we require high resolution images to be loaded into the CRM as part of a form we have created. We do not store the images, but require them as part of an application process. Is there any way we can increase the 1MB allowance for images because it's a fundamental part of our business? I don't understand this limitation as 1MB is such a small file size.
Fetch Records dialogue box loading problem
I experience a problem every time I try to drag the fetch records in script builder...the odd thing is that it only happens the first time I try. When I reload the page then it works, but when I try the first time, the screen goes dim but no box shows and I am unable to do anything except reload the page. It seems to happen each and everytime. Now I realize I need to save my work before I try to add a fetch records line, at least on the first attempt, but sometimes I forget and end up losing work.
Importing Zoho data tables into JMP
Is there a way to import the Zoho data tables directly into BI applications like SAS JMP. I know I can be exported as CSV file and then read into JMP, but I am looking for a way to directly access the data using something like a ODBC connection
Cannot change primary email
Hello I am logged in as our administrator, but when I try to change the email address of the adminuser (the address we want our customers to see on automatic email notifications) it tells me to contact our administrator eddy@habidapt.com. I don't understand as I am logged in as eddy@habidapt.com. Advice please Screen shot of the error Thanks Kirby Wanner
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.
How to change address of application?
Hi, I just created a new application on Zoho Creator, and the link to the application is https://creator.zoho.com/douglas42/<application name> I never choosed this douglas42 name. Can't I change this name to another one? More pleasing to the eyes of the customer?
emailing attachments help please
Hi Within my form I have a subform that holds uploaded documents, PDF, DOC, JPG doen not matter what format. I do it this way so I can upload multiple files. What I want to do is send an email from within my form and attach the document stored in the subform. What do I add here The document subform is called Files The field within the subform is called Documents So what do I add, anyone know please sendmail ( To : input.Agency_Email From : zoho.loginuserid Subject : "Message
http://js.zohostatic.com/creator/ZOHOCREATOR_Aug_04_2009/js/zcliveapp.js
A javascript error here: http://js.zohostatic.com/creator/ZOHOCREATOR_Aug_04_2009/js/zcliveapp.js is preventing all of my team members on Windows Chinese OS to fully load the pages. They are all located in China
New Form
If in a form(Form1), if I select Yes for Order_Complete, I want a new blank form(Form1) to open to take the new order. Can someone help?
dynamic picklist from mutliselect field
Hello, I have a question if it is possible to create a dynamic picklist when choosing from a multiselect field. In more detail, I want to classify the industrial sectors a company belongs to (using the european NACE codes). When selecting multiple sectors, a more detailed list of more specific sector criterias should emerge in a new multi select field, but only options that corrspond to the selected sectors that have been chosen in the first place. I have 4 forms: industrial_ sector_level1_form Field: level1_sector
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
How do I search with multiple fields (free version)?
I created a simple database, and I want to search for relational topics in a category drop-down (or if then) approach. I only see a simple search box, but I want a complex way to search for my data. I want to search for Student Age: (drop down to age I want to choose: 13, 14, 15, 16, 17, 18+), then Pregnant: (drop down to yes, no, parenting, no children), then to Housing: (drop down to foster, group home, family, friends). I don't know how to find this search, but I signed up for ZoHo because it
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
Next Page