Why is the word "script" suddenly reserved for variable names, input parameters and form fields?
Ok so I wake up and find that all my Deluge scripts are no longer working. As usual you get the "Improper Statement – Error might be due to a missing ';' at the end of a line" nonsense error prompt. Then after hours of debugging you find out that the word "script" has all of a sudden been reserved and may no longer be used as variable name, input parameter name or form field. Of course there is absolutely no information about this breaking change and no documentation as to which words are reserved.
Overview
Hello All, I am creating management application where everything is managed by Order Nos. I would like to create an Overview wherein i ask the user to enter Order No. and everything is displayed on the page with every data related to that Order No. Thanks & Regards
Functionality Issue in Zoho Creator - Deluge inbuilt function "hoursBetween"
Namaskaram Zoho Creator team, The deluge inbuilt function "hoursBetween()" takes two dates as parameters and return the number of hours between those two dates. But it fails in following scenario. Let us assume the start date is 08-Mar-2020 00:00:00 and end date is 10-Mar-2020 00:00:00. It should returns 47 hours instead of 48 hours. This problem happens, only if the start date is less than 10 and end date is greater than or equal to 10 and if both dates are set for 12 am. This is very
Picklist for District/State when using Address Field
Is there any possible way to do this? I know how to make this work if I use individual fields for an address, but how about when using the Address field type. I tried modifying the code in the IDE which kicked back a generic error.
Subform as a pop up box
My subform contains too many fields for the width of the screen. It looks terrible and is hard to use. Is there any way to have the subform come up in a popup box with the fields stacked vertically instead of horizontally, when one click on "add new" in the parent form? See pic. ?
Grouping Data in Charts
Hi - I have a stacked chart in Zoho Creator that contains data counts for categories A, B, and C. Is there any way to group the data so that the chart shows A and B+C together as a group? Thanks!
Sign in to databases
It seems I never know if I will be required to sign in to my Creator databases, or not. Some times I don't, but lately most all the times I am required to sign in. Cookies are enabled. No one touches the databases but myself, and I'd prefer to not have to sign in every time I open one for changes.
Unleash your Zoho Creator HTML Views using "ZCML"
What is ZCML? ZCML is HTML with a Zoho Creator twist. ZCML let's you write HTML on your website or web application very much the same way you do in a Zoho Creator HTML View. You get the benefits of the same embedded variable syntax without the need to use the ZC REST API. This is not iframing. ZCML is HTML native to the website or web application it's being rendered on. Please watch the video. Why use it? It's Fast Zoho Creator HTML Views can be very slow to render depending on the number of statements
Zoho Creator Functionality issue - Workflow triggering on Stateless form
Namaskaram Zoho Creator team, When we tried to create a workflow based on a stateless form, there are two options are available for triggering that workflow. One is 'Button click' and another one is 'Created'. Initially 'Created' has selected. When I click on the 'Button click', the 'Choose button' option has started to visible. After that, If I select 'Created' then the 'Choose button' option should be hidden. But it is being visible after selecting the 'Created' Option. Please have a look
Problem with Report Filter in Zoho Creator
Namaskaram Zoho Creator team, we have found a problem with Report Filter in Zoho Creator. We can't set a filter based on an image field from 'edit' mode of the application. But we can do the same from 'live' mode of the application. After setting it from 'live' mode, we have tried to edit the filter of the same report from 'edit' mode. Then we saw an error in that filter editing window that is the filter what we set from live mode based on the image field has been cleared automatically. Please
hyperlink
Hi, I wanted to insert website addresses in zoho creator. How to just insert a name, and then add link to instead of writing the full hyperlink address. Thanks Budcare
Line numbering / background toggle in PDF template
Hi, I'm currently building a Print & PDF template for one Report. The related form has a subform I'm inserting in the PDF. Customizing the page is quite difficult as I try to customize the HTML code. Customizing the subform field is even more limited it seems, and not html can't be changed as it's rewritten each time. My goal is to either add line numbering to each record, or display a gray background every 2 lines. Is there a way to customize this field and how ? Also, how can I write my own column
Error with newrecord/oldrecord and On Delete On Success deluge.
I have a report that is an executive summary of the maintenance we perform on our vehicles. It shows the last completed record of several types of services. I have the code below in the on success of create and edit and it works as intended. I also want it in the on success of Delete and it works fine until all records are deleted and I get hit with the error message in the attached screenshot. Can anyone provide a answer on how to avoid that error? for each oldRecord in Maintenance_History_Form[Unit_Number
Live Asset Tracking
I have read a little on the possibility of setting up a google maps API to view assets in real time in creator. Has anyone implemented this or have any insight on the best way to set it up? I have a trucking app and would like to be able to see where my vehicle are in real time to allow for customers to see where their shipments are at and to be able to better route and schedule drivers to loads based on loaction.
Adding an <iframe> into Forms using the "Add Notes" - not working
I would like to embed a Google Calendar into a Form with an iframe, but when I save the HTML for it, the iframe tag disappears. I have not been able to do it, yet. Is it possible to do what I'm trying to do? Can someone help? Thanks, Ian
Sorting report by Date is not in correct order...
I have several reports that need to be sorted in Descending Date order. My Report has Sorting configured based on Added Time but yet the report mind as well be in random order. It does not show up in the order that it should be. Yes i do also have grouping configured. Here is a picture of what i get. march should be at top not Feburary. Notice march is mixed in. There are lots of records so its hard to show here. This happens consistently accross all months and days worth of data.
POSSIBLE PAID FREELANCE PROJECT: Need help with and integration and possibly App development.
Hey guys, I have been a general CRM admin/analyst/consultant with Salesforce, Zoho, and Hubspot. I know my way around the platform and I love and prefer Zoho. However.... I am not a developer nor do I code. I do understand to extents what I am looking for when troubleshooting, but its not my expertise. With that said, I stumbled upon a possible business venture idea, and I need some help. I was wondering if anyone on here would have time to maybe take a call/video chat to see my requirements and
Data visualisation
hey guys, I am struggling now for days with a most simple visualization task: I need for a digi health start up a simple chart for each patient: two clustered bars within three different categories. Values are calculated in a form and get nicely displayed in the standard report. Just visualization doesnot come around, even with help from the support team. if I could do this as a pivot chart than I could have this per patient and for each patient per GP, with controlled data access. As a matter for
moving from one form to another
Hello, Say I have a set of five forms in an application. I want to l arrange these five forms in such a way that there is a next button at the end of the first four forms and a submit button at the end of the fifth form. When the next button is pressed the new form is displayed for data entry and when the submit button is pressed data from all five forms is pushed into the zoho creator db. How to accomplish this?
Stateless Form and Report inside of Page
I have a report and a stateless form that filters the report. I can on submit launch a popup with the filtered report, but my users keep adding and subtracting filters which become persistent and the next time they use my search form it retains its previous filters. I want to use the 'zc_SecHeader=false' parameter like I could in a page. How can I add a html snippet that has a report and the form such that they can communicate on submit?
visualization of images
How can I create this image display?
HTML Snippet Question
Hi, I am trying to work with the the new version 5 of Zoho Creator. I have created a page. On that page I have an "html snippet". I am trying to pass the record ID of a single record (as selected by a report that invokes the page url). In the html snippet I am trying to retrieve the information of the single record to use in deluge script and resulting HTML for display. I have created a function called Barcode that is invoked from the report but how do I "send" the record ID via the SendID variable
Deluge version history display Calcutta time instead of Europe
Hi, We are based in Germany, using the .eu servers. When looking at a deluge file history, time are displayed in Calcutta time. This not really relevant. We should have CET time for EU customers...
Maintaining data like Excel Vlookup
Hi All, Im trying to do something in creator that is very easy in Excel but not sure if I will be able to recreate the functionality. I have a report which stores lots of different values against a unique product number. One of the fields is 'language code' which is a number and the other is 'language', a multiselect with a list of languages. The languages assigned to a given language code can change so my plan was to have a master report with just these two columns so that if i change the language
A problem with Google Analytics Integration
Hi there, I am trying to integrate Google Analytics to my Zoho Creator application but unfortunately faced a problem I just can't find the solution. Hopefully I am wrong and you know the answer! :) My challenge is the access_token -code that I can't catch automatically from the URL to variable. I know that this would be possible by having a field access_token code on the form and then with input.access_token saving it to the variable when loading the form. According to my tests this needs however
Embeddable Search Function
Is there a way to embed the search function to a website so that only specific fields in the original form would be visible? Say for instance you have five fields in your form that you choose to all have appear in the view (or report) for that form: Given Name Middle Name Family Name Email Address Mobile or Telephone NumberNow, as far as I'm aware, if I were to embed the view on a website, then third parties who have access to the website will be able to see all the records (say 150 records) entered
TIP: How to create and use Stateless form to edit an existing record
In case helpful, since it took me awhile :-) The use case is to have an alternate form, open it from a report's Edit menu for a record, pre-populated with that record's values, and edit/submit the Update. Below shows the bigger picture and assumes some experience. Summary: * Create stateless form from existing form, choosing the desired fields. * Create a custom function that opens the form and passes the record ID, and on the report, add a Custom Action that creates the link that triggers the form
Urgent Help with Sending Attachments on Emails
I have a form where the user can upload a file. Once the user submits the form, an email is sent to a group of people with the fields completed by the user. Is there a way to attach the uploaded file with this email? Thanks!
Remove Customer Portal
HI, As a test I created a customer Portal for one of our Creator app. Now, I like to remove the feature. Not only disabling it, but removing the full access and URL. How can I achieve this ? thanks.
Magento Website Integration
Hay, Is it possible to integrate Magento website with zoho creator through Rest API? Don't want to use third party App's. can anyone help me with any documentation ? or how do i start ? Thank you in Advance.
Dynamically Selecting and Updating Multiple Records
Hi All- I have a form ("Equipment Form") that contains multiple pieces of equipment of multiple equipment types from multiple locations. One field in this current form is a "Runtime Meter". I would like to provide a user the ability to select a location and equipment type (lookups), fetch and display the applicable current "Runtime Meter" and allow for that field and a "Meter Reading Date" field to be updated with a new meter reading. Essentially, the user will dynamically select, view current
Pivot Chart not Showing Form Fields
I have Table Called Material Used. There is Date_Created Field Which is not able available While Creating Pivot Chart Report. I need to created Weekly Material used report But this Field is not Available in Column Section
Lay Out Builder for Detail View
Hi, I see Zoho Creator currently has a "Lay out builder for print/mail" (Record Templates) and there is a coming release for the "Lay Out Builder for Quick View" (Announced on Zoholics Nov-2019). It would be great to have "Lay Out Builder for Detail View". Is that a planned feature? Thanks.
Send Multiple Records in Record Template Format as email attachment
Hi - I know it is possible to send a single record in Record Template format as an email attachment on success, such as an invoice attached to an order confirmation email. Is is possible to create a custom function or scheduled email to include multiple records in a form as an email attachment in the Record Template format? Currently, we can do this manually by printing the displayed records in a report as "Print as Summary" However, it would be very helpful to automate this process so that multiple
Multi Line carriage return in html view
Hi folks. I have a couple multi-line fields in my form. As they are used, carriage returns / line feeds are added with the enter key. In the list view, these carriage returns show up fine. But when I pull the data into an HTML view with a "fetch", the carriage return is not displayed - the text all runs together. Am I doing something wrong, or do I need to do something differently? Or does it just not work? I appreciate any tips... Thanks.
when was the custom domain feature changed ?
the feature was changed from premium to ultimate subscription???, we needed to change our payment method and resubscribed the next day and suddenly that feature is unavailable, we had all these past years the "premium "subscription and we were able to use custom domains, so what happened?
summary view of information from several forms
I am new to ZC, and maybe still not thinking in ZohoStyle. However, one main power of RDBMS is that data does NOT need to be stored in several places. As I see it, if I want to have data from 2 forms in 1 view, I need to add a lookup field, this distorts a little the logic of dividing the data. However, I will ask a question, and hopefully, it's possible: Each of us has many tables/forms, some of the objects are more core objects (person, ID...), while other are data decsribing - name, address,
Button in subform to refresh deluge script for updated response
Hi, I have an expenses form I've built that pulls live currency rates into it for each item in a subform (so items could all be in different currencies) and then makes a running total in our base currency USD (so GBP and EUR are all converted by Deluge into a USD total). Is there a way I can add a button "UPDATE" that runs the script again to refresh the values? I notice it always has to be on user input but sometimes I just want the user to be able to update each line in the subform via running
Stateless Form - Attempting to pass a record ID to a stateless form for fetch and populate fileds
ZC v5 I am using an open URL command (see below) url = "#Form:Finance?lID=" + input.ID; openUrl(url,"same window"); to try to pass a parameter to a STATELESS FORM. This is the URL that is generated when the stateless form is displayed https://app.zohocreator.com/<zohaccount>/<Zohoapp>/#Form:Finance?ID=3949349000000407063 But the parameter is not being passed through to the stateless form as al alert message shows the value of input.ID as null. The same code works if I change the stateless form to
Amount to Words or Numbers to Words Converter
When can we have the feature to automatically convert figures of currency to words. We have an application that generates bills, printed as invoice, and customers would like to see the Final Invoice Total amount automatically written in words eg: we'd like a feature that could translate USD 6073.66 as SIX THOUSAND AND SEVENTY THREE dollars and SIXTY SIX cents. I understand there are some numbers to words converter websites, Can anyone advise if any of these numbers to words website offer Callable
Next Page