Create a ZOHO app and host it on AWS?
Is it possible to use Ziho creator to create an App and then host it under windows or Linux so I can use AWS?
Is there any way to insert arbitrary number of rows in a custom module in one click via custom function(s)?
Hi, I have a custom module called Vouchers which holds number of unique alphanumeric voucher codes for an account. The problem for me is sometimes I might have to create more than 100 number of unique vouchers on one click. Now, when I go to add vouchers from Voucher module and choose the account and enter number for vouchers to be created then entered number of unique vouchers should be automatically created. I am not handy in building custom functions at the moment. However, lets say I grab number
Record Count Issue / Usage Details
Went into our usage details this morning and saw that we had 85,000 records of 100,000 available. In order to reduce the number of records, I did a backup and downloaded and exported the application as a file and then proceeded to delete 2 years worth of our oldest orders in the system to see how much this would reduce the record count. After deleting these "orders" and refreshing the usage details, our record count went UP by 10,000 records to 95,000/100,000. It's not possible that we input 10,000
I want to build a Flipbook App.. Could It Be Done?
Hi, My question is... I want to build an app for a magazine.... So I want that app has a Flipbook inside..... But Not in a HTML space that shows a web site inside the app.... I want it lie Native... I don't know if this could be done with ZOHO templates or if it has a plugin that works like an ebook or flipbook native in the app. Thank you for Helping me, and if you have already done an app like this, gimme your link and i will download it ir order to see how does it works!! Thank you Very VERY Much!!
App Missing
I have an app missing. Hauling Tail Rescue
Customer Portal for application with multiple clients/customers
Hello - I'm building an application that will store sensitive data for several large customer companies. We want the customers to be able to login and see reporting/dashboards related to their info, but obviously not see the sensitive information of the other companies. The information will be uploaded by our team, and not by the customers themselves. Is there a way to associate customers to only their related data, so when they access the portal they only see their information? Is it secure to
Creator Page w/ Multiple Charts
Hello - I'm creating a Page in Creator to show multiple charts to customers. It seems that when you embed a chart into the HTML, the charts are full-width and full-height. Is there any way to limit the chart dimensions, and have multiple charts next to each other (in half-page columns) instead of full-size on top of one another? Also, is it possible to make Pages responsive or is this not supported? If anyone has any Page templates that sound similar to this, would love your guidance! Thanks Brian
phone number field
I would like to use a phone number field so when I pull the record up on my cell phone, it will be highlighted and I can click it to dial out. Tried numerous things so far and nothing works
Create Google Drive folder after record is created
I tried using Zapier, but it is not fast enough. Any ideas? I want to create a google drive folder after adding a record. Would i have to use API calls for this?
Open URL does not work after success in calendar view
I am using the calendar view, and I have scripted an openURL after success of a record. In calendar view, if i click on the little edit button or click the record, then the edit button, after success, it does not open the URL. The URL only opens if I'm in list view, not in calendar view (or summary view). Why is this happening? This is the report with edit access: https://app.zohocreator.com/deranged/deranged-entertainment/#Report:Add_New_Event_Report
how to set "OR" operator usig URL criteria for a view?
I need to specify criterias for an embedded view using URL. How can I make the view show records matching the criteria Field_A == Value_1 OR Field_A == Value_2?
COMPOSITE PRIMARY KEY
My form has three fields A,B,C forming a composite key. How do I enforce an "on add" script so mass-loading of data will be filtered: only lines with composite key A+B+C that are unique and not duplicating existing records will be inserted? Thanks! I have researched this before but there seems to be no answer to this questions.
Need to specify "OR" operator when setting criteria for displaying a view
From the docs: To set criteria for a view URL format for setting criteria with "=" (Equal) operator is given below http://creator.zoho.com/<app owner name>/<app name>/#View:<view name>?<FieldName1>=<FieldName1 Value> &<FieldName2>=<FieldName2 Value> This allows for criteria of the form <criteria 1> AND <criteria 2> as I read it. I need the form <criteria 1> OR <criteria 2>. There's other logic operators listed but no OR. Is there some way to use an OR in this situation?
Spreadsheet View with Sub Forms
Is it possible to use the spreadsheet view with a form and a sub-form? We would like to have the cut and past functionality that the spreadsheet view provides with fields in the sub form. If not the spreadsheet view, any other ideas would be appreciated. Thanks
Calendar View First day of week
Cannot find how to change First Day of week to Monday in Calendar type of view. Can anyone suggest?
Sort by returning ID of Lookup Field not Value
Hello, We have a static HTML page (stateless form) that is a report pulling data from multiple forms. a search value is passed from another form to this HTML page. Then we have a variable asset which looks like this: asset = Add_Edit_Assets [Assets_Account_Lookup == search.ID] sort by Assets_Type_Lookup ; Later in the page we have a "For Each" that looks like this: <%for each x in asset { type = Default_Device_Types [ID == x.Assets_Type_Lookup]; manu = Default_Manufacturers
Adding CRM Task from Creator Subform
Hi I am trying to add a Task record to CRM in a Creator Subform when the form action On Success is executed. Its a simple statement x = zoho.crm.create("Tasks", { "Task Owner" : "someone@company.com", "Subject" : "Chase Up" }, 2); This does not work for a subform On Add -- On Success action BUT does work on the main form On Add/On Edit -- On Success action ? Please can you advise why ?
Learn Deluge
Hello, I am having an issue with https://creator.zoho.com/learndeluge/ . Whenever I hit the "execute" button it switches to "executing..." and freezes. The app is able to return errors without freezing. Google developer console reports this error, as well, "Uncaught SyntaxError: Unexpected end of JSON input". This error happens when I hit the execute button. Any help would be much appreciated! Thanks, Tim
Updating Records of a form based on the input of another form.
Hi, I have a form Product that contains the Product Name and and the Available Quantity. This is added through lookup into a subform in another form. I need to update the value of Available items with respect to the Required quantity in the subform. Any idea how to do that, because storing the value in as it is retrieved is not working.
New to Zoho Creator (non-developer), need some help understanding how to build a simple App
Hello Zoho Community Team, I am a non-developer and wanted to assess the viability of someone like me to be able to create applications without any real coding knowledge. I was wondering if someone could help me create a super-simple application, as I have been struggling for a couple of days to create a very simple 3 page app. Essentially I am creating an interview observation Application. I want the screens to essentiallt look like this. Home Page: ---> Client 1 ---> Observations
I need a dialogue box to determine what action to take next
I have a form with a lookup dropdown of 5 fields. If a user selects one particular option from the dropdown I would like a dialogue to appear along the lines of "Would you like to create a new record in [FormName] for this record. If the user selects Yes, another form opens and data is transferred from the one form to the other. If the user selects No, the dropdown in the first for is change to a different pre specified option. I can handle the actions and data transfer, but do not know how to create
getURL and postURL not returning response body for 500 response
I have set up a temporary rest endpoint that returns a 500 error and some json to explain the reason for the 500 error. http://demo3516469.mockable.io/test500 This is common behaviour for many REST APIs to return a 500 error if something is not right and display a reason. The following test function: void testREST() { getRestResponse = getUrl("http://demo3516469.mockable.io/test500",false); postRestResponse = postUrl("http://demo3516469.mockable.io/test500", "{\"test\":\"test\"}",false); info getRestResponse;
Extend Quickbooks Integration
Extend Quickbooks integration by supporting additional modules e.g. Estimate module and enable function for sending forms e.g. invoices etc from Quickbooks via API.
How can I reload a HTML page opened as a dialog?
I have a HTML page with a list report and a stateless form embedded to it. This page is opened in a dialog to show info about the selected record. I wish the HTML page gets reloaded when I click on 'Update' button on stateless form. I already tried openUrl("#Script.page.reload", "same window") and it works if this page is loaded on whole window, but when it's opened as a dialog it reloads parent page. Any tips on how can I achieve this behavior? Using iframes maybe?
sum of values in report
hi! how to make report so that it will show sum of values?
How to read Whole url or Read URL parameters using form script ?
Hello Sir, How to read Whole url or Read URL parameters using form script ? We need url's parameter for parameter value in form.
Build app without forms
Hello, I only want to build a calculator - user enters numbers and page displays results. Zoho only allows me to do this on a form. I do not need to submit a form. Thanks!
Trying to be to clever
I have created a ToDo form and have two other forms, let's call them A and B. Todo's can be either general or specific to either A or B. So what I did was create a subform, first in the A form and then another in the B form. Went to the Todo view added a look field to the A form and another lookup field to B form. No problems with the on the A side but there's something wrong with the B form. On the B form when I click "Update" i get a spinning icon and "please wait" but this never goes away. I get
Help with creating a quote form...(new user)
3/27/17 - Been using Zoho for just over a month and need help with creating a Quote Form: On the Quote form I have 2 lookup fields that both are radio buttons : Field 1: Field 2: When any of the first 3 options in Field 1 are selected and any of the 4 options in Field 2 are selected, I need it to update the Monthly Rate Field on the Quote Form from information on the Storage Rates Form below.
Help! Help!! Help!!! "Unable to send message;Reason:554 5.1.8 Sender Address Blocked"
Hi Everyone / Moderator/ To whom this may concern, My Name is George; This is the 5th message i am sending to request assist from the moderator on my account. I noticed that i have been blocked from sending messages without sending any unwanted or promotional emails whatsoever. Please, Can you help me unblock my email, so i can reach my clients as this is my company email?? Email: info@bbmilleniumllc.com I am counting on your guy to help me resolve this effectively and swiftly, Thanks for your anticipation.
Retrieve data value from different tables all in a new table
Hi, I would like to know if there is a way to retrieve data values from different tables into a single validation page. For example if we have, 3 steps process Step 1: Enter customer data Customer Table CustomerID:001 FirstName: John LastName: Smith with Submit button - data insert in Customer table Step 2: Enter Appointment Appointment Table AppointID:001 CustomerID:001 AppointmentDate: 22/3/2017 AppointmentTime: 10:00 Step 3: Validate Here what I would like is to retrieve all the information from
Lists cannot be compared?
Hi Zoho, I have the following script: ListA = {"A","B","C"}; ListB = {"B","A","C"}; if ListA != ListB {%>Lists Not Equal<%} When trying to save, I get the following error: Error at line number : 7 at column 54 In Criteria left expression is of type STRINGLIST and right expression is of type STRINGLIST and the operator != is not valid This also happen when marking "equal" using double equal sign (==) , but single equal sign (=) is ok. Please fix thanks Ravid
Remove time from date-time formula result; not using .toString()
Dear Friends, I have date-time formula in a form to calculate certain date. Then, I have report (list type) based on this form, where I want to sort all records according to this formula field. The problem is: - To sort by formula field, I have to add this field into the report, and then only I can drag it into Sorting order - Consequently, this field becomes visible and occupy too much space in the report. The problem is that it shows also time stamp, which is meaningless for me, like: 28/03/17
New customers get better pricing than old customers?
We signed up for Creator in November 2016 with 3 users on Enterprise. We have used our 30k limit of records and have had to purchase more. Yet apparently the pricing for NEW Enteprise customers has UNLIMITED records. The support request I have just received, with its ridiculous, sunny, cheerful and inane language telling me blithely I have to spend more money than if I had signed up last week, is as follows: --- Greetings from Zoho Creator team ! The Pricing which you have referred to is the Latest
7 day reminder automated email
Hi Guys I would like to setup up an automated email reminder. The condition would be, if a record had not been updated after 7 days of creation it would send out the remainder email. Any help, would be appreciated greatly. Thanks Chris
dynamically add fields?
is there a way to dynamically add fields to a stateless form? e.g. user selects 3 items from a list (a, b, c from the entire alphabet). then generate two fields per entry, such as: a_method: a_result: b_method: b_result: c_method: c_result: obviously this could be done with show/hide, but for higher numbers of items, using iterations would be easier if it's possible. it would also be helpful to be able to then insert these into another form using iterations.
importing data from zohocrm
Hi i have hit this barrier again. We would like to move some data from zoho crm to creator. We have a field that links this data to a contact and would like to keep that intact on importation. Does anybody know how to do this as all we get is a number
Comma
It's almost a deal breaker for some users that the currency fields do not have commas. When I tell my users I can't do that I look like an idiot. Do I really have to roll my own validation and formatting with text fields? Was it a $100000000 dollar deal or was it a $10000000 deal? There are 90 million good reasons right there for commas. Please add commas. Please. tx, tt
Customer Portal User Groups
I have been told by a customer that in the next couple months they wish to move away from generic accounts per dept into user based accounts. This means that every user will have an account so I'm looking at at least 1500+ users, at first i figured i could use the customer portal of the application but because this doesn't support group creation like the normal global user setup it'll make user management a nightmare. the second option would be to have each user signup for a free account but because
Send Mail with selected Records as attachment
Hi, Is this possible in Creator that I can send a XLS file as a attachment for selected Records only using Sendmail Function ? For instance If I select 10 records in the View and click on Function so it send out those 10 records' details as a XLS format to respective email.. Thanks Arfater
Next Page