Filter a lookup field based upon another lookup field in the same form
Hopefully someone can help me. I have 3 forms: Project Info -- contains high-level information about a project. Course Info -- contains information about each course associated with a project. There may be multiple courses associated with one project, and each course MUST be associated with a project. The Course Info form contains a lookup field which points to Project_Name in the Project Info table. Task Manager Test -- In this form, I want the user to be able to first select a Project Name. Then,
Inserting fields into an email
I have two questions in regards to inserting fields into an email. 1/ Is it possible to only include part of an email if a field is NOT empty. For example, I would only like the part circled to be included in the confirmation email if the customer has
Deluge script to input initial value to a rich text field
Is it possible to write a script to input a snippet of html code as an initial value to a rich text field on load of a form. I am using the field to write an email and would like it to have a html email signature already there each time that the form
How to print / Export QR codes
I am working in Creator on a fixed asset tracking app. I can scan a pre-printed QR code# label to attach to the asset, Now I want to export that scanned QR code # back out as an image so i can print a copy of the QR code in a report. Thank You Terry
Auto populate subform row field
Hi there! I am having trouble working out how to write script to auto-populate a field in a subform based on the input of another field in that subform. I wrote the below script but it only seems to be applying to the first row I add to the subform and
Script help
I am trying to input a field in a subform depending on whether or not another form (Complete_a_Waiver) has previously been completed with the same first name, last name and DOB as the row in the subform. If yes, then it will input as yes, if no then it
difficulty downgrading to free version
I signed up to Zoho Creator to make an online membership database for a not-for-profit organisation. I had visited www.zoho.com/creator/index.html and clicked on the hyperlink: Create Online Database for FREE! but when I access my account settings page, there is a red banner at the top of the page that tells me that I am using the "Enterprise edition", and that it will expire in 15 days. I tried to downgrade to the free version by following the link. Doing this takes me to the subscription tab, and
Pop-up ads?! Seriously?!
This is a paid service. Why the hell are annoying ads being displayed on screen when I'm trying to work? Is there a way to disable them?
How to retrofit a staging/development instance of Creator then push updates to production
Hi! I'm completely new to Zoho Creator and have been inducted (but not trained) ;-) into working on it. We have LIVE forms and updates need to be made to them. Even an experienced worker (I wish I was) shouldn't edit a production instance on the fly.
Show Payment Method
Hi, I'm new to zoho, and I have a question. In the invoice format, I put a field called payment method. If the customer chooses cash, a tendered field should be displayed. If the customer pays by card, the credit card type field should appear. I already
Has Anyone created an App to keep track of coaching clients
Has anyone ever created an app to keep track of clients, either professional or in my business, for coaching. Most apps on the market seemed to be a massive overkill and designed to do everything. I just need something that creates client records for
Report Action
I have a report (Add_a_Student) action that takes the user to another form (Send_Email) and inputs the record ID from the report record into the new form. On load of the new form the original record from the report is fetched and the email field from
how to create simiple vin decoder
looking for build something that basis the vin number for a vechile off this information only http://www.nissanhelp.com/diy/common/nissan_vin.htm is there a way to build my own vin decoder app? where would i start?
Multiselect field insert field to email - new line each selection
In my confirmation email, is it possible to have the field come over as a new line list for each multi-select selection by the user. Email set up:
Creating a live feed for an iOS app to pull from
Hi there, I've set up a database and need a URL for it that I can ping with my application to pull down new entries. How would I do this? I just want the address for the XML basically so that I can point my app at it. Thanks! -Dave
How to update an integration field from another integration field
Inside a form I have 2 integration fields of the same CRM module (Zoho CRM, Products Module). The one integration field with name 'Integration1' gets all the 'Product Name' and the other integration field with name 'Integration2' gets all the 'Product
Send SMS via clickatell
Does anyone know if there is a simple way to do this like the script below for people that signed up for Clickatell after November, 2016. The note reccomends using the invokeurl task but that seems to be so much mor complicate than this simple script
Project Creation Using Template ID and Field Name - Function
I wanted to share my successful function that associates a Project Template ID to the auto-create Project Function. I could not find it in my own search, but did realize what I was doing incorrectly so below is the correct function code in case anyone
Zoho Creator and the introduction of new features(Blueprints)
I don't understand the reasoning behind the new feature of Blueprint, I cannot help but be disappointed that it's release has a higher priority than some updates to existing features which have been promised but not delivered on. There are 2 that spring
Lookup field filter
Can anyone see what I am doing wrong here? When I first load the page the filter works, but if I change the date it puts the word "null" in front. https://www.loom.com/share/dbb4bd9d004244ff97737bba01b9dffa
Zoho Creator Api V2 - How to phrase muliple "does not equal" criteria in the request
I have a data source where I want to return everything except records containing two specific codes. The field "customer_tlr" is a single line box - not a dropdown or multiple select. I have tried the following : These only exclude the first value app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!="ABC"&customer_tlr!="DEF"
Conditional formatting with function call
Should it be possible to have function call like this, here copied from Application IDE: conditional formatting ( "New Formatting" { condition = (Formula == thisapp.Sjekk_sub(input.ID)) fields = [Navn] format = "color:#ffffff;background-color:#e84c3d;"
Message Box?
Hi, Basically, I have a form with a lookup field. If the user selects an item from that lookup field that has a "*" or if the user selects an item that is not "online" I want Zoho to display a message box saying "You have selected an item that is not currently available, please go back and select one that is 'Online'". Is there anyway to do this? I was able to do something along these lines via Visual Basic using MessageBox codes, but I am not sure how to do this with Zoho Creator. I do not see any
How to Control Browser List View Column Width in Creator 5?
Since I migrated to Creator 5 some, but not all, of my old reports no longer auto-adjust their column width (originally in Auto mode) properly in List View, jamming 3-4 columns to the left of the browser window and keeping exceedingly wide columns to the right of the screen (see attached screenshot). Any manual adjustments to fix it do not stay and are lost on the next screen refresh. In the Creator knowledge base there is an article on how to change column properties from Auto to fixed width, but
Fill Field From Multi-select Lookup
Hi, I want to fill a field called "Artists" (string) based on every-time I update a lookup field called "Artist_Name". So far I've tried several things similar to this: For every artist in Artist_Name{ Fetchartistname = Artist_Name [ID == input.Artist_Name_Lookup] input.Artists = Fetchartistname.Name; } All I've been getting is my Artists (string) field being populated with the same name no matter what name is chosen in the multi-select lookup field. For instance: The lookup field has "Judas Priest"
Search with report below
See attached image. I'm sure I've built this wrong, but it gives the idea of what I'm looking for. I built a page and put a search widget at the top - where it says "PO#" is a search box, with a report widget below. When I search, it takes me to the report
Deletion of individual prices
I have , a sub form in main form with the general services, and medical services and their costs. their addition reflect in to total. sub form all rows addition shown in the grand total of main form. i am getting deletion of row. and i am not getting
Date Field Calculation / Today Function in Creator
Hi, I am trying to calculate number of days items are in stock. so in excel formula would be: today() - Stock.indate. I have two questions: 1) Is it possible to use creator to reflect Current date field in a column of a view. So it will always show the current date 2) In Creator's report, can i do a date calculation similar to excel = today() - Datefield Can you please provide some guidance. Thanks, DC Zhong
Printable Manual for Deluge Script and ZOHO creator?
I know his hs been asked before, but was wondering if there has been any progress on a downloadable (PDF or other) user and reference guide for ZOHO Creator and Deluge Scripting? It is cumbersome to have to keep refering to a wiki or other online source to learn the scripting language versus studying an actual hard copy manual. Guess I'm old school and prefer the printed word.
Get Data Type from Variable
I have looked through the documentation, but have found nothing on checking the data type for a variable. How can I determine if a variable is a map, or if it is a list, (or neither)?
Auto fill a multiselect field (that is also filtered) based on another fields selection
In my form (Add a Students Financial Information), I have a lookup field called "Students Name". I would like another field called "All Teams" that is on the same form to auto-fill based on the selection from "Students Name". I want it to auto fill with
Hiding HTML Snippets on Zoho Creator Pages
I want to add some more HTML snippets onto a Zoho creator Page so that I can show the state of progress within the customer journey depending on the services we are providing for them. My question is, I have the snippet object working fine but when there
Filter for a lookup field: Value in field cleared on Edit
When I edit a record with av lookup field with filter based on an other field in the form, the field value of that field is cleared when form is loaded. Is there any work around to secure that the vaule is kept in the field?
Menu Bar Search Element
Would be fantastic to have a Search Element on the Menu Bar.
Search Records by Criteria
Is it possible to use url params to hide/show fields on the Report Search Records? For example, Form has three fields (Name, Phone, Address). Report has three columns (Name, Phone, Address). User is viewing Report and clicks the Search magnifying glass
Parse Full Name Field to First and Last Name Fields
I have data coming from another system as Full Name (e.g John Smith) that I need to parse to 2 fields, First Name and Last Name (e.g John, Smith). Is there any "easy" way to do this with a formula? I thought I could just look for the first occurrence of a " ", but 1) I cannot figure out the formula or function to do this and 2) this does not handle situations where the are multiple spaces in the name (e.g Mary Anne Van Der Beek - Maria Anne (first name) , Van Der Beek (Last Name)
Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Custom redirect on logout from customer portal
When a customer signs out of the customer portal, they are redirected to the customer portal sign in page. I would like to redirect them to a different page. This thread shows how it can be done with a separate button - at least from the main service (rather than the customer portal) https://help.zoho.com/portal/en/community/topic/customize-sign-out-button - thanks John ...but I would like to redirect from the standard sign out link in the top right of the customer portal. Thanks.
Can I get the top search bar back?
Our Zoho was force upgraded to Zoho 5 which removed the search bar from the top of the screen and it's now a pop-out from the right of the screen. Not only that, when searching multiple fields we now have to "x" each parameter to start a clean search
User nickname?
Hello, When I'm using Zoho Creator apps, is seems I have a username "Zoho_lien", while my username should be Joshi Boomputte as it is in the CRM. How can I modify this please ? Thanks
Next Page