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
Display calendar report more than one field?On any chances?
Hello, I have a seminar date form and It has 3 different time value. I want to show these 3 dates on same calendar. What I read that it is not possible on calendar view? I also tried add zoho calendar events but this time I can't add seminar names to event name because It shows only string data :( I also use .toString() expression but This time zoho calendar shows me just long numbers because seminar names are lookup data :( I spent lots of time for this, How can I found a better way instead of
Tip 18: How to add scrollable Add Notes field to a form.
Hello folks, In Zoho Creator, the Add Notes field is commonly used for providing instructions or additional information to users, like to display "Terms and Conditions" or other important info. But how do you add lengthy text to the Add Notes field without making the form too long? The answer is to use HTML to add a scroll bar to the Add Notes field. Follow the steps below to add a scroll bar to your own Add Notes fields: Step 1 Drag and drop the Add Notes field into the form builder and click
Deluge Skript Send Mail by Date
hi, I need a Deluge script that checks on schedule if a date in a form is reached and then sends me an email with the corresponding form title. But I can't get anywhere with the Deluge script. Can anyone help me? I have the schedule already Can someone write me an example of a Deluge script? I dont understand it.
Idea : Creator Apps should be automatically added to Zoho One
Namaskaram. When we create a new app in Creator (if the account is part of Zoho One subscription), then we need to explicitly add the App to Zoho One, by opening the list of Apps and tap on 'Add to Zoho One' option. Instead, it would be better to have the Apps added to Zoho One automatically. Crafted with ❤️ Zoho Gurus | Zoho One Practice Team @ CubeYogi Zoho Authorised Partner | 8+ Yrs | 200+ Projects | 100+ Customers
zoho.creator.getRecords (Using creator name fields)
I have been having a problem for a few days trying to use the function zoho.creator.getRecords in order to pull creator records into zoho CRM. The problem seems to be that conditions entered into the function will not work if they are asked to use a field that was created using the name field in creator. The syntax for the function is given in the help page here: https://www.zoho.com/deluge/help/creator/get-records.html I followed this exactly and found that it worked fine for everything until
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
Can I login customers from a custom mobile app?
We're looking into the possibility of using Zoho Creator as the API for an iOS game that we have. In the iOS game the customers need to be able to login using their username/email and password. After a successful login, they should view records that they previously created in Zoho Creator, if there are records that have attachments, they should be downloaded and displayed in the game. Apparently Zoho Creator doesn't have an API for authenticating customers in third-party apps via HTTP requests. Is
Highlight duplicates
I have duplicate values in cells containing different sets of data. Is there any way to highlight the duplicate values within a column?
Pass Form Text Into Panel
Is there a way to pass values from a form in ZML into a panel? You can access form data but not seeing where if you pass a page parameter you could also pull string data into the panel through ZML. I know you could do this in HTML snippet.
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
Passing values via URL to a Search Field
Hello guys! I have 3 forms: Manufacturers, Products and Production Requests. The form Production Request has 2 search fields: manufacturer and products. Selecting the Manufacturer it will load the products list from that manufacturer into the search field "Product". I'm look for a way to have a button on my report Products to open a new form "Production Requests" with the values of Manufacturer and Product loaded and selected into the search box fields on that form. Any idea about how to do that?
Update dashboard panel with report filter based on value in a stateless form field.
I have a simple dashboard with two panels. First one is a stateless form. Second is a report. I want to filter the records in the report, based on a field from the stateless form. For example, as user select the customer in the stateless form, the report will shows only orders relevant to that customer immediately. Thanks.
Search for Multiple Values In Field
If I have a field in a View called Name, how would I search for records where Name = "Jones" OR Name = "Smith"?
Stepping into 2020 with a new series — Functions
Hello everyone, We hope everything is going smoothly with Zoho Creator. We are now officially in 2020 - a new year, a new decade, and, a new series to look forward to. Yes, that’s right. A brand new series on Functions in our Creator Community Learning Series. Every month we will take you through a different function that you could create on Zoho Creator to automate a workflow or get a task done faster. We'll pick from a list of functions that our users usually execute on Creator, and each post
Help with shipping request form
HelIo, I have a delivery request form, I make a cut of requests every day at 3:00 pm, after this time I no longer attend requests for the next day, in which way I can make an alert appear, when the user later From 3:00 pm select in the field of date and time of delivery, tomorrow, and tell you that you can no longer request that delivery, that you select or capture on the date of the next business day, and do not let it continue filling out the form or not letting you send the form information? until
Changing form back to Creator 4
I have slowly been moving my application to Creator V5 from V4, and I've noticed a lot of errors popping up. One of them has been no longer being able to edit some forms in V4 for some reason, despite not adding any changes. Does anyone know how to revert this?
How to Upload the XML file and read the XML file in Zoho Creator?
Hi I would like to know about deluge script for XML reading . I want to upload the XML and read that XML file with the help of deluge script in zoho creator. Is this possible in Zoho ? Let me know Thanks
Sub Form Calculations
Hay , i have one form(Product Form) in which Sub form comes first with fields:- Product Name (Drop down Field From Diff Form) Price (Currency Field) Tax (Drop Down Field From Diff Form) Total (Currency Field) Under Sub form other fields are:- SubTotal (Currency Field) Price15% (Currency Field) Price18 % (Currency Field) AP15% (Currency Field) AP18% (Currency Field) Total Elu (Currency
Code editor
PLEASE please make this changes, we have lost hours of Code changes because we hit the wrong Save!!!!!!!!!!!! https://share.getcloudapp.com/X6uDLLm7
Next Page