Publishing a page with a widget
Hey all, I need some help with publishing a Creator page with a widget embedded (in the regular way, not as a snippet). The widget itself appears, but it can't access the record inside a report (which works when the app components are not published).
How to callculate number on record
Example, i have 1 form. And have field Total Peminjaman. I want to callculate with some criteria for Total Peminjaman on record. Im try using collection, just get result like this example: 1 2 i want that to be, 1,2 and i'll callculate 1+2 = 3 Please
Rename a template as PDF
Hello, Is it possible to rename a template when we send it by attachment mail ? For exemple, I've got a template named ""DevisJour"" and when I send it by mail I would like to rename it "DevisJour & N" Thank you for your help
How to restrict embed URLs?
We have a Creator form that I want to only be embedded on approved sites. It looks like you can do this easily in Zoho Forms (here) but I'm not seeing a way to do it in Creator. We have had this set up for a long time, and it would be cumbersome to change
Link to specific week in calendar view
I'm trying to create a custom action to display an event in calendar view, and I'm able to specify the month but on the week view the calendar always opens on the first week of the month. I'm trying to open the calendar week view on the third week of the month making the users click through the arrows searching for the specific event. Is there a way to make the calendar open on a specific week of the month or specific day via parameter? Here is an example of the link I'm using to open on the specific
Can I clear only a section of a form?
I have a form with several sections. Many times we duplicate records and only need to clear a (section) of the form and not the entire form. I know there's a "reset" button for the entire form, but is there a way to make a button which will clear only
Remove alternative Options in Reports.
Welcome everyone, is there a way to remove the option to transform a calendar report into an kanban, list or timeline report? Especially kanban and timeline are confusing in my case. Thanks in advance! Best Regards Jan
Text wrap column headers in reports?
Is it possible to auto wrap column headers so that a longer multi-word header displays as two lines when the column is narrower than the width of the header title?
Making a Web Service API Request to Third Party Server With SOAP Endpoints
Hello! I am building an application in Zoho Creator to manage course registrations and online testing. I would like to set up the registration forms so that when a student commits the form, a request is made to the third party testing service to add the student as a new user. The testing service API documentation is a WSDL file. The part that I need is formatted as follows: Web service URL to call: https://secure.test.com/webservices/ws_users.cfc?wsdl <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
I have one form and a report in a Page. How to refresh the report in a Page triggered by a change in the form without changing/refreshing the form?
Hi, I have one form and a report in a Page. How do I refresh the report in a Page triggered by a change in the form without changing/refreshing the form? Thanks John
How can I make a field visible/unvisible
Hi I plan to expand my form with more information. But before I do this I need to know if it is possible to make fields visible/unvisible depending on selected values in other fields? BR Dennis Skouboe
Introducing Metrics - Zoho Creator's centralised visual dashboard to stay informed about usage statistics
Being such a comprehensive platform, the statistics in Zoho Creator often span many modules (like Users, Portals, and more)—and when there are large numbers of applications, users, and portal users, keeping track of their activities in a centralised space
Why is there no "n days from today"?
(Same would go for months/years). There's: last n days, next n days, and n days ago; but there's not "n days from now" or "n days from today" (opposite of "n days ago"). If I'm wanting to pull up how many service tickets I have 5 days from today, I'm
Dynamic timeline display
I'm looking for a way to jump to a specific date in the timeline view using Deluge. I don't think this is currently possible, unless anyone has any ideas for a workaround? If this isn't currently possible, to me it would make sense to add parameter to
Subform row with a lookup to another subform row in the same Main form
Hi All Could you please point me in the direction of solution to solve this problem. I have a Main form called Ingredients. Inside ingredients i have a sub form called units (standard subform linked to Units form) and another subform called Pricing (linked
Multiple Barcode / QR Code Scanning
Hi Creators, Barcode / QR Code scanning is really nice feature. However, the ability to scan multiple barcodes/qr codes and enter it in a multi line field will improve the speed and efficiency. Regards, Sushanth
Permission query
we have two permission settings i.e 'user permission ' & 'portal user permission' and both have the same setting that we enable for our users, Now those who have access to user permission can see a button on the pivot table, "regenerate" but those who
Updating an existing record through an email link click
My application tracks tasks assigned to individuals. It sends a nightly digest email with each individual's open tasks. I'd like to include in that email a simple mechanism for the user to click a link and mark the task as done. Ideally they'd not have to see a Zoho form; e.g. the link would be a call to a web service, with parameters preset with the task ID. The receiving service would simply select the task by that ID and update the value of the field called "Complete." If the only way to do it
Sub form not updating all rows of another subform
Hello, i have a form in creator that has two subforms in it. both subforms have a dropdown that i am trying to make related. i want to get the dropdown inputs from each row of the first subform and display them as options for a dropdown in the other subform.
Zoho Creator Calendar - Sorting Events
Hi, I have a calendar view to hold the schedule for a group of engineers. I have created a formula field to show the combination of fields I want visible as the title of the event, but I need to be able to sort the list by something other than the event
Focus calendar report on specific date dynamically
Hi, Is there any way to focuse a calendar report on a date using deluge? Thanks
Schedule a function that exceeds number of statement execution limit
Hi guys, I've got an error on a schedule that I'm running to update the age of my service users. It says the number of statement execution limit is exceeded. Each day I use a schedule to run the following function: void update_age() { for each rec in
Can you set a size limit to a Zoho Creator Upload Field
Case: We are interfacing documents we uploaded in a Zoho Creator Form with Ms Business Central. MS Business Central only accepts attachments 5GB or lower. Would it be possible to set size limit to a Zoho Creator Upload Field? So you can already not upload
Disabling Add Record in Reports
Hi all, Is there a way to disable the option to add a record in a report view? It seems to have been present in Creator 4 but cannot find any reference to it in Creator 5. I'd like to have some reports that are there to view information only and not add new records, to control the flow of data. M
How to stop publish of stage
I accidentally closed the stage production before hitting publish, and now nobody can edit it, and neither can I
Subform data not fully sync to Zoho Analytics
Has anyone faced the same issue? I have a form called Production Order, with a subform called Actual Consumption. The sync status is successful. Looking at the table: Production Order_PO Actual Consumption Info I have tried using the PO number or the
Calculating Time difference between fields Question
I have two date and time files and I would like a third field to be a formula field that calculates the difference and displays it in a simple manner... Any ideas? coolass
Can I Hide/Show fields based on user ?
Hi, Can I show / hide fields depend on user ? Thanks
Mass export of record templates
I have a Creator application that basically takes a published form submitted by the public, generates a record template pdf, then attaches it to an email that gets sent to both the person who submitted the form, and to someone in my organization. This
In zapier get lookup field as string.
I am trying to Zoho with Zapier. I am setting a filter on a lookup field. But look field showing a record id instead of actual string value, so in Zapier i am unable to match value for the filter. For example in filter:- if look_field_name = some_string then add record to google sheet.
on integration zoho creator to zoho books for transfer the data creator to books in items module , how to push the unit field (lookup) data(name) zoho creator to zoho books in (Unit field) . Pleas
Resolve soon
Circular Math Calculation Formula
Hi i have a need to do a rotational calculation between a set of values FOr example Lets assume the below values assigned to the Location Location-A= 1 Location-B=2 Location-C= 3 Location-D= 4 Location-E= 5 IF I PASS a query asking : what is the distance
Image Display in HTML Page in Portal
I have an HTML page that displays an image from the database. It works fine when outside of a portal. I want to put that HTML page in a portal but I cannot get it to display the image. I get the broken image symbol when I try to run it from inside the portal The code that works is below. The input.property is the record ID of the record that I want to display and comes across from a stateless form that is used to open the page. I moved the stateless form and the HTML page into the portal and
Updating a Multiselect Lookup Field
I'm currently trying to update a multiselect lookup field in a record, but it's giving me the error {"code":3001,"data":{"ID":"3268991000041877010"},"error":["Invalid column value for Staff"]} . I've tried the list method and the collection method. The
[Free Webinar] Creator Tech Connect series - Active Directory and SAML Authentication
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
Help with Workflow to include subform attachment
I have a Form Release_Drawing and another form Drawing_Files Drawing_Files has a file upload field named File_Upload I am using the Drawing_Files as a subform in Release_Drawing form. The name of the subform is Drawing_Subform The user typically fills
Seeking Advice on Implementing Subscription Verification in Custom Zoho Creator Application with Zoho Subscriptions
Hello Zoho Community, I am currently developing a custom application using Zoho Creator and Zoho Subscriptions and need some guidance on managing user subscriptions effectively. Current Workflow: Users create their password. Users complete their individual
Get a random record
With the introduction of randomNumber() fetching a random record is as easy as: //fetch records myRecord = My_Form[ID != 0]; //check if records exist if myRecord.count() > 0 { //get ID list idList = myRecord.ID.getall(); //fetch random record randomRecord = My_Form[ID = idList.get(randomNumber(idList.size() -1))]; }
How to edit related block tables in canvas?
i am creating a canvas that uses a related subform as a table, but the table columns are all the same width reguardless of data and it makes the table very long. is there a way to set the column widths like we can in record templates?
Updating data in one form to another form using Subform
Hi, I have problem, i can update data to another form. But just using standar field. The question, i want to update data to another form using subform. I want to update JUMLAH base on BUKU. Thank you ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Next Page