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.
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!
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
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
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
Next Page