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
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
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
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.
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
amyway to retrieve my work lost by the Sandbox feature in zoho curator
errror publishing keeps poping up. I filed a support ticket with no response in 12 hours. every time i press the Publish button I got a "errror publishing". These were minor changes. Support says 10 hour response but not every day I guess. This is a rather useless feature if I have to wait days or weeks to interrupt my workflow. Does everyone rely on the back up and restore feature instead or is that just as unreliable? ty
How can I allow users to upload more than 1 file at a time?
How can I allow end-user to upload more than one file if given quantity is more than one? For example: I've created a form where user can put quantity and I want them to allow as many file uploads a quantity amount. Right now, if the quantity is more than 1, it still only allows only one upload. Thank You
Password Field in Zoho Creator
I need to know that whether a password field can be created in the Zoho Creator. Is their way to create a password field using Deluge Script.
Feedback Analysis by rating field in Zoho Creator
Namaskaram Zoho Creator team, Good if form builder contains a field for Rating with stars in Zoho creator form creation, to find customer satisfaction level - it is useful for feedback analysis specifically in products sales Now, form builder contains a field called sentiment analysis to analyze entered customer feedback from a single-line field. But the rating stars are often used in web forms and apps for feedback analysis. So people are familiar with using this one instead of using AI for
UI Issue in Zoho Creator - 'Refer Fields' side bar is hiding the code content in HTML Snippet - Zoho Creator
Namaskaram Zoho Creator team, While using the refer fields side bar in HTML Snippet editor in Pages. It hides the code content. Image 1 shows the HTML snippet editor before using Refer Fields and Image 2 shows that the code contents are hidden while using Refer Fields.Also it is not showing any scroll bar below the HTML Snippet editor to view the hidden code content. Image 1: Image 2: Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho
UI Issue in Zoho Creator - While using conditional formatting tool tip should not be shown there
Namaskaram Zoho Creator team, In field configuration settings it shows 'i' icon (Refer Image 1) near the fields and while using conditional formatting for any field it shows a list of created rule and in that the 'i' icon is also visible which is in behind the conditional formatting setting (Refer Image 2) also it shows tool tip when we hover the 'i' icon which is in the conditional formatting setting (Refer Image 3) Image 1: Image 2: Image 3: Crafted with
Functionality Issue : Filtered keywords not containing space are not shown above Reports while using Open URL
Namaskaram Zoho Creator Team, While using filter in open URL to open a report the filter is applied properly. But its not showing the filtered key words above report when the key word used in filter has no space after are between the keyword.(For example: when we use current_status= 'Draft' as filter then the report shows list of entries having Draft as current_status but the applied keyword was not shown above the report.If we use current_status='Draft ' (Here
Customers - Timesheet - Calender
* Sorry moved this to the Zoho Creator Forum Hi, I'm trying to make an app where a user can see an appointment schedule (the user has a customer permission) for his workweek or month. The customer can only see his schedule. So far so good. But i want to make a timesheet where the user can add the real time spended during that appointment. Forms/Reports that i made are: - Customer - Employee (in this form i have a User field with customer permissions) - Appointments (in this form i have a lookup
ignore duplicates in for each
Hi, I am using the following programme to return values (Bin Numbers) and dates that have been used in the report. a = Collections[Bin_Number != "" && Site_Name.Customer_No == "WXH" && Date_Time > zoho.currentdate.subMonth(1)]; b = Master_Bin_List[Bin_Number not in a.Bin_Number.getall() && Site_Name.Customer_No == "WXH" && Ignore_in_count1 != "yes"].Bin_Number.getAll(); c = Collections[Bin_Number in b] sort by Date_Time desc; d = Master_Bin_List[Bin_Number not in c.Bin_Number.getall() && Bin_Number
Sending file via PostURL
I want to postURL data that includes a file that has been uploaded to a record. I created a simple function which should do it but I get a server error from the receiving web service. Probably because Zoho Creator automatically uses a Content-Type of application/x-www-form-urlencoded when what I really need to send is probably a different content-type (multipart/form-data?) to the url. Any ideas on how I can post a file using postURL?
Planning material with stock
Hi all, I'm trying some things with the conference room booking system, to build a crew and materials planning application. So what I did was changing the conference room page to a materials page. I love the way that it checks the availability. What I want to add is the following: 1. So lets' say I want to add a camera. I have 5 of these, so I want to add a number field in which I input 5. 2. Now when I make a booking I want the option to say I need 2 for that date/time. 3. Great! Now I have 2
Close Browser Tab
I am opening and editing a record via a link in an HTML page. I would like to close this window once the record has been submitted and return to the HTML page. I have tried a couple of options but have not found one that works. I am not opening the new window via openURL(), rather the <a> tag in HTML. Thanks for any suggestions.
Logic-based form calculations - Conditional Formula for Zoho Creator
Hi, I see Zoho just introduced a Conditional Formula for Zoho Forms. It would be great to implement the same feature on Zoho Creator Formula Fields. Here the details of the this new feature introduced in Zoho Forms: https://help.zoho.com/portal/en/community/topic/logic-based-form-calculations-introducing-conditional-formula-for-zoho-forms
How to update a form with data from a crm look up field in another form in the same application so that it shows as a text value rather than the ID number?
Hi there, I need to create update a form called "US Customers" with data from a form called "Customer Cancellation Form". This works fine using the Data Access/Add Record /"insert into... procedure . The only problem is that one field I need called "Organisation name" is a look up field to zoho crm . This field in the new form displays the Organisation ID not the name of the organisation insert into US_Customer [ Organisation_Name=input.Organisation_Name Contact=input.Contact Email=input.Email
In-App Notification Counter on Menu
See attached screenshot. Would be really nice to have a "counter", especially on the "Approvals" workflow tab.
Barcode Scanning
Hello, I would like to integrate hardware barcode scanner with Zoho creator, how do i do it?
Workflows with translated dropdown fields on mobile
Hi, I tried translating the values of a dropdown field to sapanish and found that my existing triggers related to the options chosen on that field still work while using the web but fail when using the mobile version. Is it a known error? Thanks!
Cancel subform delete
I have a form with a table of subform rows. I need to allow users to delete rows but not all rows. The capability to delete a row needs to be determined by a value in the subform record. I understand that I cannot conditionally enable/disable the delete function but was wondering if there was another way to achieve what I want. The onValidate function of a form provides the ability to 'cancel submit'. A 'cancel delete' function in onDeleteRow could give me what I need but alas it doesn't exist. onDeleteRow()
Menu - Sync Across Platforms
Hi, I've just noticed that my menu's are different across the different platforms. Is there a way to sync them all to my laptop view? Thanks
Data Limitation
What is the real limitations of size data and columns of a table in Creator? How many rows of data can it handle in a real production environment? At what point the performance of an app starts suffering because of size of table or total data size of an application?
Amount in words
Hi, Is it possible to get Currency in Words ? for e.g Total Amount is Rs 100 In Words: One Hundred Only.
Is there a way to send Uploaded Files from one application to another using postUrl?
I need to send a file from an application on one account to an app on another account, possibly using postUrl(). I'm currently getting an error when attempting this. Is there a way to resolve this?
Timeline in detail view
Hi, How do I create a more rich details page about, for example, a project. So when you click on a project in a list it goes to a new page which shows the information about it, but also a timeline for that project only. I think the pop-up sliding in from the right isn't big enough for large projects with lots of information. Thanks, Stefan
Zoho Or Knack
Hi, At the moment i'm creating an app with Knack that needs to handle team scheduling, equipment reservations / bookings (with stock on certain dates) and combined with this a ticket system (and maybe in the future time tracking). With Knack i'm running into the issue that it doesn't handle time/reservation systems very well. Does Zoho do this better? In the system I want to have multiple types of data that all needs to be combined: Team / Crew Projects Freelance crew Equipment (with the possibility
Statement Execution Limit Problem
Hi, I'm trying to fill some drop down boxes based on a previously entered value, where it has to search through just under 1000 entries. here is the code: for each AT in Asset_Types { if(input.Asset_Type = AT.Asset_Name) { for each AC in AT.Asset_Components { for each CT in Component_Types { if(CT.Item_Name.contains(AC)) { prefix = CT.Component_Code_Prefix; for each comp in Component_Stock { if(comp.Component_Code.contains(prefix)) { if(i = 0) { input.Part_1:ui.add(comp.Component_Code); } else
Changing Subform Fields via Script
Hi I have a process that basically confirms an order, the MainForm sends Email, the Email links to Stateless Form, the Stateless Form changes the Confirmation Field on the MainForm. This all works wonderfully but I now need to change the value of a field in rows on a subform in the main form when the Confirmation Field is changed. I've tried daisy chaining the scripts via 'On User Input' of the changed field but this only works when I change the field manually in the form, how do I get it to change
Passing a parameter to a drop-down field
Hi Zoho, How can I pass a parameter through the URL to a drop-down field? Thanks Ravid
SaaS Challenge - No Admin or ability to preload data, what are my options
Dear friends As we all are aware Zoho is launching a SaaS model, and I know there has been quite a heated debate - and as it is still early days, more debate to come. Personally I think it is a good move, but it is posing some challenges. You might be aware there is no Admin function (from developers point of view) so only the customer has access to their instance. This is mostly OK. You may not be aware that there is no Audit function, nor is there the ability to preload a form with data. The audit
Next Page