Copy lookup field text into single line field.
Im not really a noob but I defiantly feel like one today, Im pretty sure I've done this before but what I'm trying to do it populate a text field from the chosen result of a lookup field. This is the current code, Ive tried many but this is what I can remember. input.Nextjob = input.Which_Site_will_you_Attend_next; NextJob - Single Line Which_Site_will_you_Attend_next - Lookup Field I want to copy the result as shows in the lookup field which is primarily the client loaded from that form but
Understanding User Management and Counts in my Zoho Creator Account
1. Are external users with access only through the customer portal counted and billed for the same as shared users ? 2. I have 36 active users in my User Setup Page whose usernames do not always match that listed in the application's shared list despite having the same email addresses. Why? 3. Customer Portal users show up in the application shared list but not in the Zoho Account User Setup Page. Why? Zoho Account User Setup Page: "johnsmith" (App shared list below shows same username with additional
ZC Plugin for Word escaped characters
We've noticed that when importing Zoho information into Word using the ZC Plugin for Word, special characters in text fields are rendered using slash-escaped characters. Sometimes this causes information to go missing entirely. Would it be possible to modify the plugin so that it is able to take the text field content from ZC and convert it into a Word-compatible format so that it appears in the same manner as it does in Zoho?
Ability to view uploaded PDF files
Zoho Creator has lovely field types to design forms to allow users to upload a PDF, but that's about it. What we really need is the ability to be able to view these files.
creator drop down issue in ipad and iphone
hello, i m new to zoho. i couldnt see a dropdown list in my ipad and iphone when i could see it as a drop down in laptop. if i customise many in listing it shows as drop down but 3-5 options in my listing all 5 are shown which makes my form look bigger and complex.pls help me out
Pivot Table based on Form input
Hi Support, I want generate pivot table based on user input in a form. Example below. Form1 (Has below Field): Country: Section: No of sales: Form2: Country: No of Sales: When user select the fields in Form2 and click on submit, a pivot chart needs to show based on data from Form1. Your help is appreciated. Thank you.
How to add a new field to an existing form
Let's say that I have a form with a dozen fields and thousands of records. How can I add a new field to this form and import the new data into it? I have the data in an Excel file. The only way I can see to do this is to import the XLS and just make a whole new form, but this will break all the relations I've made with the original form. This seems like a simple and fundamental thing to do, but I'm not seeing it. Thanks.
Added_User in formula field doesn't work?
When I try to use Added_User or Added_User.toString() in a formula field, the end result is always blank. I can use ID ... how do I get to use Added_User? Thanks in advance for any leads.
Calculating the total amount of a subform is not working correctly
Hi I was following along the tutorials on zoho site. Link : https://www.zoho.com/creator/help/tutorials/advanced-app-building.html Section: SubForm Actions --> 3rd part. When I'm testing the calculation on my app, the first product that i select within the subform and I am changing the quantity the total amount is working fine, but when I add a new product and I put the quantity at 5 The total amount doesn't make any sense. I don't know if this is a bug or maybe I have did something wrong on my code
Comment form
Hi Is there anyway to add a comment form to embed in my website similar to the one found in blogs which gets updated automatically when a viewer comments?
How can I display the records from a form in HTML page by Month or Year?
I have an application that processes salary of employees and I need to create an HTML page to shows the records with details monthly of the processing. In there page must conste the details of the organization and other information, but the data must be showed monthly selecting the month in some field of type "select". I've tried to embed the Salaries's Processing report, but it don't work like I want, because, when I print the page the other informations of HTML page don't appear. Please, help me.
Loockup
How would you use Loockup when you select and search for data from another form? so i need the code
Unable to update template variable.
Hello Everyone, I'm experiencing the following error when using getRecordsbyId. Here is the code, see attachment for error as well. Not sure what the deal is. It seems to be only an issue with this type of look up. I've checked the forums and there doesn't seem to be a fix. Any help is appreciated, thanks. if (input.Lead_Id == null) { alert("You must enter a valid lead Id."); } else { crmResponse = zoho.crm.getRecordById("Leads", input.Lead_Id); }
Drop down selection creates a record in another table
Hi All, Is there any way I can have the selection of a drop down list create a record in another table and auto populate certain fields ? Basically to forms with associated tables: Main form is BAU Request and the fields in question are: Service Requested Product Type Serial No Asset No. The second form is called "Repair Ticket" and has the following fields: Product Type Serial No Asset No Basically on the BAU Request form, if someone chooses "Hardware Repair" from the "Services Requested" drop down
Adjust height of Line chart
How do I adjust the height of a line chart? It is taking up my whole screen.
Download apps created with zoho.
HI, I'd created 3 applications using zoho creator. I want my wife to download one of these apps to her iphone, without having to use the zoho creator app, as it gives her access to the other apps, which is not the point. Can you please tell me how to do it? Thank you.
Is there a way to add a color chooser?
I really need to add a color chooser option on zoho creator is this possible? k2thex
Differences in CSV data from manual export and API export
Hello. When I export from a report in CSV format, I get data from lookups and subforms as desired. But when I try to get the same report via API, I get IDs for lookup fields and for subforms (i.e., if my subform has 3 lines, I get 3 IDs). Is there a way to configure this in order to get the same result aI get from the manual export? Thanks in advance.
Breaking loops
Hi Zoho and everyone, how can I create loops based on variables? for example: Date = zoho.currentdate(); End_Date = zoho.currentdate().addYear(1); for Date<End_Date { ........ Date =Date.addMonth(1); } ? Thanks! Ravid
Send Mail with Mailgun
I would like send mail with Mailgun. Anyone could help me? I think to create a function that read from a record "To", "Subject", "Text". Mailgun c# code is this, how can I translate it in Zoho Creator? public static RestResponse SendSimpleMessage() { RestClient client = new RestClient(); client.BaseUrl = "https://api.mailgun.net/v3"; client.Authenticator = new HttpBasicAuthenticator("api", "key-bfac6e09124785239032fbae930fdd69c"); RestRequest
Custom Action openUrl function open in new window
Hello, I have scripted a custom action to openUrl but when I click on the action, it replaces the current page with the URL. How can I make the URL open in a new window? I have used the script below void openUrl(string Email) { openUrl("https://mail.google.com/mail/ca/u/0/#search/from%3A" + input.Email + "+OR+to%3A" + input.Email, " New window"); }
"Dont round if null" within the same script
This is the script that I'm currently using. input.Amount_1 = temp.Amount_1.round(0);I would only like to invoke this expression if temp.Amount_1 != null I have (10) amounts to do this to, so writing an if and else function for each one would be cumbersome. Is there a more simple function that will only round the number if not null ?
Determine file size after completing an upload
Is there some way to determine the size of an uploaded file using Deluge? My app will allow file uploads and I want to measure and limit the space my clients can use for uploads. These will be Customer Portal users. Thanks, Marcos
Can't search Zoho CRM records using DateTime field in query
I'm trying to use the zoho.crm.searchRecords() function. void searchCrmDateTimeField() { query = "(Zoho CRM DateTime Field Name|=|" + zoho.currentdate + ")"; todaysRecords = zoho.crm.searchRecords("CustomModule1", query, 1, 200); info todaysRecords; } The result: {"4500":"Problem occured while processing the request"} I have isolated this problem to searching date-time fields in CRM. I can perform the same search on a date-only field and get results back. This is causing major limitations in how
Check for Submitted Form
I would like to check each morning for a form submission due but not yet submitted. I have a list of people who are required to submit a form for today (Monday through Friday) by 9AM the next day. They are asking for a reminder to be generated at 7AM if they forgot to submit the form yesterday. I will use my SMS function or Sendmail to send the reminder. The people submitting the form choose their name from a filtered lookup to a separate application. The form has Date_field which collects the
Column Total in Spreadsheet view
I would like to know if there is any way to display the total of a column in a spreadsheet view. In other views like List it is possible to show the total,max, average etc.
Custom Action button to filtered Report based on Field Data
Hello everyone, I started using Creator today and found it great for an outgoing proyect. I have been reading doc but can't find a simple explanation to this. TLDR Im developing a real estate app. Have a form with Buyer data and specifications (ex. property type, betrooms, etc). Have a form with Properties list. (Type, betrooms, etc) I want to create a Custom Action button on Buyer report to create-show for example a "print" view of the report filtered by buyer specifications on the Properties list.
Mail Merge with Zoho Creator
If you are looking for an easy method to create a Mail merge of the Form data you have, please use send mail task. Check out https://help.creator.zoho.com/Send-mail.html Creating Advanced Mail merge process (to generate PDF of Form data) involves the following components in Zoho Creator. It becomes mandatory to have some basic ideas about them. Data View HTML View/Page Fetching records from the Form Functions Custom Actions 1. Create a Data View: Data Views in Zoho Creator are used to display the
zoho creator download images
Hi, I need to download the image when exporting to excel or pdf. The link that currently provides is not usefully if I cancel my Zoho account.
Manually edit preexisting entry in lookup field
Hello, I am aware that in a lookup field i can "Add New" entry. But is there a way to edit a preexisting entry within the parent form?
Record summary taking up whole page
Hi! I use a report in a calendar view, and I was able to click on a record and see the summary on the right side of the page. Now when I click on the record, the summary takes up the whole screen. How do I fix this? This is how I see the summary This is how I would like to see the summary
internal short code for fields
hi! there is a big amount of code that changes field_A value in form via workflow rule. and there are about ten other fields where this "big amount of code" exists and repeats. if a value in one of other fields changes - changes value in field_A value because in workflow rules of each other fields there is "big amount of code" sometimes it needs to make changes in "big amount of code". so that it needs to change same codes in workflow rules of every ten other fields it is too complex. how can i
This application is not accessible
Dear Sirs, I have Develooment ''licence'' and just created an app, but I even can't access my own app? Help please! RG Luke
Zoho Creator Application is Crashing on Android
Zoho Creator is awesome on my Apple Device. My colleague's Samsung Galaxy S6 is crashing when using the Application. Images are undersized and and will not enlarge when I press on them on his Samsung. This has provided me with a great deal of fuel to tease and ridicule him for not buying an Apple. I was wondering if the Application has a history of being unstable on Androids and if an update is coming that will rectify this in the near future? Thank you for your help. We are very pleased with Zoho
Send record summary by email
hello, how can i do to send my record summary by mail with a custom action ? thanks you
Problem duplicating / downloading ds files
Hi Zoho, When I click on "duplicate" on my dashboard to duplicate my app, I get a notification "duplication" but then it dissappears and nothing happen (no duplicate is showing). Ravid
Sub Forms updating Sub Forms
I have created a bunch of forms as a data layer 1:1 without considering dependencies. My plan was to use sub-forms and scripts to manage dependencies before a submission... Let me explain. <Form Start> <sub-form-1> Section 1 > A bunch of input required (no dependencies) <sub-form-2> Section 2 > A bunch of input required (no dependencies) <sub-form-3> Section 3> Input required but must have a 1:M relationship to input from <sub-form-2> etc... all the way down the list until...{ In between the
Criteria for 1 record associated with 3 forms
Hello! I have to manage event information, and I have been struggling for days on how to develop a script that pays contractors for each event in a certain way. I have 3 forms ADD (contains info about event. Ex: date, type of event, contractors, etc) Contractors (adds a new contractor) Pay_Contractors (a form that pays the contractors for each event) I created a custom action button for the record summary of ADD. I would like to openURL for each contractor that is assigned to the date of ADD, AND
"Where used " for a field
For any field in a Zoho Creator Form, I wanted to find out where it is used: in functions, workflows, custom actions etc... how can this be achieved from the developer side ? can you add this function for us developers if this does not exist today?
Drop down picklist populated from web page or google sheet
Hi there, I am experimenting with Zoho Creator to build a very simple physical asset library, and am new to Zoho and don't have any development skills. So any advice very gratefully received! I want to check physical media in and out, and to attach some basic details on an online form. One choice that I want available when filling out this form is a 'project' to attach the record to. The project numbering is defined from a project management system (Teamwork). A list of projects can easily be viewed
Next Page