Post, Open, Invoke URL issues on iOS and Android
I have an Epson TM-T88VI thermal POS receipt printer. It has an Android and iOS app, TM Assistant, that takes takes an XML string from an HTTP post and sends it to the printer. It works fine it I just type these commands into the web browser, Safari. But I am unable to automate the process with Deluge in Zoho Creator. I have tried postUrl, openUrl, and invokeUrl, but they all give different errors. Here is the command I type it into Safari: tmprintassistant://tmprintassistant.epson.com/print?ver=1&data-type=eposprintxml&data=<epos-print><text>HelloWorld</text><feed/><feed/><feed/><cut/></epos-print>
Invoke URL - does it exist?
@Support: I have come across this: https://www.zoho.com/creator/newhelp/script/deluge-invoke-url.html in the help documentation, however when I try to use it I get an error. Thanks, Damien bcCloudTech
Enabling invoice payment in Zoho Creator
Hi, I am trying to execute the following: Generate invoice > add payment button to the invoice with a Forte payment Gateway (already configured) > email invoice to a customer > customer pays directly through the invoice. I know how to create the invoice and populate the customer information. Im having difficulty integrating the payment function into the invoice so that it can be sent as an email. A tutorial or series of steps on how to do this would be fine. Thank you
How do I fetch data from two forms into a third form?
I'm new to creator and am setting up forms for a seed bank. I have three forms:Collection, Storage, and Withdraws. On the Withdraws form I want to fetch data from both Collection and Storage forms based on the user input in a lookupfield with unique values (this field is on all three forms). I set up the Storage form to fetch specific fields from the Collection form, and thought I could just daisy chain and fetch all the necessary fields for the Withdraws form from the Storage form, but it doesn't
Weather API function
Hi All, I am looking at creating a function for a historical weather api. I have not had much programming skills in relation to html, JSON, etc. I was looking to have a date and use the added location or IP address in a form from that date to then bring up a small weather report. (Temp, Wind Speed & Wind Direction) I have looked and can only find a previous topic from 6 years ago. Is there anything updated or has anyone got any experience in this that they can help? Dave
Deluge Script Syntax Problems
I am creating my first Zoho function (but I am not a programmer!). I've been trying to copy examples in the documentation. I've hit some problems with syntax. The function is triggered when a ticket is created in Desk from an incoming email with a certain subject. What I aim to do is to create an activity record, scheduling a call for the next day. The call is to be associated with the Lead and the owner of the lead. Issue 1 ---------- In order to get the Lead Id, I've been trying to get it using
Last 5 yeard addresses...
Hey community, We have to create a script to compleate the addresses the users had in the last 5 years and I wonder if there is any delug scrip premade for that.
Form Layout Options - Beyond "1 Columns or 2"?
I admire what you've achieved with Zoho Creator, and would like to become a regular developer on this platform. However, I'm finding the Form layout and design options far too limiting. I need to be able to create forms which: use more than 2 columns group fields into sections Here's an example of the kind of layout I want to get closer to creating. Is there a way to create multi-column layouts in Zoho Creator, beyond 2 columns? Is there a way to add lines, boxes and sections to forms, to
Comments / Notes section on a record - How would this be done? Is there any Easy way of doing it?
Hi guys, this is my first post on here so sorry if i miss out any crucial information. I have been learning creator while building a project management system of sorts for my design and print department. We currently use a custom module on CRM to make work order tickets but with Creator we can really refine the system and design it around our needs. One big feature I'm looking to add is something we currently use that is designed in CRM, this is the notes section at the bottom, as shown in the image
Excel Processing
Hi, I currently use Zoho creator along with Zoho Analytics to have an application that i can import sales data into. I import the data as CVS. Before I import the CVS file I need to process the data to have all my clients information in one file. To do this I download a report weekly for a 10 clients (the data is a CSV but I've been saving it to a XLSX). Then I run a macro which uses an append query to add the data to a master table. And there it fell over. Turns out the downloaded report is dynamic
Structured data field info not being returned by the REST API
I'm using the Zoho Creator REST api to get some data stored in a form which uses the Name and Address Fields, but these values are being returned as plain strings so there is no way to know which part of the string is the First Name, Last Name, Address Line 1, Address Line 2 etc.
Custom button with drop down
I have a dashboard wherein i have created a Confirm button and what i want when i click on Confirm button, it gives me 4 option - Approve, Reject, Pending and on Hold.
Tip 17: How to add an image to the pop-up that appears on successful form submissions.
Hello folks, In Zoho Creator, any time you submit a form or add a new entry to a form, a window appears with the message—"Data Added Successfully". It's the default message shown to all users for all forms that you create on Zoho Creator. In this tip, we'll show you how to add an image along with that default message. Using a Page to add the HTML script Step 1 First, let's create a dummy form and upload the image we want to display in the pop-up window. Now go to the report, right click on the
.get() giving error: 'TEXT' can not be cast to '[BIGINT]' for the function 'get'
so_products = sales_order.get("Product_Details"); info so_products; prints: {"product":{"Product_Code":"VOT-700400-2","Currency":"TWD","name":"VOITAIR VA 400 BLACK no base (黑芳香機.無腳架) / VOT-700400-2","id":"1839893000000212252"},"quantity":1,"Discount":0,"total_after_discount":82000,"net_total":82000,"book":null,"Tax":0,"list_price":82000,"unit_price":82000,"quantity_in_stock":-1,"total":82000,"id":"1839893000009394337","product_description":"VOITAIR VA400 divers (黑芳香機.無腳架)","line_tax":[]},{"product":{"Product_Code":"VOT-122900-821","Currency":"TWD","name":"Scent
Attaching uploaded file in the email
Hi, I would like to know how to attach an uploaded file in the email notification.
Can I send field data to an external website? Can I have data from that website populate back into Zoho?
Short Question: Can I have a triggered procedure that would take the VIN of the car entered into a VIN field in Zoho sent to an external website? Can returned data from that website populate additional fields in the Zoho app? More details on Use Case: We use multiple external websites that need the VIN of a vehicle to do a search for data. I want to enter that VIN into the Zoho app and then trigger a procedure that would go out to these sites and submit that VIN and retrieve data. www.decodethis.com -This
REST API file upload seems to fail if the field name is too long
I tried uploading a file of about 1.7 MB to a field using the Zoho REST API, specifically to the URL to https://creator.zoho.eu/api/xml/fileupload/ but I got back the error {"code":2945,"message":"MORE_THAN_MAX_LENGTH"} which is a JSON response, interesting. I was able to fix the problem by renaming the filed, it seems that if the field name is too long then the upload files which is a bit of a cryptic error message. The original field name was Financial_Information_Please_upload_your_certified_lease_agreement
Integrate Zoho Creator with SAP C4C
Is this possible? Creating custom-built forms to enter data, then pushing it to C4C or vice versa.
Null Error while Importing data from .xlsx file
There is an excel report which contains Form data ,the form also includes a subform.When I do an import from my .xlsx file without this subform field , data is imported successfully but when subform field is also included it gives Null Error.
Timezone synchronization
Hello, I have a problem. On the desk platform I set the "Rome" time zone. When I read the task the creator app does not have the same time zone as the zoho desk. I set the time zone correctly on both sides:
Zoho Creator - search bar
I have created a page in my creator App. The page includes a search bar and a report. I want the results to appear on the same page and have followed all of the prompts e.g. adding a parameter. For some reason, the search field doesn't work. The report has a loading animation as if it's loading search results but nothing is filtered. What am i doing wrong?
Importing Image field
is there any tool for importing multiple images at once?
Need help with Date-Time math
I need to subtract N days from a Date-Time string THEN set the time to 07:00:00 This works correctly, but I do not know to remove the Time portion and append the fixed time of 07:00:00 o the result and assign it to the startdate variable. startdate = startdate.toTime("yyyy-MM-dd'T'HH:mm:ss").subDay(56).toString("yyyy-MM-dd HH:mm:ss");
Calrification of zohocreator.exe import functionality
The Add or Update command for data imports using zohocreator.exe is described as follows ------------- Add Or Update zohocreator.exe <filepath> <username> <password> -e <appname> -au <formname> <fieldname> <columnname> Eg : zohocreator.exe c:\myfolder\ordermanagement.csv john mypassword -e order-management -au order_form Items Products ------------ Pls provide a quick summary of how this works as the command is unclear - would like to update a Products table with addition of new records (but only
zohocreator.exe
Need Help with zoho migration through console mode Add Or Update zohocreator.exe <filepath> <username> <password> -e <appname> -au <formname> <fieldname> <columnname> Eg : zohocreator.exe c:\myfolder\ordermanagement.csv john mypassword -e order-management -au order_form Items Products I have created the following .bat zohocreator.exe G:\Filing Cabinet\_PAYROLL\time card import files\JobNumber_auto.csv username password -e Time Card -au Jobs Job_Number Job_Number No records are added or updated when
Calculate TOTAL Daily Average - Aggregate Formula
Need to run a formula for output of Average Total Daily Revenue confined to a given month. A general example looks like this: Today is November 12, 2019, from November 1, 2019 to November 12, 2019 Busness A collected $98,000.00 in Revenue - Revenue (98,000) / Day of Month (12) = $8,166.67. Problem: Initially I had the "Date" field on the X-Axis set to Distinct Count, with the following Aggregate formula: sum("Add Revenue"."Amount")/Distinctcount("Add Revenue"."Date") The issue here is that if
How to dereference an embedded value
How to i further derefence this to extract only the account name and ignore the ID? accountName = DealDetails.get("Account_Name")
Fetching one Subform data into another Subform
Hello, I am trying to fetch data of one Subform's data to another using a Number field (Inward_No.) But i encountered an error. Please someone help me in solving this. Following is the Code: And following is the error i encountered.
attachments
Hello, I have a problem. task I can't attach photos to mine. why? gives me this error: Error Error details: Error at on submit script. Note: We are working on giving more meaningful error messages on script failures. This is the string I created: zoho.desk.createRelatedRecord(20067793560,"attachments","tasks",input.taskid.toLong(),{"file:":input.Allegati},"ZohoDesk"); I also created this string that works: zoho.desk.createRelatedRecord(20067793560,"timeEntry","tasks",input.taskid.toLong(),recordValue,"ZohoDesk");
InteGreat 1: Integrate Zoho Creator with Zoho CRM
Hi everyone, Today, we'll look at how to integrate your Zoho Creator application with Zoho CRM. As you might already know, we offer pre-built integrations that you can use to integrate with most of our Zoho products and other third-party services. So that, you don't have to spend a lot of time writing code to integrate them. Also, you always have the option to use REST API to connect all your favorite apps, if you don't find a pre-built integration defined for it. Understanding the Integration field:
Print Status
Hey Everyone, Curious to know if anyone knows how to retrieve "print status" of a single record? Setup Example: Form has "Status" radio button with "Printed" and "Not Printed" as two options. By default, upon form submission, "Status" is set to "Not Printed". Usage Example: Add new data to blank form and submit > go to form records > select record to "Print as Summary" > "Status" changed to "Printed" I can easily manage the deluge script for altering the status (I think lol), but can't figure out
Zoho Creator - Fire notification after approval if end date has passed
Hi All, I'm new to creator and could use a hand solving, what i suspect to be, a very simple issue. I have two fields: Start and End (date and time fields) On approval I need to fire a notification if the end date has passed Attempted this: And this (which errors at line 1) if input.end =< zoho.currentdate; { sendmail [ from: me@zoho.com to: you@zoho.com cc: <cc> bcc: <bcc> reply to: <reply_to_address> subject: please fire message: please fire content type: <content_type> attachments:
Calculating Mortgage payment
For some reason I am getting an error when trying to run this Deluge script. Any help is appreciated. I am sure I am missing something! if (input.Listing_price != null) { input.Monthly_Mortgage = input.Loan_Amount [(input.Annual_Interest_Rate/12)(1+(input.Annual_Interest_Rate/12)^(input.Length_of_Mortgage*12)/((1+(input.Annual_Interest_Rate/12))^(input.Length_of_Mortgage*12))-1)]; } else { alert "Enter in Listing price to calculate mortgage information."; }
Creator new builder is missing the "day of week" selection at custom schedule
From the new Creator builder is missing the "day of week" selection at custom schedule. In the old builder if I set a custom schedule to run weekly I was able to select the day of the week when the schedule to run. In the new schedule if I set a customer schedule to run weekly the "day of week" field is missing:
New to zoho creator
Hi, I am a php developper and very very new to zoho creator. As i am very new to zoho creator i really need your help. i have 2 questions. we have 250 employees working in shift base. three shifts. first shift from 5 am to 1 pm. second shift from 2 pm to 9 pm. third shift from 9 pm to 5 am. we will provide zoho creator installed android device to our employees. so that when they start work they have to connect with thier "id & pwd". when then finish they must "logout". so that we can allot the same
Alternative to Migration Tool
Does the community know of any alternatives to the Migration Tool, especially for updating existing records? We have for three days not been able to use the tool due to an unspecified error. So far Zoho Support have not been able to identify the error. I am also thinking, that MacOS users do not have the option to use the Migration Tool either, so maybe there is an alternative method available?
Conditional Formatting for a custom Record Summary
I have created a custom record summary for a report. I want the conditional formatting from the report to work on the record summary as well. I know it is possible because it works on the default template. Can anyone help me to get it working for my custom record summary. Thank you very much in advance :)
How to show time in a field without date ?
I want to show time in my field but it will be without the date . How can I do this? Thanks in advance.
Manage Territories in Zoho Creator
Hello, I want to manage territories and it's related permissions in Zoho creator app? I didn't find anything related to that. Is this feature available? if not, what is it's workaround? Thanks Rabia
Do Buttons Added to a Report Not Show in the Mobile App views?
Greetings, I'm trying to add a link in a report detail view that takes the user to another form/page. I tried using the Add Button field to create a custom action to redirect the user to the desired form/page via the OpenURL function, but the button is only appearing in the Web views. It does not show in the mobile app views (phone or tablet). Does anyone know if it's possible to add a button to a report view for the mobile views? As an alternative I tried adding an admin only URL field to form
Next Page