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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Update Subform record into another form
Hello All, I am trying to update the subform record into another form Following is the code i have used: for each rec in Accessories_Inward { fetRecFrom = Stock[Record_ID == Record_ID]; fetRecFrom.Item_No=rec.Item_No; fetRecFrom.Quantity=rec.Quantity; } whereas, Record_ID = Unique Identification code to recognize the rec i want to update Accessories_Inward = Subform of the Main form (not linked with any other form) Stock = Form where record is to be updated. Now the Problem is When there are multiple
How can I print comments.
Hey guys, a few hours ago I started building a Student registration form, and I saw that you can print out the Report for that form, as in select a specific "Student" that was added and print as summary, however I also noticed that the comments that you can place on those students didnnt get printed, is there any way to accomplish printing a Student report with all their data alongside the comments that I have added to it?
Android app Customization using SDK
Hello Everyone, I am trying to develop a custom mobile application using Zoho Creator's Android SDK. I am going through the sample application, which was developed using Java + Kotlin + XML . Is it possible to create using Kotlin and compose? Because
How to get data from certain fields in one form to another form
Hi my query may sound simple but it is stumping me! I have several forms one of which is called the 'organisation mastersheet'. In this form I have a column named 'organiser name' and in each 'organiser name' record I want data to appear from a seperate form called 'organiser management' (contact name, email and telephone number) instantly as it has been fed into the organiser management' form. So when entering the name, email and telephone in to the 'organisation management' form when I switch to
Can a form be 'closed' the information retained and the same form be reused?
Hi I have a problem that I am hoping someone can help me with. I'll try to explain my issue as clearly as possible. I want staff to be able to mark what days they can work in the upcoming week I have a form that does this - it has the week days that they
Populating a field with a customers name based on their email
Hello, I am trying to auto-populate a field with a customers name base on the email address which they use to login. The email address they use to login is the same as in their customer details. Their name and email address is on a form, called customer
Allow uses to clear out URL Filters
Users link into a Zoho Creator report via URLs. These URLs have filters. Something like: https://creatorapp.zoho.com/acct_owner/app_name/#Report:SomeReport?SomeField=123 This is problematic. The report (default list view) does not indicate to the user
Application is Not Showing Data Properly
Hi everyone, I will be grateful for any help I can get on this issue I have been unable to resolve. Context - This application I'm working on was built years ago by someone who has left our organisation. I do not have any coding background and experience.
Set the value of lookup field based on decision box
This really should be easy but im having an issue here. Help will be appreciated because it will solve so many issues for me. I have a form that has a lookup field in it. When a user checks off a decision check box I need to set the lookup field to a specific value. Normally, if i wanted to set a field value I would just use something similar to the following: input.field = "this is the value i want to set the field to"; With a look up field this does not work. How can I set the value of the
New to Zoho Creator
Hi all, I'm new to low code platforms. I've written an application (a statistical model) in Javascript. I want to develop some additional components in a low code platform such as some basic screens with a user interface and a database which will store
Next Page