Formula Fields Not Updating
I use a lot of formula fields for simple things like displaying full names of a contact or creating a URL link to a details HTML page. Quite often the formula result does not update or gets somehow corrupted... This has been happening for a long time but I'm only now getting around to reporting the issue... Simple example. 'Admin' Application, 'Contact' Form, 'NameEmail' field has formula = First_Name + " " + Last_Name + " - " + Email Right now, the majority of my contacts are displaying first and
Populating fields with data from related different forms
OK Here is an issue that I have tried to simplify: My application has 2 forms MAIN DATA MAIN which has 2 fields MainSalesPerson - LOOKUP (linked to DataSalesPerson). MainEmail - Fetch data from the DATA FORM DATA which has 2 fields DataSalesPerson - TEXT INPUT DataEmail - TEXT INPUT In MAIN, on user selection of MainSalesPerson, I want to fetch the corresponding email from the DATA form field DataEmail and display it in the MAIN Form field - "MainEmail". I cannot seem to understand how to get this
Update a field in one form when field is changed in another form
I have two forms one called application the other enrollment Both forms have a field labeled status I want the status field in the application form updated when the status field in the enrollment from changes I do not to open the application record in order to have the field update Any ideas
Posting data from Zoho to REST Api
I am trying to post data from a Zoho form to an API through XML so that I can push a list of updated records upon each add or edit to the Canvas API. This should be really easy, but I am not grasping the concepts of the built in function for HTTP requests. Could someone help with some sample code? Look at the reference data API starting on page 12 of this document: http://www.gocanvas.com/content/images/file-uploads/Canvas_Webservices_-_version_1-3-0.pdf Trying to do something like this in deluge
How to get the current date
How to get the current date
Merchant Services
We are looking to Zoho as a possible solution for the database needs of a small cell phone repair company. One of our needs is Merchant Services. We understand that Zoho added a Paypal option a year ago. Does the customer have to have a Paypal account? Or will he or she be able to pay using an American Express? Please let us know. Thank you, Tom
Can you have creator return on the first character in a field
I send out emails from zoho on record updates The form includes a students first and last name I need the subject line of the email to only include first and last initial Ideas
How to enable and disbale the tabs based on some condition
How to enable and disbale the tabs based on some condition? For example iam having 4 tabs. If iam loading second tab i dont want to show the 1st,3rd & 4th tabs to the user.
problem with condition evaluation
After the last update, some of my html views generated errors. The problem is that it is a very used piece of code which was correct until last update. An example: if(recid != null && Contacts[ID == recid.tolong()].count() > 0) { // some piece of code } Iff recid is null, the code Contacts[ID == recid.tolong()].count() was no more executed . This was the behavior before the last update and it was convenient. The condition checks if the record is null and ONLY if it is not null it checks if there
Please tell me if this is possible in ZOHO.
I am going to build an audit form that will submit a bunch of building data into a database. Example data: Building Name Building Address Owner Name Existing Measure A - Potential Measure A Existing Measure B - Potential Measure B I'm then going to submit this data into a database. Here's where it gets tricky: A) I want to be able to pull this information back out of the database into the exact same form (so I can pull up any given site and see the full details again and be able to modify it (possible?)).
Error Occurred While on Success Script
Users are reporting this error on one of our embedded forms [Note to support: it's the "Hell's Kitchen" form]. The rest of the error message isn't very helpful: "We are working on giving more meaningful error messages on script failures". What are we supposed to do with that..? The user in question received this error 4 separate times, waiting 2 hours between each submission. I have enabled support edit access. We need to address this issue very urgently.
Form Schedule Did Not Run
I have a form schedule setup to send an email on a specific date (later than today). Send Queued Posts { Execute on POST_QUEUE_FORM.DELIVERY at 01:00:00 } POST_QUEUE_FORM contains a date-field DELIVERY. However, the schedule did not run recently as anticipated. I do have the frequency set to ONCE, since I only want one email sent. Am I doing something wrong? Cheers, John Whitney
String to int
I can't find out how to parse a String to an integer in the deluge scripting language. Hopefully someone out there can explain to be how this is done. Thanks
how do I get an e-mail when a field is updated?
I have a form with multiple fields. I'd like to get an e-mail anytime one or more of the fields are changed and SAVED. However, I would ALSO like the e-mail to say: 1. Which fields were updated (what they previously were and what they currently are) 2. Give me a link to that particular data-set I know how to send the e-mail on update, but I don't know how to pull out the variables that tell me the above 2 listed items. Any help? thanks! - Quan
Reset Total value on update
Hi All, My form has several fields for numeric values to be entered. At the bottom is a total field. I set an "on user input" script for each field as follows to update my overall total at the bottom: input.Total = (input.Total + input.FIELD1Value); field 2 value etc.. This works fine and when I tab out of field the total updates. BUT.. If I go back to FIELD1 and change the value it adds this new value to the total also, so my total is way off as it has not reduced the initial value. Can someone
Want to put an intput field in Views
Hello Sir, I want to put a text field, in the views. After entering the value into that text field, that corresponding record should be updated. if this is not possible, Please try to tell me any other option.
Application Database Alternatives
I would like to create an application using Creator.......my issue.....my application database will be very large.....using Creator's database could get expensive....is it possible to create a appliaction within Creator and leverage Z Reports as my database....or any suggestions.....also are there limitations using databases other than the Creator database? thank you
total of multiple forms
Hello, I have a total of 6 forms that are linked by a single registration number per group of people. Each form contains a sum of money that is tied to the registration number. How do I create a sum across multiple forms so that it gives me a grand total of how much that person has cost me (incidentals, hotel room cost, food costs, etc). Thanks
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
link between form and subform
Hi, What is the link between a form and subform? "If I embed a sub form into a main form and enter multiple records on the subform, how are these multiple records linked with the fields of the main form?" Please help. Thanks! V
How do you reference the value represented by a bidirectional field?
I'm trying to wright a custom schedule script that references the email addresses to send to, from a form where the email address is populated from a bidirectional relation. My script errors I assume because it is receiving the ID number from the bidirectional field instead of the actual email address value I have the child form display. Here is the code I'm trying to run: temp=""; for each x in CRS[Received == false] { temp = x.Report_Type; for each e in Test_Staff_Roles[Notice] {
Zoho Reports within Zoho Creator Tab
Is it possible to embed or <iframe> Zoho Reports within a Zoho Creator Application Tab? (not a report,chart or dashboard) But the ability to use the functionality of Zoho Reports within a Creator app... To give my users a more seamless experience? Both products are great....
New product update notice - in precreator.zoho.com
Hello All, We have come up with new set of features/enhancements. It is available in our beta server https://precreator.zoho.com . Noticeable changes: Improved Calendar view Provision to specify event/task Start and End date is supported (to be configured in design mode) Supported Week & Day in addition to Month view Refer the example view below Resize and Drag & Drop to update the event time Radio and Checkbox field can display options in multi-column layout (maximum of 3 columns) In addition to
Modify existing record and save as new record.
Is there a way of opening a record in edit mode and saving it as a new record? What I want to do is use the data from an existing record, modify it, and save it as a new record in the table. Any help would be appreciated.
Zoho Creator Payment - pass other data to PayPal?
When I use a payment form option, is there any way to pass additional fields through to PayPal besides the Item Name, Quantity, and Amount? We are trying to track all of our PayPal purchases through the use of SKU's (stock keeping units) corresponding to our internal account numbers, so I'd like to be able to pass an Item ID field through to the PayPal portal. Any way I can do that?
Update 2 rows on another form on submit
Hi, I have a form "movements" and another form "Stock" with different locations. When user enters 200 for "Item A" in form "movements" I would like to reduce the qty of "Item A" in form Stock for that item and location, and increase the qty of Item A in another location. Stock type will be chosen on the movements form. Stock will always originate in the same location and end in same destination. I tried the following for on submit, on success: if (input.Stock_Type
INSERT AN IMAGE IN FORM
Dear Sir / Madam I have uploaded one image in "Image Hosting site" and get a link. but when I tried to attached this image using link in my form thru ADD Notes. it is not showing Image. Link is http://i1170.photobucket.com/albums/r521/shivdutt/05b3d1a3.jpg Please check and advice me, how i can attached images in my forms.
Double Vision when editing a Script at Creator with Copy and Paste
Please look ar this video : https://berryforms.box.com/s/73fcc58a28b2b13fa485 Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Paypal & Customer Addresses - Can you help ?
How do I either :- A) Capture Billing or Shipping address and send these to Paypal when submitting a transaction ? or B) Let Paypal capture the address and read these back on a Creator View ? ------------------------------- My preference is A, but can live with B. At the moment the customer is asked for their address by Paypal and then on my Creator view I simply have a link to the Paypal Payment information and the address information is buried in a section called All Params. The address is in there
look up not working
hi i have tried and created two forms namely order form payment option my problem is when i use the option of look up in the 1st form for a field in payment options .. the field in the payment option form is not working
How to view two forms in one view?
Hello: I have one table with customer info (name, address...) and another one with the products purchased by each costumer. I linked both tables by costumer ID. I want to create a view for each costumer to show at the top of the view the costumer information (name, address...) and then the list of the products purchased by the costumer. Example: John Williams Phone 4242-5478 Adress: 25 1st street ----------------------------------------------------------------------------------------------------------
1 Report out of 2 forms
Hi all, I created a form where I can indicate a capacity per factory, per month (form 1). It looks the following: Month Factory Qty 01-Aug-2012 Factory 1 100000 01-Sep-2012 Factory 1 250000 In another form we enter volumes per week that are forecasted so far, like shown below; Date Factory Qty (SF) 01-Aug-2012 Factory 1 90000 01-Sep-2012 Factory 1 100000 10-Sep-2012 Factory 1 50000 I need to build a report where I can see e.g. how much volume has been forecasted and what the capacity for
Auto Populate of Fields isnt working correctly
I have an application that has all of the club information in it (club number, member number, member info etc.) It has multiple clubs in it and within those clubs it has multiple member number. There are member numbers that are the same within seperate clubs. For example I could have club 0259 and member 7 but also club 0176 has a member 7. What I am wanting to do is on a display_20_scores stateless form I have then choosing the club number from a dropdown, then I have them choosing a member
Hide Edit and View columns
I have a form that I would like to embed on my blog. But I don't want the Edit and View columns on the left to show before my first column shows with my compiled data. How can I mark these automatic fields not to show? Thanks. Earnest
logo
Is it possible to use different logo and favicon for each application? Thanks! V
iframe Zoho Creator SO
Can I zoho creator for my database & views on a Joomla or Wordpress site withou using iframe? I need the zoho database server name to be the same as my domain, is that possible? SEO friendly is the key.
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
Search Form with Date Range
I am creating a Stateless form with two date fields to search Start Date and end Date. I am using the follwoing OpenUrl Task. openUrl("https://creator.zoho.com/appowner/AppName/#View::Task_View?Start_Date= input.Start_Date;input.End_Date&Start_Date_op=58", "Same window"); When I submit the form I get all the records in the view with a message " invalid date format" What am I doing wrong. any help will be very much appreciated.
Hack to sort rows of a subform and pre-populate row fields that I want to preset
Not sure if Zoho have finally enabled sorting of rows in subforms. But the hack below worked for me. Basically i take note of the random order the rows are sorted. Create a hidden field in the table being used for the subform called Order_Index. I then just set the order index to the value it appears when the subform is displayed before implementing this logic. E.g The row I want to appear first might show as row 5 so I set the Order_Index for that record to 1. I create a map() which has a key
View Link to related table wont stay disabled
If a Link to a related table is enabled for a view in the Column Properties section and then disabled it does not stay disabled. When I go back to the column properties the link will be enabled. It can easily be disabled again. The problem is that I may be in the section to make some other change and not notice that it is enable. I have tested this with two different applcations. One using teh old UI and one using the new UI. ------ If I have the link enabled for a field set as a Group clicking on
Next Page