date
Hi here :) How can I in term of coding reset the date field For example If ( A >2) { " reset the date at its initial value ( empty field) } thank a lot for your expertise
Button label error: ui.label.done, ui.label.export. How can I Change that?
A wrong label appears in the zoho creator app. Can I change it? Please see the attached screens.
Record Summart Printable Details
Hello i have problem with record summary and subform, showing. Here how it should be And this is what i get How i make it Please tell me how to do that. Thanks.
Report data hidden from view if auto-filter is disabled when an auto-filter is currently selected
Just a head's up for a clearer user experience. If user is viewing a report and selects an auto-filter. Then user goes to the application report settings and disables that auto-filter. Then user reloads the application report. User is no longer able to see report data (presumably due to the report 'saving' the auto-filter as part of the current way of displaying the data). Report should remove auto-filter that have been selected from the user's report view when admin disables the given auto-filter
Can I somehow remove 'old fields' in pivot table view?
If I change "field type" from numerical to decimal in a zoho form, it creates the following "redundant" fields in pivot table report settings (see screenshot). I'm just wondering if it is safe to remove the 'old' numerical fields and if so, how does one remove them? Thanks. Brady
Is there a limit to the number of months that will show in the date auto-filter?
I have data in an application with a date field from Jan-2012 through Feb 2017. Auto-filter by date is enabled. When looking at this filter in my application report, I only see options to filter by month from Jan 2012 - March 2016. Is there a reason for this?
Insert data into a table
Hi, 1) I want when a Sales Order in in Zoho Book is successfully created, this should trigger the insertion of an invoice (invoice data) into invoice table. All the data requuired for invoice will be extracted from Sales Order. 2) Is it possible that a scheduled routine insert a single(Batch) invoice for multiple (uninvoiced)Sales Orders, in order to reduce entries. Regards
Insert data into first column of subform?
Hi I have a form which contains 10 test points, I would like these test points to be loaded into the first column of a subform. Is it possible to enter the information onto 10 separate rows?
Report showing a decimal form field as Single Line.
I have a few fields that are decimals in my application's form but are (I believe) being presented as "single line" or some other field type when I try to create a report. See "Bakery" field - It is a decimal in the form in screenshot 2, but has a "Capital Letter T" next to it in the create a pivot table/chart report field list (screenshot 1). I can't "sum" this field on a pivot table so it seems quite clear that zoho doesn't think it is a decimal field...even though it has decimal content in the
Setting a Field Value based on defined Ranges
I need to set a field value in a table based on a set of aging buckets. For instance. Set Aging Bucket to 1 if Days_Outstanding <=14 Set Aging Bucket to 2 if Days_Outstanding >14 and <=30, Set Aging Bucket to 3 if Days_Outstanding >30 and <=60 Set Aging Bucket to 4 if Days_Outstanding >60 and <=90 Set Aging Bucket to 5 if Days_Outstanding > 90 Can someone help me with how to code this? I need to set it up as a workflow based on the value in the Days_Outstanding formula field. I appreciate it.
How can a field change it's name, depending who is seeing the form?
Hi, I want a field change it's name according who is seeing the form, so let me explain. I have a form and, Depending on who enters to the form, some fields will be displayed and hidden, But one part of the form appears to both equal people, but i need to change the name of "Hospitalizacion PR" to "Hospitalizacion" when Admin1 enters to the form, and if Admin2 enters to the form the field will appear like "Hospitalizacion UG", how can i change it?
Edit/review Email after submiting a record
Hello! Everytime I submit a record, i would like a popup to appear with an email template, that let's me edit/review the template before sending. Im aware that there is a "send mail" script that can send an email immediately after submiting a record. But I would like to be able to edit/review/cancel the email before sending it.
Cannot submit form
Dear Support, My app users are getting a "Permission Denied." message when attempting to submit forms on their iphones. Please help urgently. Best Regards, PARAMPARA
Bugs: Zoho import changing field type from decimal to numerical, pivot table error when processing numerical/decimal field
I thought I resolved all the quirks around zoho creator's import function somehow 'creating' its own decimal data (see this post: https://help.zoho.com/portal/en/community/topic/bug-zoho-import-create-app-from-xls-makes-too-long-a-decimal-from-number#2266000009001481 ), but it appears the issue is still around somehow. In trying to resolve this oddity with pivot table/chart reports: https://help.zoho.com/portal/en/community/topic/report-showing-a-decimal-form-field-as-single-line I decided just to
TOTAL NOOB - How do I create a drop down menu that opens a check mark form?
Hi there! Ok, so here's my wish: I have four brands of wine. Within those four brands there are a whole bunch of different types of wine (Cab Sauv, Merlot, etc). I'd like to be able to select a parent brand via drop down and then have it open the various wines under that label so that I can select them with a check mark box. Hope that makes sense. Really appreciate any help. Cheers!
Record Owner field is not being honored by the Charts
Hi, I have a "New Order" form, in which I designated the "Record Owner" field to be "Owner" instead of "Added User". See the attachment for some sample records and the Record owner setting screenshot. The record was added by andrew.raymond and is now owned by lexshan8. lexshan8's Role is CEO andrew.raymond's Role is COO, which reports to CEO. Therefore, the record should NOT be visible to andrew.raymond. In reality, andrew.raymond is able to see the records. On the other hand, records with Owner=andrew.raymond
Link a record to a record?
Hello! I would like to edit/update a record on edit/success of a form. The record that I want edited/updated, is in the lookup field of the form itself. Below is a picture of the form "ADD". The first field is a lookup field to another form called "Clients1". This is the picture of the form "Clients1" When I click "submit" on the "ADD" form, I want to link the "ADD" form to the client when I see the client in "Clients1" report. Below is a picture of the "Clients1" report. In human language, when
Get value from 2D array of decimal numbers
I am trying to determine if Zoho will work for our company. The only issue I have found so far is whether we can get a specific value from a large two dimensional array of decimal numbers. I have examined the list functions that apply nicely to one dimensional arrays and can imagine some possible ways to use these. My possible ways are very inelegant, however, and I suspect others have found some elegant ways to do this. Barry Sammleton Distilling LLC
Zoho API support InsertRecords by json
Hello! I'm looking at https://www.zoho.com/crm/help/api/insertrecords.html for insert record and it seems that the only way of insert new records to the api as xml. Does this mean that json is not supported as the insert methods of the API? Can anyone please tell me when json format is available to insert the records? Regards, Debasish
Lookup field selection populating the next field
Hi All, I have had a good read through the forums and tried several of the examples but to no avail. I have a form called "Parts_Used", which has several fields that are all lookups to various fields in another form called "Parts_List". I have currently got it working so when I choose a category it only filters the part descriptions under that category and then like wise I have a 3rd field that only shows the part numbers that are relevant to the part description. What I need is that when I have
Still wrong the names of the fields in my pivot charts.
Hi, i communicate with you 'cause the names of the fields in some pivot charts in my application appear like: "Number", "Number2", "Number3" Etc etc etc, and i still have no answer, i ask this since 15 days ago, you response it, but the problem still with us, and we can't create a pivot chart without know what are the names of the fields we need in that chart. Please, we need help for this problem, thanks a lot.
Record summary based on subform
Hello, I would be really thankful if anyone would be able to help me with the following issue. So i am trying to build an invoice creating app which would use data from subform and would result in record summary such as this https://www.zoho.com/creator/help/views/record-summary.html . Each time i try to create a record summary, it displays every item separately on different page. How can i create a table out of a subform with subtotals and totals that would appear in record summary? Thanks
Pull Information From Lead Website
I am updating old leads where information was not input the right way and I am now trying to fill out company accounts. I find myself going to the company websites and finding most of the information like address, phone number and e-mail at the bottom of almost every website or on an about page It would be great if I could give Zoho a company website and then have the basic information auto populated. If it is too hard to have the information found on the company website then give me suggestions
Sharing of Reports
I have an administrator account and an user account for my application. Let's say that in the main account I have a couple of delivery boys. EXAMPLE : Ram, Karan, Arjun, Ritvik. Now I create user accounts for all the delivery boys. Now when I log in from Ram's account(let's say), I want to show the deliveries that are assigned just to him. I have tried restricting visibility and everything. But in Rams account, I can see the deliveries of Karan, Arjun and Ritvik also. Example: List of orders- The
How can i do to share a page?
I want to know how to share a page with some people in my aplication, how can i do it?
Thinking of moving to Zoho
Hi, im looking to develop my app and have come across Zoho Creator, I was looking to see if i could achieve the following with Zoho; can i print a pdf with data for one record and include data from other related forms. to link child records it appears in need to add a form to the parent form or in the child form have a loopup field, is there a way to progmatically link the child records maybe using caseid as a variable? can variables be initialised when selecting a record to be used whilst working
I want to create a multi-column order form for wordpress
I need a production order form for my client. I have an excel spreadsheet and I tried to import it but then it got too tricky. Does anyone have an idea about what I should do?
Zoho Creator and Quickbooks Update Records
I have successfully configured adding a Customer record to QuickBooks from Zoho Creator, but I am now trying to configure updating records in Quickbooks when they are edited in Zoho Creator. I have put in the exact code in the sample on this help page: https://www.zoho.com/creator/help/script/quickbooks-update-record.html and I get an error that the variable 'getResponse' is not defined. Has anyone come upon this issue? In searching for the record to update, I also would like to search for a record
Limit max characters in multi line box
Hi! I would like to limit the max number of character that a user can write in a multi-line box. Is this possible in any way? Cannot find the option when I edit a multi line box.
Web page for many reports, same search parameter ?
Hello I create clinic application, To enable doctor to see all patient's reports like blood lab, radiology, need to add all reports in one web page. I know how to create button in in report to go to another page with search word in this form openUrl("https://creator.zoho.com/" + zoho.adminuser + "/" + zoho.appname + "/" + "#View:Search?searchname=" + input.Name, "Same window"); and add it to web page parameter where parameter will add to search string as a filter. The problem search string in report
Link To File On My Computer
Newbie Here. I want to link to a file on my computer - not on a website. For instance: File Location would be the field. I see where I can link outside but I don't see how to make it link to a file on my computer. Am I missing something. Or is it because it is cloud based?
Formula: Sum amounts entered in lookup field
Hello! I would like a formula to add the sum of all the amounts entered in a lookup field. (The lookup field is within the same form) I have attached pictures that I think would help. Below are all the payment amounts I would like to add. (this is a lookup field to a form) When I click "+ Add New" , this is the form that pops up.
File_Upload using Advanced Rest Client (Google apps)
Hello, I have a File_Upload field on my app in the Creator. When I am tying to upload a file using the Advanced Rest Client (Google App), I can see the status code '200 OK' , but the response is empty. Also, the file does not get uploaded in the database/table. Below are the Name-Value fields that I am passing in the Data Form section of the Advanced Rest Client: authtoken : ************** scope : creatorapi applinkname : rest formname : FormA fieldname : File_upload
How to: Show field if lookup is populated
Hello! I would like a hidden field to show when a lookup field is populated. Another way of thinking about it: I would like a hidden field to show when a lookup field is not null. How do I do this?
Ideas for my form
Hi everybody. I'm trying to make a form to distribute all the biopsies through the pathologist (residents and assistants), and I need to add two fields which I'm not able to find out how. The first field I need is one in which I see the sum of cases of each pathologist for the day, updated every new biopsy is added. The second field is one in each I can see the pathologist who received prostate biopsies in the previous day. Can anyone help me?
Initializing/updating/displaying counter variable
I have a feeling this is simple, but I'm new to Deluge and can't figure it out. I'm taking reservations for an event and want to show the remaining spaces in a disabled field called Spaces_Remaining. How/where do I initialize Spaces_Remaining so that it isn't reset to it's initial value each time On Add>>On Load? Any help would be appreciated. Bryan
Compress attachments?
Hello community, So, I'm creating my first zoho application for a friend who needs to replace an app they currently use. One of the biggest features they need to keep around is their ability to add photographs to records. In some cases they may have 20-30 photographs attached to a client record. These photo's only need to be accessible while the form is in certain status's but once the workflow has been completed and the record is being archived and used for reporting purposes only, those photo's
auto data saving
Hi guys. i have someone building a dance club databas for me with creator and i'm being told that data cannot be saved automatically within a form... when we create an event and open the booking form to add customers/members that dat is not stored unless we click the save button at the bottom every time ... whats happening in live tests are mistakes happen on a busy entrance door and while moving around the database sometimes all the data entered on the night can be lost and its even possible to
email notifications no longer being delivered
We have just moved our site from a Joomla to a Wordpress platform. Staff are no longer consistently receiving email notifications, although we have made no changes to our form, simply copied the same embed codes to the new site . Could there be some kind of conflict or is there some other explanation?
Getting Events associated with an Account record
Hi there, I'm currently getting my feet wet with Zoho Creator and I had a question about its integration with Zoho CRM. I was wondering if it was possible to get the events associated with a Account/Potential/Contact record. I've tried using this function call to no avail: relatedEvents = zoho.crm.getRelatedRecords("Events", "Accounts", accountID); I was wondering what other things I could try, and if this is even possible. Thanks!
Next Page