Changing a radio button to a check box?
I recently took over administration of an already created form. There are many instances where there is a radio button but I need it to be a check box so multiple answers can be chosen. Is there a simple way to change a radio button to a check box? Thanks!
Update email notification added user
I am the administrator, when a user asks me to update the information in the database that the user entered, how can I send an email notification, that I make the change? I try whit it, but not work (added picture)
API
what is the difference between REST API and XML RPC?
Integration with otp
Does zoho creator support OTP integration?
Inventory Management
I am trying to use custome action on a report to transfer data from one form to another and make the new form editable is the possible
How to sort results of CRM API response
I'm requesting records from CRM API inside a custom Creator Page using code like this: apiUrl = "https://crm.zoho.com/crm/private/json/CustomModule3/searchRecords?newFormat=1&authtoken=XXXXXXXXXXXX&scope=crmapi&criteria=(Device_ID:99999999999)&sortColumnString=ID&sortOrderString=desc"; apiResponse = getUrl(apiUrl); I need the records to be listed in DESC ID order. So the most recently entered record will show up first in the list. How can I accomplish this as the searchRecords method does not seem
Problem in sharing application
Hi, I have tried sharing my application with the other user, but unfortunately it is opening with the other section instead of opening with my section which I shared. I don know from where it is taking that url. Whichever the section I share it is opening for the user only with the particular same section. It is urgent. Please help me out of this issue. Thanks, ITKES
Insert sub-form records individually in record template
Hi, I need to add the fields of my sub-form record individually in my template and the hard part is that i need to do it individually for each record. Is it possible? Regards
Function - passing current (sub)form data to function impossible?
Hello, I am trying to make a function, that would as parameter get the current subform data, and based on that make calcualtion. But it seems impossible, I get an error: Error details: Error in executing On User Input script of the field, Štev. obiskovalcev Error. Error in executing Set Variable task. Unable to update template variable tot. Error evaluating NUMERIC expression : Error evaluating COLLECTION expression : New Collection row cannot be passed as argument to function. It seems like Zoho
Lookup fields stopped working today
I have been running my app for almost a year now, no changes on my end. Today my lookup field to lookup field stopped working. I have a Category and a Product lookup field Category is selected first I have about 7 categories (flour, sugars, spices.....) I select flour and the next field should limit the Products to just the Category of flour, but today it saying "No Matches Found" I havent changed anything on my end. I look at the FILTER section on the Products field and it has SET FILTER checked
Missing display fields in a lookup field
Hi Everyone, I have a lookup field that has a filter set based on a previous lookups selection. Similar to the country and state scenario. My scenario is a vehicle make, model and variant scenario though. I have a form for each - one for make, one for model, one for variant. Make just contains a single line for vehicle make Model contains a lookup to the make field and a single line for model Variant contains a lookup to make, model and a single line for variant but also a dropdown for year from,
"Error occurred while duplicating records" without reason
Hello. As the title says, my app started throwing the "Error occurred while duplicating records" error. It even doesn't allow me to add new records. And it doesn't inform the reason, so I don't know what to do to fix it. What can I do to solve this? Thanks in advance.
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?
Next Page