Google maps
Hi guys, Is it possible to integrate google maps? Simple example: I have road warriors working for me, but sometimes they don't the route. Is it possible to just input a location into a field and let google maps get it automatically ? THanks!
openurl popup
Using the popup option in the OpenURL is there a way to specify which monitor? I have 4 monitors and would prefer the popup to open on a different screen rather than cover the original creator screen.
Integration between Zoho Creator and Workflow Max
Does anyone know how to get integration between Zoho Creator and Workflow Max? We need the information to sync both ways. If anyone has any information on this please let me know.
Populate checkbox based on filtered data from another form
Hi, I have a form with countries, then a form with states linked to a country. I then have a third form that you can select a country from a lookup but what I want to do is make a checkbox field appear containing all of the states associated with that country. Is this possible? Thanks
Is it possible to use the Column sum value in script
Hi, I wonder if it is possible to use the sum value of a view's column to say fire off an email when this value exceeds a certain number. I can't see how this can be done at the moment because the variable doesn't seemed to be defined anywhere. If this is indeed not possible at the moment, is my only option to add a forumla to the form which will calculate the running total of the value of the the formula field in each form? Is this method documented in the Help wiki or the forum - can't find anything!
View field records
Hi guys, On the zoho creator app, how can i modify what i see, when i click on reports? For example: Report A: Record A Phone number A, Status A Record B Phone number B, Status B But i would like to see: Record A NamePerson A, Status A
sendmail via subform event
I have two forms: Projects and Tasks. Tasks is referenced via a subform within the Projects form, so users will only interact with the Projects form, and won't touch the Tasks form directly. I want to send an email when new tasks are added via the Tasks subform in the Projects form. I am using the sendmail function on the Projects > Tasks (subform field) > On Add Row event, without success. I suspect the problem is that OnAddRow executes the script as soon as a new row is created, but for my
Question about round function
Good Evening. Maybe an easy question but I am trying to understand how the 'round' function is working. So, I read the tutorial but my question is the following: If I have a number lets say 13.26 how can I round it to 13.50? Another examples: 13.26 -> 13.50 13.24 -> 13.00 13.76 -> 14.00 13.74 -> 13.50 I think that you get my example. I do not know how can I do it with the round function.
Fetching or Updating records between form and subform (in another form)
Hopefully it is easy to fix; else it might be a cool challenge ;-) I am building an application where we try to provide customers a service where we collect offers from partners that we work with. I have a main form called Leads where our customer request is being stored. In this form there is a subform (Offersummary) with a simple lookup picklist dropdown to select to which partners (field: Offerpartner) we request an offer. In general we have 3 partners receiving a request from us to make an offer.
send mail record update
i have seen some post relating to using send mail and with in the email it contains a link to the record to edit the record. However I want to know if it is possible to have a URL to actually update a record, with out the user ever having to open the form? Use case would be something like a invite email and with in the email they either hit a will attend button or a will not attend button and this will update the forms accordingly.
Reports missing data
I have created some customer reports and some of them are missing data. I have checked the fields in the main view and they appear identical, to some that are showing in the report, can you help?
Edit and replace an uploaded PDF?
In an application, documents are uploaded for management review and signature. Is there some expeditious way in which we can avoid downloading from the link, editing and then uploading the new document? All ideas appreciated.
How to enter email with '&' symbol
Hi, We have an email contact that have '&' symbol in it (for example Bob&Jane@hotmail.com) and we cannot enter it in the Email Address field. Is there a work around this? Thank you.
Create applications via API
Hi there, I am looking into the API of zoho (at https://www.zoho.eu/creator/help/api/rest-api/zoho-creator-rest-api.html ) but did not see a way to create / update applications using the API. Will this be available anytime soon? Also is it possible to higher the API limits from 50/hour to for example 5000/hour on request?
I cannot duplicate an application in my workspace
Hai I cannot duplicate an application in my work space . Can anyone clear this problem?
Regarding the update of my dash board
i had the total salary data in my forms a dash board to display the monthly wages of each department every month and total wages of the every department in a month
CUSTOMER PORTAL EXAMPLE
Hello, anyone has an example of "Customer Portal" made with creator? I want to try it.
Application Design Help - Delivery Driver
I'm trying to work on a delivery driver application. We have 13 AM drivers and 8 PM drivers, they deliver to pretty much the same buildings ever single day (i.e. repeating / automated daily records is a must). There are some variances (quantity, additions, subtractions, etc). As a driver leaves our production facility they check out their truck and their product. Once they deliver the product the need to update the building as delivered. I need to keep records of all of these deliveries. What
Can't drill down on published pie chart
Hi Everyone, I published a pie chart report and send the url to an email. When the recipient clicks the link the pie chart is displayed but they can't drill down. When you hover the mouse over the pie, the tooltip doesn't say "Click to see the data". I have a basic plan. Is there a restriction on that plan that does not allow drill downs on published reports? I can do it from the creator though. Here's the report: https://creator.zohopublic.com/rleiman/vacation-requests/report-perma/Days_Vacations_were_Taken/x8mBtFXOz4qMXyH4YnX3b5h3nAbg32mBxHE28R3p5DqfYVnCVXfH4UxtzYDVsUYkZQd36yEPM4QqjsVsW5Wuaaj9hsUHRgju9xzV
Work-around for working with Bank Account details
HiI believe Zoho Creator doesn't allow storing of sensitive information like bank account details in its forms. But most of the applications I'm building (e.g. vendor management, payroll) would be incomplete without bank account details. For instance, how can you claim your payroll application is complete if it can't generate a report containing the following basic fields- employee code, employee name, net amount payable and bank account details. These are the minimum information a bank would need
Avery 5160 Mailing Label Support
Hi Everyone, We are evaluating Zoho Creator and want to know if it has support for printing to Avery 5160 mailing labels or exporting to a PDF using the 5160 labels layout and positioning? We plan to print names and addresses to the labels. Thanks in advance. Truly, Emad
Year view for Calendar report
Please implement this feature! A year view for the calendar report!
Photo Metadata
Hello! Is possible to keep the metadata of a photo when is uploaded to Zoho Creator? What i need is to obtain the GPS coordinates of where the picture was taken. Thank you in advanced, Regards!
Implementing global variables...sort of
One of the big gaps in Creator is the lack of support for global variables, i.e. variables with a scope extending outside a given bit of script. The usual workaround suggested by Zoho - creating hidden fields on forms just to store temporary data - is really ugly. Three reasons it's a bad idea: a) Even if you hide the fields from all but admins, admins do have to see them (it's a pain to issue hide statements in script all the time, too); b) they aren't truly global, but are scoped to that instance
Using URL to fetch record and open in a stateless form
Struggling with a stateless form problem. 1. Public - stateless form 2. Form includes a lookup field; that once a lookup item is selected the record is fetched and the fields load with data. r = Vendor_Dispatch [ID == input.Vendor_Dispatch]; input.Description = r.Description; input.Open = r.Open; input.Close = r.Close; input.Start = r.Start; 3. URL to form has the lookup field at the end with the lookup ID https://creator.zohopublic.com/USERNAME/APPNAME/form-perma/Vendor_Invite/ENCRYPTIONKEY?Vendor_Dispatch=3080649000000690931
linked lists like in CRM
Hi all! Please, help me with one issue. I want to create linked list in Creator with algorithm like in CRM. I mean that when I create record in related list using it's own form (analog in CRM - creating Deal for Account using module Deal), I want to see this related record in main record's form after saving. When I adding subform to form, relations added only if I create record using this subform. If use the main form for the same operation there are no relations between main and subordinate records.
Zoho Creator + Zapier
Hey guys, I'm trying to write a Zapier hook so that I can import data into Zoho from other sources. The limitation of Zapier is that they only support sending JSON for the post body (ie {"authtoken" : "MY AUTH"} ). I don't see any sort of Zoho API that accepts data in this format. Am I missing something or does Zoho not support POSTing JSON? Thanks
Mail Merger with Writer
is it possible to do a mail merge with documents sitting in zoho writer?
Custom Action Edit Function - Not Getting Saved
Hi, I have created a leave application app. In the report , I have added a custom action for leave status ( pending , approved) . I need to send mail based on the approval . I try to edit the function page , but it is not saving. I have attached the screen shot of the function Edit option
I could not add record for lookup field via another form.
I could not add a record for lookup field. It's shows error message Error in executing On Add - On Success script. Due to invalid expressions insert statement is terminated Line:(2) Error on inserting the value for field 'Service_ID'. Given value '4' doesn't exist in 'Add_Service' form Line
Passing parameters to edit a specific record in embedded form
I am creating a dashboard for a customer portal in which I want to use the current logged in user (zoho.loggedinuserid) to find their corresponding customer account record and display it for editing after they log in. However I can't get the syntax correct. Here's my code: ******************** htmlpage Home_Page() displayname = "Home Page" content <%{ if(Boat_Owners[record_loginuserid == zoho.loginuserid].count() > 0) { //Display the Boat_Owners form so that the logged in user can fill it out
Offline mobile app
Hi guys, Can i use my custom app offline on the Zoho creator mobile app? If yes, can i get a link please? Thanks!
What is ui means ?
States:ui.add(statelist.ID.getall()); Here what is ui mean?
Can the 'Show/Hide Columns' option be shown or hidden in the url
Is there a switch in a url that will enable or disable the Show/Hide Columns option? In some reports I want to start with only a few fields and let the user choose the additional columns they need to see. In reports available to my customer portal users the 'Show/Hide Columns' option does not show. For some reports I need this option.
Fetch Data between different Applications?
Hello, When I fetch data among different forms in the same application, everything is ok. I am using: if(input.Project != null) { dat = Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But when I am trying to fetch the same value in another application, it's not working. I am trying the below code: if(input.Project != null) { dat = Project_Management.Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But it is not working. Can you please help me. Thanks Mustafa
Error in Fetching Data From Another Application - In Zoho Creator
I have written function in Application 1 to fetch Data from Application 2. The data passed and returned are in map format. i) I always get null values from Application 2 though the script and data passed from Application 1 are accurate. ii) But when the function in Application 2 Executed directly it gives correct values. App 1 Function: void retrive_from_Apptwo.retrive_information(int uniqueID) { product_information = Map(); product_information.put("UniqueID", uniqueID);
Content-Type is header not set correctly
I am attempting to update a contact in Google Contacts with postURL. It fails with error code 415 which seems to be connected with the content type. The Google contacts API requires atom+xml content type. I set the header for "Content-Type" to "application/atom+xml". API = gAPI [Name = "Contacts"]; header = map(); header.put("GData-Version", "3.0"); header.put("Authorization", "Bearer " + API.Auth_Token); header.put("If-Match", "*"); header.put("X-HTTP-Method-Override", "PUT"); header.put("Content-Type",
Library Form - Book Issue Return - Synchronisation -Stock upadtion -issue -Return
I have 3 forms for library management - 1) book stock entry 2) Book Issue 3) Book Return book stock has fields like bookId , bookname ,author etc , In bookissue form I am fetching, bookid , memberid as lookup values . when a book is issued to a member the respective book is subtracted from stock and the report shows the details of the member and the books taken by him or her . in book return - when a member returns the books it has to be updated in the stock . (each member is allowed only 3
there Should be a Button Field in the Form Body
it will be good if there's and button field in the form body , it can help in the type of form where an algorithm has to ran or a calculation has to be done on user input more often. like in quote calculator form I am developing , I use decision field right now , which seems inappropriate , since whenever user click calculate, after performing the calculation I have to uncheck the field via script to make it clickable once again due to which it runs the user input script once again. it would be
Unable to use GRID VIEW in a report although no client side Deluge Script is configured in the form.
As title says, I'm unable to use GRID VIEW in a report although no client side Deluge Script is configured in the form. At least none that I can see. Anyone would know how to solve this or how to troubleshoot?
Next Page