GPS Link Custom Action
Here's a custom action you can use to make a popup window using google maps void GPS(int zID) { query_address = MASTER_FORM[ID == input.zID].ADDRESS_for_GPS; query_address = encodeUrl(query_address); openUrl("http://maps.google.com/?q=" + query_address, "Popup window"); } I prefered the way the old url builder worked. It took me some time to figure out how to set-up the new url builder to work: Cheers, John Whitney
Need support with Curl API and fetch data for GPS Telematics
Hi I am trying get a GPS Data of a vehicle form its service provider .I have reced a sampl CURL Request. I am new to use this kind of API in zoho deluge .Kindly help me out with a sample code to use the same inside deluge curl --location 'https://cvp.api.tatamotors/auth/realms/external/protocol/openid-connect/token'
Sorting subform rows and display results in page
Hi all, assuming I have a subform like this: row1: a) row2: b) row3: c) than I save the record and open it later for a quick sorting the subform by dragging the rows: row1: b) row2: a) row3: c) Now I have a page that display the results, but in the first
Delete Subform Row (Orphaned Records)?
Hi guys, We have hourly instances where our employees use a parent form with a subform within. It's common for them to remove many of the rows in the subform, leaving behind many orphan records. I want to be able to delete the orphaned records that have
Creator Simplified #2: Effortless Code Management with Deluge Version Control
Hey Creators, Welcome to our next post in the Creator Simplified Series, where we share tips and tricks to make your app development journey easier. In this post, we'll be focusing on an often overlooked but super helpful feature—version control in Deluge.
How can I get emails into a list in a multi line form?
I have a form named company details with a single line field named company name and multi line field named "user email list" I have a second form named user profile. In this form there is a lookup field that shows a dropdown of records of all company
What links customer to their own information in the portal ?
I know how to give permissions to some parts of my application, and how send portal permission link to my customers, but what exacly links my customers to their own information in the portal ? I though it was as simple a recognising the email adress in
Masking phone number
Hi all, I'm trying to mask the first 3 digits of a phone number, like this example: Original: "912384735" Masked: "xxx384735" I've tried use the remove and replace function but with no success. Thank you for your help. Best regards, Rui
Lookup used in an OpenUrl script do not transfer ID ?
Bonjour, Is it possible that a lookup field I use basicaly to open another form and transfer a customer name, with the openurl, do not transfer the ID of the original form ? In a third form linked with lookups, I was not able to retreive the first form
How can I make a Math equation from user input using Zoho creator?
I try to create an app like a calculator in Zoho creator to enable users write an equation with any number of fields and operations how can the user input N of numbers and N of operations to calculate the equation?
PMT Calculation
Anyone know how to calculate a payment on a loan. I have the term in months, annual percentage rate and principal ... easy to do in Excel with the PMT function but in Creator????? I would like to just put the formula on a Form page without having to write any script ... is this possible?
Calendar report - Customizing the view
Hello, My main calendar view will have approximately 80 entries per days (customers will only see their on one entry though). Is it possible to limit the size of the calendar's day box ? Or simply put a number as how many entries are there ? Sylvain
how deluge statement usage limits are count
Hi, There is a limit of 5000 statements in a script, for example when I process an on load or submit script. In an earlier forum post I found this text: But if you have a "for each" loop within your action script, the number of times the tasks are executed depends on "the number of records iterated x the number of tasks". For example, if you have 500 records to be iterated and 3 tasks, the total number of executable statements for this action is 1500. It is not the number of times they are triggered
Need to extract date from datetime field
I have a datetime field and need only the date part from it. I am unable to find a built-in function that would be <DateTime>.Date(). I don't think I want to go the string conversion route of converting the datetime to string and then parsing out values and create a date out of it. Any one out there has a better solution to this? Thanks in adavnce. Regards Moiz Tankiwala Smart Training & IT Solutions
Help with global structure of my project
Hi, I do not know if this is the place for that type of question, if not please tell me where to send this question. I am to a point I need advises on my structure. I have created the basic forms I need in my project, but I will soon get in more complicated
Vertical List
I am trying to find a way to create a list report that is vertical and not horizontal, as most users access my app on a mobile phone and not a pc so they find scrolling vertically more intuitive. Is there a way to do this? I thought about adding a html
Sending newly created record to customer
Good day, Every year clients will need to review and update their company information. I will send them their previous years input and ask them to update it for the current year. I have created a Creator Form that will get created and populated with CRM
Troubleshooting in Creator : New Learning Series
Dear members, I'm happy to announce that, as part of the Community Learning Initiative, we are starting a new series of articles on "Troubleshooting in Creator". The goal of the series is to empower the developer with information that could help him understand
How to rename send mail attachment?
I'm sending emails using "Send mail" with attachments (reports and record templates". Is there any way to rename the attachment? i cannot find it on the deluge documentation. https://www.zoho.com/deluge/help/misc-statements/send-mail.html#creator T
Widget Init Params not working in ZC Mobile App
Hi, I am trying to fetch the Logged In User and show it in a field. I have attached the screenshots for both the mobile app and Web View. As you can see in the web view I am able to see the logged-in user email id but in the mobile app, its showing undefined.
Multi Language
Dear all, what is the best way to create a ZOHO Creator application, which is multi-language based on the Language settings of the User? Thanks, David
Fiverr is better than Zoho Partners
For anyone out there looking for help with Zoho Creator's confusing Deluge, I highly recommend hiring NON ZOHO PARTNERS on Fiverr. I've had much better experiences with those who are NOT certified by Zoho. Almost every single "certified" zoho partner
How to delete a record in Zoho Creator from a Deluge function in CRM
Hello, I've got a Deluge function in the Zoho CRM triggered by workflow with this code, trying to delete a record containing a product code. creatorApiUpdateUrl = "https://www.zohoapis.eu/creator/v2.1/data/xxxxxxxx/yyyyyyyy/report/All_Courses"; payload.put("criteria","(Course_Code==\""
Link in form to open a popup page
Hi all, is it possibile to put a link inside a note field pointing to a Creator Page (popup)?
Integrating ChatGPT with Zoho Creator for Automated Report Generation: Is It Possible?
Hi everyone, I’m currently working on an application in Zoho Creator and would like to know if it’s possible to integrate ChatGPT to automate the generation of reports based on the data captured within the application. Has anyone successfully implemented
FSM via Creator Platform
Hi Everyone, Is this feasible to create using Zoho Creator? We are currently planning on expanding our existing servicing app adding more functionality. Our existing system currently in sync with the Zoho Desk.
Having a label when cursor goes over specific days on date field selection
Is it possible to see a label when the cursor goes over specific days on a date selection of a date field ? For example, if my cursor goes over the september, 17, 2024 (not clicking on it yet), I want a lable apearing "Tuesday - Montréal - 16 h 00 to
Limit to the # of Integration lookups used within a single Form?
Change to copy/paste functionality in Deluge code editor
Recently there was a change to the Deluge code etidor where it now inserts backslashes into strings automatically when copying/pasting strings with double quotes, it's a nightmare to have to go delete all these. Is it possible to toggle this on or off?
Holding field focus
I have validation code in the On User Input section of a form field. If the user does not enter the correct information, I alert them with an alert statement. After that however, the field focus is lost completely. I want to be able to hold field focus on this field until the information is correctly entered. Is there a way to do that?
Push notifications to portal users
Hi all, it is possible to send push notifications to portal users?
Zoho Creator: Sending Approval Notifications via Email
Hi Team, We set a form for Approvals. What we want to do is all pending approval requests (notifications) will be sent via email at 7PM every night. All approval requests go to the "Approvals". In the Approvals, we have "Pending" and "Completed". We have
Not displayed as PDF
Hello everyone, I have a problem, I have a connection from CRM to bring me the PDF file but in the template of my Creator app, it only shows me the name, I want a link or to bring me the file. is displayed as text How do I do it?
How to add Single subform Row of Data based on each input of 1 field (Barcode scan)
Hello, I can't seem to get my head wrapped around getting a subform to populate data another form properly. I seemed to have coded something that technically populates, but it creates multiples of the same data, when I only need 1 row per entry of data
How to add data on behalf of the Customer in Creator Portal?
Hi all, I understand you add the "users" special field to a form and set it to "customer." When the user logs in and adds data, it's private to their login/email, etc. Correct me if I am wrong. We need to be able to add data on behalf of clients daily.
Need help creating workflow
I have 3 forms: Add_Property Add_Job Bulk_Scheduler When I submit the Bulk_Scheduler form, I want a workflow to loop through the Add_Property submissions and find any that match the parameters submitted with the Bulk_Scheduler inputs. For each record
Make a personal calendar a customer can manage himself through the portal
I have 2 forms : A customer form and a subsciption form that states how many weekly deliveries, the week they start and which day of the week they happen. I want to initiate at my convinience the creation of the calendars of my customers (for example
Import CSV and set Added Date
Hello, I was wondering if it was possible to set the Added Date when importing from a CSV/TSV. I had an "Added Date" column with a date, but it didn't get set. So I guess I have two questions: 1) Is it possible to set when importing via CSV/TSV? 2) Is it possible to set via the API? Kudos on Zoho Creator. It looks great. I'm really looking forward to subforms and future tweaks.
debug - where is "view log details"
On the page below, https://help.creator.zoho.com/Info.html it says you can debug a script by clicking "View log details", but where is this button/link?
IOS Portal users - Filter reports not working once I add page script code
I've tried to use background color for one the pages. On portal windows(chrome) and android (app), The report filter is working fine, but on. iPhone no filtering applied if there is a page script (if I uncommon the code) the filter will b destroyed and
Next Page