Links to other 'filtered' reports from current report
Need to have links in reports that will take me to other 'filtered' reports. See the attachment that shows an example of what I'm trying to do. The cells that are underlined can be clicked and the app will take you to another datasheet that is filtered according to the cell that was clicked. New to Creator and need to know if it has this capability via scripting? Thanks!
API - "New Application via .ds" OR "copy existing application"
Hello, We need to be able to make new configured instances of an app for clients. Currently this is a very manual process. I want to be able to automate the creation and configuration of these apps for clients. Ideally the API can be used. But I can find any "New Application from a .ds file" command via the api. And the https://www.zoho.com/creator/help/api/rest-api/rest-api-copy-application.html method is marked as deprecated. Is there any api method available to make a new application from a
Posting to a web service using JSON
Hi I have a job to do for someone and it's a new area for me. Can someone help, or take the job over please? Background: Source data in a simple table in a Creator database. Records added manually or via CSV import User wants a button on a View or on a Creator form that can post to a web service, using JSON We have the web service URL and it uses Basic authentication, for which we have the credentials The JSON format has 4 parameters: { "requestId":4, "cleardocsOrderId":1000000462, "status":"registered",
Shedules Settings Issue in Zoho Creator
I'm using Zoho Creator and want to add rules to trigger an email notification whenever one of these criteria is met: 1. It's 7th day after the date recorded in death_date field, which is Date-Time type field 2. The 40th day, respectively 3. And one year past after that date I want the system to send reminders in form of email notification 2 days before those specified dates. I've created some schedules (see screenshot): But the Form and Field fields are inactive, so I can't edit them. And here is
Problems importing data
Hi, I´ve been trying to import a csv file several time, trying different configurations in excel for the columns, with no succes. the file consists of several number and currency columns. the problem is that in the same column there are numbers correctly imported and wrong numbers, I have no Idea what could be wrong. I am trying to import numbers like this: $ 40.767 some of them import properly, but in many rows I get numbers like this: $ 4.076.666.667 Any help will be appreciated
Help to enter A picture!!
I want to upload an image to an html page but for them it must be housed somewhere but that's what we do not know how to do, I 'm driving this new platform , thanks
Updating checkbox values on user input
Hi Zoho, I have a checkbox field with 5 items in my form. I'd like to add an "Import all" option. I've added a "Import all" item to the checkbox list, and added the following script to the "checkbox field -> on user input" on the form script: if checkbox_field.contains("Import All")=true { checkbox_field.add("element01"); checkbox_field.add("element02"); checkbox_field.add("element03"); checkbox_field.add("element04"); checkbox_field.add("element05"); } if checkbox_field.contains("Import
Fetch and update
Hi everyone, I have the following code, but it only updates the first record of Cost in Costings. I need all price.Cost records to be updated. Can anyone help? //Fetch all records from Costings that match the Item Number and store them in a variable price. price = Costings [Material.Description == input.Description]; //This might be the problem or the previous line of code. Should find a solution in order to update all records. At the moment it only updates one of the records (the first one).
filter lookup
Hi Zoho Fans! I have a subform that has a dropdown field with some options and I also have a lookup field to a code catalogue, I would like that when the user choose an option in the dropdown the codes in the lookup field are filtered acording to the previous election. How can I do this? any help will be appreciated.
OnClik Action does not show calculation results on field
Hi I've a stateless form to calculate prices. I've created a button to calculate the price after user data submission. The script only makes some simple fetching and a simple calculation like input.price=p1+p2+p3 I verify that through Debug Info all the steps are well done through all steps, but the field input.price does not show the result (it continues with zero). For stateless forms in On Click action, is there any function to refresh/show/update or something the on screen fields in order to
Html Page Print and Pdf True
Good day, I create a Html page and I set the print and pdf = true on the header (code), I save the script but when I open the html page there are no option of pdf or print, I return to the html code and this part of the script disappear. I have another html page that works great. Code htmlpage Generate_DataSheet(equipcode) displayname = "Generate DataSheet" print = true pdf = true Best Regards,
New To Creator doing a Timesheet
I know this should be easy for me but I'm just getting my feet wet. I work for a consulting firm so we all have multiple projects that we work on daily and have to log the hours spent per project. Right now they are using an excel spreadsheet. I've set up the form and included a radio button that says "do you need to enter more time for another project" Y/N How do I set it up so if they say yes the need fields pop up again. Thank you in advance for your help.
Record Audit for Users from Customer Portal
Does Zoho creator support record audit for users who are from the "Customer Portal" when they edit a record?
Aggregate function in formula field
Hi, Are aggregate functions like sum, average etc supports in formula fields? It doesn't look like it. My "Customer" form has a one-to-many look up relationship with the "Order" form. I want to create a formula field to do : sum(Orders.Order_Total) to show how much order the customer has placed. Thanks
Need example of creating a request in Zoho Support from Zoho Creator
Does anybody have a good, working example of script that creates a Request (ticket) in Zoho Support from Zoho Creator? The Zoho Creator help documentation is not useful and its example is incomplete and not well-explained.
Fetch other form fields with wilcard
Hi I need to populate a stateles form with a previous stored data or stores the form data if it does not yet exists. The test I've made that works fine is the following on the stateless form: (final_form is the form to store data, but not to be used by user) ON LOAD: // present on screen the data already stored in db rec = final_form [number == input.number]; input.a = rec.aa; input.b = rec.bb; ON CLICK: rec = final_form [number == input.number]; if (rec.ID == null) { // if the record
Reading múltiple info from single input(csv)
Im working on a little project. Im reading a qrcode with this formar "name:your-name,age:99". The idea is take that values and pase to a variable so i can work with them, like calculate age of birth and send it too. Im reading that map can be usefull but dont know how read until the "," and the assign next value.
Look up fields
We use look up fields to multi-select Rooms from a Locations table and are filtered based upon a Site look up field in the same form. This works fine on first edit of the form but when we go back in to the form, we have to delete the Site value and re-select the Site (which deletes the Room data). What are we missing?
update on duplicate
Hi. I am playing with a way to send reminders to my customers based on them choosing a number of days between them on a form. I have put a form on our website with compulsory name, email and days between reminders. My question is that the email is probably going to be the unique identifier and if they want to go back and change the days i would either end up with two entries. My question what is the best way of dealing with this. I would like them to just update existing info.
report criteria n days before?
I'm trying to set up a report that shows records where a Date field is before 14 days ago. I'm using Criteria: (Date Field)...Day - n days ago...14 but it's not working. Am I doing something wrong?
Updating records of a form based on input of from another form.
Hello, I have 2 forms. The first form is a simple product key list, where I import product keys from an excel doc, and then I have a second column to assign a users email to them. The second form is where users register. I have 2 field that are admin view only, First is the application status, where we accept or reject their application. Second we have a lookup field that shows all the unassigned keys. (meaning they do not have emails associated with them yet) What I am trying to create is a workflow
Forbidden characters in HTML Page parameters?
I recently ran into a problem. There are certain characters I cannot pass in an HTML page parameter because it causes errors. Some are obvious "&,+" some are less obvious "#". I want users to input a form. And then I made a custom HTML page to display their results. But if the form values contain characters I cannot pass through as a parameter, the page will not display properly. I DO NOT want the HTML page to fetch the form data. Is there a function I can call that will catch entries that cannot
OpenURL not working "On Edit - On Success"?
Hi Zoho, On one of my forms I have an OpenURL command both "On Add - On Success" and "On Edit - On Success". The script: openUrl("#Page:" + input.Project_Name + "_" + "Legal" + "_" + input.Ship_Name, "same window"); (input.Project_Name and input.Ship_Name are both mandatory fields) When adding an entry the openurl is working fine. When editing - I only get a "Data updated Successfully!" message on a blank html page, no redirecting anywhere. On another form, same script, again - "On Add - On Success"
Can´t insert image in e mail
Hi, I have a schedule to send a daily email to al empleoyees, I would like to have an image in this email acording to the company identity, but, when I try using the Insert image icon in the send mail interface in the script builder, it doesn,t save the changes. Can someone tell me what the problem could be? Any help will be appreciated
Drop-down menu "other" value is not acknowledged?
Hi Zoho, I have a drop-down field (Insurance_Type) with "Other" choice. On user input, I have a script checking for previous entries with the field's value (with a few other variables): Current_Same_Insurances_List = (Insurance_Sub[((Project_Name == input.Project_Name && Ship_Name == input.Ship_Name) && Insurance_Type == input.Insurance_Type)].Internal_ID).getall(); this works great with the build-in choices in the drop-down field. when I use the "other" option, it does not work. I've tried coping
Zoho Creator form edit by user
hi I am a beginner in Zoho Creator . I wonder if it is possible to create the public edit form where the user can enter the ID of an item that is stored in my Zoho Creator , then the user can modify and then save ? a bit like a cancellation systems :)
Unable to create pivot chart
Hi I encountered the following error when i try to create a Pivot Chart. See screenshots. Any idea what the problem might be? I am unable to create Pivot chart of any form in my application. Thanks
How can I fetch text info from related form in email notification?
Hello My trouble is as title. Form2 has a lookup field(dropdown) to Form1. In email notification of Form2, I'd like to tell the selected item's name to the person who input data. When I tried like "<%=Form1%> ", only ID of Form1 record appears in notification email. Is there a good way to fetch info of Form1 record in Form2 notification email? Thanks Tadashi
Has anyone had any experience working with Creator and a domain registry API?
I have a custom module in our CRM for Domain management, I would now like to be able to dynamically keep these domain records expiration date accurate for each domain to be automatically checked for the expiration date and then update the records with the most current expiration date. Thomas
Validate Unique Form
I have a form which (Ppl-Sponsors - in the ERD below) and I need to validate it so that it is a unique entry. Not allowed: Same Person & Same Company & Different Sponsorship Same Person & Different Company & Same Sponsorship Same Person & Same Company & Same Sponsorship Same Person & More than 3 different sponsorships Same Person with no Main Sponsor Any thoughts? Thanks in advance Pete
Form A change updates Form B field
Hi there, I don't have any experience with coding and I couldn't figure it out. So... I have a form called Materials_Catalogue which contains Description and Unit_Cost. The second form (Resource_Costings) contains Resource, lookup field to Materials_Catalogue pulling Description and Unit_Cost, Quantity and Materials_Cost (Unit Cost x Quantity executed on User Input) I need Materials_Cost in Resource_Costings to auto update itself when Unit_Cost in Materials_Catalogue is updated. To simplify, when
Zoho Creator: forms with decimal/currency fields: need "thousands" separator recognized
When I try to fill out a currency or decimal field on a form, if I fill in "5,950.30" it's an error. When I do "5950.30" it's accepted. I think your forms need to be intelligent enough to recognize that the "," is a thousands separator.
Alert on "On update"
Hi Zoho, I have a form that is being update every week. In the form the user enters a list of approved agents, and than in a subform lists the valuations he got from them. On input, the list the user entered is translated to a drop-down menu of all the approved agents from the user to choose from. But when the user is updating the list - I need to have an alert if an entry in the subform is from an agent that is no longer approved. Trying to script the following on the list entry field "On Update":
Trying to add record using REST API, but file gets downloaded
HI All, I'm having a bit of an issue, I have just started developing a portal and would like to add records, as I'm still testing the API I wanted to make sure that I can send and receive information, as most of the work will mean that information is recorded more than read I started trying the add record part of the REST API, but whenever I try it just downloads an xml or json file, with correct information, bit nothings updated in Zoho Creator. If anyones run into this before please let me know.
Total Multiple Subforms
Hi, I have a form with multiple subforms. Each subform has a field named Score. How can I get a total for all of these Score fields? Many thanks Antony
Custom field validation
Hi, Is there a way to implement custom validation, for example using a regex? I have a field which I want to restrict input to the following format [0-9][0-9]:[0-9][0-9]-[0-9][0-9]:[0-9][0-9] The users are being prompted to enter opening hours for their businesses in the format HH:mm-HH:mm. Thanks in advance!
Custom Filter Ignored In Report
I have a simple report that I'm trying to get to report (and summarize) only records where a number field <> 0 by creating a "Custom Filter". It seems from all the different things I've tried, ZoHo report generator wants to ignore the Custom Filter. It does also utilize an "Auto Filter" to select a month/yr at run time, and this aspect works, but it's still listing records that should not be included according to the Custom Filter that is saved with the report. I feel I must be missing something
No template option in schedule.
Hi, I have a schedule that sends an email to all empleoyees. Normally in the send mail interface, in the attachment section there are 4 types, view, report, file and template, but, when I try to do it in the schedule, What to do section, there are only two, view and report. is it possible to send a template in this case, when one send mails with schedules?
marking fields in a form
Hi Zoho, I have a form that two users need to fill together. Each user has his own fields, but can fill in the other user's fields too. I give both users the link to the form - but I need to mark the fields in some way, so each user will know what fields are on his responsibility (to be filled or to be checked, if the other user filled them). How can I do this? any way to format the field's title? Thanks Ravid
Google Translate API
Hi, I am writing a HTTP Get request to Google Translate API. The URL request follows the Google conventions and the answer from Google comes through JSON format. https://cloud.google.com/translate/v2/translating-text-with-rest void Google.Translate() { //transRes = getUrl("https://www.googleapis.com/language/translate/v2?key=AIzaSyBjYIY5pf9uyTDZq1jjB6FWdsb8bKyByOo &target=PT&source=EN&q=test translation"); transRes = getUrl("https://www.googleapis.com/language/translate/v2?q=This is a test for zoho&target=PT&source=EN&fields=translations%2FtranslatedText&key={API
Next Page