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
ZoHo Creator Database newby Question
Hello ZoHo Community, Can someone help me out with my first ZoHo Creator Database? I created a database with a form to submit data on a date base. The data entry consists of 4 columns. For example: Date Value1 Value2 Value3 Value4 01-01-2016 10 15 20 10 11-01-2016 20 20 30 50 I would like to calculate the difference in values on a daily base, based on the datevalues in the Date column. Based on the example above the avarage daily
Populating a fillable PDF with zoho data
I see that there was a question like this about 5 years ago. Is there such a function already
How to update the status of an item in a report
Hi everyone, I'm new to Creator and struggling to figure out the following: I have an order form that my sales person uses to enter orders taken over the phone. Typically an order has several items which he can add to the order by selecting from a dropdown that uses a lookup to pull from a master list. I have created a report that shows my procurement person each of the items in the order so that he can pull them from the shelf. At the item level there are details about where it can found in our
Replicate Xero
I am looking for someone to help me with the design a system within Zoho Support via Zoho creator to replicate the below modules: Book Keeping: https://www.xero.com/uk/ Property management: http://www.arthuronline.co.uk Anyone looking for work and can deivery this please let me know.
Adobe Echosign Links not saving in Rich Text Fields?
Normally the URL that is inserted as a link in a rich text field works fine; i.e. they can be inserted, they save during update and are available in the rich text. However, Adobe echosign links sometimes fail. They get inserted fine, but on updating the field the link gets converted to straight text and only the description text remains.I tried converting the dash and underscore characters per other threads but did not work. Is there a known issue with echosign links in Creator? Link Example working:
Using parent form as a subform in another form but not create a record in back-end
Hi I have a form A which is a subform of Form B. I am using Form A only to fetch records into form B and hence i dont want a record to be created in Form A table when i create a record in Form B. Is there a way around it? As i understand a sub-form will create a record in the back-end and we cant change it. But can we find a way around it so that i can still fetch records from Form A to Form B and not create a record in Form A. I cant use the normal Fetch records because Form A is fetching data from
Getting an error "Invalid entries found. Please correct and submit again."
I already allowed edit access to the support team. To reproduce the error: https://creator.zoho.com/lexshan1/production-manager#Form:Order_form Select the "test customer" and fill int he Address 1 line, click "Submit" I'm still under trial period, if i don't get this issue resolved, there is no way I'll upgrade it.
Auto populate user name in field
I'm kinda new at this and I need to figure out how to auto populate a field with the user name that is currently logged in. There is a mandatory 'Created By' field for all notes, but I want it to autopopulate with the user name that is logged in and adding the note instead of having to choose from a list of users.
Form Field Not Showing up in Lookup
Why is a field on my form not available in the Lookup function when trying to create a relationship with another form?
Update a field based on user input
Is it possible to have a field update as soon as any other field is edited. For example i have a grand total field how do i make it update as soon as any other field is touched for example if i change the product then it will update or when i change the discount it will update.
Multi-Select to fetch prices and apply them to a total.
Okay let me try and explain this the best I can. So currently i have a product table with all my products name and prices. I have also set up a Order form for when orders come in. On the orders form i have a multiselect box so i can select all the products the customer has ordered. Is it possible for when i select the products it pulls the prices and applies them to the total. Example if i select product 1 (£10) and product 5 (£2) from the multi select the total would be £12 on my order form etc.
Record Summary - Customize layout for subform items?
Hello again. I am fairly close to getting my record summary to look how I want it to look, but there's still one other thing I can't quite figure out how to do... My record summary is for a form (Form A) that has a multiselect lookup field. The other form (Form B) which the lookup is connected to contains a multiline text field which I use to store the data I want to show as one long string of HTML code. In the record summary, I added the multiselect field from Form A and select only the big text
Next Page