Follow lookup field link in subforms or reports
What am I missing here - there appears to be no way to drill into a record linked to as a lookup field, either in a subform, or as a column on a report. How is a user supposed to be able to quickly navigate through related records? Please add a magnifying/drill into button next to lookup fields, or make lookup fields displayed in reports a clickable link. Please refer to the attached screenshots - as you can see I can create Master/Child set up but then there is no easy way to drill into a child
Is there a way to have zoho connections use the logged in users information instead of posting as me?
For example in my Creator App I have a few OAuth Connections that I created to link different Zoho Apps. The "System Connections" perform as expected, where the Logged in user is the one who posts the content. However, for any non-system connection everything
Custom action or link in related block in detail view
Hello. I have a detail view of a report where the subforms of the main form appear as related blocks. I would like to create a button with a custom action for each record in the related block or a link that would open the report for that record but it
INSERT IMAGE IN FORM AND WRITE ON IT
Hello, I have a vehicle transport company and I want my drivers to be able to use Zoho and complete a photo of a vector vehicle. The idea is that they can put symbols or letters (X damage, E dent, B Dent) on the image. Do you think its possible. How to
How do I get a hot link to and an updated field to be send via email
So when I new record is created there is a url shortcut to the new added record, thanks :)
Link Images to a Excel Report
When I export to a spreadsheet. How do I get it to create a link that goes to my image. Right now it shows up in Excel as: /sharedBy/appLinkName/viewLinkName/fieldName/image/1510098844838_Image_07-Nov-2017_18_54_03.jpg
Missing record from multiple record creation
I have made a deluge to create multiple records based on date as below z = input.Total_Number_of_Sessions; x = z - 1; y = input.Interval_between; var = input.Start_Date_Time.daysBetween(input.End_Date_Time); iterationString = "".leftPad(x).replaceAll("
How do add more than three columns In creator.
Hi there, I am recreating an Excel quote form in creator, and part of that form has multiple columns that are needed how do I do this in creator, thanks :)
Popup / Expand option not showing for Subform with less than 20 rows in Zoho Creator
Hi Folks, I am working on a project. Where there is a subform with around 15 Columns. In order to see other columns, we need to scroll to the right. We have a popup option for Subform, with which we can view the subform data in a popup view. But the issue
Fetch Records within a Date Range
This seems like it should be an easy thing to do, but I can't get the syntax right. I want to fetch all the records in a form that are within a certain date range, say the last six months. I have seen syntax like this rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; referenced here: https://www.zoho.com/creator/help/script/fetch-records-within-range.html I do not understand, however, how a range for Added _Time can be an integer like 1 to 5. I would think if it as a date-time field.
Restore Deleted Records
Today I was the victim of accidentally bulk deleted records. The process to get them back is onerous, long, difficult, and almost impossible. I would love to request the following feature. The record audit tool is a great tool and can show me all the records that were just deleted. It would be great if you could add a button next to each record that was recently deleted, to restore that record. And maybe even select many of them, and then click restore to the whole group. This would make it so that
Making form fields mandatory dynamically - input of one field changes if a field is required or not
Hi all, I am trying to see if there is a way to dynamically change if a field is required or not - I found some forum posts from years and years ago about workarounds and showing alert messages, but nothing that was recent so I wanted to see if it is
{"4834":"Invalid Ticket Id"} as response of ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials");
Today all fetchs to zoho crm give me the error {"4834":"Invalid Ticket Id"} All calls that I made are of the style ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials"); crmResp = zoho.crm.getRecordById(("Accounts"), input.Cuenta_ID); etc. I have found some post with this issue and it seems that it's related with the auth token.... but i don't know what i need to do to fix this issue. Could you help me?
How to add or reduce the number of columns in a form based on the value of a field from another form ?
Hello, I'd like to know if it's possible to add or reduce the number of columns in a form based on the value of one (or more) fields from another form. The idea would be to be able to have a form with date columns that would vary according to the company's
How to restore values of a deleted field?
Hi, Lets say I'm editing the development environment of an app. The app has a form, I deleted a field named "field1". But in the production environment, there are several records of the form that contains values in the same field. Now in the dev environment,
Zoho Creator's v2 API GET Record - Detail View Missing Fields
As the Title said. I tried to use Flask request.get() and Postman and both of them only showing a some of the fields availiable. It seems it's showing what's in the Overview and not real Detailed data fetching. How can I get this field? I feel Detailed
Duplicate a row in a subform
Hello, I want to either duplicate the previous row that has been populated in a subform or better still copy some of the fields using code. Any ideas? Is this possible?
Passing data from form to subform
I have successfully passed data from Form to Form and subform to subform but cant find any information on how to pass from a form to a subform. Let me explain; I have 2 forms, A and B. Form B is embedded into Form A as a subform. I want to achieve the
Try to get a work flow to work on CRM
So the work flow is meant to send a reminder e mail 40 days before the contract ends. Tried a few things and cant seem to get it to work, also is there a way of testing this instead having to wait for the trigger time. Thanks
[Free Webinar] Learning Table Series - Creator for the Technology Industry
Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for various
Upload Image from ZOHO Creator to ZOHO CRM
#Tips & Trick of the Day data = Ar[ID == 4227213000000688005]; myImage = data.Site_Picture.replaceAll("/sharedBy/appLinkName/", zoho.appuri); myImage = myImage.replaceAll("viewLinkName", "All_Ares"); myImage = myImage.replaceAll("fieldName", "Site_Picture");
Formula field not working properly
I have an input field "Basic" and some other fields and one formula field "Total" in a form. When I input data into "Basic", then an workflow runs (on user input). The workflow populates some values and puts those into other fields. The formula field
Formula fields do not update
Hi, I've found that the Formula field does not update it's results dynamically if any of the data changes. I wondered, are formula fields supposed to update? Many thanks, Katie
Issue in Zoho Creator in Billing Page
Hi Team, I have found an issue on the billing page in Zoho Creator. In the application usage, I noted that the ‘User Connection’ usage appeared twice.
Matrix Choice - Is it possible in Creator?
Does anyone know if creating a matrix/grid choice type questionnaire is possible with Creator? I wasn't unable to find anything via KB or Forums. The only mention of things similar are over 10 years ago and appears to have gone nowhere. By matrix choice,
Any way to refresh publish page?
I have published page that include: 1 - stateless form (published) 2 - report (published). the stateless form has a field for user input and a button. I've created workflow for the stateless form button click that do some updates for the records showing
Zoho incorrectly interprets incoming email Content-transfer-encoding when charset is not UTF-8
In nordic countries (Norway, Sweden, Denmark, etc.), Microsoft Outlook default setting is to produce email headers like this: Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable or Content-Type: text/html; charset="iso-8859-1"
Boolean operators
Why can't I use != (not equal to) when comparing 2 booleans?
Tip 33: How to create custom forms and reports using widgets
Hi folks, In this month's tip, we're going to talk about how to use widgets to create custom forms and reports in your Creator application. But, before that, let's cover a few basics. What are widgets? Widgets help you extend the capabilities of your
Get form name?
Hi Zoho, Is there a way to get a form name (to be used in the "On Success" script)? Something like the formdata function, but for the form name... Thanks! Ravid
Creating a local text file with deluge script
Hi, I'm looking to find a way to create a text file on my local disk with deluge script. Just want to put text field in a sample.txt file. Anyone has a tip on that ? Thanks, Pascal Veilleux
How to change name of the portal user
Hi Team, I am not able to change the portal user name. By default, it is taking the email prefix. Is there a way to give or update name of the portal user?
Increase or reduce the number of columns when creating a form, depending on the value of a field from another form.
Hello, I'm wondering if it's possible (via Deluge, Workflow, Blueprint or whatever) to make the number of columns, when creating a new form, depend on a value entered in a field from another form. In this way, with the same field, you could decide to
Microservices Missing in Zoho Creator
I'm listed as an admin for Zoho Creator but I can't see an option for Microservices. I need to manage connections and from the kb articles, it would seem admin permission is sufficient for this. I'm an organisation admin in Zoho one if that means anything
How to fix this error
// Get the selected user from the form selectedUser = input.Meeting_With; // Fetch the email of the selected user from the User list attendeeEmailList = Users[Full_Name == selectedUser]; // Check if a valid email was found if(attendeeEmailList.count()
Adding a customer specific record to customer subform
Hi, Can anyone point me in the right direction I have customers as a form with all their details on it. I also have separate jobs, tasks & assets forms that I can also fill out, now when I create one of these records let say for Customer A - I fill out
How to get Monday as 1st day of the week?
Hi, The first day of the week is Sunday in Zoho Creator calendar.So it is hardly usable as in Europe the 1st of the week is always Monday. How can I get Monday as 1st day of the week? Best regards, Chris
Zoho Creator | Panel not saving after editing keeps on loading.
How to use different print templates for the same report.
I have two record templates that I have set up to be used for printing a PDF, but it seems only one of these can be associated with a report's detail view "Print" and "PDF" buttons. Is there any way to access the second template from detail view, or do
How to embed public report in html snippet
Hello, I want embed public report in html snippet. If i add iframe, the report button-urls are not working(navigating). How can i acheive this. <div elName='zc-component' viewLinkName='<string>' params='zc_Header=true'>Loading View...</div> if i use above
Next Page