Dynamically Re-generate a Pivot Chart
I have a pivot chart that I would like to call through a "Custom Action" button that calls a function containing the OpenUrl. My question is, since data in the reports (i.e., Pivot tables, Pivot charts) are not automatically updated, how do I dynamically Re-generate the chart to refresh the new data through the script and without pressing on the little "gear" and clicking re-generate?? Thank you for your help
getURL & postURL cannot pass "Authorization" key in header map.
This exception has been thoroughly tested. Problem : The header map variable (passed to getURL & postURL functions) will not permit the inclusion of an "Authorization" key/value pair. DS function to HTTP resource : map test.passingHeader() { url = "http://webpdi.com/info.php"; header = { "Authorization" : "Basic dXNlcm5hbWU6cGFzc3dvcmQ=", "header1" : "passed header1!", "header2" : "passed header2!", "_Authorization" : "So I can
Send e-mail based on StartDate Field
Hi, I would like to send an e-mail notification containing Form data related to Startdate. For example, I would like to send e-mail listing all records that have a startdate of 3/18/2013. All records occurring based on the StartDate filed.. -----Email------ StartDate Unit Assinged 3/18/2013 231 Megatron 3/18/2013 605 Optimus Thank you very much
How to transform rows to columns in view
I'm exploring online database solutions using Zoho Creator and so far, the experience has been quite good. We're hoping to pilot the solution and if accepted, upgrade to a paid account. However, one of our databases requires a particular view. I understand that each entry is displayed as a row, and the data for each entry is displayed in columns. This works for one of our requirements. But for another requirement, we actually have only 13 entries with quite a lot of data for each entry--about 30
How do I add a form to my website?
I would like to add a form that I created in Creator to my website. Is this possible, what are the steps. Thanks, Brad
What do I do so that 00:00:00 is omitted from date fields?
When I import my spreadsheet to Zoho, it works beautifully except the time stamp that appears in the date fields. How do I stop it from doing this?
Set Email Notification on Edit
Can a feature be added to send a formatted email on edit or delete. This would be identical to the Set Email Notification on Add. There have been several applications where an audit trail is needed. In these cases I have used a sendmail script to list all the fields. This works but it would be nicer if I just have to check a box to get a nicely formatted email. Herb Wexler
Creat a Rule
Hi, I apologie if my english is not too clear at times (its not my primary language) I would like to ask the following: Having two fields as shown on this picture I want to make it so that when you select "Finalize" it turns the last field ( shown as Number) into required field validation! Is there a way to do this? Any help is very much apprecited. Best regards.
Show value upon User Input (Auto-Fill)
This should be easy but I am not completely familiar with the zoho scripting. I have two form: CARE STAFF MaxValueCAREstaff When you input a new staff member, the maxvaluecarestaff.CARE_Staff_Number gets 1 added to it, thus giving the next staff member a unique staff number. This works fine but I want the input form to show the current staff number. Right now there is a single line number field for STAFF_Number which is assigned the current MaxValueCAREstaff.CARE_Staff_Number value. I don't want
Layout of Charts and tables
Is there any way to have headings in a table or chart wrap so I can make the columns smaller but still read the headings.
toDate from Numeric Variables
I am trying to convert numeric variables to a date: curMonth = 2 curDate= 15 curYear = 2013 Date1= (curMonth+curDate+curYear).toDate() I have also tried Date1= (curMonth+curDate+curYear).toString().toDate() In my script i just keep getting error that it couldn't convert variable to a date. Can someone please help. Thank you.
i dont want any asociation with facebook or zoho
i began signing up for zoho till facebook came up as a part of it i stopped the application in midstream since i get unlimited spam from facebook unwanted and i never finished creating a zoho account [3407love] not my hotmail has gone to outlook on me more unasked for.unwanted invasion of my mail please remove zoho from any connection to me, my account, etc pls disable outlook i could not after following 2 sets of instructions please dont presume those were wrong and send new ones ---------------CUT
Hide Print opcion view
I need hide print opcion in one view embed in htlm view, zc_ print ?= false????????
How do you format a formula
I am using a simple formula and i need to format it as currency. How do I do it ?
copying the field from a different form
Hi all, I somehow have troubles with finding the answer to this simple question. I have two forms: -Companies -People Form Companies has 3 fields: -company name -telephone -address Form People has 4 fields: -first name -last name -company name (a lookup field) -telephone (I want the field to be automatically filled) How to set the field “telephone” so it automatically copies data from the field in form Companies ?
zc_ variable for private key
Anyone knows the zc_ name that we have to use to pass the secure key when we to insert view in html view without user login ? The insert view in html view is better than the regular IFRAME. <div elName='zc-component' viewLinkName='Rapport_des_rdv_View' params='zc_XXXXX=CM53WNP4jg8Bvt4pOKYAjeB78hSAeX99C86uBwAwUM3HkygeX1N9787f48EqkRTTBthhdKM9g5gwBxFBNPz8vVG2VPQXRK2pE&zc_Header=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_RecLimit=false&zc_SumRow=false&zc_Summary=false&zc_RecSelect=false'>Loading
creator custom domain for app
hi how can i share my app with custom domain name? for example appname.mydomain.com or custom-domain.zoho.com
send mail to all email address from a specific database
Hi , what i want is to automatically send an email after a specific field had been completed by 10 users ( a form that contain a email address ),after the after the tenth user has completed that specific field , to all 10 users email address that completed the form . something that collect all email addres that had been submited ( like a address book ).
blank edit page
Hi, I don't know what I have done but now when I click on the edit of a record the page appears blank Please help
Calender help
Expert help please... Fields Name John Smith Place At the office Time and date 15/03/2013 14:25:00 How do I send this data to my zoho calender Thanks
Get Related Record Count and Display in Parent Table.
I have a table called "Contacts". I also have a table called "Pets". I want to display the "Contacts" table with a field called "Pet Count" which would display the number of related records in the pet table/form. I have an ID field linking the two tables. Contacts.ID = pets.Contact_ID. I would like my table to look like this: First Name | Last Name | Pet Count I know that I have to either use a formula field or a script that will set the Contacts.Pet_Count field with the related record count,
Fetch and set variable. Please help
Here is my scenario, I have one form called Palo Alto Records and it consists of Phone number, business name, and address. The second form is called sheet1 and it has Phone number, Phone number status, New Phone, business name, business name status, and business name, address, address status, and new address. In the Palo Alto Records form I have imported many business phone numbers, names, and addresses. For the second form I want to be able to put in the phone number and have the records from
Day of week help
I need expert help please Take 2 Fields Date... Day... How do I tell my Day Field to put the day of week based on my Date field Thanks
Hide Column in View (Embedded Column)
I am displaying a view/table and need to hide columns. When I use "hideColumns=Contact_ID;Property_ID;Res_Unit_ID" it works fine, it hides the columns. My problem is hiding the embedded columns. I have have tried: "hideColumns=Property_ID.Address" but it stills shows the embedded column. I have also tried "hideColumns=Property_ID[Address]" but it stills hows the column. How do i hide the embedded columns? Thank you.
If statment in mail content
Hi, I would like to include if statements in our emails, so I don't have to replicate all our emails as the company expands. Something along the lines of... <p> Hi ${Leads.First Name}, <br/> Call us on: ${if (country=="uk") {alert("01273 000 000")} else {alert("+44 1273 000 000")} } </p> This will basically show our UK phone number to UK enquiries and our international phone number to everyone
Send details to my hotmail calender
Hi, If I create a form and within that form id a date and time field for an appointment, is it possible to send that date and time along with the clients name to my hotmail calender. Thanks
Login Restrict Records Global
Is there a way to build a stateless form and use that form to create a global variable or session in which i can restrict records. I need a way for people to use this login form to view records but also restrict records I don't want them to see. The standard User functionality only stores two variables (added_user & modified_user) . Well i am the only one adding and modifying records so these filter don't do any good when you want to restrict records from people who did not create or modify them.
maximum number of characters for multi-line fields
We are setting up a database with several multi-line fields. When we import the data the text is invariably truncated. The documentation mentions a 64Kb limit for fields, but what does this translate to in terms of characters/words per field? Is there any way of increasing the character limit for a field?
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
hi there when I go to editing my View, there is a masage: [ServletException in:/jsp/edit/view/viewedit.jsp] null' and I can't delete a View can you help me? thank you
Formula to assign value to form entry
I have a form to enter information about client contracts into Zoho Creator. I'm trying to create an a formula to automatically assign a number value to to each selectable line in a dropdown. The field name is input.rating and the following lines are selectable: A1 A2 A3 A4 A5 B1 B2 B3 I want the formula to assign the values in the second column below when a line selection is made and display it on the form or view. A1 10 A2 8 A3 6 A4 4 A5 2 B1 4 B2
Is There A Way To Do Data Unions In A View
I have a main form of members (member_info). Some members have family memberships and the data for the other individuals is in a separate form called (household_members). household_members is linked to member_info via the record ID of member_info. The person in the member_info form is the "primary" member and the household members are "additional members". There are times that I want to produce a report of all members (the "primary" member in the member_info form plus the "additional members"
Eliminating elements from a pick list based on elements in another pick list
I have 2 pick lists: picklist 1 and picklist 2. Each pick list is populated by elements based on a separate search criteria on 2 different views. picklist 1 is typically a subset of picklist2. I would like picklist 2 to persist as a pick list populated with only those elements that are contained in both picklist 1 and picklist 2. Can this be done? Robin
why login&pass for "Through this code snippet, you can access the form without login" ?
hi i just made snippet on my paid account and put it on site snippet code "<iframe height='341px' width='100%' name='zoho-form' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/vsavonkin/rabotanaem/form-embed/form/tC2rp1HCeEn1tTUDxew9P2sd3EVDahaqmOSEq1H3CgzHbJ6Ea3QfqDaCw1M1vmF4fqqARm8DmgsVYSxeyBa3CaT27bEMWJ9Nqh6t/zc_BtnFontSize=18&zc_BtnBgClr=red&zc_BtnClr=white&zc_BgClr=lime&zc_SuccMsg=Мы получили вашу заявку и уже ее обрабатываем!'></iframe>" why in browser
Can the SendMail from a form only send data from the decision checkboxes selected by the user?
I have the email set up, so that it sends a copy of the data to the form user once they have completed it. However, as I am using a lot of decision checkboxes, with only a few actually being ticked by the user, I want to know if there is any way of limiting the data that is sent on the form to those decision checkboxes that have been checked by the user? Does anyone know how to do this please?
Reference data from forms in other applications
I know you can reference other applications for lookups as well as calling user defined functions. Can you reference other form data in deluge scripting? eg for each test_record in application1.Form1 { //Do stuff in application 2 } Will this be added in the future?
Using Scheduler & forms to move data
I wish to move data in a form from a tab in a view called 'A' to a tab called 'B' can anyone given me a heads up on possible script to do this thanks
Deleting Tabs in a view
From a form I created a view with tabs. How do I delete the tabs, I have gone to the extent of deleting the original form and yet the tabs still remain which seems like a bug to me any advice?
Fill in parts of a form for the client
Hi, I am new to Zoho, so apologies if this is a basic question... I want to create a feedback / evaluation form that I can email to clients following a product launch or show, but I would like to fill in parts of the form for them, i.e. their name, the dates of the event, the name of the activity and so on - is this possible? And if so, how would I do it? Many thanks in anticipation of your help. Mark
Leading zero for period
Hi, I have a date field capture posting date. Then, a formula field convert the posting date (2013-02-01) to period (201302). I have applied this formula on the formula field: ((PostDate.getYear()).toString()) + (PostDate.getMonth()).toString() System return 20132 but I need the leading zero for Feb -> 02 instead of 2; otherwise sorting will be a problem. I didn't find a padding function and looks the substring function does not support -2 as starting position. Is there any workaround solution? Quincy
Creating an event in Google Calendar
Hi, I have listed below the deluge code snippet for creating an event to GoogleCalendar. The script uses the PostUrl function to send header parameters and write XML Data in the request body. Function for generating authoization header string getGoogleAuthToken(string email, string passwd, string GoogleService) { accountType = "HOSTED_OR_GOOGLE"; url = "https://www.google.com/accounts/ClientLogin?accountType=" + accountType + "&Email=" + email + "&Passwd=" + passwd + "&service=" + input.GoogleService;
Next Page