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
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
Is it possible for a non-zoho-user to fill in a form created with Zoho Creator ?
Hi everyone, I have created a form with Zoho Creator. Now, I would like to share this form with non-Zoho-users. In order to fill in the form, do those non-Zoho-users have to create a Zoho account ? In other words, is it possible for non-zoho-users to fill in a form ? Thanks, Kevin
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
Opening a custom view with passed parameters from view list
I am new to custom programming within ZoHo and am attempting to place an action (New Blank Form) into a form. The form currently lists all open quotes. This action will open a custom view called 'Quote_Review_and_APQP_Tracking' and display the previously selected rows data. I was able to place the Custom Action into the form that calls the function apqp.APQP_Window and it seemed to open the view but the view requires a potential ID to display correctly. The following is the code in the apqp.APQP_Window
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
Form with Payment View
I have created an application with payment, and it works fine. However, in the view it displays each submission on one line, with each item checked for purchase listed with commas seperating them under their respective column. I would like to have a sperate line displayed for each item selected for purchase. I've tried to figure it out on my own, but haven't been able to. Any help would be greatly appreciated. For instance, if one person selects choices 1, 2 and 5 for purchase, I would like
I have two check box fields. When one is checked, I want the user to not be able to check the other (and vis-versa). How can I make this happen?
I have two check box fields. When one is checked, I want the user to not be able to check the other (and vis-versa). How can I make this happen?
Views- Disorganized Fields
Every time I create a new view, all of my fields are out of order. There doesn't seem to be any logic to the field placement either. This is causing a great headache since I have 30 fields or so per form and do not want to have to rearrange all the fields every time I create a new view. Anyone have any suggestions? 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
Time Colour changing
i have created an app, for live job status, i need to be able to colour the row of data, if a entry is coming to its due time and if the data is today. is this possible? thanks in advance
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
Colur tagging
im lost, what i want to be able to do, is if an entry is coming upto the current time, i want the entry to turn red. also if the entry has the required date that matches the current date, then its to turn orange, is this possible, im really struggling here :(
Zoho Creator - extremely slow
Creator works extremely slow for me. Has someone the same problem? Regards, George
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
lookup into another form takes into consideration html formatting
Hi, Am two minded if this is an issue....it is for me but maybe this is so by design: Form A has lookup field (hello) from Form B Form B has the hello field with an entry wrapped in HTML as such <span style=color: red;">[WORLD]</span> (the word WORLD in RED) If fetch Form A and write the same HTML <span style=color: green;">[WORLD]</span> (the word WORLD in GREEN) Result....nothing shows in Form A Conclusion, From A lookup is not displaying anything in the hello field because this exact string does
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
How To Set Address To Google Maps?
How To Set Address To Google Maps?
Multiply the field1 in"FormA" by field1 in "FormB" then the result in"FormC"
Multiply the field1 in"FormA" by field1 in "FormB" then the result in"FormC",is that possible?
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
Submitting File via Email
Hi, Is it possible for a user to submit a file (excel, csv, txt) via email to a form? Thanks! V
Multiple branches control
Hello, I am running a business, which has 2 branches for the moment. This will change in the near future with a third and a fourth branch. I would like that each branch, after logging in, can only see their customers, their employess etc. As also, after logging in, only specific fields on the forms will be active depending of the logged user. But, the admin would be able to centrally see all customers, all employees, all fields etc. Is this possible with Zoho Creator? Thank you
Next Page