Trying to total a sum for inventory
Hello, Currently, I am trying to track the running total of my inventory on a basic level. I have a "Quantity Onhand" field and a "Quantity Received" field. On submit, I would like the amount (Quantity Received) of the Product to be added to the Quantity Onhand. I am very new to scripting so any suggestions would be greatly appreciated. Here is what I have on the Quantity Onhand field on Update: temp = 0; for each rind in Order_form [Quantity_Received == input.Quantity_Received] { temp =
calculate the total sum into a form
Hi, I have two forms. Form A with two fields: Group and Quantity. Form B with 3 fields: Group number (a lookup type field), quantity and Sum. I fetch into the Form B the records from the Form A that are belonging to a specific group number that I select by the lookup. I want to calculate into the Form B the sum for the column quantity, for all the fetched records. The sum calculated in the view mode of the Form B works very good, but I dont know how to have it into my Form B. So I tried to compute
Work around for lack of sum function?
I understand there is no sum function in creator. I need to create a html view to display an income vs expense with a total of the income items and another total for expense and a grand total that calculates income - expense. The form has a field for item name and amount and a checkbox for income or expense. Right now the only way I can make it work is to have each expense amount be a negative number when entered. This prevents me from being able to make a chart from this data. If I could sum
HTML view sum example
Can someone provide me an example of how to calculate the total absolute values of a field in an html view? For example: FormA One entry is this: Field1=10 Field2=5 The second entry is this: Field1=5 Field2=5 The third entry is this: Field1=2 Field2=1 HTMLView Field1Total=17 (10+5+2) Field2Total=11 (5+5+1) I'm assuming this can be done with the "for each" clause, however I'm stuck on figuring out how to calculate the sum in an html view.
1 More n00b question on scripts
Hello, Thanks for all the help I have recieved here. I was wondering if there is a way to 'auto delete' records after 7 days with the free account. I have added the date field, and have it automatically filling in that information, just in case its needed for 'autodelete' functions. I have looked around on the web and here, and I cannot find anything. Sorry if this has been asked or is not possible. Thanks again!
Is there a way to link 2 applications?
I was wondering if there could be a way to link 2 applications i.e. App 1, let's call it Contacts, and then App 2, let's call that Hobbies, so in Contacts I would add all of the contacts and their info... so in Hobbies i can access Contacts and find a name then select the name and add a list of hobbies. I need the apps to be 2 different ones though as the information I am adding is a lot, and not all of the things in app 1 have the information, so it is easier to create 2 different apps so the information
Email the actual reports
Hello, Is it possible to email a copy of an actual report that is generated by Creator? I have several reports created that have special filters, and functions applied to it, and I would like to email the finalized reports as a PDF, instead of just a PDF of the VIEW that I created the report from. ANy help would be greatly appreciated. Jason Rapp
Copying of application blocked if quotes used in rich text field
Attempts to duplicate and copy the application from the home page failed, and so I saved the application as a script and tried uploading it into a new application. Turns out that it finds errors in all rows of the script that define a rich text (comment only) field, where the text defined include single or double quotes. The presence of quotes confusing the format for the script coding. Either quotes shouldn't be allowed, they should be deleted from text during the copy or save process or, better
Bug in Notice for Modified Function
I appreciate the notice below a modified function warning me about references to the function on other pages/forms. However, recently I'm seeing the notice below, even after correcting the references... Function is modified successfully However the following other functions have argument mismatch in invoking this function Make a note to correct them as early possible, as it may lead to execution errors In action script--> with arguments (int ,string ,string ,string ,string) Where? Usually it mentions
Dashboard issue when adding Quick Create - New Request
I found that my dashboard has an issue when adding Quick Create - New Request. It does not allow to save the contents to the database, and comes up with an error: Error occured while executing on click script. Please let me know where I could be troubleshooting this issues. I haven't found the original form for this embed. Thanks, -Jaap
Creator: How long for public access and one silly question.
Yes, I have requested public access to my application through email. I was wondering what is the average wait time for it to be 'published' publically? Im in no super big hurry, but was just wondering. << THIS ISSUE IS BEING TAKEN CARE OF. Now for my silly question. I have my form (application) created, with a pop-up warning about how to fill out a certain field. As a blank field I have the value as '---|---' so that is what shows when you first access the form. This is the format I would
How to Execute action for collection of records
I have a form, that when in the list view, i want to be able to select certain records and execute a function that will display only the results that i have selected in an HTML view. I know how to launch an HTML view for individual records, but i do not know how to do so with a collection of records. Can someone please post the post. Thank you very much
Discussion Forum vs. Lounge
Hi All: What is the difference between the "Discussion Forum" and the "Lounge?" Thanks, Kevin
Can't seem to Share application
I've created an application and I cannot seem to share it with my friend. He can see the app in his SHARED APPS area, but when he clicks on it, he gets the "not authorized" message. I've attached a document where he explains what he's doing. To me he seems to be doing everything right. I have been able to successfully share the app with another friend without any problems. Can you tell what I'm doing wrong?? THANKS!!
Get input.ID on Stateless Form Submission
Concerning stateless forms: One thing that bugs me is that an ID number is generated after form data is submitted. This is an issue in my mind. Here's an example: A user submits a stateless form proposing some idea to a team. The team is then notified by email of this action along with a url linked to the idea. We cannot use a url link that has https://creator.zoho.com/admin/myapp/form-perma/newidea/&ID=212085000003178069 form because the ID is created after the fact. Rather, we are forced to create
Zoho and e-marketing
Hi there!!! OK here's my dilema. I'm want to be able to sell "packs" in the form of grouped documents such as PDF documents to clients on my website. This will be in the form of a shopping trolley where clients can purchase using online payment such as PayPal. My question is this. Is there any way of linking Zoho database so the client can view the database of "packs" and then make a purchase, this is turn automatically filling a field stating "sold".
"No Records Found" page in HTML view?
Hello, I have an HTML view in Creator that displays records based on a search parameter (State and Country). How do I display a message on that page when there are no results found? I need to give users information for what they can do when they don't find any listings for their area in our organization. I've looked around and cannot find an answer to this. I need the code for "if search results=none then display this HTML". Thanks
Is this how ZOHO Marketplace is supposed to work ?
Note: I am posting this in the ZOHO Creator section because I don't see a separate section for ZOHO Marketplace. I just published a (dummy) Application to ZOHO Marketplace in order to test the behaviour of Applications when being demo'ed in their workspace. The Application I submited was defined as Private ... with two HTML Views made Public. In the published Application, I noticed that the Access/Share definitions are being ignored completely ... as I am able to View ALL components of the Application.
Zoho for MS Access Users
Is a great idea the migration software that you created to help who create aplications in MS Access. I'd like to propose an idea of two function that exist in MS Acces that would be wonderful in Zoho Creator. They are: SUM Function: The SUM function returns the summed value of an expression. ex. Sum(ZohoForm [ZohoField == input.Criteria]) DSum function to calculate the sum of a set of values in a specified set of records a domain (domain: A set of records that is defined by a table, a query, or
Adding scores and returning an average...
I want to create a form that will allow any number of clients to rate a service and display the average score in realtime on the same form. Any ideas?
Is there any other way to show the formula field
Im trying to display the price (Rate*Quantity) to users in my form. I have read that the formula cannot be shown. Is there any other way to display ?
Set criteria for a checkbox field in a view with URL
I have a checkbox field. I need to filter a view depending on a value of a selected checkbox field. For example, view all records where option1 is selected. Which operator should I use? I tried URL?fieldname=option1 and URL?fieldname=option1&fieldname_op=26 - none of them worked. Help please!
How do I put a form inside another project?
Hi How do I put a form inside another project? For example: I have a productive and have also the form Shopping .. They are individual forms, I need to put them on a new project or group that would be anew application called Management .... Thanks
How do I create a function that adds a new field in a view of a form?
Hi How do I create a function that adds a new field in a view of a form? Thanks
How do I make for when the person is a view has an option to add a new field?
Hi How do I make for when the person is a view has an option to add a new field? A field such as Observation Board. -------------------------------------------------- -------------------------- Another way would be How do I make to be able to edit only one field in a view? Thanks
Getting the selected value from multi-select list
I have a multi-select list. How can I figure out (with code of course) which values are selected and which are not?
one sigle record
Hi, Please, How can I get just one record for may website? Exaple: I have a table with a cell with produc name: "Suarez" and I want in the next cell the value of "Suarez: that is in the db. Thanks in advance, Ricardo
How do I make that a Form A press on the screen data from another form in various fields?
Hi How do I make that a Form A press on the screen data from another form in variousfields? For example: The Form I-Product I want it in another form I select from a combobox the product name and thenautomatically loads itself into other fields all information of the product for which Iselected the name. Thanks
Add a checkbox on a view filled
Hi I need the following features: My example: I have the Form Products I need to create a View that has all the products registered in a productive and has anoption for eg a checkbox that I can mark it as a product with low. How would I do that? Thanks
How do I fetch data from a field in FormA to FormB with the criteria in both Forms?
-- I have Form A (names and other info of SHOWS) -- I have Form B (names and other info of PROJECTS) -- In Form B I have a field "name of show" -- I want to have in Form A a list of all the projects that match the "name of show" Can someone help? Thanks, Illetsac
Creating an alert when a duplicate is detected
I have a field called input.Client_PO i would like to create an alert when the user inputs a location that's already in the DB. so fas i have Client_PO -> On user input If (input.Client_PO == ***duplocate formula****); ( show alert_label; } of course the part i need help with is the formula for finding duplicates, once that happens the alert label will be unhidden. thank you.
Remove records to another database
I have a database, that inadvertently ended up with nearly 2,000 records that do not belong there. Although they are not for this database, I think they might be valuable to someone else. I can only see how to totally delete them, and at that, no more than 200 at a time (200 in the view). Is there a way to MOVE the particular records, found in a search, to another location, preferably on my hard drive ?
Getting an Error that I cant Figure out!!! HELP
I have a set of Stateless forms that feed into a master form, to produce a single view of all the data collected from the various stateless forms. I have 100+ fields in the master form, but when i try and add additional fields it gives me the below error... please help Ive put way to much time into this for it not to work. Error modifying the page Syntax error or access violation, message from server: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
Automatic Time Refresh upon new entry
One of the applications we are using with Zoho is a Call Log. The date and time of the call are logged in. Is there a way to set the form so it automatically updates or refreshes the screen with the correct time when a new call entry is made? Right now, the person has to manually refresh the screen every time a call comes in, sometimes they forget to do that and then it throws our records off because our work is time sensitive. Thanks.
Trying to make cell color RED if AGE is = or < 18 using a function
I'm trying to create a function where if the age of the user is less than or equal to 18 ( legally a minor ) the cell back ground color would turn RED. I've been trying to work this out but I'm not sure how to approach. With this current function setup I am getting the following error, and I havn't even got to the changing the cellcolor portion yet :( The Left expression is of type TIMESTAMP and the right expression is of type BIGINT And the operator - is not valid here bool isMinor(int Student_DOB)
2007 somebody ask this question : no solution in 201 ???
have embedded my survey form into the family website to gather information about family members. So far I am very pleased with every aspect of your application and its ease of use. The one thing that is happening that is a bit frustrating is: those filling in the form are hitting the enter key to attempt to go to the next field. When they do this the data is submitted and the form settings open up the home page. They then hit the back button to get the survey back and it creates another record with
Maximum code in a form?
Hi, I was wondering what is the recommended amount of code to place in one form. If you don't have an exact limit, how many lines of code would you recommend out of experience? I've been getting some strange errors and want to make sure I haven't overloaded the form. Thanks!
Getting records after a specific date.
By now, I know how to set a criterion for a view to restrict by relative date, such as "within the last year" or "before today". What I need is to know how to restrict a view to only show records after a specific date. Background: I have an invoicing application, and for this one view, I only care about seeing unpaid invoices (Date_Paid is null) that were sent in or after 2010. So I'm trying for something like Date_Sent > "2009-12-31" (which is the date format that my application uses), but I can't
Need user to fetch data to update form using iframes??
Hello, I have 2 stateless forms, each called to an iframe in an HTML view. On the bottom iframe is a duplicate of my main form (which is public) used for updating records. The top iframe has two single line text fields, Group ID and Listing ID. I want to use these fields to look up a record and populate the bottom stateless form so users can update that record. Our organization has 1000+ groups whose officers change all the time, so Zoho user accounts are not going to work here. I want whoever
== operator not valid for boolean variables?
I have the following line in a script: frn = Furnishing_Options [Furnished_Value == Furnished]; Guess what? It throws an error: Error in statement at line number 1 The Left expression is of type BOOLEAN and the right expression is of type BOOLEAN And the operator == is not valid here So I can't compare 2 boolean variables? This seems to me a serious limitation. Regards, George
Next Page