Issue with Fetching Data from Zoho Creator using Custom Outlook Add-in
Hi Team, I am encountering an issue while trying to fetch data from Zoho Creator in a custom Outlook add-in. The goal is to retrieve origin and destination information from a specific report, but I'm facing CORS-related errors and failed requests. Error:
Zoho Creator Widget Update record error 401
This is a widget project, I try to update record.value1 with a popup page, I can fetch data from ZOHO.CREATOR.API.getRecordById but when I try to update record, it show 401 error code with { "status": 401, "statusText": "error", "responseText": "{\"code\":2945,\"description\":\"EXTRA_KEY_FOUND_IN_JSON\"}"
Set Lookup Field to Top Option
I'm trying to set the lookup field to the top option, but I get this error... Is there any way to get around this?
true and false invertion in my script ?!
In the following script to send emails, the true and false condition seem to work inverted. The emails with "false" condition receive email when "true" is in the script, vice versa. Any explanation ? CourrielFerme = "info@fermerondine.com"; Demain = zoho.currentdate.addDay(0);
Gantt Chart in Zoho Creator
Is it possible to create a gantt chart in Zoho Creator? There is one old posting which does not quite answer my question. Here is an example of a Gantt Chart:
Add a MATRIX field to the forms creation
Same as Zoho forms, we need a Matrix field in Zoho Creator forms, is very usefull
is it possible to adjust the date field to show Monday as a first day
Hi, Is it possible to adjust somewhere the date field, so the first day of the week is Monday (instead of Sunday)? Thank you! Ferenc
Ajust multi-line inventory sub-form upon submitting form
Hello, Just need a good start on a script. I have an order form with a sub-form for every line items ordered. That subform source, with a lookup, product details, including actual inventory. Upon submitting the order, I want the quantities of every item
#Zoho Creator - Button Click Function in Page
Hi, I have created a button in my page .I want to perform button click operations. Is there any way to call the functions in the application when the user hits that button?? If anyone have alternative solution for this problem, please help to resolve it.
How can I access the extra properties for "Formula field"
This is a formula field property image. Here, you can see properties like 'Field Type' and 'Display Format in Report.' How can I access this? Is there a way to do so? My question is: Do I need to enable these properties?
On User Input - Display Image in Subform
Hello All, I am creating a Form for Creating multiple product orders I need assistance in displaying the Image of the Product on Lookup Input of Product Name Field
Trying to get the pdf of a form record on button click in a deluge script
I'm trying to send a notification on whatsapp of the pdf version of a form record, for this I need to generate the pdf of a record using a record template in deluge, so i can pass it on to the API to push whatsapp notification. What is the way to do
How can I get the Image or File URL from Zoho Creator to insert into another application?
I've tried retrieving the image URL from my Zoho Creator application to insert it into another application. However, I'm facing issues as the proper image URL isn't being obtained. The same problem occurs with file uploads. I can upload a downloaded image
Date format changed when appended to list
Hi, I have a dropdown list whose choices depend on user input of another field. The following code works fine. However, in our original data, the date format is dd-MMM-yyyy, but when the following code runs, the items in the list become yyyy-MM-dd. Clear
Can I make a client portal so that they can upload/download documents?
Hello Experts I would like my clients to access a portal using some kind of authentification (their email address?) so basically access to their own secure client/customer portal and let them securely upload documents in a folder related to them. so my
Add and Delete Customer Portal user via Deluge
Using Creator to build an app involving a customer portal. I'm trying to integrate the customer portal for the first time and it is raising questions, mainly because it's new territory. Is it possible to add a new user to the customer portal via deluge? For example, if an existing user invites/refers another potential user to try our app, is there code to automate via deluge, setting up an account ready to go for them? The referral would include their email address, and a workflow would set up the
Passing the image/file uploaded in form to openai api
I'm trying to use the OpenAI's new vision feature where we can send image through Api. What I want is the user to upload an image in the form and send this image to OpenAI. But I can't access this image properly in deluge script. There are also some constraints
Sort a Multi-Select Lookup Field
I have a multi-select lookup field coming from one app to another. Currently that lookup data is being sorted on the printed report based on the added time of the form that's being brought in. Problem: I'm ideally trying to sort the lookup data by a field
New Gantt Chart Extension problem with relationLinkName in Creator
I've burned a few hours now trying to solve this one, but no luck and there aren't any posts in the knowledge base yet: Anytime I try to include "subRelationName" the Gantt chart fails (invalid subStartdate and subEnddate). Works if I exclude the "subRelationName",
Developer access
Hello, how can I limit the developer role access level? I want to remove access to all reports.
Integrate with Power BI
Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
Suggestions to Enhance Translation Features in Zoho Creator
The localization capabilities in Zoho Creator are great, and as a partner who heavily relies on them, I’d like to suggest a few improvements. These changes would streamline workflows, save valuable development time, and enhance the customer experience.
connect zoho creator with google drive
Hello everyone, I need to connect to a folder drive. The idea, is that google drive loads a text document with some data, I must read that text document to be able to autofill a form that I have in zoho creator with that data. I also attach PDFs and place
Insert field data on each row of uploaded and parsed content
Hi, On the upload and parse content below, I want to insert data into each row that I need on the parsed input to the other form so the data can be grouped by this field, but it can't be on the uploaded .csv. How can I do this? fileContent = input.Cruise_Sales_Upload.content;
Offline mode for pages based app
Hi community, I have a request for creating an app where users can enter data into multiple forms. Those forms I plan to embed into creator pages. The users navigate throw the pages and can access the forms to enter their data. The use case of the app
Embed detail view of a report in a page layout?
I have a form that allows one entry per user, and a report that only shows the current user's report, so there will only be at most one record. I'd like to display the detail view because it shows the related records. Is there a way to force the report
Update field from second form based on Lookup value on first form.
I'm sure this has been asked a zillion times. I am using Lookup field to obtain a value from a second form. Based on the choice I want the corresponding value for another field on the second form to be input into the field on the first form. I know this is a set value action of some sort but am new to Zoho Deluge and cannot see how to do it or see any build functionality on the field properties to achieve this. Basis stuff but how?
Improper statement line 31 (Highlighted in red) pls help
// Fetch the current record from the AMER form previous_record = AMER[ID == input.ID]; info "Previous Record: " + previous_record; // Fetch the record from the AMER form by its unique ID previous_status = previous_record.Status; // Get the old status
Is there any way to fetch records in ascending order by Name Field?
for each userItem in User [ ID != null ] sort by Name.first_name { }
Creator Offline Form from Record
Hello, We have a list of records that need to be viewed offline. When a mobile user opens the detail view of a record we'd like for them to click a link or button to open a form. For instance. A list of work tickets. The user opens a work ticket offline
SEARCH BOTTON MENTION IN SALES BY SALES PERSON COLOUM
DEAR SIR/MADAM, THIS IS MY REQUEST TO YOU PLEASE GIVE SEARCH OPTION TO SALES BY SALES PERSON COLOUM.
Creating pdf template with pivot table
Hi, I have a form which is a list of customers with delivery dates, more than one date for the same customer name. There is no subform, so I need to do a report with pivot table to make a list of customer with same date of delivery. I would like to create
CORS in Zoho Creator Custom API
I have a Custom POST API in Zoho Creator with the authentication type using Public Key. My team tried to use this API in client service and apparently there's an error with code 2945, UNAUTHORIZED_CORS_REQUEST
Cannot Edit Zoho Creator Apps
Hi. I have been unable to edit my creator apps. When I click “Edit Application” it goes into a loop.
Page variable do not show decimals
I have a variable in a page for a currency amount. The original data is from a form in currency with 2 decimals, and the page variable is indeed a decimal type. But the decimals do not show in the page. The script is : input.FactureDecimal = Administration[Courriel_client
Generate Revision Number in Format 1.0.3
Hi all, I am trying to implement an automatic version number for our management system, so when we make a change, it will go from 1.0.3 -> 1.0.4 and so forth. Can anyone help me with this, please? Many thanks Nick
Automatic import from ini file
Hi, kind a tricky question today. Our client send as record via email stored in a text file (.ini). As per today, we open that file, copy and paste in a ocr field and then processed with a workflow to store info in zoho creator fields. Is there a more
Creator roadmap for the rest of 2022
Hi everyone, Hope you're all good! Thanks for continuing to make this community engaging and informative. Today we'd like to share with you our plans for the near future of Creator. We always strive to strike a good balance of features and enhancements
Post to Cliq only working for me (Top lvel admin)
Hi, We have started sending messages to Cliq to help us monitor things; however, the Cliq messages are only generated when I submit the record as the account holder. If another member of staff does, no messages are sent to Cliq. Am I missing something?
Report access on portal for page only, not sub-menu
Is it possible to give access on the portal to a report on a page only (dashboard) and not in the sub menus ? Having the sub-menu is redundent and useless for me, and it might confuse my customers. I triied many things on the portal permission setup,
Next Page