Passing a set of values to a Parameter E.g. #View:SomeView?ParamID IN {1, 2, 3, 4}
In my application, I need to show a view of records which are determined at run time i.e. my logic identifies a variable number of records (code in an HTML View) and I need to display an embedded list view where I want to be able say that ParamID can have any one values from a set i.e. {1, 2, 3, 4} as an example. I have gone through https://help.creator.zoho.com/Functionality-based-URLs.html and I am unable to find any set operator like "IN" when passing parameter values. The functionality that
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.
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.........
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 =
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
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
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
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
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?!
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", "
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
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!
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.
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
Scheduler error msg (missing)
Occasionally in Scheduler clicking on Save does not save the changes and does not issue an error message. The only way to know that the changes were not saved is the red * to the right of Define the Action. You can click to another schedule or close the browser tab with no warning that changes have not been saved.
Pasword Field
Created a Password Field in Registration Form.When I enter values into password field it is showing text entered.How to show Dots or Stars instead of text
Grab a date from the calendar?
When someone clicks on a date in a calendar view to add a new record is there a way to grab the date and pre-fill the appropriate field on the form. -------------------------------------------------------------------- On a week view is it possible to use a separate field for the time slots. For example I have a form to make appointments. The user first chooses a date and then chooses the time from a drop down list that only shows times in 1/2 hour increments. I cant use a date/time field because I
How to store or copy the result of a formula field into another field
Hi, I want my formula field to lets say put the result of Single_Line1 + Single_Line2 into say Single_Line3 I tried a formula field of Single_Line3 = (Single_Line1 + Single_Line2) Which gets accepted but does not work. What am i missing Thanks
Subform the actual subform form interesting point
Hi In case you wondered, i did When a parent add's or edit's the subform it seems that the subforms on add or on edit section is not processed. At least the on success part is not. Delete does not count as subform entires are not removed I put a send email task in my subform and never received one whenever the subform was being edited or populated maybe Zoho can verify not an issue but one day i am going to need to put some script in the subform , i bet
Look up in another look up
Evening I have several applications for different pieces of information. I have a candidate and seperate employer application, I have others but these are the main two. I am currently creating another application for assessment booking. I would like to create a look up to pull thru the candidates name which is not a problem, but I am unable to pull thru the employer which has been selected in the candidate application, which has been entered in to the employer application. Any suggestions
Disable Formula Field ?
Hello. I am prototyping/evaluating creator. I would like to know if there is any way to "disable" a formula field and prevent it from executing while in edit mode? I have a formula field that auto calculates a unique quotation ID (I sure wish there was a random number generator) based on date/time when the form is originally submitted. I don't want this field to auto-calculate to a new unique number, every time I edit it. Thank you in advance.
Creator: actions on user input :actions on update
I would like to script a copy of a record when it is opened on the form. Copy of a record when the form is saved Then I would like to compare the two records If no changes create a new record in table that records userid date time filenumber(keyfield) no change If changes are made a new record in table that records userid date time filenumber(keyfield) the beginning and ending vaules and the field name (a change or audit log feature would make this a lot easier) Has anyone done
openurl - embedded view no login
I have a view embedded in my website. I have it configured to allow for no login. Everything works fine. The view has a function assigned to display for each record in the view (shows a button on the righthand column of the view). The function uses OpenURL to call another view that has been configured to open without login. In my function, I have tried calling the view using the methods shown below. I prefer the first method using the #View: syntax because the view pops up inside my website.
Without using for each record how to iterate the loop between two dates
I want to show one html view in 7 times in another html view i.e nested html view (view in view) .And this 7 times data showing date also which is incremented. There is any possibilities to show just like data or any loop (while,for etc)
Can't Get Deluge Script to Save / Run / Work
I've followed the examples in the tutorial. I've read through every single Forum mention the word Deluge. Nothing answers why it's not working. The example don't show either of these two differing lines in the actual script: <return value as map> = zoho.reports.createRow(<Database Name>,<Table Name>,<Data as map>); All the examples at this page show: http://reports.wiki.zoho.com/Creating-Data-Entry-Forms-for-Zoho-Reports-using-Zoho-Creator.html Without including that line with "return value" at
Additional row is also added when tried to store seperate rows for each item in Multi -select list
Hi, I am creating an application that includes a form called Form 1 with single line field 1 single line field 2 and one Multiselect Field(Look up). When i tried adding more than one item in the Multi select list for the Form 1, in the Form 1 View this is stored in one single row with the items seperated by comma's in the Multi select column. So i have written the below code on, Script(On Add) -->Actions On Success, that enters the records in different rows for each item selected in multi select,
How is it possible to import data in a form for a user who is not admin ?
Hi everyone, I have created a form with Zoho Creator and, because I am the admin of my application, when I click on "Access My Application", the form appears and also the "More Actions" dropdown with "import data" function. Now, when I share the form with another user, he does not have the "More Actions" dropdown... So I wonder How is it possible to import data in a form for a user who is not admin ? Explicative screen shot in attachment. I hope I was clear.. Thanks Kevin
create list using toList() then use remove from list questions issue
Hi Still getting my head around this but here are some questions so far 1) toList() enter_string = "X</span>"; enter_string_as_list = enter_string.toList("</span>"); THE String List will contain a trailing , ie X, Q1) Is this meant to be like this by design, lets assume it is for whatever reason 2) remove the element takeout = enter_string_as_list.remove(0); takeout is now X which is correct BUT theemptyaize = enter_string_as_list.size(); returns 1 Q2) Should it now not return 0 ?? as the list
Alert or Pop up in html view
I want to check out the date field in query string is present /null/or invalid for that i want to use alert box
How i create autogenerated date
I want to generate date which is autogenerated and pass through query string andand show in also input field
Limiting subform multi-select based on selection in main form
I am developing a database with forms for corporate data, project data, and employee data. I have created another form to track activities data associated with a client/project by employee. In the activities form I can select a corporation, which updates a multi-select for projects associated with that corporation. I have a sub-form within the activities form that allows me to select an employee and record dates/times/activity for that employee, and associate them with the project selected in the
Faster Data Entry... Need help with Lookup data type...
How can my lookup field "remember" their values from previous form submission? I'm trying to improve the speed of data entry by "remembering" the last value that was submitted using the form. I see where I can assign the value to a variable, but how can I then assign that value to the lookup fields when the form is loaded. Or is the right approach at all?
Next Page