Time Comparison
I need to check if user has performed some form action after 10 am but before 11:45 am. While I can easily look at hours as shown below, is there a solution my question? if ((zoho.currenttime.getHour() > 10) && (zoho.currenttime.getHour() < 12)) { //some code; } Cheers, John Whitney
Passing a multiples select lookup field to a function
How do you pass the contents of a multiple select lookup field (in my case a list of IDs) as an argument to a function?
Formula field: text formatting?
Hi! I have a text only db and I need to concatenate and format text strings in a forluma field. Could you please help? It is a bibliography so my formula should return something like this, Reilly, Rahtz, 1992 Paul Reilly, Sebastian Rahtz (eds), Archaeology and the information age. A global perspective, London, Routledge, 1992 I am ok with concatenating fields and with adding commas and periods or fix words among them, but I have a couple of problems: 1) Is it possible to manage style (e.g. Italic or Subtitled)?
Multiple Select Lookup fields
How do I set a single value in a multiple select lookup field using the insert into statement?
Possible bug
Hi All, Apologies if someone else has spotted this but when duplicating a form by copying the With Action definition from the original and pasting it into the new form, if the word "unique" is in the script, an "null" error message will be shown. If you remove the existence of the word "unique" from the xml, the script will then save correctly. Perversely, once the script has been saved, you can put the "unique" word back and the script will still save ok.
Zoho Creator and Google Drive
hello, is it possible to create a directory in Gdocs in Zoho Creator ? thanks
Connect applications in the sections of a main application
My company needs a huge application with a combination of subapplications. So I would like your opinions for the structure of the application. Let's say that I have a main application (Extranet) with sections Inventory, Managing, Trading. It's section is a separately application. For example Inventory has forms for hotel details, type of rooms, room prices etc, Managing has another 4-5 forms etc. The same with Trading. My question is how can I connect these 3 subapplications in the main Extranet
Update on ZohoCreator apps && ZohoCloud SQL
Hi Team, Could you please provide an update on the integration of ZohoCreator apps && ZohoCloud SQL Presently only ZReports is supported. Even that doesnt seem to have the oDBC diver support. (or did i miss it) Please advice Thank you Regards -Deepa Govind
Multiples addreses in sendmail
If you send a single email to multiple persons then what is the correct syntax? What is the address separator and are spaces ignored?
And If
Is there a way to perform an "And If" I have work orders being sent to my office when they are completed by the tech. I also want to be able to send some of my customers a copy of the completed order when complete. But not all of them, just certain ones. Example; Work Order If input.Billable = yes then email else If input.Billable = No then email and if Customer = Joe send email to Joe's boss "I only want to send email if the customer is listed"
Create HTML view of records
Hello I would like to know if its possible to create a HTML view which shows a summary of two forms that are related. My situation is as thus: I have two forms Clients and Commissions. In the Clients form I have an agent and client. In the Commissions form I input the commission for each client. [This is the related link]. I would like to know if its possible to have a HTML view which allows me to show the total received by each agent, and I can also choose the month. The HTML view should show all
Cancel button not working when I open record in a new window for editing
I've created a field that displays a link in my view allowing users to open the form in a new window for editing (to avoid the popup/floating window, which creates problems for us in certain situations). The problem is, the "Cancel" button no longer works in this window. "Update" works fine, and the user can close the window to avoid updating, but I'm afraid that if the cancel button doesn't work, they will feel forced to click "update", which could lead to data loss or input errors. Is this a bug
Function tolong()
What's wrong with the following that I keep getting the error message below? temp_list=List(); for each selection in Team_Members { e = Team_Members[ID == selection.tolong()].Email_ID; temp_list.add(e); } Team_Members_Text_List=temp_list.tostring(); Error at line number : 4 Not able to find 'tolong' function
Uploading data
Hi, I have a view in which I want to upload data periodically. The data language is portuguese and there is a problem during data upload for words with accentuation("á", "ã", "â", "ê" "õ" "ç", etc). The data is in .xls format and when the data is imported the accented letter displays as unknown. Do you have any suggestion to prevent unrecognized letters? This Zoho's limit doesn't allow us to have a good use of Zoho Creator because we have thousands of data and most of them has accentuation. If it
function page error
Hi, When I'm trying to click on define a function in Custom Actions it gives the following error
Subform and Mainform relationship
Hi all, I have created one main form and one sub form A is the parent form and B is the subform or child form 1- Form A has a unique mandatory field and I added a subform field in A that pointed to B 2- Created a lookup field in B that points to the unique field of A mentioned above 3- In form A Report added the autonumber field of B and all the relationships seems fine except if I create a record using form B, it does not show up in the Form A which is the parent although I select the right record
Android native app for Zoho Creator
Team, What is the latest update on the availability of a Zoho Creator native app for Android & iOS? Thanks
IOS App Suggestions for Offline Front-end Using ZC as Back-end
I need to be able to collect data offline. Does anyone have experience with or a suggested app that is available on the market? I don't want to waste my time with junk as there are many apps out there. Thanks for any suggestions!
Expanding field in zoho creator
I'm working on a project which includes showing created leads from zoho crm into zoho creator form. i.e if there are 2 leads, 2 lead names should be visible on the form . Which field can we use for this purpose in "form builder" to build this application in zoho creator which gets expanded in accordance no. of leads names available to be shown ?
.toLong() not working
I have a user defined function that calls .toLong() built in function I have added it to one line and it works fine. I tried adding it to another line of code but I get the following error. Is anyone else experiencing this issue? How can I overcome it? Not able to find 'toLong' function
Subform picklist problem
I mailed support about his problem a few days ago, but have had no response other than "we will respond soon". So I thought I'd try my luck here. I was running the script below on the On Edit > On Load action of a parent form to populate dynamic picklists on a subform with the data that was saved previously. This has been working fine until a few days ago. When I made a change to a different line in the script totally unrelated to this code I got an error message saying "variable record not defined"
Is "Duplicate" broken?
I've been trying to duplicate my own application all weekend and I just get the "Duplicating - Please Wait..." message until everything times out. What's going on?
Button on a form to run a script?
I have a series of data input fields, visible calculated fields and fields that show as set variable results. I want the script to run after the user has completed inputting the data and this is of course easy to do as an 'on user input' on the last field. However in many instances the user will see the results and wish to recalculate after modifying one of the input fields. I need something like a RECALCULATE button at the bottom of the page. Any ideas?
Label colour: change background or text?
It would be useful to be able to differentiate fields on a form by colour, either the text or the background. For example I have visible calculated fields and financial summary fields where this would be handy. Any ideas? Right now all that I can think of is running a red line in a notes field.
Auto Number issue after import an application from .ds file
The Auto Number field was working perfectly when we initially created the application. However, after we import the application again from a .ds file, the Auto Number field is ignoring 'Start Index' and always start from 1. Any suggestions?
How can I prepopulate one form with data that has been previously entered in another form, in same application?
I am looking in https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form But I could not make it work :-( On my application (which I am trying to build) is like that: There is a Form "Registration" and 3 fields (Number; Name; Email) There is a From "Feedback" and 3 fields (Number; Email; Comments) So, every time that the customer put his Number on "Feedback" form, I want his email to be automatic updated. Could you make an exemple to me? Thanks!!!
Issue with Groups
I just sent a bunch of invitations to join a security group for an app in zoho creator. When I got the invitation and clicked "join group" I get an Invalid Confirmation message.
Zoho Creator Support Still on Holiday??? [Urgent] Pages Script is disappear and Version History Gone
Hi There One of our Zoho Creator Pages (PLC-Monitor) has been changed to something else by system, and all version history are disappear recently. Could some one help Support Function is Enabled. Thank you!
Add a URL to an Add notes field within a form
Hi, I want to insert some Add Notes fields into a form as help. I then want to create a link so a user can click it and go to another website. The Link icon in the Add Notes field asks me to insert the URL but does not then allow me to create the Thanks, Clive
Make a form field mandatory based on response in another form field
For reference, see my Creator form at http://www.jaxareagolf.org/index.php/meeting-notice%E2%80%8E. In the Attendance Options, if a user chooses "Meeting, lunch, and golf", I want it to be mandatory that the user also put a response in 'Tee choice:' and 'Handicap INDEX'. I am not quite sure how to go about doing that. I would appreciate any help. Barney
Multiple conditions( Help)
I have the Client Rate Table that contains the Company Name that is a lookup to the Company Table. The Client Rate Table has multiple records for one company. the records are differentiated by the Rate Category Field in the Client Rate Table. Based on a radio button selection in The Time Entry table <Rate_Type>, either "Normal" or "Storm" I want to load the rates from the Client Rate Table that are based on that Category from the Client Rate Table. r = Client_Rate_Table[Company_Name == input.Company_Name
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3 I have 3 forms Patriot_Time_Entry Client_Rate_Table Work_Type I am working in the Patriot Time Entry form When I select a Work TypeLookup that matches a Company Name in the Client Rate Table, I want to populate fields in the Patriot Time Entry Form.
Alternate to subforms
Let me start by saying I'm frustrated and losing faith in Zoho. Zoho pitches their service as easy to use and mobile compatible....but they neglect to make it clear that certain features do not work well on mobile devices. And the new Android Creator app does not handle subforms with image uploads. So I invested a lot of time and money creating and app that allows us to create work order tickets for our field service tech. Everything we do is documented by photos. It can be 5 photos or 20 depending
Application Context
I was testing out the password retrieval / reset for an app and discovered a few things that should be fixed to keep the user's experience focused on my app rather than on Zoho services. This is related to my other post which has yet to be addressed although the service was updated today. The sign-in page and link to password help is within the application context. No problems here. Clicking on password help, the user is taken outside the application context. Here is the first issue: the logo is
Another window type for openUrl
Hello! Can you add a new window type in openUrl function? Type "New Tab". "New window" is not easy to tabbed browsers. Thank you, Ulia
Sub Form Fields
Hi There I am creating my first ever App in Zoho, using a number of Sub-Forms as my one-to-many relationships, and also to create one "Master Form". Would I repeat my Primary Key Field on each Sub-Form as a Look-up Field, to accommodate "Auto Filtering"reporting from a field on one of the Sub-Forms when creating a Report from the Master etc? Would I need to repeat other Fields from the Master or other Sub Forms to also accommodate this? Kevin
I can't get a condition for a Report to work
I have a report that lists all companies grouped by territory. I want to open that report restricted to companies in the territory in which the current user resides. The user's territory is PersonForm[Email_fld==zoho.loginuserid].Territory_fld In the report definition I want to say show all rows from CompanyForm[Territory_fld == this user's territory] But if I code it thus show all rows from CompanyForm[Territory_fld == PersonForm[Email_fld==zoho.loginuserid].Territory_fld] the
Is there a field limit?
I searched but could not find the answer. I have a zoho creator application that needs over a hundred fields on a single form. I get 99 added, but when I drag the 100th field onto the form, I just get a spinning "adding". Have I reached a limit?
Need unique case ID field
If I use the auto number field, it is hidden and the user cannot see the field to use that as a case id. Due to confidentiality requirements, using the victim name is not an option. I am assuming I will have to use a single text with no duplicate entries. But, this means the users will have to generate their own case ids. Is there a better way to insure compliance and consistency? I would really like to keep my current method, ##-####-#### first two digits, member program service provider id
Creating a composite report
Hi everyone, I need to produce a composite report for my database. The database contains student information. The first table contains the "front page" information, consisting: Name, DOB, Class, Residential House. Then there are other tables all with a lookup selection box in each pointing to Name+DOB from this front page. These tables contain: Home Information Family Contact Information Emergency Medical Information Daily Requirements etc etc I need to produce a final report using the majority
Next Page