Integrate Google Maps with ZOHO Creator / ZOHO CRM / ZOHO Reports Data
HI all , On another forum discussion I told there is a workaround to integrate ZOHO Data with Google Maps . then I am getting lots of email but I could not help enough b/c of my work pressure. so I thought It would be good if I could post the process then other developers can help ZOHO users. However before proceed you might want to watch video that I posted on Youtube.com so you can see what can do ? Video link : https://www.youtube.com/watch?v=_kW1DJAf1x8&lc=z23wvvbxjkngvjf0lacdp434r453uiuqfzv0qcgb4ypw03c010c
autonumber displays "null" instead of the number
I have a formula that refs an autonumber field, the result is fine but when I thereafter edit a record the autonumber part of my result changes to display "null". Any ideas?? if((Legacy_Project_Number == ""),"LP."+ Project_autonumber ,Legacy_Project_Number)
File upload thumbnail preview.
We would like to be able to have a thumbnail preview of the image files we upload. For now what we do is to upload a file, go to the list view, copy the URL and paste it on the Image Field, but this doesn't work for different views because the link has a reference to the view and not to the file itself. :( Very disappointing!!! Today all programs have previews for image files. Its ridiculous that we have to do all this work to get a thumbnail up.:( Florencia
Sample code for passing parameters to a form from a view
Can someone please point me to sample code for how to pass a parameter when opening a form from a custom action in a view? I've created a function with an openURL statement for the form I want to open, which works. However, I can't figure out the syntax for passing the function parameter through to the On Load action in the form. The error msg says that the input.RefVar is null in the On Load action. Thanks.
Connecting Zoho Analytics of another Zoho Account
In attempting to create an Analytics connection/data source, when I try to authenticate it automatically looks to the signed in account. If I sign out to sign into the analytics account I want to access, it also cancels the original Creator session.
Save to Google Drive and return shared URL
Hello, I don't know much about the Google API theme, as much as I see it I don't know how to implement it, what I want to do is basically in a zoho creator form to save in an attachment field a file, when saving must enter that file to a specific folder
Summary Page (Record Template or ZOHO creator page) in ZOHO Creator
Hi Team, Good Day! Requirement: Want to create a summary page for a student management app in creator. If the student is passed for a particular exam, the marks / grade needs to be in green color or else it needs to be in red color. I thought that for
Transfer ownership (and billing) of Zoho Creator app to another user?
Gents, I created a Zoho Creator app under my user, but now I need to transfer it to another user (for billing and management purposes). How can I do that? []s Manoel
Concatenate Multiselect & Checkbox fields in a formula field w/ a conditional comma.
I want to combine the selected choices of a multi-select (dropdown) field and a checkbox field with a comma between the two within a formula field. However, one of these fields might sometimes be empty, so Multiselect +", " +Checkbox would leave me w/
Link records in one form to another via number range
I work in a high volume ecommerce sales business where we process items that are grouped together in boxes. Each item has a unique ID number, and the box that they are in also has a number. Each item is entered into our database including the item's ID
Action button in report to create new record but NOT on-click; also, full screen success message??
I have a report action button that sends data from one form to another and creates a new record. It works, but I don't like that the new record is created On-Click of the report button. Is there a way to just open a form, populate it, but have the new
Restore backup and portal users
How can I get my user definisjons back after restore of an application?
Download a custom template from a report
Hello, I have a report which contains 3 templates, but I want to press a button in the report to download the template, which is by means of a condition, since I have not been able to do it and it always downloads one and not the others I don't want to
how many I have selected on report
Hello, Is there any way that in report list, when I select multiple records, it tells me how many I have selected? Thanks.
Zoho Creator Pivot Report - buttons are hidden on smaller screens
On Pivot Reports, the Refresh, Sort, and Export buttons are not visible on smaller (13 inch) screen sizes. Even when the screen is extended to the right, it doesn't show. This is a critical feature for us. In the screenshot below, this should normally
PDF Page Breaks
I have a HTML view that I am exporting as a PDF however the page breaks are the wrong places. Is there any way to define where each page breaks to ensure my layout is correct?
Failed to load ZML - Hotel Management > Check-in History > Click on Invoice 1 or Invoice 2
Failed to load ZML. Please check for errors in your ZML script and reload. Hotel Management > Check-in History > Click on Invoice 1 or Invoice 2
Total QTY field by DATE field?
We ship widgets and I would like to see a report that shows how many stops and total quantity shipped by day. Attached is an excel example when I'm doing it manually, but I'm hoping there's a way Zoho can automate this process in a report or page.
User does not see updates in the app
Greetings, hope find all good and safe! I have created an app (Zoho Creator 5), added to Zoho One and shared with an user. After, I have done some updates in the app, but the user does not see the new updates. Is there some procedure that I have to do
Creator : Adding a customer record on sign up - getting the zohoid
I have an external sign up form and when the new user signs up I use the following script to update the customer portal : thisapp.portal.assignUserInProfile(input.Email,"nzaas"); What I want to do is also add a record to a form called customers and then
Trying to Hide and clear multiple fields at once
Hi guys so ive got a form where im trying to let the user select a Division, and then a Category, and then the sub-category. Each is dependent on the level above it. How can i make it so that if the user changes their answer on any of the levels, it
On User Input read value and then clear field - Barcode
Hello I have a form that has a barcode reader field that when the cell receives the code automatically adds a row in the attached subform showing information from that scanned code. The point is that I have done this with the 'On User Input' workflow,
List function format
Hello, I have this scenario: codesFormA = input.Multiline.toList("\n"); codesFormB= List(); for each line in FormB[ID == input.Lookup_Field_Name] { codesFormB.add(line.SubformB.Code); } My question is why codesFormA returns: 1,2,3 And codesFormB returns
Copy value integration field
Hi, I have an integration field with CRM to look up account names, I want to copy these names to another field but every time I do it I get an ID. I have tried like this: input.other_field = input.integrationField;
submit button on top of form
I have a form with many fields. The user needs to page down 3 times to get to the bottom. I've arranged the fields so the important fields are near the top. Most users will never need to enter information in the fields near the bottom of the form. Is it possible to create an additional Submit/Cancel button on the top of the form? Currently all users need to go to the end of the form just to hit Submit. Thanks Herb Wexler 222.PreventingMediocrity.com
Open subform as popup from report button
Hello, I have a form that has a subform inside, this subform I want to fill it when I press a button on the report page and then save this data in the record. I have seen some examples in other topics but it is not clear to me because some have different
JS SDK - I can't execute from other route than index.html
I am working with a React widget. When I try to use AddRecord from the JS SDK APIs from /index.html of my react app the request is successful. While when I try to use the same function from the same promise (initialised in App.js) but from different route,
Add a record in another form and adding new fields
Hello, I would like to ask how to do so that when an order changes status, for example delivery, automatically add a record in another form with some of that data and adding one or two new fields for example, file upload. In the end what I want is that
Add sub stage to Kanban
Hello, I am making an application for internal company use with Zoho Creator, I would like to know if there is a way to add as a kind of sub-state to an order. For example, I have an order in production but I want to indicate that within the production
SMS Twilio Response
Hi Everyone, How does Zoho creator handle a response from Twilio is an SMS is sent and then the user replies. With Twilio the they have php, ruby, C#, javascript, erc. But how does this integrate with Creator in order to handle a respose?
Logged in user view
Hello, We made a custom app (Days Off) in Zoho Creator. The Admin (who is also the sales manager) will create reports every month for every user (e.g. pierre_beerproject) by selecting a users name in each report. The purpose is that each user will have
Is it possible to generate a generate and print a QR Code/Barcode on printed documents
Hello Friends, I'm wondering if it is possible to include a barcode/QRcode to secure or prevent forgery of documents printed from my developed apps
QR Code to Create/Edit/View Forms
I conduct agricultural field trials and each test has a sign - that I intent to codify with QR codes. I have a record of each trial and every week we have to update information. I would like to use QR codes to do the following: 1. View records. 2. Edit records. 3. Create new records.
Generate random QR code
Hi Dev , i am using the Event management app in zoho creator , i was wondering if i can send a random code generated as a QR to the confirmation email sent to people registering . it could be the autonumber field. e.g. Thank you for your registration , please bring this email with us to scan your qr code and the QR code will be shown in the email. thank you
QR
Hello, Can you print or convert a form in validate to QR? Or put a button to create the QR with the data entered? Thank you in advance for your help. Eloy
Zoho Creator form import data sheet
Hi, I am currently moving off of google docs to zoho. I just created a zoho form via zoho creator. My Google docs form already has data since 2009 and I would like to import these data to my new zoho form (in zoho creator). I can't see the import function and my zoho form only allows me to complete 1 form at a time. How do i import a sheet? perhaps from excel? Many Thanks, Mark
Pivot Chart - comparing data from the same field
Is it possible to replicate the attached screenshot (which was created in Excel) in a Creator Pivot Chart? The blue columns are aggregates of a single field, ALL records. The grey column is data from the SAME field, but for a SINGLE record. I've played
PULLING RECORDS FROM EXTERNAL API DIDINT WORK
Hi everyone, I just want to ask if you have a solution for this. We already reach out to Zoho Support about this problem. They suggested optimizing the script and looping in the script and upgrade the current plan of the account, We already optimize
Can we List the customer portal users in Dropdown list automatically?
I am looking for a way to fetch the customer portal users and automatically will list in dropdown menu. Is this possible?
Keyboard Shortcuts in Zoho Creator?
Does Zoho Creator support keyboard shortcuts at all?
Next Page