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,
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
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.
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
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.
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.
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?
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
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
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!
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?
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
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.
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",
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?
update form from another form
Inventory system. I have a form/table containing (among other fields) part number and quantity on hand Three scenarios which I guess would be handled with a series of if statements. 1: New part is received from the distributor. 2. part is removed by a technician for use on a service call. 3. part is returned from tech to warehouse a. defective part which was replaced is returned to the distributor . b. part is returned unused and will be added back into our inventory on hand a separate form
Print as PDF on Submit click
I would to like to print the record as a PDF when the user hits the submit button? I want the record to print as a summary, so that when the user opens the PDF record they can use a PDF signer to put a signature on the PDF. Is this possible?
entry changes logging
hi! is there any tools to log each change for every record in zoho creator app's database? or may be there is some webhook functionality to send every record's change to other database? need to know info like "at field A - new settings are X, Y, Z" so - task is to send current new settings to other resource when this field is changed
Dynamically updating field title text
I need to create a simple Form which has two single line text files, let's call them "Name" and "Response". Initially the "Response" field must be hidden. The "Name" field must give the prompt "What is your name?". As soon as the user enters a name, the "Response" field must be shown, and the prompt for that field must be "Hello <Name>, how are you today?" where <Name> is the value entered in the <Name> field. How can I implement this? So far, I've got both fields created and in the init script
Automatic
Hi guys, So i have a small problem. Sometimes i have 100 of products of the same brand, but with different serial numbers. So i have to input it separately. Is it possible for a field to remember the brand i choose previously ? For example : Serial num 001 Brand XLo (Input) Serial num 002 Brand XLo So if i have to do it manually for 100 products,it takes a while. is it possible for a field to choose the brand automatic, based on the previous choice? Thank you
Add PDF to email from URL
Hi, When a user books a course, I generate an invoice with an API call to our online invoicing platform. As a result from that call I receive the URL for downloading the invoice as PDF which I save in Zoho Creator. The next operation is to send an email to the user with the generated invoice attached. Adding a link in the mail to download the invoice is not an option, since the link contains our API token for the invoicing plattform. Is there a way, that I can download the pdf file to a File Upload
populating one subform data to same subform on next count
hi all, I have a form (Inwards) in which there is subform (remaining items on P.O). forget count 0 plz on count 1, subform add row i have populated count 0 data to subform which is working nicely on 2nd count, subform add row i want to populate (remaining items on P.O) to same form. i am using this script for 1st and 2nd count if(Inwards[Purchase_Order_Number == input.Purchase_Order_Number && Field_field == "Open"].count() = 1 ) { rec = inward_items_lookup[Inwards == input.Inward_Number]; i = 0;
can't duplicate an app
Hello I have an app “Inhabit Master” that I am trying to duplicate. It shows “duplicating” but nothing shows once it completes. It has 850 records. If I try with another app with 180 records, it works. Can you please help. Feel free to run the duplicate yourself if you wish and load it to my account. Many thanks Scott
Number of decimals not displayed correctly
Hi, I have a field that is of the type "Currency". When I use that field in scripting it only displays 1 decimal (eg. 220.0 instead of 220.00) in the form it is displayed correctly (220.00). Can this be fixed? Thanks, Michel
On Load script causing application error
I have the follow code that simply looks up a CRM Contact record and does some basic conditional logic. It works okay if a record is returned from CRM, however if nothing is returned for the criteria it shows an application error when it gets to this line: crmContactMap = crmContact.get(0); I thought it is because it's trying to work with a null record, so I've put this line within conditional logic that only runs if the record returned is not null. Full code is below. I can't figure out what I'm
Fetch data from In a subform and auto complete
Hi guys, Im a little stuck on building a form... The issue being I have two forms, one being the item form and another the order form. In the order form there is a sub form where there's a lookup to the item form using one of its fields but what Im having issues doing is using the lookup function in the subform and auto filling a field with data from the item form... Ive tried so many ways and I'm trying to keep it as simple as possible for the users... The best way we have thought of is using
Aborting an entry
I have a field action on the ticket number in my service form. After the user enters a ticket number the script will determine if that ticket is already entered, and if so, will populate all of the fields allowing the user to edit the data. Here's the problem. If there is a change that the user doesn't want to save, clicking cancel does not clear all of the data nor does it exit the form and return to the report from which it was called. If the user edits a ticket from the report list, there is
"if then else" inside "add record"
when updating data at form 1, a new record is created at form 2 some fields are directly transfered from form 1 to form 2 this is acomplished with "add record". but form 2 has a field (a) wich value depends on a value of a field (b) at form 1. That value has only two possibilities and should be obtained by a "if then else" with a value of a field (b) of form 1. how can this "if then else" work inside "add record"?
Next Page