Pass File_upload field as function parameter
Hi, I can't pass a File_upload field as function parameter. I need it to do the proposed workaround to preview a file: https://help.zoho.com/portal/en/community/topic/how-to-open-a-pdf-file-of-a-view-in-preview-mode Why is it not working? I activate the function through a custom function button found in a report. The File_upload field is shown in the report, but I can't select it as a function parameter. Thank you for your help!
Sorting records by date on a subform
I have a subform sitting on the mainform. I have a fetch record deluge script. Two issues. First issue, I cannot do a sort on the records on the form unlike reports. Second, the records pulled up on the subform are duplicated atleast twice. Below is my deluge: fet = All_Table_Donations[Fk_Sponsor_ID == input.Child_Name.Sponsor_ID]; input.Sponsor_ID = input.Child_Name; input.Birth_Date = input.Child_Name.Birth_Date; input.Sponsor = input.Child_Name.Sponsor; input.Surname = input.Child_Name.Surname;
Workflow on form validation
I've added a workflow to extend my validation but it doesn't work. I have no idea why it is not working: Steps I've taken: Add workflow Select form to apply workflow on In my case I want to apply the workflow on Create and Edit And the next step is my line of code. But when I submit the form with one of the selected values, nothing happens, I don't get any alert. Not even when I just add an alert on top of my file so I am stuck on this. Please help me if(input.CompanyType.Name == "reseller" || input.CompanyType.Name
Iframe opened by OpenURL stopped working
Hi, I invoke an iframe into a HTML snippet in my Page using openURL. I created this workflow a few hours ago, it worked for a time and now is giving me this error: I invoke the OpenURL through a custom action. Here is the code: My pages are published: Also, when I invoke the same report within an iframe, it works. I use the following code: Please help! Also, I have a question: is it possible to filter a report by filtering a multi-select lookup with ID? For example: Url/Multi-Select_Lookup_Field
How can I get value from another form based on multiple user input values
Hi all, I have 2 forms, Material Cost and Quotation forms. I would like to fetch selling price from Material Cost, which 4 user inputs need to be matched. e.g. selling price is based on Material, T, W, L all 4 fields in Material Cost are drop down fields. Please see screenshot in "Material Cost Form" Here in Quotation form, I have Material - lookup field T, W, L - decimal field Please see screenshot in "Quotation Form" How can i fetch the selling price? Thanks in advance Mien
Creating a New Record, can I retrieve URL parameter?
I have a report that is filtered using a URL variable, like this: https://app.zohocreator.com/xxx/xxx/#Report:PlanReport?PlansID=3918399000000852003 When I click the "add" button from the report header, I want the new record form to open and populate the Plans field in the form with the PlansID parameter in the URL. How do I retrieve the parameter in an On Load Deluge script (to pass into the field)?
Matching Products to Deal Requests
Dear All, Use case: Real Estate agent I want to have a button on my Products page that when clicked opens a 'Matching' page that lists all the potential customers that may be interested i.e. matches on the price field, no. of bedrooms, neighbourhood etc. I then want to be able to select those I wish to email with Product brochure. Can someone describe the bones/structure of this configuration? Would it be creating a 'Matching' module, running a report on the search criteria? Would this all be done
I need to insert 300 records to a zoho creator report
I am trying to insert 300 records, but I get the following error 414 Request-URI Too Large, but if I send 2 registers everything goes well . How can I insert the 300 records into the report? I share my code. //Two Records $data_xml = "<ZohoCreator> <applicationlist> <application name='zoho-cdr'> <formlist> <form name='Formulario_Carga_Inicial'> <add> <field name='ID_CDR'> <value>1213</value>
How to check the dropdown selected value is null or not.
How to check the dropdown selected value is null or not. Iam using the following code , if(input.dropdown!=null && input.dropdown!=""),But this is not working for me. EX;if(input.dropdown=="Some value") show "Some value" else if(input.dropdown=="--select--") hide "--Select--";//i need to hide the "Some value" but that is not happening. Please suggest any solution.
autofill lookup field in subform
Thanks for any help on this. I have created two forms/tables: property and building. building is child of property and has a lookup field of 'property name' in property table. I added a subform building to property mainfrom. My goal is: 1. when user edit an existing property, all the buildings associated with the property through the lookup field will be shown in the subform of the property. 2. when user add new building to an existing property, 'property name' is automatically filled in the subform
Using localized letters in Creator Forms
Hey, I´m facing the issue that my employees can´t use the german letters : Ä, ä, Ö, ö, Ü, ü and ß in my Creator Forms from the keyboard. They are getting a constant error message. Is there any solution for this problem, so that the Forms are accepting that specific letters?
Multi-Select Data in Charts - How to?
Hi - I have a simple asset library (1k records) where I track things like asset type, and date. There are some fields that are multi-select (like which product an asset relates to, it can be more than one). How do I graph multi-select fields? This is a critical feature for my app.
passing parameters on embedded forms and reports
hi i have 2 forms and a report embedded on my website and i want to pass parameters between them. i was able to do it on zoho platform by writing open url script on the first form to call the report and then writing a custom action function on the report to call the second form but unable to do it after embedding them to my website. thank you for your help.
1:n relation between forms and data assignment
Hello together, At the moment, I have three forms: Form: New Contact Form: New Car Form: New Car Rating In the 'New Contact' form I can create a car by subform 'New Car', so the created Car should be assigned to the Contact. In the 'New Car Rating' form I can choose a Contact by lookup-field. And now, I need a dropdown-field for choosing only the cars which are assigned to the choosen contact. I hope everybody understand my problem. In summary, I need a 1:N relation between Contact and Cars and a
Email Notifications Blocked! Need help ASAP
Hi I have been trying to address an issue for a month now and I need a resolution. One of my clients is not able to receive email notifications sent through Zoho. This means there is no way to invite them to use the application, and they can not receive email notifications when a record is submitted. The company has whitelisted the Zoho Creator domain as well as a number of IPs provided to me to give to the IT department. The IT person for my client asked if the server was located outside of the
How do I fetch a specific record from Zoho Creator?
Hi, Since I couldn't pull all contacts from Zoho Books to Creator, I decided to create two lists and keep them in sync. Among other things, keeping them in sync means if a contact is updated in Zoho Books, the corresponding contact should be updated in Zoho Creator. But before I can update the record in Creator, I need to first fetch the correct record. So after digging through the available documentation, I came up with the following script. contact = customer.get("contact_name"); booksID = customer.get("contact_id");
Widget Frame Size
I've created a widget for my app but the frame that it sits in doesn't fill the page. In the Page Builder widget height is set to auto. This seems to set the height to 700px If i change this and specify a height then this changes the frame size but I don't want to specify a fixed height, i just want it to be 100% of the container Is this a glitch or am I stuck with this?
Attach a Template from a Creator Form in CRM?
How can I attach a PDF Template to my CRM? I found this line of code: "<variable> = zoho.crm.attachFile (<module>, <record_id>, <file_object>, <connection>);" But I don't know how I can get the requested variables through DELUGE.
Batch edit doesn't run workflow
I have a workflow that looks for a status change on a form (when form is created or edited) This works fine, but if I edit several rows by selecting them in the report and then editing a single field for all selected entries, the workflow doesn't fire (or perhaps fires for only the first record in the list). Is there a way around this?
Display Record Summary Inside of the Form
How can I easily display a record summary, record detail inside of a form. Example: I have an order form. If the order form is a split order, then I want it to show a previous order (un-editable). I have the logic of finding the previous order, I just need to display it. Possible Solutions: I could create a stateless form and then have the form populated. Thats a lot of work to just show a record. Use the notes field and fetch the data and populate with HTML. This also is a lot of work since Zoho
Bug: iOS app consistently crashing on image load
I’ve created an application that calls (multiple) images to be displayed in a Notes field. Works fine on pc, but the iOS app consistently crashes upon the first load of the form once a new image has been added. Subsequent loads (when the images have been saved in cache??) of the same form load ok. Please support.....
How to get data from this API response
Hello, I'm having trouble figuring out how to read this response. The result posted below is saved on a variable called response. <?xml version="1.0" encoding="utf-8"?> <string xmlns="http://www.ventamovil.com.mx/ws/">{"Confirmation":"24","Description":"RECARGA EN ESPERA","Folio":"000000","Folio_Carrier":"000000","Notice":"Feliz navidad 2019","Balance":"0","transaction_date":"23/06/2020 17:44:33","productVersion":"21"}</string> I want to get the data between {} I tried this but got null: info response.get("Confirmation");
Javascript Variable Scope
Hello Guys, I am trying to get the value of the variable "mthitems" out the function defined to retrieve the record data and run the for loop as shown below. But somehow it does not return me any value for the variable in the console if I print the values outside of the function, but inside the function when i try to it does return the proper values. Can someone help? mtconfig = { reportName: 'Match_Stats_View', criteria: 'Parent_Season==' + ssitem.ID, } var mthtitems = ''; let mtdet = ZOHO.CREATOR.API.getAllRecords(mtconfig).then(function(mtrecords)
Zapier Integration to Creator
Hi, now after few months creator V1 API will be decrypted. & New API needs auth token and it will valid 1 hr. every request we need to validate that token so on. But now, for automation tools, such as Zapier or Zoho flow Used old base authentication Token now they are automated tool then How We can do for As per New API V2 base?
Does Zoho Creator support Arabic Language on the User Interface?
Does Zoho Creator have inbuilt support for the Arabic - where the form labels would display on the right, the text box cursor would move from right to left as Arabic Data is entered? See sample Gmail login page with my Browser language set to Arabic (Saudi Arabia) [ar-SA]:
It is possible to call Zoho creator custom function by using Rest API or by URL
Hi Guys, I need to call a zoho creator function for every 20 minutes in a day. In zoho, it is not possible to schedule task for 20 minutes. So i thought of calling function by Rest API or by URL. Guy please help me to achieve this task. Thank you in advance.
How to make pop up form dependent on subform row user entry
I currently have a product selection on my user form which has two options (box of 12 and box of 6). When one of these is selected I have a pop up form appear which relates to the option selected by the user, triggered when they select the product. However, when a new row is added to the subform and another product selected, the subform only looks at the first row to determine which pop up form to load, not the current row that the product is being selected for. How do I make the subform check for
Can I show multiple Subform entries into a Kanban quickview report?
I was wondering if it is possible to show multiple Subform entries into a Kanban quick view report? Or any quick view for that matter. I have a report that shows fields from a subform. Let's call it an order with rows of products. In the quick view, I can select the Products subform to show, but it only shows the first product. How can I get it to show ALL the products? Thanks!
Using Zoho as a developer
Hello, I've set up a small system under my Premium license for Internal use. Since there are only 4 of us, this works fine with me using the 'user' license and then my colleagues as contributors. I think that there are several customers for whom we could develop applications but our customers are mostly small or micro business. They would typically have 5-10 people accessing the application. I'm trying to get my head around the pricing model for this sort of situation. Using a 5 user site as an
Zoho Creator App
Opinion on Creator APP Design and Customization So I have created a Sites Form: site_name, site_address etc... Next I Created a Site Stops Form: (Lookup Field: site_name) and SubForm to allow adding tour stops I created a Check-in Form to allow the tour guide to check in. They specify the (Lookup: site_name) and date/time is automatically filled in with current date/time. I created a form called Tour: where I have some fields that they must fill in like how_many_ppl and notes and few others.... Once
Update records that meet criteria
I'm trying to create a schedule to update records daily that meet criteria. My deluge code looks like this: for each oldTruck in Enter_Tank_Inventory[Latest_Record = true && Warehouse = "T13"] { oldTruck.Latest_Record=false; } But I keep getting this error: left expression is of type BIGINT and right expression is of type STRING and the operator = is not valid How do I get the warehouse value of T13 in the criteria?
Error Code 2945 , PATTERN_NOT_MATCHED
Hi, I am trying out Zoho Creator API. However, I always get the following <response> <code>2945</code> <message>PATTERN_NOT_MATCHED</message> </response> However, error code list error as Invalid Ticket. I do not know what is wrong.
Open Form with Parameters from a page
I have got a page, Added a button Action is to open a form. I want the Email field to be populated with zoho.loginuserid Wondering if I can pass that on with the "Query Parameters" under the action tab. If so just wondering what to type in there. See attached screenshot
Upload file API
I am having a really hard time with the Zoho Creator Upload API. I am trying to upload a pdf file from google drive using the following google app script. I keep getting the following error message {"code":2945,"message":"LESS_THAN_MIN_OCCURANCE"}. Any insight would be very much appreciated. Code: var theFile = { 'file' : DriveApp.getFileById(fld.fileID).getBlob().getAs('application/pdf') }; var formData = { 'authtoken' : 'xxxxxxxxxxxxxxxxxxxxxxxxxxx', 'recordID' : 'xxxxxxxxxxxxxxxxxxxxxx',
App for recording delivery of consignment of blood products
Hi everyone I've recently taken on the role providing technical support to a charity here in the UK. We provide emergency out of hours transportation of blood, platelets, human milk etc. for the health service here in the UK. We have a Zoho Creator app that our controllers use to log a call from a hospital, assign it to a blood biker, and record collection and delivery details etc. Currently our blood biker has to fill out a paper receipt and request a signature from the person receiving the
How to post data from a web page to Zoho database with no network!?
Firstly, an apology - after much reading I'm not even sure I have the right forum. I was looking for the forum relating to the Zoho database our charity uses - I think it's Creator? But all the docs talk about Creator being an app platform, not a DB, so I'm not sure. Apologies if I'm in the wrong place. Secondly, we're looking at how to allow our mobile end users to submit data to the database when they have no network. Yes, I know, bear with me... We're considering a few options but one of them
Bulk Edit a Log
Hi I saw this post and want to know if this feature can be done using bulk edit? I have a courier company and want to update the status of multiple packages at the same time? It started as a simple long text field "Notes Log", and then we added a feature that: User enters new text in a separate field "Add Note". Upon submit, scripting prepends what they just entered at the top of the "Notes Log" field, AND it automatically adds the current date (we decided against date/time), and a visual divider
Comparing string values
Hi Does anybody know how to compare string values such as if string1 begins "s" { list = list + String1 }
'Application' vs. 'Solution' in Zoho Creator Developer Zone?
1. What is the difference between building an 'Application' and a 'Solution' in Zoho Creator Developer Zone? 2. I want to build an app and have customers subscribe to my app rather than sell the app to them. What is best for me? 3. Is there a way for a client to subscribe to my software and for them to add their own users like you would using any other software out there? I really like the Zoho Creator platform but I have no idea how to get my app to market in an effective way..
Triggering an 'On input' script for existing records
Hi, I have a form with some simple automation whereby editing one field dictates the input of another. This was achieved using an 'On input' deluge workflow. However, I only built this flow after having created many records. How can I trigger this script for the ALL of the existing records. I believe it can be achieved with a function but I'm not sure where to start. Any help would be much appreciated.
Next Page