Hide Subform Field for members
Hi, I have a field in a sub-form which I would like to remain invisible for anyone except the administrator. In the Permission section of this field I have selected "Hide this field to others". If I log on as user, the field is still visible. How can I hide fields to users?
Direct link to record audit?
Is there a way to create a grid view action that would take me directly to the audit record for a particular item that's clicked on - what would the URL be?
adding currency fields in a formula
This seems like a no-brainer but when I try to add two currencies in a formula field I'm getting a concatenation instead of the sum of the two fields. So, $5.00+$8.00 becomes 5.008.00. Do I need to convert the currencies or something?
Export to pdf. Images not showing
My report contains a column with images. When I export it as a list, the images do not show in the PDF document. I have published the report but the images are still not visible. What should I do so that the photos appear in the export?
Zoho Creator Can't Create a Spreadsheet Report
Hello I have an existing creator app with a bunch of form data. I want to create a new report in the spreadsheet style. I'm able to do so, but in the view report I can't edit any of the cells and this little red * shows up at the top of the report. I
How to protect attachments with password?
Hi, I would like to know how to protect PDF attachments with a password before sendmail task! I have an idea of how to do that with public forms. But I would like to know if it's possible with native deluge or if there is some integration flow that can
Closing a Stateless Window
Hi! I have a stateless form that I'm displaying with openUrl("https://creator.zohopublic.com/company/application/form-perma/ISN_Stateless?Trade_Order_Id1=" + input.ID,"popup window","height=300, width=500"); and that works great. The form has an 'OK' and a Cancel button. At the end of either event (OK & Cancel) script I put openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:script.close","same window"); but the popup window merely 'refreshes' and the window stays. A cancel will not kill
Stateless Form: Close the Window
A simple question: I have a stateless form and want one the the buttons on the bottom to close the form's browser window. I tried openUrl("javascript:self.close();", "same window"); but that's not working in Chrome. John M. Whitney
How to disable subform records dynamically
Hi Everyone I have a requirement to dynamically disable or hide subform fields based on certain criteria. However, the code I tried didn't work as expected. It either disabled or hid all the fields in all subform records or none at all. What I actually
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Lookup fields and self referencing tables.
Is there any reason why using a Lookup field to select a record from the same table doesn't work? For a CMS system, I wish to create a hierarchy of web pages where sub-pages 'point' to their parent page which itself is a child page of another parent page etc. I don't want to limit the number of levels that the web site requires. The most structured way of pointing to another page is to use a Lookup field for the ID of that page. I have tried to do this put the field doesn't appear in the form. Does
Lookup field to the same form
Hi, I'd like to create a lookup field that points to the same form where i'm creating the form. Is it possible somehow? I want one record to point to another record in the same form, based on some critierias. Thank you.
Report - Group By Month?
Hi all, Is it possible to group by month in reports by any chance? Many thanks
Virtual keyboard input to form in page
I have built a page meant for our customers to sign in at a kiosk with. Since the kiosk is a touch screen, I created a widget that adds a touch compatible keyboard the page. Is there a way for me to access the html/zml of the form to get the keyboard
Get image url from image uploaded to app
I have a table in my app that holds uploaded images and a string value for each one. I am trying to dynamically upload one of these images to a different form's image field based on a selection the user makes in that new form. I need the entire image
Different behaviour when saving record depending on how I open the record editing page
Hello, I've created an app on Zoho Creator and I see a different behaviour depending on how I open the record. 1) If I open the record by navigating the app, edit it and save it: I see a "Data updated successfully" pop-up on the top of the screen and
Conditional Formatting Date parameters
I have a date field that is used for a deadline. I'm using conditional formatting to color the date text red if the date is in the current week. The problem is if the date is past due over a week, the color does not stay red. It reverts back to the normal color if the date is post-dated over a week ago. Is there a condition that says, "if the date is after the deadline, keep it red." I've tried using the "after" condition but there isn't a way to tell it "after" the field date. It only allows a string.
Email bounce back in Creator
Hi guys, trying to figure out if I can receive email bounce back notifications in Creator when sending emails? I can see topics about this in CRM but not in Creator. Anyone know if it's possible? Quite important for our booking system that we've built
zoho.projects.getProjectDetails Doesn't Show All Records
Hi, in Zoho Creator Deluge function, I use the following to get all projects from Zoho Projects. zoho.projects.getProjectDetails("maveninsightssolutions171","active","creator_projects_connection") It works fine but I realized that it only returns the
Approval doesn't work once form is published
I'm very new to creator this is my first time using it. I'm trying to create a form for my clients to use to update their contact data and other information, and then upon approval by me or another admin a deluge script runs that pushes the data to zoho.
Add image to report...
Greetings, I send a weekly color coded report via Creator email. I would like to add the legend somewhere in the report. Header, footer where ever. I have the legend saved on Google Drive and can access it via shared link. Sure someone has wanted to add
How to get the Geo Location i.e. Longitude and Latitude value in ZOHO Creator Application
How to get the Geo Location i.e. Longitude and Latitude value in ZOHO Creator Application.
Implementing a virtual keyboard for a check-in kiosk
I have been working on a queue application in Creator that would require customers to sign in at a kiosk. Since this kiosk is touch screen, I would like to try and add a virtual keyboard to a page for the customers to input their information. I have been
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Record Limit on Report
I have set up a report that I'm putting on a "page". I have filters set up to only show the records with deadlines in the next 45 days. But I only want the report to show the first 3 records (and if possible have a pagination option at the bottom to access
Unable to rollup calculation by group regardless of report
Hello, I have data related to several forms in my system. "Raw Material" is Form 1 and is the name of the item I want to roll up totals for with related forms. I have a lookup field in Form 2 "Production" that relates the record to "Raw Material". I will
Errors with isEmpty and toLong
I have some old code that just stopped working and nothing I am trying to do to fix it is helping. first of all, I am getting an error of for code that reads: if(response.isEmpty() || response1.isEmpty()) { alert "The Registration Number you entered wasn't
Pull (Parent Form) variable into (Sub Form) as the function iterates through recordset??
Hi guys, I need to update just over 23,000 records from 2023. I may be overthinking this; however, as you can see, I've added a single criteria to the function and initially designed it to run on the click of a single record. I would be there for years
Zoho Canvas review
I have recently explored the Canvas feature, and I'd like to start by discussing its pros. I'm optimistic that the list of pros will be longer than the cons. Finally, we can create a front end that looks and feels current. While I appreciate the scalability
How can I open / edit an existing record using deluge openUrl in zoho creator
Is there a way to open a specific record of a form using deluge? When trying to edit the record, the Url is the generic url for all the reports. What would be the url to open the same view (edit mode of a record) without using the same generic url for
Remove item from multiselect field
My basic issue is that I would like to be able to remove an element from a multiselect field (i.e. the inverse of ui.add...like ui.remove, which doesn't exist). Here's the set-up. I have a "unattached" form with a search function that lets the user add items to a multiselect field one at a time. (search, select the desired item, that adds it to a multi select field by ui.add:, and all items in the multiselect field are selected). That all works very nicely. I would like to add the ability to select
Can Deluge be used for conditional formatting of records?
Hi all, I need to highlight records in a report that meet certain criteria. Unfortunately this criteria depends on related records from a different form, so regular conditional formatting in the report "configure fields for web" page will not work. There
Creator App, Auto Generated form comes in .pdf, can it be altered to .xls
In the Creator App we have created a form for requesting test products. When this form is completed and submitted zoho creator generates an email with a .pdf copy of that filled out form and starts a workflow. Is there a way to change that auto generated
How many storage are left in my account
In previous event we couldn't use this product as a production for few days as because lack of storage. This is our past experience. Now we are using "Zoho creator". Please let me know the current storage status.
Make record in subform clickable
Hello, I'm creating an app to keep track of the procedures used in the company. For each task run in the company there's a "Task" record containing some information + a sequence of steps (procedure) needed to perform the step. Is there a way to make each
Zoho Creator - [Free Webinar] Creator Tech Connect - Cloud Functions in Zoho Creator - Session 6
Hello Everyone! Technologies like Java and node JS has an extensive user base and has an enduring demand amongst the developer community. Zoho Creator as a platform has revolutionized the solution building/application development process with minimal
Page parameters - Button custom colors
Page parameters can be configured to pass values to pages and display them inside page elements such as panels, charts, gauges, forms, reports and so on. I have a page and buttons to activate these filters. Is it possible to configure them like this?
Get min and max value from subform
Hi, I would like to show the min and max values of the subform within the parent form e.g. Parent Form = Products Subform = Variations Variation entry 1 - price =$200 Variation entry 2 - price =$300 Variation entry 3 - price =$400 Variation entry 4 - price =$500 The parent form would show "Price $200 to $500" Please can someone advise on the deluge script I could use in the parent form to calculate this Many thanks
Process large CSV file | forach limit
Hello there, given is a CSV file that usually has between 500 and 1000 rows and consists of 31 columns. I would like to change the file uploaded by a user, a certain value must always be set in one column and only under certain circumstances in another
Optional Function Arguments
How do you define optional function arguments in deluge?
Next Page