Condition on time
Hi, I want to put a condition to hide the fields of a form if the currenttime is bigger than 5 O´clock, is it possible? Like a If ( zoho.currenttime >= 17:00:00) { hide input.Name; } Thanks.
different visibility/editing of data for different users
hi i have a amount of data for each entry (goods devilery order) in my zoho creator database. example: "id:date:name:address:phone:email:goods list:price1:price2:data1:data2:data3" how can i make different views of data for different users? with _editing functions_ example user1 can _view_ and _edit next fields "id:date:name:address:phone:email:goods list:price1" user2 can _view_ and _edit next fields "id:date:name:address:phone:email:goods list:data1:data2:data3"
Possible internal bug for list manipulations
I have two functions that both should do the same thing. Here's Function 1 int COUNT_BY_ID_ALT(list PRI_LIST) { //use samples CRA,BIR should be 263 n = 0; UNIQUE_ID_LIST = List(); for each element in input.PRI_LIST { ID_LIST = (SUBSCRIBERS[LISTS.contains(element)].ID).getall(); for each ID_element in ID_LIST { //makes unique list of ID's if (!UNIQUE_ID_LIST.contains(ID_element)) { UNIQUE_ID_LIST.add(ID_element);
error when sorting list
Hi! I am trying to retrieve the last 5 participants, introduce their names and performances in a list and then sort them and show the ranking in an HTML view. My code is the following: <tr class="zc-row-header"> <td class="zc-viewrowheader">Name</td> <td class="zc-viewrowheader"> Correct answers</td> </tr> <%index_list = {0, 1, 2, 3, 4};%> <%name_list = {};%> <%performance_list = {};%> <%for each index1 in index_list { row = Session_2_Water_and_jar [ID != 0] sort by Added_Time desc
Modify default table view - add data from another table?
Hi -- I've been at this for about a day now and I have not had any luck with this. Here is the scenario: Form 1 - Contains a list of Companies (e.g., Nike, Addidas, Reebock). Form 2 - Contains a list of store locations for each of the companies in Form 1. When displaying the table view for Form 1, I would like to display a new column that shows how many total stores are available for that company. I wrote a very simple function to query the data: LC = Locations[Company_Name == input.COMPANY_NAME].count();
using preinstalled image in form?
Hi i just make a working place for a employee. so, form with about 50 entities is divided in 5 categories. how can i in form for each category assign an image for quick orientation?
Problem when refreshing the HTML view from any button Click event
I have html view when I click on my button name is SUBMIT ,I insert the record and delete at same time via Delete.And after that I call Open Url and pass #View:Html_view .But here is problem that Adding record double i.e. value of my another view is double ,example:one date show twice.But if i am executing that HTML View by refreshing through URL it working correctly,No twice data. And in Button Click I only pass the URL. If Any one work on it please reply what is problem and solution.........
Sending an e-mail to everyone in view
I have a list of members in a view. One of the fields is e-mail address. How do I send an e-mail to everyone in the list? I know how to export data but it exports every field of every entry. all I want is the e-mail addresses.
Creator is Faster with Chrome latest versus FF latest
Just me or does anyone else notice this Chrome latest edit, views, all seem to noticeably faster than FF latest
Specific data in view can be clickable? possible?
Specific data in view can be clickable?
What is the Difference between the count function and Aggregate Record count statment
Maybe i am being slow today but under most conditions would they not return the same result and in fact serve the same purpose ?
Dynamic map key iteration
I am trying to dynamically populate four drop down fields based on a drop down selection. example: 1. The user selects a work type from a drop down. 2. The selection is passed to a function which retrieves four lists and stores them in key/value pairs in a map. 3. The map is returned to the form. 4. The keys are pulled and iterated in a 'for...next' loop. FORM SCRIPT WorkMap = thisapp.function(input.Work_Required);// this retrieves four lists with the keys set to the Form Field name WorkMapKeys =
help zoho support
this is the message in the view We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com why ? i lost my view because of this
Assign Point Values
Hello, I have a form that asks questions of the user, and I would like to assign a "score" to their answers behind the scenes. For example, I have a drop down field called "Licensing" that asks for the users license type and then there is a drop down with the following selections: N/A, Med 1, Med 2, or Med 3. I would like the following scores to be assigned to their answer: N/A = 0, Med 1 = 1, Med 2 = 2, Med 3 = 3. What kind of formula will work for me? Thanks
how to clear application view?
hi how can i delete unused (and deleted) forms from application view? see upper dark-grey row in attachment and how delete views in light-grey row an bottom?
Locations of Forms and Views
Hi, I made a mistake and put a couple forms and views on the wrong tab. Is there a way to change that? (e.g., Applicant View is on the Form tab). Thanks! Q
Headers and Footers in HTML
Hello everyone, Just wanted to share something I have found, using the following link / code: http://www.w3schools.com/html/html_layout.asp I was able to create headers and footers which you can use to make professional PDF files for customers, etc. A few people (myself included) have been asking how to do this, and the above link is the code that you can use to do it :) Feel free to ask any questions if you need some help Many thanks Ben
Delete a subform entry by clearing the Parent ID Relationship field
Hi I have my subform form with an existing relationship field showing so i can see the parent form ID which is written every time a subform entry is made from the main form Can I and is it safe to delete main subform entries by writing a null to this field. This would give me a way programmaticly remove subform entries. (in may case delete a booking record if date expired and deposit not received) While i am thinking about it, is it safe and smart to programmaticly add entries to the subform form
how to display 'added time' as number of days since that date
hi for the field added.time we would like to display it in our 'view' as number of days since that date. ie. 4 days. so anytime someone uses this view it will show them the current days it has been since the added.time what do i have to do to get this working? or do i need to use some kind of report/schedule? cheers Lathan
Using Script Builder "No rows found for the table PersonalityConfiguration in this DataObject" when updating a variable
Hi, Seems to be an issue with script builder and subforms as follows in an On edit on success section when i write this script 1) abc = "test"; 2) for each put_dates_in_patient_info in input.v3booking_form { } 3) put in a command to update a variable example abc="test"; for each put_dates_in_patient_info in input.v3booking_form { ************** abc=put_dates_in_patient_info.Added_User; ***************************************** } the command abc=put_dates_in_patient_info.Added_User; will give
search indicator
After the records have been fetched... why is it that the search indicator" still rotating?
When editing a report show the report name on top
When editing a report show the report name on top. Also if there is room show the View the report is based on. Herb Wexler
linking my customer contact form to product form
I have two forms, already populated with many data entries. One form has client contact info (Customer Contact Data) and the other (Lift Data) has details on the product or products they have purchased from us (handicapped accessibility lifts), including serial numbers, install and warranty expiration dates, and date of last service, etc. Both forms have a field called "Full Name" and I want to be able to connect the records with matching content in the "Full Name" field in both forms together.
Alert pulling data from input sheet... not sure its even possible!
I'm creating a purchase order form. I've imported the PO numbers to be assigned to Column 1 of the data sheet. The other columns are blank. What I would like is for the data from the form to be saved in the next "available" PO number row (if that makes sense) AND for an alert to come up and tell the person filling in the form what the assigned PO number is... does that make sense?!
Background
My website background color is blue but when I embed the form, it doesn't blend well. How can I change the background color of the form to different color or make it transparent?
how to make visual edits to form
I want to add static labels to different parts of a form- how can I do this? For example I want a portion of the form to say "Mailing Address" then I want to add actual fields like street, city, state, zip, etc.. under it. Thanks, /db
Search using Multiple If Statements
Hello, I have a form with several fields that an applicant must fill in. I want to create a script that will look at certain fields in the form, and if a particular answer is given, I want it to return "Ineligible". I guess my issue is that I will have several questions to look at and if any of them has a certain answer, then the script needs to return the word "Ineligible" Here is the formula I tried to use: if(DQ_Response == "No, I cannot attest to the above statement.","Ineligible", "
"On User Input" scripting for Multi Select fields
Hi, Is it possible to execute field actions for multi select? When I click on a checkbox in my multi-select, I want to cause a field to show (un-hide) on the same form. I know this type of action can be done for many other field types. With multi select, putting in the usual "input.MultiSelectfield == "Selection"" in the "If" condition leads to a stringlist-string error. Any way around this error? Thanks
Using HTML 5 tags
Hello, Is it possible to use HTML 5 tags in the HTML views? I am trying to use the <footer> tag but it doesn't seem to work. Are there some I can and can't use? Please see here for more information: http://www.w3schools.com/html5/tag_footer.asp Thanks in advance Ben
Fetch Balance from last entry
Hello, I have a simple accounting form with the following fields: Date Previous Balance Current Balance Amount Change Percent Change Row1 When I go to enter a new record, I want the Previous Balance field to be automatically populated with the previous entry's Current Balance.. This is the formula I tried in the "On Load" section, and it seems close: Current_Balance = 0; for each row1 in MGMT [ID != 0] { Current_Balance = row1.Previous_Balance; } Any help would be greatly appreciated.
Use Yahoo Pipes Web Service module (HTTP POST data in JSON format) to add records to Zoho Creator
I'm trying to use Yahoo Pipes to remix an RSS feed, and then post RSS feed items/data using Yahoo Pipes Web Service module to Zoho Creator. The Web Service module does an HTTP POST in JSON format to external web services. Unfortunately the Zoho Creator API does not accept requests in JSON format. I've asked this before, and someone said that I'd have to create an HTML view that accepts the JSON data, parses it, and then inserts the records. Can anyone show me how this might be done in a simple
Lookup field not showing all possible fields in other forms
I don't know what I'm doing wrong. I am trying to create a lookup field in this table, but when I try to choose the field that exists in another form, that field doesn't show up on the list of possible fields to create that relationship. Why is this happening?
Radio field
I have a long survey that uses a lot of radio fields. It would be nice to have the option of lining the radio buttons up horizontally as well as vertically. You guys have a great thing going here!
Criteria matched value to show up in drop down automatically
Hi guys, Kindly help me for following things.. 1) When I use lookup filed, the value that matched with criteria (only one value) cannot show up in drop down automatically and I need to choose again for this value. How can I overcome this ???? Please refer me for sample script. 2) And can I pass parent form's field input value (From Look Up field drop down) into sub form and also vice visa. ??? BR, zzw
error : null.t_1029225000000123671.null.
Hi! When pressing Submit on a certain form I get this error: Error occured while on Success script.Unable to update data on the form variableUnique constraint Failed in the form field null.t_1029225000000123671.null. I noticed that it does not happen for all the users and always but I really need to know what I can do to solve the issue. I'm using Zoho in a bit unconventional way, in order to gather data for my master's thesis and I am on a tight schedule. Help!
Missing Data
Towards the end of a form I added a comment box. While the contents of the comment box can be found in the email sent on completion of the form, there is no corresponding column and so no contents shown in online view form or the exported data. The same thing happens with a radio button I also added. The rest of the form works perfectly.
SMS service implementation
Hello Respected Members of ZC Please see this page first... https://blogs.zoho.com/general/how-to-send-sms-from-zoho-creator-apps well i see this application and i am also try it, but Clickatell service is not for free it is take some cost. Is i can use another service replaced on clickatell service and if YES then tell me how i can use another service in this application. Thanks
Want to Add Date Dynamically in view
I want to add dates dynamically in table monthly.If the month is february then only 28 or 29 days added it and for another month 30 or 31.But in Zoho Creator, add record 30 times its increases the code.Any another way to insert Please reply me.
Row level access control
Hi I'm sure this has been answered a million times but I can't find what I'm looking for. I'm starting to create an application using creator which will require row level access restrictions on the data based on the company they are employed by. I want to ensure that Mr X (who has a user account) working for xyz company can only view, add data and report on xyz data. Please help Thanks Simon
Adding IF statements together
Hello, I want to add multiple "If" statements together and I am struggling to make it work. Here is an example of what I am trying to do... if(Behavior_Supports >= 1,1,0) + if(Catheter_Care >= 1,1,0) + if(Patient_Bathing >= 1,1,0) Do you have any tips on how I can make this work? Thanks Nick
Next Page