Record Summary to Display Collected Data
The Record Summary is a GREAT feature, and I was wondering if, after we've designed a Record Summary, if it was possible to use this Record Summary as a way to view data, such as List, Summary, or Calendar views? The major issue is I have multiple fields of data and I would like to view all of the fields at the same time, as opposed to having to scroll horizontally (as in List and Spreadsheet view) or vertically (as in Summary view). The Summary view is the one that comes close, as the List and
Pre-populate "Add New" Form based on Main Form data?
Hi, Is there any way to prepopulate the "Add New" form based on the input of the main form as shown in the picture?
Allow customer to look up record via one field entry.
I don't exactly know how to explain this so someone would understand - I have a parking citation application that I would like to be able to embed some type of search form, or report in a web page, and a driver can then go to the website, enter their license plate number (which is entered by the officer) and view their parking citation online. Is this possible? I know I can embed an entire report, but I can't figure out how to allow someone to search for their (and only their own) parking citation
Creating multiple Products for your Quotes in Zoho CRM.
Hi, We now support creating multiple Products for a Quote using zoho.crm.create task. Below is the deluge code for creating multiple Products for a Quote in Zoho CRM through Zoho Creator. string createQuote(string productId1, string productId2) { maplist = List:Map(); product_map = {"Product Id" : productId1}; product_map2 = {"Product Id" : productId2}; maplist.add(product_map); maplist.add(product_map2); resp = zoho.crm.create("Quotes", { "Subject" : "Quote for ABC Corp,Ltd",
Need help to build a Labour hire app - Developer wanted!
Hi , I am looking for a developer to help with building an labour hire app where we can get the employees to Register online Update work history bank details and tax file number availability for shifts each week online timesheet - supervisor to access to approve Employee inputs shifts worked Tables for clients rates. ie $20hr flat rate, time & half $35 , double time $ 40 Allowance: for each client table: Travel allowance $10, meal $15 Employee - payslip and update details portal access Regards
New user shows up as pending in invitation list!! Please help
Hi Team, I've created 3 users and 1 of them got created successfully but the 2nd and 3rd (admin@ewayinfosystem.com, info@ewayinfosystem.com), have been placed in the Invitation List and shows up as pending. There is a very quick short red message showing up when I try to create that last user but it disappears too fast to be able to read it. Could you please help me !
Customize Text
Hi all, Can i customize the text you see when you update and/or delete a record? When you add a record you can customize the text "Data successfully added". Is it the same for update,delete,modify? Thanks!
Using libraries
Can I make use of external libraries in any programming language in Zoho Creator for hashing passwords or displaying a CAPTCHA in a web page? I would like to put some code in the Validation part of the workflow for a form.
Find correct script
Hello, I need to use this script for count all record inserted at 06:00 AM, but it doesn't work (Error at null): void dati_per_report() { x = Dati_chiamata [ Added_Time.getHour() == 6 ].count(ID) ; } Any idea? Best regards
How can I add/fetch the data extracted from a QR code scan to a lookup field.
How can I add/fetch the data extracted from a QR code scan to a lookup field. I have a form with of all addresses and info of my customers (each has a QR code) and another form to capture deliveries. I want to give my drivers the ability to scan or look up manually the address in the lookup field linked to my customer form. Thank you for you help
View record button
Hi, The dropdown button coming by default in Zoho Creator is not practical for quick viewing/editing a field (very often you open the record just below!). To avoid this problem I have created a Custom Action called 'Edit' which is much easier to use (it is not a dropdown-list). This is better but not fully satisfying as I am viewing records more often that I do edit them. How to create a 'View' button in custom action? I could not find a command for that. Regards, Chris
Ideas Needed for Inventory Management System
Dear all, My idea is to use Zoho Creator to build an inventory management system with tracking capabilities which mimic the current Excel/Paper use in my company. It has to have the current features: 1. Able to display daily inventory level with - Base Inventory (Sum of each items until yesterday) - Outgoing (Today's outgoing) - Receving (Today's incoming) - Total (Base + Recv - Out) 2. Able to track Lot No. of each inventory. - In my test system, I am able to record
Column Hide and Show
I have a column " Lead type " with two dropdown value company and individual and other column "group" so I want when the lead type will be company then group column will show or if the lead type will be individual group column will be hide show how can I do that
API View Related Record's ID Instead of Display Name
Hi, Let's say there are two forms: 1) Person 2) Family A Person can be assigned to one Family. Let's say there are the following Families: #) ID - Name 1) 1 - Johnson Family And there are the following Persons: #) ID - Name - Family_ID 1) 2 - Mary - 1 2) 3 - Paul - 1 When I use the Zoho Creator API to download the Persons data I get the following information: #) ID - Name - Family_Name 1) 2 - Mary - Johnson Family 2) 3 - Paul - Johnson Family I do not get the ID of the Family. So if I
Access data by user owner - RLS
Dear gurus, I started testing ZOHO Creator, and one of features is of course RLS, meaning that users can access only his own data. As I read in instructions, this is the default feature in access rights (Advance sharing settings), but in my testing application each user can access all the data? I now have only free version. Can you guide me on what should I do? Rg G
dynamic dropdown
I have a dynamic dropdown but i want to add a search function to it, It's possible?
Pivot Tables: Associate data shelf with different rows
I would like to have my Updates column relate to "last modified" while my New Issues relates to "added time". Is there a way to do this in the same pivot table? In the example below, I want the number 8 to be on the month Apr because all my updates were during the month of Apr. The example below shows that 3 updates were in March because the record was created in March. I need to see the sum of updates that happened within the listed month. https://creator.zoho.com/appbuilder/joeybuck/host-care-managment/report/Month_to_Date/edit
Fetch record referenced to on another form
Hello, I have three forms in my application: "Projects", "Contacts", and "Activities". On my project form, I associate every new project with a contact. On my activities form, I want to be able to pull up a list of all active projects via a lookup, choose one, and then display that project's contacts details (e.g. full name). How would I go about doing that? Activities Form Lookup -> Project A -> Project A Contact Record -> Full Name Thank you!
How to set different logo in different Customer Portals under the same organization account
I think that my question is not supported for now. We have 2 working companies under the same organizational account. We have also created 4 applications (2 for the one company and 2 for the other) and we also use customer portal for these apps. My question is if it is possible to have different company logo in each application. 2 applications with the one logo and 2 with the other. I think no, as it is not possible to manage 2 companies under one organization account like Zoho Books for example.
report on creator
hello india ! I have created several reports based on different part of a same form Is it possible when i edit (update) a report to show only the corresponding part of the form without showing the entirer form? thank you in advance
Multiple Payment Methods
I am setting up a registration form for classes that we offer, and I'd like to give people the option of paying either online with PayPal or with cash or check at the event. Is there any way to do this?
Run script On Load of application?
Hi! I would like to run a script when the application loads. If this is possible, how do I accomplish this?
Exporting to spreadsheet creates duplicate lines
Hi! I have a client who is exporting a report from Zoho Creator. In the Creator report, there are no duplicate lines. In the exported spreadsheet, however, there are (very occasionally) lines that are duplicated. Has anyone else experienced this problem? Thanks!
Auto populate form based on dropdown selection
Hello all, Thank you for taking a moment to read my request for help. It has been a few years since I have worked in creator, so please be patient. I have a form named Build_Sheet where several values are entered during an assembly process. Such as serial numbers, configurations etc. I have a second form named Data_Collection where additional information is stored about the equipment in the Build_Sheet form. Workflow is as follows. Assembly builds a new tool comprised of multiple serialized
Sending cv's to zoho recruit by e-mail and create the candidate
Hi all, I would like to know if its possible (and what will be the process) sending cv´s by an e-mail account to zoho recruit and create the new candidate by that. Thanks in advace. Pedro
HTTPS in iFrame not working
I am trying to create an iframe of the page of my gmail. But I cannot do this. Why? I have experimented with "www.zoho.com" and I can click on everything without having problems except when I click "access my account" then the iFrame goes blank. How do I fix this issue?
Show a specific report when application loads
I would like to show a specific report (calendar) when the application first loads. I have 3 main menu items positioned at the top of the application.These each have links under them to pull up certain reports. I know you can change the order of the sections, but in this case I do not want to. My 3 main menu headings are: Patient Information Calendar Reports The Calendar report does not have any drop down links. The other two do. I would like the Calendar report to load as the as the default
element positioning
Hi , I have selected two column in my application. Now after inserting some elements in the left column I want to position an element in the right column adjecent to specific element. Only problem is the space above is empty and any element inserted in column 2 gets positoned to the top. How to solve this?
RMA TRACKER
Is there any way something in Zoho can be setup so that I can issue and track an RMA?
Retrieve associated field in nested lookups
Hi I have a a set of nested lookups in forms: Country Region (with Country lookup & filter) State/County (with Region lookup & filter) I have another form Profile on which I have a State/County lookup. When a user selects a State/County, I want the associated Region to load into a regular input field. So if the user selects Nottinghamshire, East Midlands appears in an input field. As Region is a lookup inside State/County form I can't access it the same way as I would do other fields. Can you help?
break one field into many
I want to split one field into two.How Can I do that : for example I have a field name Company Name: Kader rahman tonmoy I want to split first word under FIrst Name and rest of the string under Last Name Like below : First Name :Kader Last Name: rahman tonmoy How can I solve my problem or Which string function I need to use?
Embedded URL Row Limit
Hi, I was using the "Embed to Website" link from a Application generated report to provide a feed for a Power BI report. This appears to be working great except that I only seem to be able to pull out the number of rows that are displayed on the first page of my report. I have 200 Rows visible on the first page of my report, but there are 357 rows of data in total. When I pull the refresh of the data to my report it only gives me the latest 200 rows. Is there a way to have the embedded report to
Webhooks - Update Creator Record from ZOHO People
Hi All, I have a CREATOR application that gets populated whenever a new Employee Record is added in ZOHO People. I have used Webhooks and Creator ADD API for this. It works fine. Now, I want to UPDATE the Creator Record whenever the Employee Record is Updated in ZOHO People. I have used Creator UPDATE API. It does not seem to be working fine. I am getting the below Error, that says no CRITERIA is specified. <response><result><form name="E"><update><criteria>null</criteria><newvalues><field name="Email"><value>krithika@langoor.com</value></field><field
Paypal Within the Portal
A few years ago, there was a problem where Paypal payment notices were not getting back to forms in the Portal. So if the form connected Paypal and the user made a payment, the On Add/On Success event of the form did not know that the payment had been made and never completed the transaction. Does anyone know if that has been fixed? Can I put a form that uses Paypal in the Portal and have it receive Paypal notices reliably? Thanks Jon
Build contact manager in Creator
Hi, I want to replicate Contact manager in Creator. That is I want a vendor page that I can link multiple contact records to. What is the best way to go about this? Thanks
deluge statement execution limit
Hi. I have function: float z(float k, float g) { // size = XS and 6 s = 0.0; if ((input.k < 700) || (input.g < 700)) { s = 6; } // size = S and 8 else if (((input.k >= 700) && (input.k < 900)) || ((input.g >= 700) && (input.g < 900))) { s = 8; } // size = M and 10 else if (((input.k >= 900) && (input.k < 1100)) || ((input.g >= 900) && (input.g < 1100))) { s = 10; } //size = L and 10
Change portal name
Can you please change my current workspaces http://creator.zoho.com/workspace/valeriano.bonacina to http://creator.zoho.com/workspace/bcccarugateinzago is it possible?
Timesheet Totals
Hi you clever people We have a form TIMESHEET with the following fields TIMESHEET_ACCOUNT - (Lookupfield ACCOUNT NAME field from ACCOUNTS Form) TIMESHEET_START - Date/Time Field TIMESHEET_FINISH - Date/Time Field DURATION (h) Formula field - ((timesheet_finish - timesheet_start) / (1000 * 60 * 60)) timesheet_transferred_to_accounts - Decision Box Is it possible to have two read only fields in our ACCOUNTS Form as follows: Hours Billed - which provides a dynamic total of all the durations where
How to populate a drop down field with data from last two records fetched from another form
I just don't know why this does not work. I'm fetching all the records from form "Received_Ingredient" in which the "Grains" field is "Rye". I want to populate a drop down field, "Rye_Lot_Number" with the "Lot_Number" in the latest two records. I think the last two records will be the first to be fetched, but if not I can sort by a date field in each record. This won't compile without error. count=0; for each delivery in Received_Ingredient[Grains="Rye"]; { if(count<2) { count=count+1;
does the strings in Zoho Creator starts with "." ?
I am trying to get a number from US Format "11.11" to European Format "11,11" using strings and the built in function: "replaceFirst". However I found an interesting behaviour: tmp_string_price_ = "abcde"; tmp_string_price = tmp_string_price_.replaceFirst("c",","); returns "ab,de" as it should be however tmp_string_price_ = "ab.de"; returns ",b.de" Correspondingly, it seems that an "." is found at the first position, even if is not what I have stored in that string. Obviously, with numbers
Next Page