How do I make prices not a preset value, rather a custom value that is subject to change?
I am trying to let users be able to set their own prices when they create a new order using the Order Management database for Zoho Creator. As of now, the price section is grayed out when I try to create a new order. Since we are a wholesale company, I want this to be a custom price that is subject to change depending on the volume of the order.
Help with some code please
In a multi line text box I use some script to populate the box The script is input.Map_Address = input.Clients_Name + ", " + input.Clients_Address + ", " + input.Post_Code + ", " + input.Telephone + ", " + input.Place; This produces Ian Mitchel, Benfleet Close, SM1 3SD, 07860635993, Sutton I want it to be Ian Mitchel Benfield Close SM1 3SD 07940635993 Sutton How do I add the carnage return and how do I centralise
Time Comparison
I need to check if user has performed some form action after 10 am but before 11:45 am. While I can easily look at hours as shown below, is there a solution my question? if ((zoho.currenttime.getHour() > 10) && (zoho.currenttime.getHour() < 12)) { //some code; } Cheers, John Whitney
Passing a multiples select lookup field to a function
How do you pass the contents of a multiple select lookup field (in my case a list of IDs) as an argument to a function?
Multiple Select Lookup fields
How do I set a single value in a multiple select lookup field using the insert into statement?
Multiples addreses in sendmail
If you send a single email to multiple persons then what is the correct syntax? What is the address separator and are spaces ignored?
Changing an e-mail address
Say over the course of a few years I used a certain e-mail address all over my zoho database. Now that e-mail address is no longer used. How do I change each instance of that e-mail address easily and efficiently? Is there a way to change all in one step or do I need to go in and change each one individually?
Use of tags separating Deluge script and html: Script Builder
Hi I followed the tag explanation given in Create Html Pages which explains the use of the <% and %> tag to separate the script from the html. However the example shows the use of the <%}% as the tag marker with no explanation as to the difference. I input my script as a free flow. But when I save it, script builder has changed "simplified" my closing tags. Why? Original: html page <%{%> .........html script <% start my script %> end my script tag <%}%> close my html script
Configuring add notes field after fetching data
Dear All, I have a form (Hotel Details) with a single Line field (Hotel Name). I also have a second form (Seasons) with an add notes field. I used the following <font color="#ff0000" size="5">Add your Note here ...</font> to change the size and the colour of the field. What I am doing is to fetch the value from the single Line field to the add notes field. I used openUrl(((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Seasons?plain11=" + input.Hotel_Name, "same window"); and it works fine.
Write field contents to two tables
Hi there, I have a form named "Observation" which has in it a multi line field labelled "Issues". We enter items into this field separated by commas. When submitting this form I would like the contents of this "Issues" field to also be written to another table from a different form. I'm guessing I need some sort of on-submit script but don't know where to start. Is this feasible? Many thanks!
Report to show only users info
i created a pivot chart to track employee vacation time. showing vacation requests approved and total vacation accrued. My report is pulling all the vacation accrued from everyone. "vacation accrued" is a field in a form that is manually updated but is located in another form other than the leave request. Thanks for the help.
Formula
I am looking for a formula that would pull a field(s) based on a date range. Example: Show all software licenses (field) between x and y date range expiring in 30, 60, 90 days. Thanks
htmlpage syntax
Hi What is the syntax for htmlpage <view>() what parameters can be passed in the () ? I can't find anything on this in docs but from some of the sample applications I can see that parameters are used. Dave
Logout from an embedded form
I embedded a form in a website that requires login. Once logged in is there a way to logout? For example if a user wanted to log in with a different id? Herb Wexler
background in html-pdf view
Hi, I have a html view http://www.creator.zoho.com/misca/consulado-geral-do-brasil/htmlview/Print1/edit/ in which I put a background in html language. In a simulator I can see the correct html view, but when I put it in the view of zoho creator I can see the image as background. How can do to see it? Thanks Mic
Note Field
I would like to limit the width of the notes I add so it matches the label width . Also can I would like to open form through an api push with some data for the form already there . I can use script to adjust the note based on form entries but I don't know how to change the CSS of the field - Is there a was to make note change live and still keep the setting - meaning font color , size also how do you word wrap inside a note field
Create a starting page
I am new to scripting, but i am trying to figure out how to make the dashboard page be the page that users see every time they log in. now it takes them to the last page they were on instead of the dashboard.
Auto notification - contain users id who changed data
i am setting up an auto email notification to the zoho.admin, when a user changes certain fields. I would like the email to contain who changed the data. i tried this script in the message body, but it didn't work. "user" <+input= "zoho.loginuserid"> has changed any suggestions
Error by lookup update
In field actions Customer_Name On User input I have: if(Factory[Customer_Name == input.Customer_Name].count() == 0) { clear Factory_Name; } else { factoryList = Factory[Customer_Name == input.Customer_Name]; Factory_Name:ui.add(factoryList.Name.getall()); } When I start it, I get follow error message: Error executing GENERATEJS_TASK task (in else block)
Protected lookup
I have a one-to-many lookup where I want to assign a customer a batch of keys, but once assigned those keys are not available for any other customer to select. When I set this up it looks like a new customer entry can select another customer's key and take it from them, which will not work for my application. They need to be permanent one-time assignment, preferably non visible in drop down list for subsequent customer assignments. Form 1 Customer Form 2 Keys Thanks for your help.
Work around lookup drop down with too many entries
Hi I have a Company Form and a People Form with a lookup so I can associate People with Company. (one to many relationship). But since there will be about 150 records in the company form, the lookup drop down would be unworkable. Is the only option to use Deluge scripts to associate the records with the ID field? Thanks. Dave
Feature does not work since changes, please help.
Since Creator was updated, a feature I created now does not work and I don't know why. Can anyone help. So on my project I have jobs that are grouped into dates that the jobs will be done. Now also within the grouping I added Map_Location which gave a listing of all the post codes attached to that date.The purpose was so I could cut and past a whole days activity into Google maps to work out my route. The formula used to achieve this is code=""; for each r in Signing[((Run_Number == input.Run_Number
Auto Populate Fields On Sub-Forms
I when data is entered into one single select field in a sub-form, I need the value for the other fields in that record automatically populated. For example, if the Main/Parent Form is the "Order Form" and the Sub-form/Child Form is the "Products Form", when the user selects the product name in the "Product Name" field in the Subform, I need the application to automatically populate the other fields, such as "Product ID", "Price", "Product Description"- fetching this data from the "Child Form/Products
Report Filter
Hello, I am trying to filter a report based on zoho.loginuserid. I have the PM field in the Job_Number table to use as part of the filter criteria. Basically, I put the following in the criteria area on the Report Summary: PM equals emp_list.PM[zoho.loginuserid = = Email] I run the report, the filter does nothing, and it deletes the criteria. I'm sure due to an error or syntax. Let me know if there is a better way to do this, is there a way to write a script for this in the report? Thanks.
Pivot Table/Chart Filter
Is there a way to program filters for pivot table and charts? I am looking for a way to filter the data for the previous and current work week. I can do this without an issue in list reports, but fail to see how to acheive this in pivot reports. Thanks.
How to add search button in the view header?
Could you please clarify how to add a search button in the view header? I appreciate if you can give more details and step introduction. Thanks
Summary View Save to Excel
Is it possible to save an individual summary view to excel file? We're expecting an individual output like this Thanks!
Filter Picklist by shared status
Does anyone know of a way to filter a name picklist to show only those people you have shared access to your application? To clarify, I have a form, emp_list, which contains all of the employees for our company with their correponding email address, which is their zoho.loginuserid. I would like to filter the employye list in the lookup field so that only users that are active in the application show up. Thanks
Donation wish list
Amici, I'd like to create an online donation list in a sort of dynamic form. I"d like to create it somewhat like a wedding gift registry site: There is a whole list of objects needed by the organization, let's say Teddy Bear, Car, Lego... Then people start to register and choose one (or several) of these options. Now anytime someone ticks a checkbox of an in-kind donation (e.g. Teddy Bear) it should be hidden for the next person checking the form. So the next person could only select from the rest
Loading image in HTML view.
When a user is looking at the view there is a custom action that loads an HTML view and loads all the info based on the value. Everything works fine except the image. For some reason the image is just a broken image and I cannot figure out why. Here is the image link I am using <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=job.Art%>&sharedBy=zoho.adminuser&appLinkName=XXXXXX&viewLinkName=XXXXXX'> What view do I need to put in the viewLinkName? I have been using the default
Month End Calculation
I have created my first function in Zoho Creator. Something I think I'll use often throughout the project. date MonthEnd(date MyDate) { WorkingDate = input.MyDate.addMonth(1); WorkingDate = WorkingDate.subDay(input.MyDate.getDay()); return WorkingDate; } This gives you the last day of the month for any date given.
Duplicate reports - same name, different filters
My app has several different sections, for continuity, each section needs to contain a list of the same report titles. Within each new section the reports, although duplicate in structure, vary by their constraints/filters Example Section 1 - Cyclones report - Financial Support (filtered to only include cyclone data) report - Business Support (filtered to only include cyclone data) report - Personal Support (filtered to only include cyclone data) Section 2 - Drought report - Financial Support (filtered
A sendmail function from an individual record in a report that will permit the user to attach a file?
A function can be created to send an email from an individual record in a form. This is useful because the record Filename can be used to create the email subject line. However i wish the user to have the opportunity to attach a file to the email before it is sent. Is this possible? Merry Christmas to all in the Zoho community and to Herb who has answered so many challenging questions:)
Where can we store/find functions?
Is there anywhere where we can save any functions we have created that might be useful to other people? Examples: validate email address on entry, validate and format phone number, etc. It seems that a lot of people must be reinventing the wheel all over the place here. Also useful items that can be cut and pasted for drop-down lists, such as US States, Canadian Provinces, Months, Days of the week, etc.
How to schedule an immediate email of an uploaded file attachment?
I see time as 00 and hours as 00 are options in Scheduler but it does not seem to have the desired result.
How to implement AGGREGATE functions in Reports in each group
Is there a technique in Zoho Creator Report to display the Average when grouped by specific column? Say per date. Thanks!
Converting Simple Excel Formula to Deluge Script
Hi I'm currently evaluating Creator and have fallen at the first hurdle. I have a simple excel formula to calculate commission on sale price: =IF(Net Sold Price <50,Commission Level *Net Sold Price,0) I know that I need to write a script in Creator to achieve this same result. I am not a developer, i don't know java or VBA so this simple task is extremely frustrating. Can anyone provide the script that I need to enter in to the form? Any help would be much appreciated! Thanks Adam
assigning a value upon submit button
So I have two forms 1) Main_image_id with variables a) Main_id b) Main_complete (numeric variable currently all set to 0) <-- I want this value to be turned to a 1 on submit from form 2 (Images) 2) Images a) Main_id <--from lookup dropdown referencing Main_id in form Main_image_id b) bunch of other fields. What I want to do is when the submit button is selected I want to change Main_complete = 1. Then I want to filter the lookup dropdown
how bulk renew fields in entries?
hi there is about 1000 entries in database each entry has - id like id1, id2, id3 and so on - number of fields - field1, field2, field3 and so on how can i renew one of field in all entries? example - renew content on field3 in all entries from id1 to id1000.
How in Custom Action Function Configuration to include a literal parameter?
e.g. I want the custom action to call myfunc(ID,"literalvalue") Thanks.
Next Page