Will Pay for Zoho Specialist
To whom it may concern, I am finding it nearly impossible to complete even the most basic tasks using Zoho. This is clearly a powerful platform but I will never be able to use it without assistance. Will pay to have phone access to a Zoho specialist for one week. Regards
Master Field overriding All rows of Subform field
My form as a 'Master Approval' dropbox ( Pending, Approved, Denied) as does the attached sub form. I'm asking for some help in coding my Master Approval field so that when a new choice is selected it overrides the selection in the Approval fields in each row in favor of the MASTER APPROVAL Selection. Has anyone had experience with this?
Build Custom Report - Access Relational Data??
I hope I'm missing something, but I have an application working great with a number of relationships between forms. Zoho does a great job in creating the underlying default report to include the relational form for access, however when you you want to create a pivot table custom report, you are not allowed to bring in the related table (form) to use these fields for the report. Why can I ONLY choose from forms, and not existing reports, to build another report that is truly meaningful, utilizing
Custom Actions - sequence by Action Name
I've created several custom actions so that when a user is at a row, and they select that row, they can access the Custom Actions. Great. HOWEVER - the custom actions appear in the order that I've created them!!!! How can I make the default sequence be alphabetical by Action Name????
Possible To Easily Persist Data With Application Distribution?
Is there an easy way to persist the data in chosen forms to remain with the application during shares and copies? If a customer is going to have to do some importing upon first obtaining the application to allow for basic operation, this may be a deal-breaker for some. My application has 95% of the "items" a user will need, and all they would need to do is plug in their own price defaults. Their unique items can also be added as necessary. But I want these 30 or so items to be a part of the purchased
How to retrive date stored in table
I have one stateless form which has date field and which is storing in table. I have functionality where for particular ID i ant to retrieve data from database there i am able to retrieve all data but i am not able to retrieve date. How can i do that?
Decision Box On Report
Is there a way to make a decision field type display as a "checkmark" on a report? This seems like such an obvious option to include in basic reports design. It looks great on a form as a checkmark, but on a report listing showing a bunch of "false" and "true" entries is not very appealing when all you want to see is a checkmark, or no checkmark, and in fact it's hard to easily distinguish if it's true or not without hurting your eyes. Am I missing something?
Usage of lookup field. Form1=>2=>3. Can Form 3 get info from Form 1?
Hello Now I'm making an application like below. 1. formEntryAllUser =>Name,Email,Address ...etc basic infomation 2. formEntryLimitedUser =>Lookup to form1,some additional info 3. formEntryInfoOfLimitedUsers =>Lookup to form2,additional info necessary only for limited users Now I've finished creating these forms and reports. I want to use basic information in form 1 like name, email etc in both form and report 3. But in form 3 (there is only lookup to form 2) , I cannot get information
Mass Data update to Form
Hi, I have a form like below where there are three columns like -- county , Fips, Housholds 2013. The first two columns county and fips never change. But the third column Households 2013 will be changed every year. There are around 3,000 rows of data of this form view. For now all of these columns are now connected to several forms by anyway in the entire application. below is the form view screenshot : my question is that what is the best way when I will try to update the Households 2013 column
Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms.
Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms. Hi. I need to do a bulk update so that when a field is ticked, another field updates. I.e. "Confirmed Status" is ticked then a text field called "Current" status would be updated with the text of "Confirmed". I have created an app to do this. It does lots of checks and the code works great in a single form as it uses the OnSuccess events and the OnChange events that happen when creating a new entry or editing
How can I set a custom filter for a multi-select checkbox field?
Hi Zoho Experts! I'm trying to create a custom filter/view in a report that relies on information from a field that is a mandatory, multi-select checkbox in the original form. The field is "Season" and the values in the field are "Winter" - "Spring" - "Summer" - "Fall" I need to create a custom filter/view that allows me to see all items that have both a "Fall" and a "Summer" value attributed to them (regardless of Winter and Spring). I am able to create a custom filter for one season, but I am
Programmatically Add (Insert) Child Records Upon Parent Add Event?
Is it possible to programmatically add child records [to subform] on the "add record" trigger of the parent form? For example in a basic order-entry application. There are Orders and OrderDetails. OrderDetails accepts entries of Inventory Items. For example, an order may be of a specific "type". This "type" typically includes 10 of the same Inventory items that meet a certain criteria according to "Class" or other field value. So when this "type" of order is added (initiated), I want to programmatically
Report using zoho creator
Hi, I have created one property application in zoho creator, so i want to take report by monthly wise. For Ex : Jan Feb ......... upto Dec AAA 12,00,000 3,00,000 5,00,000 BBB 23,00,000 12,00,000 9,00,000 Issue is Date Format is nt accepted this type of month value, i have one date formatted column.(Added_Date) Can you please ans for this one .........
Automatically update Zipcode
Hi , I want to update automatically zip-code in fields For ex : Location ------ OMR Zipcode ------ 600003 It's is possible in zoho creator,i think it will take from Google Map or other sources
Add Record, Only Want Some Fields Available Before Submit Button
I'm looking for a clean way that when a user wants to add a new record, a "form" ("report"?) opens up with only the key required fields available for data entry, before the Submit button is displayed. In this application, when a new record is added, the remaining 60% of fields are not required as the data for them is not yet known. I don't want the user to have to scroll through many times to get to the Save button far off-screen at the bottom. Also, along the same lines, if I have a report that
How can I allow another user ability to edit my application (add new forms etc)?
I would like to grant another user permission to edit my application, please tell me how I can do this? Thank you, Bianca.
Convert HTML to PDF with filename
Hi, When using the header option pdf = true in an HTML view is there a way to generate the PDF with a file name other than the name of the view? Any help would be appreciated.
Auto Duplication of Form Entries based on Criteria
Hello, I am currently building an Invoice Program in Zoho Creator due to Zoho invoicing not having everything that we need. I need to include the ability to allow re-occurring invoices which are duplicated every month based on the original invoice. I currently have a tick box which if ticked I would like the system to create additional entries once every month until it is stopped. Is this something that can be done? Is anyone able to give me some advice.
List in sendmail
Hello everyone: I have been using a string variable to "build" the list of email addresses that is used in the To: line of the sendmail task. See portions of code below: if ((peemail != "") && (peemail != null)) { toEmails = toEmails + "," + peemail; } and the To: line: sendmail ( To : toEmails, input.Email1 I can't take credit for this genius bit of coding as Zoho did it for me to resolve a sendmail issue I was having. This has been working for a long time and recently
Fetch, Update, and Schedules
Hello! I have a form that has a drop down called "Status" which I use to filter for reports. I'm using the Schedules feature to send a report of records once daily based on the status field. I'd like to create a second schedule to update the status field shortly after the first report is sent. Is this possible? Thanks Arlan
Formula update
hello, By example i would a number field witch is the subtotal and a formula with TAX and formula with Grand total I would that when my script deluge calculate the SubTotal the TAX and the GrandTotal will be update automaticlly. Is it possible ? thanks you
Display next record +1 on next Add row in SubForn
Hi I'm trying to have the next field to be = Previous record value + 1 so I can start working adding Lines every time the user hits Add new in the Item_Sub Form. Try this but only pass as result = 2 to all new records. x=(row.Number + 1); row.Number=x; I'm completely new on this code trying to learn. Your help will be greatly appreciated.
sharing
hi : i am new to zoho and so using a free version to devlop a small app by it . i have shared my app with a friend ,which appears on his account page as a shared app,but it denys access, is it because of limitation in free version ?, or i miss a setting to let him use it..? please help
Filter of Checkbox Field Not Working in Reports
I have a Form called Fuel Order. On this form I have a checkbox field called "Invoiced" with two options, "Fuel" and "Freight". When I try to generate a Calendar Report showing only selected records, using this logic: "Invoiced" does not contain "Freight" This does NOT work. It shows all records. I think it is a bug. https://monosnap.com/file/Mq5z8WYfxPbqfLPQhrlc9u6g2XiCiG Any help would be greatly appreciated.
What better way for a veterinary consultation record ?
Hello , I need to create a query form for animals. 1- How do I create queries in the customer file so that the history be stored and has good usability mobile? And may I add the service values at each visit ... 2- How to make two date a form fields appear on a calendar ? I need to schedule more than one procedure but could only configure each on a different schedule. Thank you!
In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid
I am having a problem with the following code. QBD_Line_6 this is result from a user selecting from a Lookup field QBD_Type is the field that the Lookup field draws from QBD_Cost is the form that all the data is drawn from Cost_per_Pc is a cost associated with each QBD_Type QBD_Value_Line_6 is the field that the cost should display to the user. if (input.QBD_Line_6 != null) { temp1 = QBD_Cost [QBD_Type == input.QBD_Line_6.toString()]; input.QBD_Value_Line_6 = temp1.Cost_per_Pc; } This code gives
Bug in Creating URL's
Hi! I am getting a REALLY weird problem. I have the exact same email being sent to two different people. On one of them the a URL in a link (generated by Zoho Creator) is different that the other. Just a tiny difference. Why? See here: The Correct Link: https://creator.zohopublic.com/jjmancini/fuelorders-v2/view-perma/Stateless_Carrier_Acceptance_HTML/12345YFYyjw1PECxegqWkRMeGHhMCS0u6dYZ61OtJuUR7axhbawj3qPkyW87JpeEP3pCWrH5M4RW7ubQ84658XPFS06jKt6Qj/Order_ID=555539000012469123&Carrier_Reply=Yes&CarrierSCAC=XPER&Carrier_Contact=555539000004748233
Create a List of Checkbox Choices
I have a form which includes a checkbox field with about a dozen different choices. In a script, I am trying to create a list of what those choices are. I am not trying to get a list of which boxes are checked, but instead just a list of all the choices available. Is there an easy way to grab those values and stick them in a list?
Zoho Creator - Local Backup & Scriptng
Hi, I want to know if I can take local backup of data and app available on my zoho creator. Also to do the scripting in zoho what I need to learn HTML or something else. Also I am trying to build two way communication program in this,let me know how can you help. Please let me know.
How to generate HMTL Code?
Hi all, I am would like to generate HTML Code in Creator. I created a products table in Creator, and I have an html template, which require to put some product information in the html template, just like a mail merge. However, after html code generated in the form, the HTML tags was trimmed. Is there any way which don't trim the HTML tags? Thank you in advance.
Customer Portal
Would it be possible to to have a system variable that returns a user's Profile Name from the Customer Portal that then can be used to determine the user type in scripting? Is there a plan for Profiles to be included when duplicating an Application? The ability to export a Profile and reload it into another version of the same Application would be equally good. Many thanks!
Edit Record Passing Parameters
Good day this is the following way to edit a record passing parameters could you please confirm how to perform this in form-perma. http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> Best Regards,
Copying values between forms & lookup/editing with barcodes
Hello all, I am build an application that I can use to keep track of my company's hardware. I have a New Hardware form for adding new entries, an All Hardware form/report, and a Check Out/In form to perform the check-out/in action. I have a couple of basic questions I need help with: When a "New Hardware" form is submitted, is there a script I can implement to create a new entry in "All Hardware" and copy values over? Is there a way that in the "Check Out/In Form" I can use a Single Line field
Bug: Stateless form buttons don't work on mobile.
Hi, Both button types (Standard and Submit) don't appear to execute their deluge script on Stateless Forms via the Zoho Creator mobile app. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Stateless_Form Please advise. Regards
Android Phone photo - unfortunately Zoho creator has stopped
Hi, I have a new app (and have a developer helping me with it) My android phone is giving the error "Unfortunately Zoho has stopped working". The cause is when I take a photo and submit it. This works fine on an iPhone. Questions: 1. Is this a common error? 2. How fix it? 3. I have logged with Zoho support. Will they be able to resolve? 4. Are photos generally a problem area? All help appreciated.
Problem with subform and adding fields to picklist and txt.
I have a form Items, and form Recipe with a subform. In my subform I need to populate a dropdown box based on the item selection. row.PurchaseTxt=Items [ID == row.items].Purchase_Txt; row.InventoryTxt=Items [ID == row.items].Inventory_Txt; row.UsageTxt=Items [ID == row.items].Usage_Txt; clear row.Usage; row.Usage:ui.add(Row.PurchaseTxt); row.Usage:ui.add(Row.InventoryTxt); row.Usage:ui.add(Row.UsageTxt); Any help would be appreciated.
Sharing records
I have a situation where we want to share some records between apps. Specifically the apps are for keeping track of leads for different websites. In some cases, the leads are common to both sites or apps. We want to have the common record available to queries from both apps. Is this possible with zoho creator. Note, the apps are identical in structure.
Select or Deselect a Field Weh the Field is Updated
I have a checkbox field called "Invoiced1". I have the following code in the Field Action, On Load section for a field called "Carrier": Invoiced1.deselect("Freight"); It works great! When I try to copy and use the same simple code into the Field Action, On Update, it fails. Saying error on line 0. Any ideas? Help is much appreciated. Thanks!
Combined Report of 3 forms
I am having trouble (since I am new to database design with Zoho) on creating a "final report" that shows results of three forms linked by a field called "exercise title". I have reviewed numerous documentation documents and forum topics. Any one have any suggestions? Thanks Adam
Create combined report with 4 forms
Greetings: I am totally new to Zoho and am in need of some help. I would like to link 4 forms together and create a "final report". I have allowed edit access in Support and would appreciate any assistance anyone could provide. Thank you in advance!
Next Page