Does this App already exist?
Does Zoho have a pre-made app that I can organize the following information. Group One Client Info Name, address, etc. Group Two Seller/storefront info Name, links, notes Be able to link a seller to a particular client Group Three Business/individual info, notes, attachments Then be able to link a client to individual sellers for example where a client is monitoring 30 different sellers, it would show a list of those sellers under the client name, or where a different client is monitoring the same
Does anyone know how Pricing Plans and Users works?
First off, I just want to say I asked Zoho Support directly if they could help, and I didn't get a useful response. So I'm asking here. I am trying to set up my Pricing Plans for my SaaS solution I'm creating in Zoho Developer. This may sound dumb, but I really can't figure it out. Let's say I have an SaaS app. I want the monthly cost to be $80 a month for 5 users up-front. And I want to give them the option to add additional users for $10 each. Can I do something like this?
Fetching data from other app
Hi I've been trying to fetch address information from a client database in one app into another app. I understand the normal way within one app doesn't work. I've already found a few responses on the forum but none seems to work. I understand I create a function in app 1 and call on it in app 2. For now I'm using in app 1 forthe function the following code: string GetClientInfo(int varID) { fetaddress = Nuevo_Cliente[ID == input.varID]; return fetaddress.Direcci_n_Cliente; } In app 2 I call on
Best method to search for a customer using CRM - Creator integration
Hi, I'm working on an app that makes use of the Creator/CRM integration. Since you can only access one field at a time using the Integration field type, I'm trying to find the best way to do a customer search. For example, if I choose Last Name as the Integration field, then you could have a dozen customers with the same last name and no way to see which is the one you are looking for. Any advice? Thanks, David
insert data into two forms from stateless form- script doesn't work
I initially created this script for a stateless form to generate a unique accession number based on the current year and then insert the data into a normal form (Master_Nursery_Database). The first two portions of the code work fine. This script executes on submit. Recently I wanted to also record the data in a second normal form (Master_Database), but when I add another 'insert into' script it doesn't work. What do I need to add to get it to input data into the second form? I've included the whole
How do I make a check for an existing record Not case sensetive
If I'm checking to see if a record trying to be entered already exists, how do I make ignore the case? The code below works for checking my records, but if a user doesn't capitalize their entry, it gets added to the table/form. if (count(Region[RegionName == input.New_Region]) > 0) { alert(("This Region already exists, please select from the list above")); input.New_Region = ""; }
POST to Popular Web Services
There's lots of discussion of late about posting data to external applications. https://help.zoho.com/portal/en/community/topic/http-headers-when-using-zoho-creator I think it would be great if ZOHO, or community members, provided some cookbook examples for users (like me!) to follow for popular web services (Google, Twitter, Facebook, Foursquare, and such). One I'm really interested in is posting calendar data to Google Calendar. While the ZOHO iCal feed is handy, Google Cal does not sync the feeds
Calculation in subform
Hi everyone. I have my subform as with an struture of a product, and I need to calculate in this way: Inside of the form "MODELOS" I have subform "ESTRUTURA" That means that I have a field "Consumo_Unit" that means consume, and I have a field "Custo" that is the total cost, and I also have a field with name "Custo_Unit1" this mean that I need this calculation: "Consumo_Unit" * "Custo" = "Custo_Unit1" So, how I can do this ? Thank in advance.
How to learn how to create custom functions and learn Deluge
What is the easiest way for me to learn how to write custom functions and learn the Deluge programming language? Where can I find samples so I can understand how to write the deluge code properly?
Annoying/ugly grey lines on header
UPDATE: Forgot to mention that this is happening on FireFox and Chrome. ORIGINAL POST: Been using Zoho Creator for a few years and always wondered about the ugly grey lines that appear all over the header (see red arrows in attached screenshot). Can you please tell me why they appear and how to make them disappear?
Check for duplicate
I have a persons register in Creator. Now because the database has been populated from different sources, it is possible the same person could be in the db twice. Even with different data. Therefore I want a function that can check for duplicates based on just one (or two) fields. I think what might work is check the DOB. If there are two records with the same DOB, it could be the same person. Not necessarily, but possibly. So if I could have a function that checks all records and outputs a list
Calendar Report: Ability to define the time interval in Week/Day view
The time interval defined for the Calendar Report in the Week/Day view is defaulted to 30 minutes and it can not be edited. This causes that any event with a timeframe lower than 30 min is not properly displayed. Here an example with 5 slots where 1 slot has a 30 min duration (it looks great) and the other 4 slots are 15 min (they are cut): Surprisingly, the timeline report has the minimum interval defined as 15 min so it looks to me inconsistent to keep the calendar report defined with a minimum
Import or get data from CSV file in Google Drive
Hello everyone, I'm trying to figure out how I might be able to get data from a CSV file, preferably from Google Drive, and use that data to input records into my app. I would like to have a CSV file of bank transactions import into my app, and hopefully via workflow/automation, rather than add transactions via mobile app/form one by one each time a transaction happens, or having to use the standard import function. At a minimum, I at least need a way to retrieve the data from the CSV. I could
How to edit /delete Page Parameters in Zoho Creator under Zoho Developer?
Team, We are unable to edit page parameters or delete them under "Page properties". Could you please provide direction? See snapshot below:
Giving a number value to a drop down label
Hi, I am trying to denote certain values to the numbers in the dropdown. I did this on the last program I used shown in the picture below. I need to set 1" with a value of 10, 2" with a value of 28, 3" with a value of 51, and so on. What's the easiest way to do this in Zoho Creator? I would love it if someone what help me out and send me in the right direction! The data is exactly the same in the old program as it will be in creator as seen in the picture below. Thank you so much, Kevin
Workaround for multi-language support beyond the standard
Hello all, I want my app to support English, Spanish and Portuguese languages. There is a localization feature in Zoho Creator but it's limited to field names and some field types like Drop down, Radio, Checkbox and Multi-select field. Has anyone figured out a workaround to translate certain single line fields? Not user created ones but there are many that will be predefined, for example, for my app which manages activation for wireless service from different carriers in different countries I have
Zoho Developer Custom Solution - Dashboard Does not Load - Script Timeout
Team, After importing a .ds file, the dashboard for our Zoho Developer custom solution does not load. Every other menu item on the left hand column works, except for dashboard. See snapshot below: the load progress blue bard on top stays blue all the way and nothing loads. What may be causing this issue and what do you suggest as a resolution?
Report from another application can't be viewed
Hi, There are two applications A and B. The application B has a page with report from the application A. For the administrator (myself) this works perfectly, I can view the report. However, for the customer there's an error "Report not found.". I have enabled customer portals for both applications. I have also added one test customer in the application B customer portal. I believe this is an access rights related issue, how could I allow the test customer to view the report? Or allow the report be
Sending data from ZCreator form to an Estimate in ZBooks
Trying to figure out how to send data from a Zoho Creator form to an Estimate draft in our Zoho Books account. In the form is a lookup field to "Products" in our CRM, which is synced with our "Items" in Zoho Books. Maybe this is all wrong from the get go but nonetheless still trying to figure out the best way to make this work. I've tried using flow but since the form as deluge scripts the "Flow" won't work properly. The "Products" from our form are actually part of a sub-form so ideally let's
Can I insert rows (add records) using criteria in a multiselect field?
Hi fellow zohoers, Thanks to some help from a moderator here. the code I used below allowed me to insert rows in a different table given certain criteria: The decision box "All" had to have a value of "true" (if (input.All))- and the input.client id had to match the client id selected in my URLs table (in my SEO order tracking app, this script is executed in my Orders form and inserts rows in the Order Lines form for each URL a selected client has. My question is: can I adapt the following code so
Telephone Number Field Bug
When using deluge to add a telephone number to another telephone number field it appears a bug. The telephone field text goes behind the country code and cannot be seen very well. It also appears the field hasn't been filled in correctly. In this instance I am automatically inputting the telephone number based on the lookup of another form.
Creator New Help Pages are showing up empty
When I try to search for some strings on the new help pages and click on a url of the resulting query then a page does show up but its contents is empty. I was having this problem since a long time but couldn't exactly pinpoint the reason. Right now I need to find out some certain guides and can't find them on the help guides. For example the "Import Records into Report" page also doesn't exist on the instruction sections which can be selected from the left menu of the "Reports" home page. The sub
Creating my own pivot table using For Each Record
I would like to know how to group items and summarize the amount, based on a certain field. This code in my page (below) works just fine to get all the expenses that meet the criteria and produce the total of all the expenses. What would be cool though would be to have sub-totals of each category, as well as the grand total (like a pivot table) What I can't figure out is how to get just the records that are of a similar type, in this case all record with the same category (Home Expenses), then sum
Add organisation name to a Record Template (under Extensions > Settings)
I want to be able to add to a project template a field which is the name of the organisation. I have a Form where the user inputs this when setting up their business in the application. However, I am setting up the Record Template based on another Form, and I'm trying to work out how to pull in the name of the organisation into the Record Template. I have thought about creating a field on the Form to which the organisation name is added every time a record is created, but this seems a bit long-winded.
Auto Populating Multiline with values appearing on separate lines
While autopopulating a multiline filed using deluge, I want different data to appear one below the other as different lines and not on the same line. When i use " ", it appears with one space between two values. So, how to make them appear one below the other?
How to work with this exchange rate data
Hey everyone, My question is more of a personal head scratcher. In my finance app, I want to do a some exchange rate conversion. I found this site, https://api.exchangeratesapi.io/latest, which provide basic csv type data of the current rates of the day (adequate for my needs, and free :-). I was able to make a workflow using the invoke url deluge task to bring the data into a text field. Great. Problem is, now I can't seem to figure out what to DO with the data. In the text field, it's not
RegEx in Creator using replaceAll function
I am having trouble wrapping my head around the use of replaceAll and RegEx in Zoho Creator. It's my understanding I can't capture groups like I would with JS or Python. Can anyone provide guidance on how I could accomplish the following? str = "abcdefgh Record Date: 2020-04-05\n. abcdefghijklmnop" I'm trying to capture the word after Record Date:, and between \n. In other words, I'm trying to use the function to return only 2020-04-05.
Revieve error {"code":1002,"message":"Statement of Accounts does not exist."} when creating invoice in Books from Creator.
I receive the following error message when trying to create an invoice in Zoho Books from Creator: {"code":1002,"message":"Statement of Accounts does not exist."} Here is the statement i'm using to create the invoice: response = zoho.books.createRecord("Invoices","6699999999",values); Here are the contents of the 'values' variable being inserted into the zoho.books.createRecord statement: Values{"customer_id":62944600000011xxxx,"reference_number":"afa","date":"03-Apr-2020","line_items":[{"item_id":"125789400000155xxxx","name":"210XGD","quantity":1,"description":"blah
I want the "Approve" button to update current record
I thought this was as simple as using the criteria Zoho offers but I cannot seem to get the record to update. I just want to click the "Approve" button and update the record to Post. The only two options in the dropdown of BA are "For Approval" and "Post" I have attached images so you can easily see how I am trying to perform this action.
zoho pos bulk import
I've tried all different combinations to bulk import data into Zoho point of sale but it doesnt get the product. What am I doing wrong?
Using REST API insert to subform !
i have a main form call as Employee in this form has subform with Name: Employee Adress is a Subform fo Adress now i using REST API ................... <input type="text" name="Employee Adress[City]" value=""/> but did not work ! so how to format a subform data to work with ReST APi thanks for support !
Passing URL query string to embedded form
Hi there, I have an embedded (Iframe) Zoho Creator form on my external website which I am trying to pre-populate via a URL query string. The query is populated from merge tags, meaning the value changes depending on who clicks the link. I'm having trouble getting the web page to pass on the parameters to the embedded Iframe.... Example as a link from an email (where the name values would change given the merge tags: <mywebsite>/edm-enquiry/?fname=Emily&lname=Smith Iframe embedded into my website:
Mobile APP Jobs
Am new on zoho. If i get a mobile app design jobs from a client eg Restaurant, Church ,Hotel, School Mobile APP, what are the step by steps procedures I should take using zoho creator and how much can i charge.
[IMPORTANT] Addition of numbers using single textbox?
in Signle Input text /number field when i enter 5+5 or any number it will automatically get addiontin and display 10 replace with 5+5
Converting single line field to time sheet
Is it even possible to convert a single line field to calculate start time and end time in zoho? I would also like to add a time for lunch as well.. Example 30 minutes or 1 hour lunch to subtract from start and end time. I have found a few resources online like https://app.zohocreator.com/martryl/date-time-functions#DateTime but I cannot figure out how to do this without implementing the date-time field. Is this possible in Zoho Creator? I'm working on building a timesheet application that my employees
Zoho Creator XML RPC API - Add Record NOT WORKING - returns 200 success with empty response object
Hi, I am trying to add a new record to a form using the Zoho Creator XML RPC API and it's not working. The API always returns a 200 success code with and empty <response /> object, but no data gets inserted/added, nothing happens. (If I use the REST API, it works but REST doesn't support adding data to subforms) Here's an example request to a basic form that has only 1 field : XML RPC API (Not working) : REST API (working but cannot add subforms) : Si essentially I have 2 questions : 1) Can someone
Fetching Data from Lookup Field of a form.
Dear Sir / Madam, I have a form name Item which have multiple lookup field including one mane field named Item name , Lookup fields are Item category from category form and Item unit from Unit form. Now I wan't to create another form where I will setup a look up field for Item Name from item form and have two single line field which will show Category and unit of the item i select in lookup form. Could you please help me telling how to do this in zoho creator. I have searched but could not find
Hide fields based on input of lookup field
Hi all, I have tried different scripts but i keep getting errors. All i am trying to do is simply hide two fields when a certain input is chosen in the lookup field. Lookup field name is: Job_Name Other two fields i want to hide are: Cost_Class and Cost_Codes So, IF "No Job" is chosen in the lookup field Job_Name, I simply want to hide Cost_Class and Cost_Codes ELSE, show fields I have the code as follows: if(Job_Name.Job_Description == "No Job") { hide Cost_Class; hide Cost_Codes; } I keep getting
Sorting Values based on a certain Field Name and then Rendering to Table
I have a table that is getting all the correct values, and the only thing I want to do is sort this table when rendered by the Date_of_Invoice. I cannot figure out for the life of me how to do this or where to begin. Any help would be appreciated. Here is the code: <div class="divTableHeading3">Section C: Trust Distribution Payments</div> <div class="divTable1"> <div class="divTableBody"> <div class="divTableRow"> <div class="divTableCellB">Trust</div> <div class="divTableCellB">Amount from Trust</div>
Send Attachments via SendGrid
We have implemented a SendGrid integration with Creator, we have had to use SendGrid so that we can send from more than one email address. The integration works fine but we wish to extend it to include Attachments. We could do this using the SendMail function in Creator however in doing this we loose the ability to control who the email comes from. Has anyone implemented a SendGrid integration to include attachments. Thanks Gordon
Next Page