How can I edit the signup/Signin page for Zoho Creator - Customer Portal
I see an option to put header. But, I am not able to update the text on the Signin/Signup page. e.g. I have a restricted portal (dg.culytics.com) and want to update the message, asking people to get on the wait list. Any ideas.
Hotel Management Built in App issues
Hi, 1. There are many flaws in the Hotel management bulit in app.we are not able to completely use it or refer it to cumstomers. 2.(Eg) in the subform the "Mandatory Fields are Hidden" . When I fill the form and Submit, it throws an error that fields should have value. In this scenario how can an user fill the forms?. 3.This app is not full fledged and ready to use. 4.Have you completely tested it and checked or not?
How to convert a number to a string of the month name
Hello, I am using the .getMonth() function that returns the number of the month of a date field. How do I convert that number to a string of the name of the month. Example, how do I convert the return value 1, to display "January" as a string? Thanks in advance!
Offline Access - Not via mobile!?
Hello, I'm looking at Zoho Creator for creating a sales tool. This is so our sales team can generate quotes on a bespoke level when in a face to face meeting with the customer. Our sales team will not have internet access during this meeting, I see you can get offline mobile access, but our sales team use laptops. Is it possible to get offline access via a web page of some sort? Thanks Danny
Pivot Table - Last Entry
Is there a way to setup a Pivot Table filter for the last record, by date for a known key pair? For example I have Lease - Tank - Date I only want to show the last Date for the given Lease + Tank in the table.
Populate a drop down list in one form with items from a subform in another form
Hi all, I'm new to Zoho Creator and could use a little help. I have two forms. For simplicity, let's distill them down to what's described below. The field I'm trying to populate (with Deluge code) is highlighted in red. Form #1: Orders - Client Name selector: This is a regular lookup field that is populated with all the Client Names from the Client form below. I use this to select the Client for whom an order is to be made. - Client Users Names selector: This is a drop down list containing the
Date and Date-Time field need to be unified
Lakshman & Creator Team, thanks for the exciting updates! Proud to be a Zoho Creator Partner for almost 8 years now. Reg the 'Date' and 'Date Time' fields : we need just one field type for both. And in the field properties, I should be able to set the format for display, whether it's only date, or date plus hour, or date plus hour plus minute and so on. The reason behind this : sometimes, when we build apps for customers, the initial requirement might be just to capture the date in the form. But
Being able to use the new 'Search' field against multiple reports
Namaskaram Creator team, I think the newly introduced (Oct update) Search field is a beautiful addition to Creator. As Creator partners for 8 years now, this is one of the features we have been looking forward to. It will be wonderful if the option can search multiple reports, instead of limiting to a single report. Right now, we have report's in-built search which comes quite handy for such use cases. However, in a single page, we might have several reports embedded. In such cases, being able
Autofill a Field on a form based on values stored in a table.
I use Form A to inser data in Table A. Then I have a Form B with two number fields (Field 1 and Field 2). I expect the user to fill the first field on this form (Field 1) and after that I need the form to autofill the second field (Field 2) with the closest coefficient where the Value A <= Field 1. Here the ilustration: Example: if the user types "1.9" on Field 1, I need Field 2 to be automatically filled with value "14" if the user types "2" on Field 1, I need Field 2 to be automatically filled
Form Calendar with multiple dates
I am trying to create a report calendar that displays data with multiple specific dates (not in a date range) I found advice on making a sub-form that holds the date data and creating the report based on that however I don't see any option to base my report on my sub-form. any advice would be appreciated
Variable?
Hello everyone, This is my first post and I am NOT a coder but can sort of do a few things. LOL I'm trying to combine the address fields into one field named "Address". Everything is combining in the address except the "Zip Code" field because I don't know if something needs to go in between the words of the code since this field has 2 words. I'm getting a "null" word. This is my code: mp.put("Address",f.getJSON("Street") + " " + f.getJSON("City") + " " + f.getJSON("State") + " " + f.getJSON("Zip
Obfuscated file export url and report url
Hi Creators, The file download URL, when sent through email or when report is made public looks somewhat like this https://creatorexport.zoho.com/file/[UserID]/[AppName]/form/[FormName]/[RecordID]/[FieldName]/download?filepath=/1234567890_file.pdf However as you can see a lot of information is being exposed to the outside world. Instead it would be better if the details are redacted in the URL both for file export url as well as published report urls , something like this https://creatorexport.zoho.com/file/download/[EncryptedRandomString]/1234567890_file.pdf
Spreadsheet report displayed as normal report
Hi, In one Creator app, when I create a new report as spreadsheet, I can edit in situ every records and fields from the report. Just like spreadsheet. However creating another spreadsheet report from another form of that application, displays a classic List report. I can't edit in situ, and clicking on a record displays the overview panel. I suppose there is a limitation in using a spreadsheet report when the list view is used instead. But I can't figure what: Number of field ? Type of field? number
Pivot Table - Data as a String
I want to use the Pivot to create sheet of values in the past 7 days. I use "Areas" as columns, rows with date but when I put a text field - string in the data, it wants to count it. Is there a way to just display the value?
Multiple form application
Hello, Just looking for the best approach. I spent quite some time figuring out myself but still unsure. Goal is: Application for people creating their CV. We will use the Customer Portal for each user to add data and view/edit their own record. The administrator should be able to access all records. There will be multiple sections, for example: Personal Details Qualifications (with some file uploads) Work experience etc. about 10 sections Prefer building each section in a seperate form to avoid
Report on Page with criteria passed as parameter?
In C5, I want to create a page that serves as a "dashboard" for a specific asset. The page should display all records in a log that specifically relate to that asset (by ID). How do I have the criteria for the reports on the page filter by that specific asset ID, given that it needs to be dynamic? To be clear, it doesn't need to update or refresh dynamically, I just want the page to show all records for a given asset, chosen by a stateless form, or forwarding from a button. My first idea was to use
Scheduled Emails
Hi, If we had a simple order form, where order details were entered, then split in to individual monthly amounts on the form, how do we go about scheduling an email alert when each amount is due? Regards Ben
OneDrive integration with ZOHO
Any movement on this front?
Free Flowing Script editor
I feel like I am missing something I believe I am using Creator 5 In my script editor there is no test window I am new to zoho and an amateur scripter but all the videos I watch online their deluge scripter has far more functions then mine the only way I can test my functions is to include a info line to show the result of my script in the app. I find this very cumbersome. I have looked everywhere for the 'Free-flow Scripting link" in my application but it is not there. Is there something i am
Zero K "exportScript.dms"
Hi folks, I have an application I built years ago that I have not changed in recent years. I decided to export it, but when I go to Settings and click on the "Export Application" button in the upper right, it just downloads a zero K file called "exportScript.dms". I tried uploading it to my other account, just in case it would do something, but it doesn't. Shouldn't it download a .ds file rather than .dms?
Transfer MYOB Essentials to ZOHO?
Hi there, I run MYOB Essentials and want to transfer to ZOHO. I have around 4 years information on MYOB. Can my current customers and all financial info go to ZOHO?
Status Change for Old Records
Hay , Have Form (DAP) with fields:- PA_Name (Lookup Field from Different Form) Status (Drop-down with values Current , Arc) Other Fields On Success of this Form i need:- if PA_Name is already existed in old records than status is equal to current in Current Record. and Status changed to Arc for all the old records which have same PA_NAME Value. How can i achieve this ? Thank u in Advance.
Automate Birthday Wish
Hello, How do i automate birthday wishes on DOB using sms integration. I am gonna use Clickatell for sms integration. Thanks.
Duluge Script Issue - Send Edit Record URL
I am stuck and I cannot get this thing figured out. I have read and done exactly as a couple of posts said to do, but still cannot get the task to work. Upon successful record creation I want to create an email. The email should contain a link to edit the record that was just created so they can fill in their information that I need to obtain. I have the script set to do everything, but the link does not work. I have tried for about five hours different link code, but still does not work. My
Access the screen "Data/Design" after an app is created
Hi, When creating an app from a file the import interface sports two tabs - Design and Data (refer to email below). I see this screen very useful since you can see the columns present in each table, the field type mapped to each column, and the relationships between the tables all in one screen. Is it possible to access this screen after the app is created? Thank you.
Service Failure submission form?
I am trying to make this application work for this need. Below is the scenario I need to perform. I have the first three figured out - done 1) Vendor has a service failure 2) Employee records the service failure using a form 3) The information is sent to the vendor in an email "Service Failure Notification" Here is where I need guidance 4) The vendor needs to open the form (edit available fields) and enter their reason for failure, their name, the date, and their corrective action 5) Vendor submits
Zoho creator compare dates
I'm trying a few weeks ago to do the following without success, if anyone can help me i will appreciate your help. I have 3 forms one is for the employees, second are a list of projects and the third is where I assign an employee to a project. My problems is that when the user try to assign an Employee two time in same dates i need to send an informative messages to the user, without use cancel submit (if i use this line i can see the message but can't save the record) In this form (Assign Employee)
Move record from one report to another
I wish to know how to move a record from one report to another? We have a Documents/Contracts form which contains a file upload field, a status, and a type. These documents update often so whenever we change the status to "Archive" we'd like the record to move to another report. I know we can set filters however we also have an "Account" form and report that we most often refer to. In the "All Accounts" report some entries have many documents/contracts and we wish not to have old expired documents
Insert iframe into page
Hi there! I know this is probably super basic... sory, i'm a basic user. How do i insert and give name to an iframe into a page, so i can then use that iframe as a target to show a report based on the user imput in a statless form inside the same page. I have created th statless form and placed the open url code in a button. That part works great. What i can't or don't know how to do is to create the iframe in th same page and name it.. Thanks!!
Zoho Creator : Dowload file uploaded with Upload Field of a Form (private or restricted access)
Hello, I'm looking for a way to access the data (file) uploaded through the File_Upload field of a Zoho Creator form. Then, I would like to upload this file to workdrive or any third application. I succeeded getting the data with a public URL : "https://creator.zoho.eu/file/<app_owner_name>/<app_link_name>/<report_link_name>/REPORT_ID/File_upload/download/<view-perma>?filepath=/ZOHO_INTERNAL_FILENAME;" So I can post it to workdrive of any other third party application. However, this means that all
Problem while publishing report in Website
Hi, I published a report and used the embedded code in the website but I'm unable to view the report in the website. Please check on this and do the needful ASAP. I've attached the screenshot for your reference.
Page - Element - Data
Hi, Is there a way to take the data from two elements and make a 3rd? For example, Element takes the value of a table for the last month. Another Element looks up a price for the month. The 3rd element I want to multiple Element 1 with Element 2. Another example is Element 1 is yesterday number and Element 2 is today's number. I want element 3 to calculate the % increase or decrease between the two.
Insert Value on "Add New Row" in subform
I have a need to input a date value in a row as soon as as its added in a sub form, see below Link to Form (with subform in it) When I click add new in the sub form, I want the date field to be populated with the next day in sequence, based on the previous record. Which in turn will make the "Day" field value +1 of the previous row. See the attached screen shot of what I'm trying to accomplish. Any help would be greatly appreciated
How to open a pdf file of a view in preview mode?
Dear All, As you can see from the image below, I have an upload file field in which I upload some pdf files. I would like to ask you, is there any way in the view (like below) to open these PDFs in a preview mode? Because now, when I click in the file then Zoho always downloads it. Is it possible to have a preview mode? Maybe with custom action and Openurl??
Lookup - By Two Fields and Sorting by Earlier Dates
I have this lookup. It works except for I can't find a way to ensure I get the date that is previous to the current date. tlRecord = Daily_Water_Gauges[Lease_Name = input.Lease_Name && Meter = input.Meter] sort by Water_Gauge_DateTime desc; input.Previous_Water_Gauge_DateTime = tlRecord.Water_Gauge_DateTime; input.Previous_Meter_Reading = tlRecord.Meter_Reading; Any suggestions?
Google Maps in notes field
Hi, I know there are a few topics relating to my question, but I have a specific problem which I can't find a solution to. I can display a static google map in a notes field but when I try to add a marker to the map no image displays at all. So when I run this everything works and the map displays: addressVar="1600+Pennsylvanian+Avenue,Washington"; imageUrl = "https://maps.googleapis.com/maps/api/staticmap?center="+addressVar+"&zoom=13&size=320x320&maptype=roadmap"; input.map1 = "<img src='" + imageUrl
Value of Previous Records
Hi, New to Zoho and trying to figure out how to do this. I have daily records of fluid level for multiple tanks. For any given tank, I am looking to pull data from the previous days (or could be a couple of days back - last record) for the new entry, so I can calculate the change in levels. For example Day 1 - Time 1 - Tank 1 - Level = 5' Day 1 - Time 1 - Tank 2 - Level = 1' Day 3 - Time 3 - Tank 1 - Level = 6' (what to calculate 1' of chnage) Any pointers or suggestions? Thanks, Chris
'Search' as a property in any field, apart from being a field itself
Search field in the new Creator Oct 2019 update is a welcome feature. Kudos to the awesome team behind such a technically challenging product Image Credit : Zoho Creator team updates post in Community It would be nice if 'Search' could be a feature in every field. We could just switch it on/off in Properties for any field. For example, I might have a field 'Employee Address'. I could switch on search for this field, so that I can search existing records and use those results in the form/report.
Fetch record when data in main and subform are equal or match
Hi I have two forms. One is the mainform and the other is the subform. Main form: Airstrip Profile Fields in main form: Airstrip_name Subform: Amo Profile Fields in subform: Airstrip_Assigned Airstrip_name and Airstrip_Assigned fields are equal. When I edit a record and based on Airstrip_Name in the mainform, it should fetch the record that matches the name in Airstrip_Name with Airstrip_Assigned in the subform. Please can someone show me how its done. Cheers
Automate MS Word templates by fetching data/records from Zoho Creator View,
Hi, We need to auto generate MS Word template reports based on the Zoho Creator View/records on a day to day basis, any suggestions. Sudhir
Next Page