multi select lookup with reports
i want to create a report for that selected lookup field entries how can i do that can you please send any sample code ? for each item in input.Students1 { ins = insert into filtering_students [ Added_User = zoho.loginuser Add_Academic_Year = item.Academic_Year Manage_Course = item.Manage_Course Manage_Batch = item.Batch Date_field = item.Date_field Add_Subject = item.Subject_field Students =item.Students1 empname = item.empname ]; } its my code . students1 is a multi select look up. but it throws
Acceso de info a clientes
Hola. Existe la posibilidad en zoho de dar algún tipo de acceso a mis clientes donde únicamente puedan ver su información sin necesidad de que tengan un usuario o rol???
image are not getting fixed size in pop up window
hello zc, In a form i add a notefield where that note field is used for showing image.when the form opens in main window the image size getting fixed when the image opens in pop up window it is not getting fixed.can anyone tell how to make a fixed size even in pop up window? input.plain = "<img src='https://www.smashingmagazine.com/wp-content/uploads/2015/06/07-functions-opt.jpg' height='300' width='1000'>";
Sub-form templates
Is it possible to combine multiple templates(templates of a subform) into a single template(template of main form)? I want to show all the subform templates together in the main form.. is it possible?
Background images
can i have a background image or change the background color in forms?
Deluge Script: filtering a view based on user input
Hi- Upon login, I want to be able to have a user select from a list of projects and then display a filtered view based on that project selection. I want to be able to do this in a script. Any ideas? Thanks.
Grouping Drop Down Values
Hi All, I'm trying to get a Parts Selection sub form working in my Repair ticket form. I have 4 fields in my sub form: Model Parts Catagory (Base Plastics, MotherBoard, Screen PLastics, Screen etc..) Parts Description (this would list say Screen Fascia, Palm Rest, Screen Lid etc..) Part No. What I want to be able to do is Choose a category, which then lists the descriptions under that category but only category once. So for example, I choose "Screen Plastics" as my category and I want 2 options,
Calculating the median by using percentile
Hi, I try to calculate the median with the suggestions made by one of your blogposts. https://help.zoho.com/portal/en/community/topic/how-to-get-median-to-work. I use a pivot chart in which I have the number of patients that had a fall per month listed. I added the formula as suggested by the answer to calculate the median: Percentile("Autoview_1498650252695_Clinical_Quality_indicato Table"."Number of patients that had a fall",50) but that does not work. Can you provide me with some suggestions
Retrieving actual text from a Lookup Dropdown
Hi Everyone, I'm following Zoholics videos on Deluge and used this statement to lookup the pizza price from the Inventory: colPizzaDetails = Inventory[Pizza == input.Pizza && Size == input.Pizza_Size]; This error is displayed when trying to save the script: In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid In the video, he was able to save the script. Looks like a BIGINT is stored in the Lookup Dropdown now instead of text as shown
My app stopped working - Lookup fields
I've tried 3 browsers, MS Edge, Chrome and Chrome on a Chromebook. And my App stopped working over night. I have two lookup fields, The first lookup field never sets up the second lookup field. It was working fine yesterday and today its not working. I've not touched my code or changed anything as its a production program, so I'm at a loss as how to fix it. Thanks Andy
my account is inactive
my account hello@sexysexdoll.com is inactive without any pre-reminder. I have tons of customer requests there, now I can't access to my business, it makes me lose a lot of money now! this is ridiculous. Please reactivate my account ASAP.
Computation of Age
How do I automatically show the age of an employee based on his birthday input and today's date? what field would I use - number or formula field to show such automatic computation? Thank you. frsaiop
How to Cache Lookup Fields for Offline App Access?
Hi, In the Offline App access section it says that my Form will be cached for offline access if it meets the conditions here: https://www.zoho.com/creator/help/application/offline-mobile-access.html My app meets these conditions and is available offline, however, I notice that the lookup fields are blank. Obviously this surprised me, shouldn't the lookup fields be cached so they have all existing choices in them when offline? I noticed that if I load the Form online, go through all lookup values
Simple search interface with a Lookup Field instead of Single Line
Hi, I want to apologize if my question seems too trivial - I am just getting started with Zoho, and I figured almost everything I need except for the search function. I want people to be able to search my records using their email. I used the Search Interface in Zoho Creator tutorial available on this page - https://www.zoho.com/creator/help/application/search-interface.html. Search works when I am querying a form that uses Single Line to store data. However, the problem arises when I search the
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.
Next Page