Report Filters on Pages
Hi I have a Page with a stateless form and a report. The report is filtered on a value entered in the stateless form. The page is shown using openURL and passing parameters. All works fine except that I don't want to show the filtered field in the report
Print Mulitple Template at once
Hi all, I setup a template to includes a QR code as label for my record entries, I can print out the template using the Detail -> More -> Print. However, it going to be time consuming for me to print out the label one by one going into the detail
How do you get a value in an embedded stateless form out to use somewhere else on an html page?
I have an html page with two items: 1. Stateless form without any buttons. 2. An HTML button that triggers a function. I need a way to get the value in the stateless form into my html button that runs a function. How do you get a value in an embedded
How to embed a form to edit in a page
Hi, is it possible to embed a form to edit to a creator page? like below but to edit?... thanks for any answers... <div elName='zc-component' formLinkName='Orders' params='zc_Header=true&&zc_SubmitVal=Submit&zc_ResetVal=Reset&'></div
JS SDK - Zoho Creator - React
Hi, I am testing out the JS SDK, and wanted to load React no-build libraries. However I am not able to load React library. In the sample app I can see that JQUERY is being used in the same way that I am implementing ReactJS external libs. For reference,
Deluge Script - Print multiple records, one per page
Hello Is there an openURL command that can do the same as printing a summary of chosen records? For example, if i choose three records in a report, and choose print, then print as summary. This will print each record on a different page. How can this be down with Deluge script? Thanks
Bulk/mass email from a filtered list
Hello, I am looking to send an email to a filtered list. I have a form called school_details that has an email field and from this form I have a filtered list report. When I create a record in form b I want it to send an email to the email addresses in
Getting valuefrom a field in one form to populate a field in another form
Hello, I'm fairly new to Creator, I am trying to copy the value from one field in a form to the field in another form. I have a form called Allocate_Tickets_Form and another called add_edit_schools. I want to copy the data from a radio button in the Allocated_Tickets_Form
Update existing record and not create a new one
Hi Can anyone help with my code below. On form submission, it should check if a record with the same estimate number already exist. The Estimate_Number field is a look up field to another form (Client Info). The problem is that it is creating a new quote
Help pls !!!!
I want to perform calculations on the amounts in my 'table_faits' table, multiplying them by the corresponding coefficients. However, it's essential that this is done sequentially, starting with a specific movement type, for example 'MAT', where the amounts
Fastest and easiest way to test / interact with deluge scripting?
I have a background in ruby / JS so the actual programming logic of deluge is obviously no trouble but the main struggle is trying to actually see what information I have available where and how things are working and I haven't found any great test environments
Loading a saved draft automatically
Is it possible to improve the UX of drafts? My forms are not particularly complicated but can require my users to gather information so the save draft functionality is very nice to have. However using it can feel strange where you save a draft and your
Zoho Creator Subform horizontal space/ appearance
in Zoho Creator I have a subform that will show or hide depending on the task selected by the user in the main form. However it looks terrible because on load, the subform shows fields horizontally and this spreads out a lot wider than I would like. ie.
Get prefix of field, get distinct list, insert list as new records in new form
I'm trying to get fetch records in a form, get the first section of data from one of the text fields (everything before a "-"), then filter out duplicates, then use that list to make new entries in a new form. Here's what I think it should look like but
Page Scripts
Trying to get my head around Zoho Creator Pages. Can someone point me to a decent tutorial on how the Page Script functionality can be used? Thanks Kevin
Zoho Creator Actions button when selecting Submit and Cancel/Delete on a form
I would like a to know how to create an alert or action when Submit or Cancel/Delete is selected at the end of a form. I know it is possible to do it as a successful submit action but more along the line of the cancel/Delete.
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?
Next Page