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?
Export Back-ups
Hi, I have 7 applications and I will be making more soon. I would like to back-up my data through exporting it all onto a excel speadsheet (each different application). I was wondering if there was a way to get them all to download at once with one click instead of going on all of them and doing it manually and if possibly there is a way to do a scheduled back-up some how? Thanks
Conditionally Call Paypal
Is it possible to conditionally call the PayPal function? For example I'd like to have a radio button options to Pay online Pay at the Door If they choose Pay online it takes them to the PayPal screen otherwise the form saves normally. Herb Wexler
HTML View Problem
I am evaluating creator for possible use by our company. I am having a problem grasping the concept of the HTML View format. I have my form created, and have created many working view with that. I would like to create an HTML view to report on a single unique record row from my table/form. I understand how to build the HTML portion, but how do i display data from the form in the view specifically. I have passed the variable that I need to set up the criteria to select the correct row, but how do
Opening View from list and passing record ID
I am new to custom programming within ZoHo creator and am having difficuties in creating a function that will open a custom view with the lists record ID. I have the custom view called Quote_Review_and_APQP_Tracking and here is the inital Free Flow Script htmlpage Quote_Review_and_APQP_Tracking(potential_idstr) displayname = "Quote Review and APQP Tracking" pdf = true content <%{ curPotential = Potential [ID == input.potential_idstr.toLong()];%> I have created a custom function called
How I iterate the loop without using form data
There is 'For Each Record' is iteration loop in Zoho creator But I want to iterate one html view in 7 times with incremented date. How I resolve this problem by using Zoho creator? Please Reply
Unable to add or edit records
We are not able to add to any records in the database ("please wait" continues without proceeding") nor can we update any existing records. We have tested in the latest version of all browsers.
how i transfer value from one form to another?
I want to transfer one form value to another form and which is also display in view.
Import Data fails with set variable validation
Hi, In my app (app name PIM), I currently have a form called 'Categories', which has the following fields: Root Category Child Category Grandchild Category Website Category I want to be able to import this information and set the Website Category automatically based on the following formula: Website_Category=(((input.Root_Category + if(((input.Child_Category).length() = 0),"","/")) + input.Child_Category) + if(((input.Grandchild_Category).length() = 0),"","/")) + input.Grandchild_Category;
Unable to add or edit records
We are not able to add to any records in the database ("please wait" continues without proceeding") nor can we update any existing records. We have tested in the latest version of all browsers.
if and else if are they counted differently when it comes to number of Deluge statement executions
Hi, I think i read this somewhere need to verify maybe i understood wrong when counting number of deluge statements executed would this be different 1) if ( a==b) do b if (a ==c) do c 2) if (a==b) do b else if (a==c) do c thanks ...
Zoho Creator - File upload with Google Docs
Team, The file upload field does not work for Google Docs. It displays the file name (sometimes) but nothing more. The Google Docs link is not importing. I see that you are working on this in CRM forum. Will it be corrected in Creator as well. Thanks
Importing Data and Code Execution
I know that On Load and On Change code is not executed when importing data. However I was under the impression that On Submit code would be executed. I'm not seeing this happen... Cheers, John Whitney
Embed a View with Export, Print, and More options
Pretty sure I know the answer is no, but I thought I'd ask just in case... Is it possible to embed a view with the Export, Print, and More Options menu buttons? The reason I'm asking is because the URL in my client's application kinda gives away too much for custom filtered views. By embedding it, the url is less obvious to the casual user. And my client wants the Print and Export buttons. Cheers, John Whitney
Next Page