Return the last 2 letters
Hello, How can I return the last 2 letters of a text field (Abcdefg...), where the total number of letters are unknown. Thanks
My Email is going in SPAM of Recipient Email box.
Hello Respected Members , I have an problem which is coming from some days, it is not come when i am beginning my application. The problem is that the Email function (Which is added to the Form). It is confirmation type mail which is delivered to the Form Submitted user. But these days every generated mail is going to the USER'S Email Spam folder, instead of Inbox. Now please tell me what can i do so my mail is go to the inbox instead of Spam folder Please solve my problem , my many users are report
default view filter and/or removing view criteria
Hello, I have a view that I want to be filtered by default rather than having to open the view and then select the filter from the dropdown. Right now I'm using view criteria to restrict what records are displayed, but I don't see a way to turn this restriction off while accessing the view. My only alternative, and correct me if I'm wrong, is to have a view for each criterion and not rely on filtering— problem is, this is pretty inefficient. Any ideas? Thanks.
Display Multi-Select Field in HTML page
Hello there, I'm trying to show/display a multi-select field in a HTML page. Below is the code i'm currently using. <%for each task in job.Task {%> <h4><%=job.Task%></h4> <%} This is how it ends up displaying: <h4>3094299000000125003,3094299000000125007</h4>But I need it to display like this: <h4>3094299000000125003</h4> <h4>3094299000000125007</h4> If anyone could point me in the right direction that would be smashing. Thanks, Giles.
formula field to create a dynamic, conditional link. is it possible?
I am trying to use a formula field to create a dynamic, conditional link. I want to check to see if an organization has any members and if so display the organization name as a hyperlink in a view that links to a summary page for that organization. If there are no members in an organization, the organization name should appear as simple text (no link). I can get each step of this process to work individually but putting it together doesn't seem to work. Am I doing something wrong or is this just
Map Limits
I am no longer allowed to update a map. Is there a maximum number of characters or items that can be held in a map? or The map is being held as text in a multiline field in order to be used at a later stage. Is there a max number of characters allowed in a field. Thanks
Barcode Generating registration form
Folks, i am new to zoho with non programming background, i want to create a simple app user view 1- when a user tries to submit a registration form its sends user back with his registration details and a barcode which contains his name, date of birth, and unique membership number. 2-user can log in and edit his details any time member fitness center - can log in and update their store details and add fitness trainers details -any user on my site can enter a podecode and see nearest fitness centre
Zoho Creator Workbook Outdated?
Hi everyone, Very new to zoho creator so I started working through the Zoho creator workbook. https://www.zoho.com/creator/help/tutorials/add-business-logic.html Just got to the bit to add business logic. It seems that the way the creator works with deluge is different to how it works in this tutorial. I have tried to fill in the gaps but keep getting the following errors... So I removed all business logic to restart the tutorial but now I get the following error hmm can anyone help. I've copied
Limiting options in number field
I have a number field, and want to use it in a calculation. Is there a way of scripting to limit the input to 1-5?
Subform formatting using new UI is a mess
I am trying to customise the size of the fields within a subform. For some reason, the titles adapt to the entered size, but the input field seems to default at 150px. I've tried this on Chrome and Edge and it does the same thing, see the image below for an example. This really limits the usability of the nice new UI. Help!?
Request: On forms, for "URL" and "File Upload" fields, add a way to OPEN from the form
On forms, for "URL" fields, and "File Upload" fields, please add a way to OPEN the link or file while on the form. For files, next to "[change]", add "[open]". For URLs, near the field, add "[open]". ...or any other method deemed best for the UI. Thank you!
Custom function
I am looking for help with a custom function that will do the following: Look to see if Report B contains any products from Report A and then delete any product records from Report A that havent been used. There could be more than 5000 products that need to be deleted. Thanks in advance Sean
After baihui.com transform to zoho.com.cn, Can't import file!
After baihui.com transform to zoho.com.cn, Can't import file at "https://creator.zoho.com.cn/appbuilder/bobmai/hanguhis/form/new" click "import file " , then the page hungup . ------------------------------------- Another way: same failed. download "baihui-migration.exe" from page: https://statement.wiki.zoho.com.cn/creator/ms-access-and-excel-migration-tool.html run this migration program, after click " upload ", show error messages: "problem encountered while creating the appication null
sync existing data base with customer portal users
Hi, I have an empleoyee report, with the information of all users in the company, among this info there is an email for each person. Now I activated the customer portal, in order to create an user for each empleoyee, what I am planning to do with the same emails in the empleoyees records. It tis possible to sync the users I create with the info already existing in the report? So far, I created just one user to test this with no success. I create the user, set his profile to be able to view only their
purchase order and purchase request
Hi, I have a Purchase order form, that works really good. There is a subform in this purchase order with the following structure. Reference (lookup to Product Catalogue) Description Cost Quantity tax Total Cost Status (dropdown with 3 choises: approved, disapproved and pending) Now, I am working on a Purchase Request form that has a subform with this fields. Reference (lookup to Product Catalogue) Description Quantity Status (dropdown with 3 choises: approved, disapproved and pending) I would like
Relation between forms
Hi Zoho Community I need some orientation creating relations between forms in my app. I will explain you what I have and what I want to do. I have a Catalogue, where my products are. I have Purchase Request form (PR), trough this form all departments in the company request the products they need to the purchase department. this form(PR)has a subform (PR Detail), that has a Description field, which is a lookup field to the Catalogue. It also has quantity field and Status field (dropdown with 3 choises:
Print and PDF buttons on Page not working
I've created a page and enabled Print and PDF under the Header Option. When I render the page and try to click on either the Print or PDF buttons nothing happens. Is there anything else I need to turn on to make these buttons work? Al
User initiated Sync between Creator and Reports?
Hi, I store my creator data in Creator and then sync a lot of it with Zoho reports. I then display the advanced reporter dashboards i construct back in creator. I often use the sync time of 1 hour due to customer requirements. Some clients want the sync to be almost "realtime". I know i can code a stateless form and store the data directly into reports but i'm trying to avoid that as its just added complexity i have to deal with. So my question is .. is it possible to have a script such that it
How can I change the "displayname" which is displayed on the top of the form on edit>on load, dependant of the view which is editing?
I want to give different "displayname" to the form depedant of the view I am editing. Is it possible? Thank you.
Count records and display in html page
Is there a simple way to display the number of records from a certain form/table into a html page? Eg table Contacts: var x = number of records in Contacts <h1>Currently x records in Contacts</h1> Thanks for any tips
Getting started with variables
I have been using a different RAD tool for a few years and am looking to move across to Zoho Creator. Everything is working fine but I just need some help to get me started on variables. I have a report called Assessment_Plans with the headings: ID Assessment Plan Assessment Plan Date I want to be able to add a custom button on the report that when a row is selected the ID of the that row will become a variable. I then the user to be taken to another report where they will see only records relating
Barcode Scan Record ID
It looks like record IDs are 19 digit numbers. When using the IOS apps (iPhone and iPad tested) it will not scan barcodes that long. Most I can get it to scan is 11 digit numbers. Is there a setting to restrict the number of digits assigned to the record ID when created? Or maybe someone can tell me about the structure of the record IDs? We only have 140 records so far, but they all start with the same 14 digits. The first 8 digits being 3014701 followed by 7 zeros. This leads me to believe the
Billing History
How do I access my Zoho Services billing history?
Is your software able to implement this case?
I have the synonym database, including 2 tables: words table: id (int) word (text) synonyms table id (int) word1_id (int) word2_id Several notes 1. Columns word1_id and word2_id are id-s of words table records. I know that it is not the best solution for this specific task, but it is just the example. 2. Synonyms table cannot include two records with the same ids of both words (at least in the same order). I want to have one or several softwares (or online services) which makes possible without any
Links to other 'filtered' reports from current report
Need to have links in reports that will take me to other 'filtered' reports. See the attachment that shows an example of what I'm trying to do. The cells that are underlined can be clicked and the app will take you to another datasheet that is filtered according to the cell that was clicked. New to Creator and need to know if it has this capability via scripting? Thanks!
API - "New Application via .ds" OR "copy existing application"
Hello, We need to be able to make new configured instances of an app for clients. Currently this is a very manual process. I want to be able to automate the creation and configuration of these apps for clients. Ideally the API can be used. But I can find any "New Application from a .ds file" command via the api. And the https://www.zoho.com/creator/help/api/rest-api/rest-api-copy-application.html method is marked as deprecated. Is there any api method available to make a new application from a
Posting to a web service using JSON
Hi I have a job to do for someone and it's a new area for me. Can someone help, or take the job over please? Background: Source data in a simple table in a Creator database. Records added manually or via CSV import User wants a button on a View or on a Creator form that can post to a web service, using JSON We have the web service URL and it uses Basic authentication, for which we have the credentials The JSON format has 4 parameters: { "requestId":4, "cleardocsOrderId":1000000462, "status":"registered",
Shedules Settings Issue in Zoho Creator
I'm using Zoho Creator and want to add rules to trigger an email notification whenever one of these criteria is met: 1. It's 7th day after the date recorded in death_date field, which is Date-Time type field 2. The 40th day, respectively 3. And one year past after that date I want the system to send reminders in form of email notification 2 days before those specified dates. I've created some schedules (see screenshot): But the Form and Field fields are inactive, so I can't edit them. And here is
Message Box function
Please provide a function to display a message box, ideally of the CSS later type rather than JS. EDIT: oops, I meant the "CSS layer type".
Making Groups of 5
Hello folks, I just joined zoho and started a creator app in hopes that it can help my online gaming guild quickly and efficiently create groups for certain events we have. I created a form and report already. The report has 13 columns. The first 3 are just text fields that will rarely ever change once entered. Columns 4 through 12 are number fields. Column 13 is a total of 4-12. This total represents the total number of an in game item that the player has in their possession. The next part of
Problems importing data
Hi, I´ve been trying to import a csv file several time, trying different configurations in excel for the columns, with no succes. the file consists of several number and currency columns. the problem is that in the same column there are numbers correctly imported and wrong numbers, I have no Idea what could be wrong. I am trying to import numbers like this: $ 40.767 some of them import properly, but in many rows I get numbers like this: $ 4.076.666.667 Any help will be appreciated
Help to enter A picture!!
I want to upload an image to an html page but for them it must be housed somewhere but that's what we do not know how to do, I 'm driving this new platform , thanks
Zoho creator is fantastic, Zoho Support sucks. (took 20 days to fix a report data issue causing by wrong email format)
Although I appreciate zoho creator product very much and have been used it for years. I have to say I had terrible experience with Zoho support for this ticket 11000574. There was the data issue in the report causing my major reports not working. The issue was created May 15, it was not solved until June 3 when I bring it up to the Live Chat Support and asking for an update. The cause of the problem is simple, in one specific record: Email was entered as : xxxxhotmail@.com, which caused report
iFrame Embed Show/Hide Not Working
Hi all. I am embedding one of my Zoho Creator App forms into my GoodBarber App. I have published the app and when I embed the iFrame code, the fields that I had set to "Hide On Load" all show up. Any help figuring this out would be greatly appreciated.
how to add 2 form data in another form or pages?
I want to add the Lead and Account Data into Another form or Pages in ZOHO Creator. can anyone guide me how to achieve this.
Updating checkbox values on user input
Hi Zoho, I have a checkbox field with 5 items in my form. I'd like to add an "Import all" option. I've added a "Import all" item to the checkbox list, and added the following script to the "checkbox field -> on user input" on the form script: if checkbox_field.contains("Import All")=true { checkbox_field.add("element01"); checkbox_field.add("element02"); checkbox_field.add("element03"); checkbox_field.add("element04"); checkbox_field.add("element05"); } if checkbox_field.contains("Import
Change Customer Portal URL
I cannot change my Customer Portal URL? Can someone help me?
Failed to add data
I am entering data via my forms and am getting a failed to add data error Application: https://creator.zoho.com/essistmgmt/assets When I close the form and resubmit the same information, sometimes it saves successfully after 3 attempts. Other times it works straight away. The forms are not behaving consistently. Forms where I have seen the error https://creator.zoho.com/essistmgmt/assets/#Form:TELCO_SERVICE_ORDER https://creator.zoho.com/essistmgmt/assets/#Form:CONTACTS https://creator.zoho.com/essistmgmt/assets/#Form:ASSET
Question regarding Advanced Display Field
Hello there again, I am new to the software but I am enjoying playing around with it, I was wondering if there was a reason as to why I cannot delete one of the fields on this form. The error message is as follows; "This field is referred as display fields in the following places. Please remove them and then delete this field." "Advanced Display Fields" "1.Customer Contact List - Asset Manager - Sales Order No." I can't seem to find the relationship, if that is indeed the problem. Thanks in advance
Fetch and update
Hi everyone, I have the following code, but it only updates the first record of Cost in Costings. I need all price.Cost records to be updated. Can anyone help? //Fetch all records from Costings that match the Item Number and store them in a variable price. price = Costings [Material.Description == input.Description]; //This might be the problem or the previous line of code. Should find a solution in order to update all records. At the moment it only updates one of the records (the first one).
Next Page