iOS Creator - Pivot Table Report View Issue - Minor
Zoho Creator v 3.5.4 for iOS in IOS (on an IPhone 6), a pivot table report that generates more then several columns is difficult to view because the "Rows Popup Tab" remains up and will stay up until the user coaxes it to go back down. Seems it should drop back down momentarily after making any scroll changes without user intervention.
Zoho - GITEX - Dubai
It was nice to see Zoho in GITEX
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????
Set working day at 10hours period with zohocurrentdate?
The zoho variable Zoho.Current.Time and Zoho.Current.Date is very good and I use it to input time and date as a hidden field and also how long it took to close the ticket (with last modified time): "Length" field: ((Modified_Time - Date_Time) / (1000 * 60 * 60)).round(2) What I get is a number of hours, but what if I want to limit those hours to 7am 7pm? eg when I get "Length" = 240 hours, it is since the ticket is opened, but not in real business hours from 7am to 7pm... If I open a ticket today
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
Need a mass update solution...
Hello all, I am a beginner here... So please be patient :) I need to do the following: I have two forms. Form A contains product informations. A few thousands or records. There is a field named "Categorie" and it is written in French... Form B only contains two fields, first the same category infos than Form A (a few hundred types) named "Cat_FR" and the translation field (in English), which is named "Cat_EN". How can I "mass edit'' the Form A to add the field "Category" (with the info from
mass update via Deluge
To mass update 5,000 records, if I use Deluge do I have to use the Iterator method? Is there any other day of doing this? Thanks.
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
Problem following the tutorial for Zoho Creator
I'm following the tutorial for Creator in the link https://www.zoho.com/creator/help/tutorials/advanced-app-building.html However can't get past the step "Link the Product Form and the Order Form" Seems like when you click Done after following the instructions, the Fields column become blank and it is only selected up to the level of Applications > Forms rather than Applications > Forms > Fields. Not sure how to resolve this.
Zoho Creator - User Audit Detail - Information not available
Please note we are unable to extract audit realted formation from the system on DAILY basis in Zoho Creator 1. Login / Log out Details of all login users – Database wise . Where can we view the summary report (list of all login / log outdetails - userwise) at any given point of time ? 2. 2. Row-wise audit history – for all active rows in a Form i.e. - Each row created date and created user id and last modified date and last modified user against each form in a database? 3.
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
creator.zoho and mobilecreator.zoho
Hello. How to synchronize application from creator.zoho.com to mobilecreator.zoho.com. When user enter data at form on mobilecreator(for example in Zoho app box application), these data automatically update in Report on creator.zoho.com. And another question, I want creat my own application for Andoroid\iOs (.apk .ipa) and then upload to Apple store with own logo etc. but with application on Zoho creator. Is it available, or any ideas how to do that ?? Thanks !!
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
Multiple notification rules, yet more than one rule is applied
Hi, I have a drop down box with the aim that when an item is selected, it will produce a custom notification via email. I set up the rule with in criteria section: Dropdown - Equals - "specific dropdown item". I have 12 rules set up - it all works apart from Rule number 1 will always send a notification out as well as what ever is selected in the form. Can you 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!
Edit record issue
Hi In one of my form I have a single line field ,that is referenced to some other reports.Now when I go to report settings and I tried to hide,it shows one warning message like "lose the data of that column".I have shared the mockup below,can you please let me know why its happening? Thanks
Zoho creator Not saving changes
Hi Im having issues whit my document in zoho creator when i try ti save something new a message saying saving records shows and stay for a long time not saving my changes. There is anything i need to do to fix it ?? what is going on ??? i already try to log out and log in a couple of times, and also do it into google chrome and safari and still not being able to work.
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
Seperator for passing variables via url string
here is my nonworking example (between forms) openUrl("#Form:Client_Form_GC_CL" + "?TZ2CF_Address_1=" + input.TZ2PF_Address_1 & "?TZ2CF_Address_2=" + input.TZ2PF_Address_2, "Popup window", "height=400,width=400"); NOTE the single ampersand does not work as a separator between fields...what does?. Help Please Thanks Larry
There is no such view in Zoho Creator
I am trying to use the REST API to download data. It keeps giving me the above error. Below is the data that is being sent. URL: https://creator.zoho.com/api/zoho_bob191/json/t3/view/GoldMine_Web_Import_Report And this is the data that I am sending to the above URL: <form method="GET" action="https://creator.zoho.com/api/zoho_bob191/json/t3/view/GoldMine_Web_Import_Report"> <input type="hidden" name ="authtoken" value="xxxxxxxxx"> <input type="hidden" name ="zc_ownername" value="zoho_bob191"> <input
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
Auto email report on form success
I can't see how to email a simple report of a form as soon as it is saved.
Send a report when a form is saved
How do I set it up so that the report associated with a form is automatically sent when the form is saved.
Next Page