Can I include iframe in the Exported page as pdf
Am I able to get the iframe preview (rendered) in the PDF export file of the page?
Daily Recalculation of Accumulated Interest field
Dear community, I am new to Zoho Creator and currently running a trial version in an attempt to create an internal management system for my property development company. One part of the application contains financial information related to different development
FInd & Replace
Does ZOHO have a feature such as FIND & REPLACE, similar to WORD ? Search for a specific word or phrase and Replace it with a new word, spelling or phrase? Something in Bulk Edit. In Creator
Bi-directional communication with SAP
Good day, Where can I find documentation on an API / process to allow bi-directional communication between Creator and our SAP implementation? Regards, Jason
Zoho Creator Published Form on Wordpress Page
Hello folks, I tried to embedd a published form from Zoho creator over iframe and with the permalink into my wordpress page but the form isn´t displayed. The frame is loading and says: creatorapp.zohopublic.com has refused the connection. Tried also over
Save PDF Record Template to 'File Upload' Field in Form
CONTEXT I have a Record Template that is used as a donation receipt. As a non-profit charity, it is essential that we have an original copy of the receipt. Yet, the template itself will change slightly every year. For this reason, it is important that
Get Image URL - Can't get it working
I tried to get the Image URL from a field by: https://creatorexport.zoho.com/xappuser/xapp/Orders_Report1/Scan/image/13404324386_Scan.jpg Where /Scan/ is the Image field link name. What is the right URL scheme to use?
Compound Primary Key
I need to create a table of team members and I need to ensure that no team member is entered twice. How can I make the combination of first name and last name unique. Thanks!
Error Occurred. We are sorry for the inconvenience...
I just opened an account and started a sample app and upon doing so, have continually received the following message. Error Occurred. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. I have refreshed and even deleted the app and recreated from scratch but continue to get the same error. I would like to evaluate this application for a non-profit and it appears we might be able to make it work but first impression has not been good. Hopefully there
assignUserInProfile is returning error 'user is not valid'
Hi, Can anyone help with this error. I am using assignUserProfile in a Form for the customer to add Users to their App. However, it is returning the same error 'user is not valid'. I have set the output as a variable to capture in a Form field TXT_profile, but clearly it captures nothing. var = thisapp.permissions.assignUserInProfile(input.New_user,"Write",TRUE); TXT_profile = var; I have tested in both Stage and Production environments and its the same problem. I am not a seasoned programmer, so
Fetch Email Id Associated with Username
I have a form that uses the "Users" look-up field, which is used to assign tasks to registered users on the app. I would like to automatically send an email to the User when he/she s assigned a new task. "Username" is a text string, but I'd like to be able to fetch their "Email ID" so the email can be sent. Doesn't seem like fetch records will work because the User info is not collected in another form. Any solution to this? Looks like I can set the field type to "Email ID" but would prefer to
Print records
There must be a way of printing a batch of records and specifying which fields to display for each record? I have in mind printing to PDF, where each record occupies a separate page. Is this possible?
Address Autocomplete Using Google Api
Hi, I have long been looking for a solution to replicate something similar to Salesforce's Address Autocomplete feature using Google Api. See below image, when you use Search Address, there is a pop up that then uses Google Maps Api to Auto Complete the address, after selecting it, it populates the fields "Street", "City" etc. This is now a default feature of Salesforce and I could only find a custom version of this also for Salesforce https://github.com/benedwards44/sf-address-autocomplete Would
Run an "On edit" action once for all existing records
Hi, I'm looking for a solution to this. Context : I have a field in a form that fetches it's value in another field in another form based on the value entered in another field in the same form. That bit is ALREADY taken care of with a script that fetches
Protect subform row from deletion or modification?
Hi, If I open a form for edition from a report, I'd like to protect existing subform rows from any deletion or modification. New rows are allowed to add. As far as I know it is not possible to disable fields in the subform, and I do not know, if row deletion
Is it possible to loop through a subform and create inventory adjustments in Zoho Inventoy
Hi, I've been programming a while so I'm familiar with all the constructs of Deluge in Creator, but I'm struggling to understand the process of creating inventory adjustments in Zoho inventory from a deluge function in a Zoho creator app. I have a simple
Background Picture in Record Templates
Hey, I´m facing the problem that my inserted background picture is not stretched correct to fill the complete background of the record template. The size of the paper and my exported image are the same but either the picture is too small or stretched
After Submit of Stateless Form....
I learned how to create a Stateless form, with a Submit button, and on-click put data into a Form (in fact, into 2 forms!) I know how to include a Reset button, so the Stateless form clears out, and we can add another entry. I know how to have a message come up that says: - Good job! Your data was inserted Can I have the form close after the data was inserted, and a specific view/report come up? .
Form Field Tab Order
If you want to optimize data entry on a zoho form in Creator, how do you set tab order for fields on your form?
Checking for duplicates in a subform
I have an app with a mainform, and within that is a subform (see screen grab) which contains rows of employee names along with hours worked per day by each. I am attempting to create a validation script which will cancel submission of a new or updated record if a duplicate employee name is found. I've tried a couple of variations by defining a variable and using COUNT, but depending on how I do it I always get an error saying the form doesn't exist, or the variable doesn't exist. I'm fairly new to
How to add record to zoho creator from Github webhook payload data
Hi, I want to use a Github webhook to send data to Zoho Creator. I understand the Github webhook needs a payload URL to send the data to. Looking through community forum postings this URL will be a creator form URL in the format https://creator.zoho.com/api/<ownername>/<format>/<applicationName>/form/<formName>/record
Error at on click script: We are working on giving more meaningful error messages on script failures
I am getting this message in a stateless form. In the old version of Creator errors would show something meaningful info, like a brief description and a line number. In the new version this seems to be all I get. I looked under Settings - > Developer
Accessing widget from Zoho Creator IOS App returns non UTF-8 JSON Results
I have a widget that works just fine on IOS (iphone Safari) as long as I am not using the Zoho Creator App on the iphone (don't have it installed). But if I do install the default zoho creator IOS app and then access this widget from the App, then when
Calculating Time Difference between Date-Time fields in Minutes
Hi everyone, I know that there were a lot of concerns regarding time difference calculation, especially if you want to calculate it in a number field. I went through a lot of articles but I couldn't find a solution that I wanted, I wanted to calculate
Update wordpress database with zoho creator?
anyone here have tried to push information from zoho creator to update wordpress database? i have a plugin for my woocommerce which built under wordpress. i can connect to woocommerce api but the plugin data is on wordpress database.. anyone can shed
"Unexpected error"
Hi One of our customers are reporting that when she filters in reports she gets a prompt saying "Error Occurred. We are sorry for the inconvenience" randomly. I was asked to get some more info from the customer and it looks like it doesnt look like what
eSSL Biometric integration help
Hi Team, we are in need of quick support for us in terms of understanding the biometric integration part.
Zoho Deluge (Creator) developers - how do you organize your environment and code?
I've been doing Zoho Creator/Deluge development for about eight months. I come from a PHP/Laravel background. While there are many things to love about Creator and Deluge, I see two main challenges as my code base becomes larger: Testing/Dev Environment
Please add "Last Updated" to the Functions list in Workflow ( or a least have the same "Created On" column that all the other tabs have
All the tabs in Workflow have a "Created On" field, EXCEPT Functions. Why? Even more useful would be a "Last Updated". Adding "Last Updated" would help code management immensely. Many of us develop using a copy a restored back-up because the limitations
Permissions: Remove Ability to Create Duplicate Record
I would like to remove the "Duplicate" option within permissions for a user, but I'm not seeing that anywhere. Thanks.
Lookup field data in Deluge
I have a workflow email with various field data ... when the field is a lookup from another form the email displays a code number eg 40540007788. How do I get it to display the actual field data from the lookup field rather than this number?
Create chart with html snippet
hi guys, is that possible that we can build a chart with html script? the page chart has quite alot of limitation like height is not adjustable and cant show figure in the chart other than howering the chart. pivot chart not in consideration as in it
Subset Sum solution in Deluge
I'm trying to figure out how to implement a feature that requires the Subset Sum algorithm. Use case is pretty simple--processing a single customer payment against a subset of open invoices, but I don't know which specific invoices the customer payment
Query Parameter not working in Zoho Creator Page Configuration
Hi, I am trying to setup an Action to a Page panel using the Query Parameter option as show below. Test_AD is a field link name. Test is the field name. As shown from the corresponding Form below: As per the link here, we can query the report with a
Auto Increment field with both 1 static letter and 4 incrementing numbers
Short Question: How can I have an auto increment field with a single letter that is static and four numbers that auto increment with each new entry? More Explanation of Use Case: I looked at Zoho a few years ago to replace a spreadsheet we maintain for our car inventory. Each car is assigned a stock number that is a combination of a single letter and four numbers. For example G1441, G1442, G1443 are stock numbers for cars bought in 2019. Each year the next letter is used to start over the number
Field Link Summary Page for Creator
Just an idea to have a page similar to the CRM's API reference page for Creator Forms. Large Forms require us to build the reference table ourselves for third party integrations. The script editor's suggestions in Creator are helpful, but there is no
Import adres field
Hi, Just antoher question, i'm tryiing to import data from Excel but run into the adress field. I like the ZOHO adres field cause of it's map functions. In my Excel sheet i have columns "Street", "Zipcode" and "City". How do i import these into the ZOHO Adres field component? I can import them to a single line component but then i miss the map functions. Thanks Bart
How to check if a String has alphabets & numbers?
Hi, I would like to validate if a string has 4 alphabets and 6 numbers. For example: alphaNum = "BHGU789412" I would like to check if the user has entered 4 alphabets and 6 numbers in the above variable alphanum. Please let me know.
Bug with "For Single Record" & "For Multiple Records"
Hi, I removed "Duplicate" button from "For Single Record" under "Actions" in "Quick View" of a report. PFB the configuration. However, the changes don't reflect in the UI. PFB The changes would reflect only if I remove that button from "For Multiple Records"
Change Ticket Custom Function Example in ServiceDesk Error
I receive the following error when trying to use the example program to change a ticket in ServiceDesk: "Error at line : 17, 'TEXT' can not be cast to '[KEY-VALUE, TEXT, LIST]' for the function 'get'" LINE 17: status = result.get("status"); PROGRAM: //Assigning
Next Page