Zoho Creator mobile not displaying report column
I have a very simple Creator app that when I access a report from the mobile version, the last column in the report is not displayed. It displays fine when I access the web-based version on a PC. There are 5 columns in the report and only the first 4 are displayed when I access via the mobile app (Android). Am I doing something wrong, or is this a limitation?
Zoho Creator Application Packages documentation?
Where can I find any documentation on the Zoho Creator Application Packages feature?
Fetch Data from ID
Hi I'm trying to populate a table based on the ID number of a record. I have a table (Main) with People & Courses having lookup values as their records People Courses 3081044 3001505 3150808 3205808 3081044 3045088 I want to fetch records in this table where People = the ID number of the People table when I edit the People table. So; user edits People table (maybe adds a new course that the person needs to do). When they click 'Update', this code kicks in... training_records
How Do I Populate a Notes Field with Iterated or List Values?
I have two tables: Locations CustomerContacts (there are many customer contacts for each location) In a third form, I would like to show all of the CustomerContacts in a "note" field once a Location is selected. I understand how to use the for each and iterate through the CustomerContacts, but I cannot seem to get it to list, or show all of them. How can I do this? Thanks!
passing a variable to a wordpress embedded form
Hello. I am stuck. I use 'WP Estore' and WP Emember to manage my store functionality. I want to pass the sign-in email to a Zoho embedded form on my Wordpress site. I've searched these forums, and found a few that are very similar, but not enough for me to figure out how to pull the variable from Wordpress to Zoho. The Wordpress variable can be called with this WP Emember function: wp_eMember_get_user_details("email"); First time posting, and fairly newbie php programmer. Any ideas? Jason
Zoho Creator - Who can start developing the application
Is it necessary that a developer need to be coding / programing the application? Can a person who does not know coding / programming develop application using Zoho creator?
Sorting a multiselect lookup on success
Hi, Here is a list of options selected in my lookup field called contact type (NB: It is a multiselect) that references my form contact types: Warehouse Accounts Sales Purchases I want it to sort to alphabetical order: Accounts Purchases Sales Warehouse The code I have written on the On Add-> On Success portion is as follows: IDList = List(); for each ContactType in input.Contact_Type { GetDetails = Contact_Types [ID == ContactType]; IDList.add(GetDetails.ID); } GetSortOrder = (Contact_Types[ID
Create report for time spent
Hi, I have in one of the forms start time and it saves it in the DB, MM/DD/YYYY HH:MM:SS then in the reports you have an Add Time when the user finish and submit the report automatically saved by the system with the same format MM/DD/YYYY HH:MM:SS. I'm trying to make a report where it takes form start (MM/DD/YYYY HH:MM:SS) - finished form (MM/DD/YYYY HH:MM:SS) = time spent (HH:MM:SS) I can't figure out how. If you can please help me it would be great. Thanks!
get records from zoho books using "greater than"
Hello, I want to fetch records from zohobooks searching for Invorce IDs greater than the last one fetched. Example below. is it possible? if no, what's the most efficient alternative? Books_Response = zoho.books.getRecords("invoices", "xxxxxxxxxx", "Invoice_ID >" + Last_Invoice_ID); Thanks Luis
Using Creator with Zoho Sites
I'm new to Zoho, so forgive me if this is a dumb question. Is it possible to run your "Entire" public and private website using your own domain name with Zoho? I currently use WordPress to sell online classes and subscriptions. The online classes are videos, hosted by Vimeo and embeded in WordPress Pages. The subscriptions are handled by a "Membership" plugin restricting access to custom documents just for that customer. Can I use Zoho for my public site pages (blog, static content pages, forms,
Time Stamp
I have a notes field on each clients form. I add notes to their record from time to time. Is there any way a time stamp can be added. before the note, each time I edit the notes field? Thank you.
Atomicity in Zoho Creator?
I need a unique "order number" for each new order. I use a form's field to keep track of the next "order number" and increment it. string WalkIn.OM.Orders.NewOrderNumber() { g = Global [ID != 0]; temp = g.Next_Order_Num; g.Next_Order_Num = (g.Next_Order_Num + 1); return temp.toString(); } The problem is, when 2 orders are created within 3 seconds apart, they'd get the same order number. Is there anyway to guarantee atomicity for the function above?? What's the right way to implement
CREATOR Grid & Spreadsheet Reports in the NEW UI
I am developing an application that heavily utilizes grid or spreadsheet views for the purpose of QUICK data update without having to open every record. Several weeks ago you could not get creator to accept a value into a field in these views. This has been fixed.....and I was told by email that the grid and spreadsheet report views are fixed. However these issues REMAIN: 1. The grid and spreadsheet are no longer 2 distinct views 2. When there are 20 to 40 or more records....it can take 5-8 seconds
Issues with viewing VIEWS on creator forms in CRM
I recently purchased crm plus. The first two weeks. I could create a tab for a creator from. I could than view ALL views of that form beautifully. Then there was an API issue and you could not view any integrations. That has been corrected. HOWEVER, I currently CAN NOT view ALL the views of a form that has been integrated in crm plus from the crm. No matter what view is selected the same view appears. I have made several calls to tech support with NO feedback on when this might be fixed. This
Date format and decimal separator
Although my application be set for the Brazilian date format, my forms show the months with the abbreviation in English as "Sep" for September instead of "set". I'm also not finding a way to use the comma as the decimal separator. Could you please help me? Thank you!
Find invoice number (Zoho Creator -- Zoho Invoices)
I am using Zoho Creator to create invoices in Zoho Invoices. Zoho Invoices auto-generates the invoice numbers. What code can I use to find the invoice number of the newly-generated invoice ? THE CODING I'VE TRIED: The following line creates the invoices successfully: response = zoho.invoice.create("Invoices", "633994822", values); I would have expected "inv" in the following line to give me the invoice number, but it results in a null value: inv = response.get("invoice_number");
Subforms
Hi Guys, Basically most of my forms require to have subforms that are existing and the user is required to add to some of the fields in the subforms. So data is populated into the subforms and user is required to append to it. The main issue I have is the non-availability of the function to add or delete rows in a subform using deluge script. This causes a number of issues as follows: 1. I have to pre define the number of rows for the user, where sometimes the subform might have more or less. 2.
Add an element to a form by a Custom Action
Hi, in one of my form I have a Custom Action which open a report where some fields are pre-filled (based on the record selected) and there are others that the user should fill. When I press the "submit" button, it adds the fields in the correct form but the report remains open and not closed. I followed this guide: https://www.zoho.com/creator/help/views/editing-records-via-record-id.html My URL is the following: sURL = ((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname)
Using Not In
Hi! I need to load a Drop down with a list of names of people. This list must be a result of a fetch operation in a way that excludes (not in) records in a lookup field related to another form. How can I fetch records excluding (not in) records from another fech operation? Thank you!
Stop Automatic Update of Form Fields
Hi all, I have a form with the following fields: - pieceLength (m) - weightPiece (kg) - weightMetre (kg/m) Depending on the value put inside one of them, the others get updated using the OnUserInput field action. The problem is that if for example I put "pieceLength" = 15 and "weightMetre" = 5 then "weightPiece" is calculated as 5 / 15 = 0.33 but soon after weightPiece is recalculated (because 15 * 0.33 = 4.95 and it's different from 5). What I need is that the fields are correlated, but the changing
View Records API Mutilple criteria values
When can we have an option to fetch multiple records having different value for a single parameter field accessed through a single API call. For Example, if a user wants to view records for 10 different order numbers, he has to make 10 calls one at a time. This is how it works now. But we should be able to fetch multiple records with a single call, may have an upper limit (say 100). Avinaw
How to access lookup field values in fetch records
I have an application with a product form ICO. To do a monthly inventory, I created a form Temp_Inv to allow users to enter inventory amounts, in On Load, I fetch records from ICO: for each x in ICO { if (x.Inventory != "Labor") { insert into Temp_Inv [ Added_User = zoho.loginuser MD_Serial = x.MD_Serial Inv_Date = eomonth(today,0).addDay(1) Supplier = x.Supplier Pack_1
click on text open edit field?
Hi Zoho, I've seen a post directing this here, but I can't find it now.... I have an html page displaying data from different forms, I'd like to have the option to edit the data straight in the html page - meaning when I click on the data, an update field tiny window will pop up next to the text (just for the field that needs to be updated, not for the entire form). I hope I've explained myself well enough. Will appreciate any help.... Thanks Ravid
Configuring Conditional Dropdown
Can I create a conditional dropdown based on a radio button or check box selection? ie Radio button for "documents" selected dropdown would contain those items or "improvement plans" selected dropdown contains plan types
Filtering a table on an html page
Hello Zoho's, I have an html page with a table in it. The table takes its data from one form in my application (lets call the form "FNA form"). I'd like to have the option to filter the data in the table, with 4 possible fields to filter by. I figured my solution is to embed a stateless form to my page, next to the table, and to have its field passing parameters to the html page, filtering the data I fetch from the FNA form. - note - I do not want to embed a report to the html page, for many reasons
Viewing more than 10 records by default
On my page I have posted the html code from my different views for my application. The problem is the default view is 10 records. I need to change it to be the maximum by default. Is that possible?
Internal Server Error Sorry! Due to an unknown error occurred in our server, the page cannot be opened now. Please try again later.
Hello, could you please fix the bug in my profile? micheledacosta at iCloud dot com Thanks! Michele
is it possible to integrate zoho creator and zoho reports?
i have created form with one file upload control and one button control in zoho creator. first i can upload excel using file upload control , secondly when i click button i want show the sprint number analysis(from zoho reports) on the form for uploaded excel file . is this possible with zoho creator???
How to use PHP fonction like md5 in HTML view ?
Hi, I'd like to use md5 (http://ca3.php.net/md5) in my application for authentification purpose with another application. Can we use PHP in HTML Views ? I'd like to push a string and get back the result to make a if in my HTML view. The sample code is like this : <?php $str = 'apple'; if (md5($str) === '1f3870be274f6c49b3e31a0c6728957f') { echo "Voulez-vous une golden ou une spartan?"; exit; } ?> Is it possible ? Thanks, Pascal | nsisolution
Need to insert a "." between numbers in a string field
I am trying to take a string field in which a number like 1415 is entered and have the field insert a "." so that the result will be 14.15 What is happening with either of the examples below is resulting in 14.5 with the Creator Cursor spinning forever and locking the record/field up. Can someone tell me how to "end" or "return" the processing so it will stop continuously looking at the field named Start_Time and move on the next field or process. I'm sure there is a qualifier that has to be put
Mobile App IOS Ipad
Two problems using file uploads in the mobile app. 1 The indicator within the Report of the existence of an uploaded file is an icon of 4 tiny dots that can hardly be seen. 2. The file, for example a PDF, will open ok but clicking the Action icon will crash the app.
Variable is already defined of data type
Greetings, The first four items, have been working fine in getting "currency" field from the CRM. When I added the fifth, BMD, I get variable error. Can you point me to the error of my ways? "Variable 'BMD' is already defined of data type 'DECIMAL' but trying to update 'STRING' data type //Dealer Opportunity gdr = crmResp.get("Dealer Gross Revenue"); lsv = crmResp.get("Less Service Revenue"); lsfas = crmResp.get("Less Sales from AS"); INDopp = crmResp.get("INDEAL Opportunity"); BMD = crmResp.get("Base
how to fetch records whose list field contains a certain value?
I have a form which contains a multiselect field. Now I want to get all records searching for a value inside that list on form. I tried something like this: records = Form [multiselectlist.contains(input.value)]; But Deluge tells me there's a syntax error. How is right way to do that?
Import Data
Is there any way for a non admin user to import a mass amount of data into a table in creator? The import data that the admins can access works perfectly. However we'd like this function to be usable by a non admin user. The Zoho Migration tool seems like it could be an option, but I get an error when trying to install that on our machines saying that the software is incompatible with the operating system. E-mailing doesn't seem like an option, from what I can tell that only works on I row of data
Missing Grouping & Sorting Link in report settings
All but one of my report settings has a grouping & sorting option. Anyone know why this option would be missing in one report? I need to sort it by date Gill
Time (Duration) Question (Data Entry)
I am contemplating adding a feature to my app that will take from 2-8 time entries and add them up. It is important to note that the times entered are not calendar-related but rather, units of duration in the format "h:nn" What I'm looking at is either a form to store the data entries or perhaps I'll just use an unbound form to perform ad-hoc calculations (addition) of multiple time durations. But what I'm ultimately after is this Does Zoho offer a quick and easy way to enter a time as some spreadsheets
Cannot display a form image in a Page
Hi I have a page wants to display a company details. Name and Logo. so in the form Company Name (Single Line) Company Logo (Image) then in my page I fetch the record MyCompany = Company [ID == "333344343"]; then I look to display the name and the image <p>My Company name: <%=MyCompany.Company_Name%> this works great.. but HOW do I display the logo? Is it something like this? any ideas? I cannot find it in the doco. <p>My Company Logo: <img src="<%=MyCompany.Company_Logo%>" alt="" height="42"
Unsubscribe link to pull in email address
I am creating a form for unsubscribing from daily emails. Is it possible to set the Email field to pull in the email address of the person that clicked the link in the email they received with workflow code?
Search Page
I am trying to add a search function based on the instructions at https://www.zoho.com/creator/help/tutorials/advanced-app-building.html I believe the first part is working as it opens the html page with the word that is typed in the search box e.g. #View:Search?searchword=skills However, I cant get any results to be listed. I have copied the sample code as below; //pass the parameter (searchword) from stateless form (Aistear_Links) //fetch the record from "Aistear" form (Aistear), fields = Category,
how to set filters dynamically to pivot chart
Hi, I've to generate pivot chart based on the value selected on the form. For example, After completing survey, I''ve to show survey report for that particular survey. For this I need to set filter value based on selected survey Id. Can I do it. Thanks for the help, Regards, AppAdmin
Next Page