How to make numbers field align to the right?
My currency fields are all aligning to the left in the List report: How to make them align to the right ? In some case, the currency is missing the $ sign too (like the Achieve field) . Please help. Thanks!
Global Variables
I am fairly new to Zoho and have been following the instructions relating to global variables here: https://www.zoho.eu/creator/help/script/sample-application-global-variables.html I have two questions: I can get this to work populating a field in a 'results' form using a script on the 'result' form's onload event but what I would really like to do is to call the getGlobalValue() function in a formula field - is this possible, I cannot seem to get it to work. The function works on strings, if I
Will a record with incomplete mandatory fields be saved if created or updated by delute script?
I am trying to modfy some existing code in an application to add two more fields to a function for updating a record from another or create a new record. However I have found that the record that is being written to or created (destination) has three fields that are mandatory whilst the record used to supply the data (source) does not have these three fields mandatory. So my question is, will I be able to save the record if any of the mandatory fields on the destination form are incomplete.
Create records in embedded subform
Hello, I have a main form (Scheduler) and added a subform to it (Product_Subform).. I can create records to add an new appointment repeating every X weeks that matches an existing appointment... but I want to also duplicate the subform records in the new appointments that are being created. Thanks, Jason //get current appointment record myApptID = input.ID; //repeat appointments repeatInterval = input.Reoccurring_Appointment; if(len(repeatInterval) > 0) { //get substring repeatIntervalDuration =
Will old Perma-Links still be valid if I change to the new UI
I read that the new UI, uses a different URL structure. However I have a number of users accessing published perma links to forms (without having to sign in) to enter data, will these old URL's still work if I opt to upgrade ? Are their any other migration considerations when moving to the new UI. I've been very happy with the old UI for many years, but maybe the time has come to update ! Thanks Neil
Get key name from map based on index value
Is there any way to get the key name in a map based on the index value of the key -> value pair? map.getkey(0) or something like that?
Subforms IDs instead of data using REST API
Hello. I have defined a form with subforms, and an associated report. When I download the report in CSV format using the web interface, the subforms data appear ok. But when I download the same report using the REST API, subforms IDs appear instead of their data. How can I make the real data appear instead of the IDs? Thanks in advance.
Lookup field returning ID not String on page. Please Help!
hey all So I have a page that displays selected product information triggered via a custom function on a report. It shows the name of the product, price and image I'm also trying to show the company name of the product, but only get the ID number not the string value. On the "Add_Product" form, the company name is selected via a Lookup Field that gets its results from the "Add_Company" form I've made the code in bold that is returning the ID number. Anyone know what code to add and where to make
Calculate the End date
Hello everyone! I have a Start date field and a Number of days field, I would like to get the End date by using the fields mentionated before. Also, I would like it to not count the weekends, e.g: Start date field: 15-september-2017 Number of days field: 4 End date field: 20-september-2017 ...and so on. I managed to do it in the other way around though, can anyone help me out with this please? I would really appreciate it. Best regards.
Zoho Creator IOS app- filters on a report
This just recently stopped working. I've tried multiple tests. Basic problem: On my iphone APP of Zoho Creator, my filters on the reports aren't working. Via Web Browser, I create a custom filter within a report. It filters properly and is working great on desktop web browser. Over in the iphone app, I immediately see the new filter that I created is available, but when I choose (See attachment)... it doesn't filter. Looks like all same data. Thanks for your help! -Zach
How do I find who is application owner?
I'm working on an application and need to debug it. I think I can use Info statements to give me information at various points to help me find out where the problems are. However zoho tells me that only the application owner can see info statements. So my question is. 1) How do I find out who is or which group of users are deemed application owners, including myself, so that I can warn them in advance that they may get my debug notices.
Formula field displaying long ID instead of string value
Hello, I have set-up 2 forms "Clients" & "Project codes". On the "Project codes" form I have the following fields: 1. Project_name << standard text field 2. Client_ID << lookup field to look up Client_ID from Clients form. Client_ID is a text string (such as "ABC" or "XYZ") 3. Project_code << formula field to concatenate Project_name + Client_ID My problem is that when selecting Client_ID (for example: "ABC" or "XYZ"), the Project_code field reads the Project_name + a long record ID number. How can
Deluge script: IF (condition) in On User Input behaving oddly after working fine for 5 months
My form Add_Charge started behaving oddly with a sequence of "if" and "else" conditions. The sequence is meant to pass a set dollar amount to the Fee_Earned field On Add>On Success and On Edit>On success. The sequence worked fine for 5 months, then it stopped passing the dollar amount about a week and a half ago. I created a support ticket with Zoho Creator (#17925342#) on Aug 31st that remains open and without any updates since Sept 4. Thank you for any input or assistance in advance. Here is the
List filters
Hi There, I've been struggling with this for a couple days now.... I have a long list of lighting products. I'd like to create a filter for indoor/outdoor. Then another filter for the product type (high bay, low bay, wall pack, wrap, etc). Below that, I would like check boxes (rebate eligible, in stock, etc). Each selection further narrowing down the list. Thanks for your help,
pop up message
how to a pop up message every 1 minute of the user accessing my application ?
Authenticating with Zapier
Hi, I'm trying to connect Zapier to Zoho Creator, but can't get it to authenticate. Zapier is asking for an auth token (which I have successfully created) and my "Ownername" or "screenname". The instructions (here: https://zapier.com/help/zoho-creator/) says that this can be obtained through the "My Workspaces" menu item below my profile icon at the top-right of the Zoho screen. However that "My Workspaces" menu is not present for me. I've tried using the "Full Name" used in my Zoho profile (which
Can't use scrollbar in disabled rich text field
Our client is asking me to enable the scroll bar in a text field that is disabled. The field is disabled because the content of the field should not be edited by most users, but they all need the ability to view it. Is there any way to enable the scroll bar, but not have the field be editable?
Split Page Results into two columns?
hey all So I have a page that displays selected product information triggered via a custom function on a report. It shows the name of the product, price and image the results are all under one another. How can I modify the code so the results display in two columns? I.E Product A Product B Product C Product D Product E Etc Thanks, here is my code: htmlpage ProductSample(empid) print = true pdf = true content <%{%> <h2>Mood Board</h2><%prodLst = input.empid.toList(); for each prod in Add_Product
XML RPC API - Keeping Auth Token private in a public form?
We have a public form that we wish to add records into a creator application (inlcuding is't subform). We are able to successfully submit our form data into Creator using the XML RPC API, with the data structure as per the support doc examples - https://www.zoho.com/creator/help/api/xml-rpc-api/xml-rpc-api-add-records.html#Sample_Request My question is how do you keep the Auth Token private? Anyone who inspects the source code of the form will be able to view the auth token and username. Many thanks
How to update a list via REST request
There is no documentation about updating array via REST API https://www.zoho.eu/creator/help/api/rest-api/rest-api-edit-records.html If I send only one element as a string "Some value" list updates. But if I want to update the array with several elements, API responses with failure "status": "Failure, Invalid column value \"One, Two\" specified" I tried different variants: - [One, Two] - [One,Two] - One, Two - One, Two - One;Two
Subform width size not working. Fields displayed in two lines
Please see below how my sub-form is displayed. Any fix? Custom Size does not work i change to any value and it simply ignores it. Also tried to adjust the size of each field but still the same. I also tried creating a new form with just this or any other subform and all are displayed the same way with the X to erase the record on top instead to the left. Please help
I woud like to create a report that displays info from multiple types of forms
The reason for this is so that we can sort all of the active jobs whether they are service calls, new sales or front door sales (3 different forms) by the city they are located in to make day planning easier. Any help would be greatly appreciated.
Have a very simple array, how can I turn it into field choices for a drop down or multi select?
Hello I am hitting a database for an array of names and wanting to use them as choices for a drop down or multi select Here is an example response: ["bill","bob","jon","brendan","jane"] I have tried using map functions to no avail. Any ideas?
Is it possible to get the logged in users First and Last name?
I'm trying to display the actual name of the logged in customer portal user - is that possible? Just using the email or login username is not that pretty vs. seeing a persons name. Thanks.
*RESOLVED* Prepopulate form with data from another form
I've spent hours on this today - I feel pretty silly because there is so much info out there. I have a staff details form (HR_Form) that one person has to enter Employee Name, Start Date, etc. The next person has to fill out an IT requirements form. I want the Employee_Name field in IT_Form to be pre-populated with the value from the Employee_Name field in the HR_Form. What is the best way to do this? Ideally, the person filling out the IT_Form clicks a link in an email, and is prompted to fill out
Can a Form on a Page drive a Report also on the page?
If I have a Form that's embedded on a Page and it has a relationship to another Form's data, can I also embed a Report (in list view) below that Form on the Page and have the data in the Report show the Report for the records related to the record shown in the Form portion? So: Form at top of Page Report of related records on bottom of Page I hope that's clear. Thanks.
*RESOLVED* Return error if date field input is within 7 days from current date
Hi all, this is my first question on the forum. I've got a field called Start_Date, where a manager can enter when a new employee will start at the company. I'd like to have it return an error if the date chosen is within 7 days of the current date. Something like if input.Start_Date < zoho.currentdate.subDay(7); maybe? Any help is much appreciated Levi
Commenting System
How do you go about doing a comment system on a particular form. Example, I have a Project Form, I want users to be able to add comments on a project. Once a comment has been added, it cant be edited anymore. Any idea how to achieve this? Ofcourse, I want to know who commented and when it was written as well. Appreciate any help.
How to have info show up based on a drop down menu selection?
I have made a drop down menu where our customers are stored. There is a search bar at the top and an add new button at the bottom. Once I have selected the customer I want; id like to see all of their information displayed on the form. Any help would be great!
Auto Record Advance
I need to enter numbers "heads down". For this I created a sub form with one (text) field. Now, after every entry, I need to manually hit the + ADD NEW button to be able to enter a new line. What I need is, when the user enters data and then hits Enter (Carriage return), the record is Added and a new line is presented. I looked into the scripting section but I can't find how to do this. Anyone?? Thx!
Adding Commas or Separator to Compiled Values
So I'm trying to fetch the form "lesson material"'s module name ("module_text"), subject name ("subject_text") and category("category"): FetchMaterial = Lesson_Materials[ID == input.Lesson_Materials]; Then I'm trying to insert those 3 things (module name, subject name, and category) into a multi-line text field: input.Multi_Line = FetchMaterial.Module_Text + FetchMaterial.Subject_Text + FetchMaterial.Category; This works fine, but when there is no spacing or separator between the 3 things. So I end
View URL with multiple OR values
Hi, I have 3 forms: A, B and C. Form C has a lookup field to A and another lookup field to B. I created a stateless form S where I would like to select A records and obtain all related B records (through form C). I have successfully coded the form action (using "for each") and now have a list (an actual deluge list) with all B record IDs but the problem is (apparently) I cannot use openURL of view B with multiple OR values (all the IDs I got from going though form C): openUrl("#View:B_Report?ID="
Sort 'searchRecordsByPDC' results by Date field
I am using the below code to fetch all CRM 'PurchaseOrders' records from a specified CRM 'Potential' and then insert them as SubRow items "On Success" At the moment they are inserted in their default order, however I need them to be saved in a custom date order (Start Date). What is the easiest way to sort the fetched record for inserting in the SubForm? var1 = input.ID; //pull data from CRM based on Potential id srch = zoho.crm.searchRecordsByPDC("PurchaseOrders", "Potential Name_ID", input.Bookid);
Record summary - How to display Invoice items in table format?
I have a invoice form with item details as sub form. I want to display the invoice items in a tabular format. I tried dropping table component with each sub form field in a column. It displays all the item details in one row. How can I do this?
One giant app with multiple modules or multiple apps
Hello, in planning for developing creator apps for several aspects of my business (inventory, hr, and billing to start) would it be best practice to make one big app that includes these different pieces or make multiple apps because the uses are too different? What should be the main factor for considering one method or the other? Another question I had if I go multiple app route: if app1 is not shared with a user but app2 is shared and if app2 had lookup fields from app1, would the user be able
For each row in SubForm create a CRM record - zoho.crm.create
We're trying to create a new 'CRM' PurchaseOrders record for each row in a 'Creator' SubForm. I have written the below code, this currently creates CRM records "On Success" but instead of pushing each rows unique data into a new CRM record, it pushes duplicate data from row 1 into each record e.g. if there are four rows in the sub form, it creates 4 records in the CRM but all have data from row 1. What we would like it to do is create a unique CRM record for each row in the SubForm e.g. row 1
Password Fields in the Forms
Does ZOHO Creator provides facility to have a password field in the forms.... I tried but could not find it.......... Please tell me about it
Cant access edit form
1. I created a form at https://creator.zohopublic.com/registrocivil/registro-de-nacimiento-doble-ciudadania/form-perma/Envio_de_Documentos_inicial/UbUsnYy7X5gyZhpJCjjt9hkAj01Y0AtV1kAM9kGsjJ3hBBQtRgVvsZQQsd2qjFrTZvOeMPNh5kFpNV7BqHbsjpNG29DQAqRehUYY 2. I need customers to be able to modify captured data afterward without a Zoho account.. For that, I’m trying to use the following link: https://app.zohocreator.com/registrocivil/registro-de-nacimiento-doble-ciudadania/Envio_de_Documentos_inicial/record-edit/Envio_de_Documentos_Report/3400680000000013173/
Label Printing
Hi I would like to print labels whenever I update records among a condition. Is these posible? Looking forward to a soon reply, Greetings!
How to create a Summary Report from two forms data?
Hi I am trying to build a database wherein I store all inputs of adding a stock and another form to removing the stock, how do I create a page wherein when I putin a Product ID it shows up a complete summary of stock in hand in various locations? And do I create an indirect table to hold these values which are updated whenever there's a stock addition or removal? Totally new to this software so looking fwd to some immediate help! Thanks Amit.
Next Page