12 Hour Time: Simple Solution
EDIT 07-FEB-2012: I made a free marketplace app for you all to test https://creator.zoho.com/public/showAppInfo?canvasurl=kqpjzaljg There are a number of posts here about TIME in ZOHO Creator. Many have requested ZOHO supporting a 12 hour format. With some help from Gave a while back, I have been using a rather long function to verify if a user typed in proper 12 hour format (i.e. 12:15 am or 05:00 pm but NOT 1:15 or 07:00 PM). I found a better way to do this that only uses a few lines of code.
Pivot Table report sub-total recalcualation
Hi, I have a simple application to manage a warehouse for an ONLUS that provide food to poor people. We are obliged to maintain a warehouse report in a specific format Each time a new product go IN or OUT we add an entry with: OPERATION DATE: date of opertation PRODUCT: name of product IN: quantity in OUT:quantity out the report must have a row for each OPERATION DATE in the below format OPERATION DATE_________PRODUCT 1_________|________PRODUCT 2_____ | IN |
Limit number of records in report
I am using Zoho Creator for project management and for each project I have a list of upcoming tasks and a deadline. I am trying to create a report that will show upcoming tasks for each project, but set a limit on the number of tasks displayed for each project. For example, if Project A has 10 upcoming tasks, I only want to see the next 3 of them with the newest first. I know how to limit the number of records per page, but I'm looking to limit the number of records displayed for each project.
Change start index of an auto number field
Is it possible to change the start index of an auto number field? after the first chance you have when dropping it
Best approach to obtain data from this type of Map
Hello, I have the following code snippet and I wanted to ask fellow dev on what is the best approach to obtain data from this map. What I'm really interested in is getting the Company string data from this map. Below I use a combination of prefix/suffix functions to get the desired data but is there a way to get the same data using map.get? MacLookupMap = { "responseCode" : "100", "responseText" : "[{\"company\":\"Lenovo Mobile Communication Technology Ltd.\",\"addressL1\":\"No.999, Qishan North
Multiple lookup-fields referencing same form
So in form1, I have lookup fields lookup1, lookup2 corresponding to field1 and field2 in form2. Whenever I change value in lookup1, I want value in lookup2 to change to the field2 value in the same row in form2..... this is dumb request... but can it be done?
how to add pictures to apps?
hi! how to add custom picture for each app?
Best Practice for creating relationship between multiple forms
So this is what I am trying to do. I have a form: Modalities, that is just a list of names basically, Modality_Names. i.e. Massage, Acupuncture, Personal Training, Rolfing, etc. Second form: Company, in which there is a lookup field (Modalities_Selected) linked to Modalities and allows multi select. i.e. Company.Modalities_Selected would be a list like Acupuncture,Rolfing My third form: Service_Providers, needs a field so they can only choose from the subsection specified by the Company.Modalities_Selected.
Formula field based another formula field
I found that to construct a formula field, I can't call another formula field .......... is this by design or sth is wrong with my form??? thanks.
Please help with some fetch code
I am having trouble with the following code if (Salesman[Name == input.Salesman].count() < 10000) { temp = Salesman [Name == input.Salesman]; input.Salesman_s_Email = temp.Company_Email; } Gives the error Error at line number : 1 at column 5 In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid but all the fields are strings Please help
adding a dot to a field
Hi How do I make a field that says 'nigel cross' to say 'nigel.cross' notice I want the dot in the middle instead of the space. Thanks
Fetch records only from this week?
Hi, Sure I am just missing something but how do I select records in a fetch script for records that have a date field greater than last Sunday so that every time I do it I get the records for the current week only? Thanks
variable from another field in Fetch feature.
Hello, lets said I have an app with 3 Forms: Local, National, Int. each form has the same information of products (Name, Code, and Price) except for the price, this is the different field on every Form. I have another form to sales, there I will select which pricelist would use, so I have a field named "Source" and it will be filled with the name of the Form I want to use, then I'd like to write an script to get the price of the appropriated list, something like: input.Price = Source [ID ==
Grid report not supported when using Deluge Script in form
My ability to use the grid view in reports for mass updates vanished. I found this: Grid report is not supported if there is any client side Deluge Script configured in the form (i.e) On Edit -> On Load script (or) On User Input script for any field. This appears to be a result of me adding the following for On User Input: Work_Due_Date = input.Date_Joined.addYear(1) ; The goal was to automatically populate the Work_Due_Date with a value of 1 year from the Date_Joined. Any thoughts on how I can
iCal Feed with single date event
Hi - I'm using this GUIDE to create an iCal feed for a task report. The URL is being accepted into google calendar, but no records are displayed. Because the deadline for the task occurs on the same date, I am using the same field name (Deadline_Date) for DTSTART and DTEND. Below is what one of the entries looks like when I paste the url into the browser, and it seems to be be pulling the data from the report...any idea why not showing up as calendar entry in google? BEGIN:VEVENT DTSTAMP:20160210T214625Z
Trigger date field update when another field is completed
I am hoping this is a fairly simple request, but, I can not seem to find the solution in documentation. Here is the scenario: Object has two fields: Date Joined and Date Hours Due When a member joins, they have one year to complete volunteer hours. So, when a value is entered in Date Joined, I would like Date Hours Due to be populated with a date value that is one year later than Date Joined. Now, here is the catch. Sometimes, members get extensions. If this is the case, the Date Hours Due would
how to install DKIM & SPF for sending emails from zoho mail servers with my zoho admin login?
Hi send emails from app recipient's mail servers say that email was send from untrusted domain and mail servers can't check trust of sender's domain zoho admin login is from "@yandex.ru" mail domain and email sent from zoho mail servers recipient's mail servers say that i need install DKIM and SPF how to solve this task, so that recipient's mail servers will trust my emails?
Give access to form but only allow them to edit one field
i have a database of clients that i want the sales reps to be able to edit the comment box but not allow them to edit the other fields such as the address etc. Is there a way to give them access to the form but only allow them to edit one field?
Text size
In a RTF field, I keep adding text from various sources. Then I try to make all the text the same size, usually the smallest available. Sometimes it works, sometimes not. When it doesn't I end up with a messy looking record with different size texts. I have tried copying all the text to WORD and making all the same size with no problem, then pasting back in ZOHO. While it works, it's a time consuming solution. As far as I can tell all the text I bring is is the same, but I must be missing something?
Zoho Creator SQL query updates
How can I write direct SQL queries to update data in forms? Thanks
hiding -select- from drop down fields on Sites Form creator
good morning id just like to ask for a tip on how to hide -Select from a drop down field please and thankyou
Complex query and update
I need to count by grouping fields FIELD1 and FIELD2. I need to group by FIELD1 and FIELD2, and get the count of each group. For example VALUE1, VALUE2 = 30 OCCURRENCES. Value3, value4 = 40 occurrances. I only need the value groups where the count is >1. Then I will get the FIELD1 value of the group and update all rows containing this value. I know how to write this easily in SQL but how do I implement it in Zoho ? Once this function is written I will make it run nightly.
Fixed day - x number of days
I have an issue in a form where I need to derive a new date based on a fixed date minus a variable number of days. The formula field would look something like: ((Fixed_Date - variable_days) / (1000 * 60 * 60 * 24)).round(0) However the issue of course is that the 'variable_days' field is STRING type data. How do I workaround this?
"Dynamic" HTML links
Hello All: I have built an HTML page to display project information. The page is working great and I am looking to add some more functionality. I have a couple of tables where I have iterated the information to be displayed. I would like to create links within the table to open reports filtered based upon the information specific to that row. I have links working but all the links within a given table provide the same results. This is my first foray into HTML so I am on the inexperienced side.
SEARCH FOR SPACE in a field
Is there a way to search for a space in a field in a form ? I have more than 50,000 rows in that form. Thanks.!
Auto Capitalize / format the first Six Words of a string - a free gift...enjoy!
Simply replace the ww and zz values with your own input and output point. be aware that the '&' cost you a word ('john & john' is 3 words to this script). ww = alpha_input_field; xx = ww; aa = xx.getSuffix(" "); ff = aa.getSuffix(" "); jj = ff.getSuffix(" "); nn = jj.getSuffix(" "); rr = nn.getSuffix(" "); if ((((((xx.length() > 0) && (aa.length() = 0)) && (ff.length() = 0)) && (jj.length() = 0)) && (nn.length() = 0)) && (rr.length() = 0)) { ee = xx.indexOf(" "); bb
Dynamic field names/labels, anyone have a good solution or work around?
Hello, I am currently building dynamic field choices on the same form that flex for my different clients. Using one form versus many forms is key to how we maintain our databases. My clients are in a similar industry, but sometimes they use different verbiage when referring to essentially the same thing. I have been able to get away with trying to use my "cookie cutter" form across clients, but I'd prefer to allow my clients to have their own terms used for each field display name, even though behind
Zoho Creator report page to automatically update Excel tab
Hi I have been trying to pull data from a Zoho Creator report via HTTPS into an Excel file. The format of the data does not look pretty in Excel. I have tried different formats.... what is the best practice in pulling Creator data automatically into Excel? Thanks!!!
Edit error messages for required fields
Hi everybody, Is there a way to edit error messages for required fields (error popup and red text below the field). I wanted to use show field (and cancel submit) when submit but we can't. Any advice will be appreciated. Thanks Pascal
Excel refresh
Hi how can I embed a Zoho view in an Excel file, and let the Excel side refresh automatically on a frequency or on demand? Thanks.
Search Bar in Zoho SItes Form
hello im creating an onboarding form threw Zoho SItes everything is working fine but i want to know if there is anyway i can have a search bar in the form itself? i have all the companies in a drop down box but i want to be able to hide the companies so other companies dont click the wrong file in the drop box, i know i can use a single line and use if (input.Search = "Company Name") { show Venue4; } but you have to spell the whole word and corretly aswell, is there a way i can create a search
Mandatory Fields through script
hello im currently writing an onboarding form for work but im having trouble with makeing a mandatory field for certain companys but not others ive tried a different couple ways but im absolutely stumped on it if(input.Company = "Company Name") { if(input.First_Name = null) { alert ("Emergency Contact Required"); cancel submit; } } ive tried this and replacing null with "" and it still wont work please assist
hide specific column from attached view
Hello, How can I hide specific column like "upload file column" form view when I attached this view in email. without creating new report without this column. Regards, Omar
trying to get list to display in multi line field
this script returns a single value filed and I need it to display a multi field list. Please help!! a = TZ2WOD_Work_Order_Details [ID = input.Select]; zz = aa.TZ2WODe_Group_ID; bb = TZ2WOD_Work_Order_Details [TZ2WODe_Group_ID = zz]; input.Line_Item_Display = bb.Group_Name; Cheers, Larry
how do i enable sms?
how do i enable sms? couldnt find setting-add ons=
Return Function date-time to text
I would like to make a function that if a date and time box is null, the become "". For there is nothing in place that says Null. I'm doing this function a new page, so I do not have the "Return" and I think I must invoke the function. Example If F_Registro is full { F_Registro = ""; } I am no expert in this type of functions, I have a similar function, but allows me only in numbers and I want to date a specific word, Nulltext string (string texVal) { orgVal = "0"; if (input.texVal! = null) { input.texVal.toTime
Setting up a barcode system with Zoho Creator
Hello! I am researching how to set up a barcode inventory system that is compatible with Zoho Creator. I am working with an art inventory, and I want to be able to refer to each piece of artwork with a barcode. My goal is to be able to generate a barcode, store that barcode in a Zoho Creator database, be able to print out a barcode label from that database, and have the database pull up a record when the barcode associated with that record is scanned. I understand that there are barcode generating
Copying string values between the same field in succeeding row?
In a subform, how do I copy string values between the same field in succeeding row? Sound simple but has me stumped...help thanks Larry
Auto update
I have created a field that reports the number of days between a date field and the current date. How can I get this value updated automatically each day to reflect the change in current date? Thanks, Martyn
Only show records being sought.
I want to know whether a view can make the record only appears if searching for the ID number,but if you do not want any record, appears completely blank list.
Next Page