Print and save form
Trying to build an app for our Racquet stringing business. Want to be able to print customer information and save as a separate record. If they have multiple racquets want to save separately.
Fields not showing in report builder
Hi, I am not seeing several fields that I need to build reports. They are not multi-select fields, just look up and drop down fields. Found this from 9 months ago, but going to properties also didn't help. Thanks, Jeff
zoho creator backup will not contain the files that were uploaded using the File upload field.
I just read this warning buried in the zoho documentation: "The backup will not contain the files that were uploaded using the File upload field" I think this is a serious flaw. In any decent application today there will be elements that are uploads. e.g. scans, pdf's photos etc. In case of a crash how does one recover these? Are there workarounds? It's like an online Photo storage app saying they can recover metadata but not photos themselves.
Rounding non decimal number
Hi, I have created a function which takes 2 numbers and performs our calculations perfectly. However, I can't seem to find a function to round the number such as: 2214 -> round to 2210 2218 -> round to 2220 I have tried all the functions and searched the forums to no result. Does anybody have any ideas? Thanks
Calculate Pivot Table Column Difference
I would like to have a pivot table calculate the difference between columns in the table but I don't see how to do that. My data is rows of expenses by month by expense category, for example Category, Month, Amount Power, January 2018, $115 Water, January 2018, $25 Power, February 2018, $120 Water, February 2018, $22 My pivot table has Category as the rows Month as the columns Amount as the data in each column For example January 2018 February 2018 Power $115 $120 Water $25 $22 Is there a way that
How to filter a unique row with highest number of interaction in a list report?
Hi, I have a view named Customer Interactions in which I have captured multiple interactions of a customer. Fields are Unique ID, Customer Name, Interaction No#, Interaction Date and Follow up date. It is possible to have a multiple interactions with a customer in a same day with same follow up date. For those type of multiple interactions I just want to show a single row having highest Interaction Number(On every interaction ,Interaction No# increment by 1). ref: Figure - it contains 3 record of
Pivot chart axis reverse order
Hi I’d like to create bar chart whose Y axis is reverse order. Means smaller value will show higher. Please advice.
Azure SQL Database
How do I make a live connection to SQL Server on Azure from ZOHO Creator?
How to have a graph (from the values in the entry) show in the record summary?
Is it possible to build one/two graphs form the data inside a record and show those graps in the record summary/print summary? Thanks
Field in a record to be updated based on some conditions in another condition on the same form.
I am new to Deluge Scripts so am posting this issue here so someone can assist me. I have a form with the following fields. (1) Date, (2) Priority, (3) Due Date, (4) Past Due Date Priority is a drop-down field with three options namely High, Medium and Low. High Priority will have 30 days, Medium will have 60 days and Low will have 180 days. Below is the scenario: If someone enters date into the Date field and selects High from the Priority drop down field then automatically the Due Date should
Add AVG value of selected records into dashboard
Dear all, I created a Dashboard and displayed a report up in the screen. Right below the "List" report I'd like to add a field that displays the AVG value of a "VOTE" field that I'm displaying up in the screen. This field must be dynamic because it should reflect the average vote of the above selected report. Say for example the report is displaying all the votes a student got for multiple topics, it has multiple lines per student with different votes depending on the subject. The field should calculate
Round to the nearest 5?
Hi, Is it possible to round to the nearest 5 or so in Zoho Creator? So 30.5 would round down to 30 and 30.6 would round up to 31 and so forth? I'm sure it's an easy answer and I'm over-thinking this... Thanks
QUERY
Can we use a SQL Query in ZOHO Creator; I have a form and then I want to have a query based on information contained in the form report; Can we create a form which can query this report
Email Quotation through 'Quotation Management' App
I'm new to using Zoho, and been playing about with the 'Quotation Management' app, pretty much set it up the way I want it (not really changed that much from original app), There is a decision box for emailing the customer the quotation, but it is actually sending 'You've been granted access to Quotation Management by Company Name' email, where I thought it would send a PDF document with the actual customer quotation details?. Can anyone point me in the right direction? Thanks in advance, John.
One Dashboard for customers with only their personal data
Hello, I want to know if I can make a Dashboard for customers that when they access they only see information they have submitted? I want to create an app for customers so they can see how much money they have spend in our products. Thank!
How to change account status and send email to customer (non-repeatedly)
Hi, I have created a client form. On the form, I have 2 options being "Operational" and "On Hold". I have created the code that triggers "On Update" an email is sent to the user about the account change, however, I can't figure a way to stop it doing it - as in only once. Each time I update the form it resends. Do I have to capture the existing status and compare or something similar to only send it once? Thanks
ist of URL's to be whitelisted for using zoho projects
List of URL's to be whitelisted for using zoho projects without interruption, as there is no direct access to any application in our environment.
Tree view
I would like to have a tree view, like in the Windows file explorer. It would be really easy to see all the child and parent relationship with this. Does somebody has ever developped something like that?
Records before x days from today
Hello, I want to highligth in red in a report all the records that has their update time, for example, at least 15 days before from current time. So, in others words, all the records that are older than 15 days, make those records red in the report. Is it possible? Thanks!
Displaying images in form
I have picture field in my form. I want to see the picture when editing a record. How can I do that ?
Detail View of Lookup-field-link has no edit- and delete-option
Hello, I'm having an issue with the Detail View in the recently updated look of Zoho Creator. In the average case the Detail View gives the possiblity to edit, duplicate or delete the record. (As long as it is enabled like shown in 4: the settings of the linked record) But if I'm following the link of a Lookup field to the linked record as shown in 1., it doesn't show the buttons in the upper right corner. (compare 2.) By using a report of the linked record, the Detail View shows the buttons correctly.
Generate a report pulling data from multipule applications.
Basically i have multipul applications 1) All Horses 2) Farrier 3) Vet work I want to create a report where i can show all activities that the horses in "All Horses" have had completed. Thanks in Advance JD
Linking to local network files
Is it possible to remove http:// prefix from the URL field ? My files are located on the network drive eg. Z:\FOLDER\PDF_FILE.pdf When using URL field it forces browser navigate to http://z/FOLDER/PDF_FILE.pdf instead of file:///Z:/FOLDER/PDF_FILE.pdf How is it possible to link to local files for local network use?
Lookup Fields
Hello, I am new to zoho creator so forgive me if I use the wrong terminology. I have created an Inspection request form. I have a lookup field that looks up the permit number from another form called permit information. The permit information form contains permit number and the building address. How can I get the building address to a user input report without having to select is on the inspection request form?
zoho creator totaling subform error
Hello I am trying to add qty's in subform When I add a new line in the subform I am getting the following error The below is the code I am using input.Total_Training_Cost = 0.0; for each line in input.Attendee_Signature { input.Total_Training_Cost = input.Total_Training_Cost + line.Currency; } Thank you for any help you can offer Kind Regards Amanda
uploading images to google drive
My question is how to upload images to google drive form zoho creator. If you know Please guide Thanks in adavnce
Zoho Creator-Tasks Done
In the Tasks Done application, how do you change a tasks status to complete?
Can't change field value from custom button
Hi, I have been trying to get a custom button in my stateless form to change one ore more field values in the form. Using the syntax input.SomeField = "SomeValue"; works fine when used in onLoad actions or any of the field actions, but it does not seem to do anything in an on Click action? Ist this deliberate? Is there a workaround? Am I missing something? Thanks in advance!
Hide sections from non-admin users?
Hi Zoho, I have a few sections in my app that I would like to hide from users that are not an Admin user (or to show it only to me). How can I do this? show/hide button does not let me specify the users. Thanks! Ravid
[Suggestion feature] Double-click to row edit mode
From a list report, it would be really great to be able to double-click a record to enter some sort of row edit mode. Where only that row's columns can to directly edited from the list report view. At the moment, the spreadsheet report has big limitation: not more than one person can edit the records at the same time and no on-load workflow can exist. With having only one row at the time been edited in a "edit this row" mode, multiple users could work on the same report at the same time and on-load
Adding a Booking Reference field
I have a form for booking customer flights. I need to create a booking reference. Can anyone suggest how to. I want the reference to be random but I am willing to accept a solution which is more simple
How to add row to a subform on load workflow/script
Hi, Is it possible tom add rows to a subform on load workflow/script? I want to create three rows to a subform on load workflow/script but i didn't find any solution for the same. Guys if anyone has any solution for this please help me.
Report colum width
Hello, i just have the problem that the colum width seems to be only changable in the IDE. (if you have a total pixel width wider than screen size) My question is now, what's best to do with different screen sizes when using web only. You only can use px width not %? (Attached picture from the IDE) Now i have 5 colums and make them eqal on my screen should not be a problem, but it would be nicer to give % values, so that on another screen, they can see all without horizontal scrolling. Another thing
Retrieve relational drop-down list ID
I need to retrieve relational drop-down list ID, I have used following script: temp = FromA[Relation DropDown == "Variable"].ID; Relation DropDown.select(temp); but error appear Thank you in Advance,
JSON Response
Hello, Can someone tell me what I'm doing wrong, I want to fetch the tax_total from Zoho Books using a geturl function. The function which I made is written below: //API Books headerMap = Map:String({"Authorization":"Zoho-authtoken <auth_token>"}); x = getUrl("https://books.zoho.com/api/v3/invoices/" + X + "?organization_id=6231230351",headerMap); //Fetch JSON for MultiLine input.Response_Books_Get = x; //Get Total_VAT response = x.getJSON("invoice"); result = response.getJSON("tax_total"); input.Tax_Total_Tekst
Default Value per user based on user
Hello All, I have a form with drop-down list, this drop-down list contains countries, one user login to the system to show him default value from drop-down list with read only mode For example: User1 --> country USA by default from drop-down list User2 --> country India by default from drop-down list and so on. Thank you
Rearrange the menu
How do I rearrange the menu on the left See the picture attached
Updating data into a form with an excel import
I have created a form from an excel template and imported data from it. When I import another excel file with the same data it maps the fields and imports the data correctly by adding new rows. Is there a way to import an excel file but update the data based on a key and not import the rows ? For eg. Excel file with columns Product ID | Product Desc | Product Type | Qty | Rate Step 1. created a PRODUCTS form by importing the above excel file with base data Product ID | Product Desc | Product Type
Invoke a URL to fetch a record and populate a stateless form
When the admin clicks the button to invoke this action the form opens correctly and fetches the information. When 2 non-admin users try this they receive a message to contact the sys admin. When 1 non-admin tries this function it works correctly for them. I can't figure out why the users with the same level of access would have an issue. Any suggestions?
Look Up Filters
Hi How do you concatenate an input field with a look up field? For example, when I look up a form, I only see the feeds which are direct entries in that form i.e. "Cable reference number" but not fields which are lookups from another field i.e. "Location" or "Device". I want to see "CABLE REFERENCE - LOCATION - DEVICE" Also, how would you then filter the concatenated field
Next Page