Convertir Numeros a texto?
Quiero saber si es posible convertir números a texto en Español, Quiero enviar facturas con números y texto: ejemplo: 1000 (Mi ) ó 20000 (Veitemil) Es posible o algúna funcion similar dentro de zoho?
Zoho Api Question
Hey All, Have a quick question regarding parsing json. I believe my code is valid however it doesn't display a response when i search for specific key / value. I can however return the response->uri just fine but can't get anything other than that or the full file. function GetLeads() { $file = fopen("https://crm.zoho.com/crm/private/json/Leads/searchRecords?authtoken=API KEY&scope=crmapi&criteria=(Last%20Name:test)", r) or exit("Unable to Open File!"); while(!feof($file)) { $theData = fgets($file);
Include lookup field in function
Hi I have two forms (A and B) connected with a bidirectional lookup. I want to copy records from one to another including the value from another lookup (from form Country) which they both include. So far the function looks like this: void copyRecord(string First_Name, string Last_Name, string Email, string Profession) { insert into New_Profile [ Added_User = zoho.loginuser First_Name = input.First_Name Surname = input.Last_Name Email = input.Email
Total income calculation form
Hi , I wonder if anyone can help me. I have a job process form where by the user records a job undertaken, which calculates agains a job form. So there is a list of jobs complete in a report. I want to a separate form where the user can select a month of the year, and it will calculate the earnings over that period. I have attached a screenshot below of the "Job Proccess Form" which i would like to build this new form from. Thanks for your help in advance. Danny
Numerical format field report
Good Morning
I could collaborate, to know how to format numerical reports Zoho Creator. For the numerical field shows it without any format and I would like, if possible, to show it with scores of thousands, hundreds, etc.
Example: 1234567 see 1.234.567
Thank you for your cooperation
Add edit button to record summary
Hello, I have taken a look at these 2 posts https://help.zoho.com/portal/en/community/topic/how-do-i-create-a-link-to-a-pop-up-edit-window-in-an-html-view https://help.zoho.com/portal/en/community/topic/tip-using-duluge-create-url-field-with-dynamic-parameters-such-as-record-id But none of these posts solved my problem. When I click on a linked record from a record summary, I want to be able to edit that record in a popup view within the application. I've gotten this far temp_param = input.ID.toString();
How to get value of field in current record
Hi, I have a table called 'Classes' In that table, I have a field called "Class1" - it is a drop down field. On the action "On user action", I want to save the value that is in the field if a user removes that value. So, if the value in Class1 == null, I want to know what it was before it was removed and save that value in a variable. This gets me the value that is in the field before it was deleted. ctemp1 = Classes [ID == input.Class1]; How do I save that value though after the field value
Mobile app Zoho creator
Hi, Can the mobile app be customized like the web app? for example the layout or icons?
"?Terminal.Id="
What does the "?" in front of the "?Terminal.Id=" mean?
Alternate version of same data
Is there a way to display an alternate version of a data in certain layouts ? For example, I have a radio button field with two choices : Yes and No. In a "list" layout, I would like this data to show as Y or N instead of Yes or No (...or show as X or "empty"), but I still want the data to show as Yes or No in other types of layout. Is there a way to create an alternate version of this data and indicate which version to use in which layout type? Thanks for your help!
Pre-tick a check box in a form
Hi, is there a way to "default pre-tick" one or more check boxes in a form the same way you can "default pre-select" a radio button? Thx!
Enable and disable fields in a subform On Edit - On Load according to an other field value.
Hi Zoho, I have a subform and I would like to know if its possible to enalbe or disable a field "Quantity" according to an other field "Status" for different rows when I open the record to edit it. I was trying the following code, but I can't even save it. for each rr in Detalil_RC { if ( rr.Status == "Approved" ) { disable rr.Quantity; } } It says "rr" is not defined. Any help will be appreciated.
Retrieving zoho.loginuser variable using email address
I am trying to retrieve a zoho loginuser variable by using an email address so i can link only relevant information to the specified customer.
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
Next Page