Re: Lookup in a Subform
Hi, I am hoping that someone can help me with this. I have two forms: Enquiries Look Up Customer Name (Drop down) Look Up Contact Customers Name Contact (Subform): Name, Telephone, Email I am trying to make it so that when a customer is selected from the drop down, the Look Up Contact gives a drop down of all contacts for this customer. Any help much appreciated. Thanks,
Auto Number
Hi, I am trying have an auto number field that is displayed when adding/editing a record. Our reference numbers are in the format: B-879 and increase by 1 each time. When it gets to B-999 the next record is C-000. Is it possible to do this? Any help much appreciated. Thanks,
render a list of product records and create a new quote record
I have a requirement where I need to show a list of product records and allow the user to select certain product records using a checkbox and then create a quotation by clicking on a custom button. Can this be achieved with ZOHO creator?
Fetching Records
Hi, I have an enquiry record which records the receiving and quoting of an enquiry received from our customer. In this we have a subform which has a look up field which records which supplier we have usedand the value of their quotation. We have another form which for Suppliers. In this Supplier form, I want to have a subform that displays the previous 5 enquiries where we have used this supplier. It will display fields Our Ref.:, Customer, Date Rcd, Drop Down, Value (from Supplier subform). Any
Reset Counter Daily??
We want to assign each entry a date code with index. So each submission would look something like YYMMDD-[Index] I can get the YYMMDD-[Index] and i have the function working to increment the index after each submission but what i can figure out is how to get [index] to reset every day so each day it starts at 1.
Different effects of sign-on on different computers
I ended up with 2 computers. On one computer, when I upload a ZOHO database that I DO NOT want viewers to make changes, I get the normal top heading, with SEARCH, and on the top Right SIGN IN . Without signing in properly no one can make changes. JUST WHAT I WANT. On the other computer when I do exactly the same and upload, I only get SEARCH on the left and SIGN IN is not there , and even I cannot make changes. Can you tell me what is going on. And how I can make all of my several CREATOR databases
Error Form
The request was triggered by different origin ...??????
Search page and pre-populating values in form
Hey Guys, I have a form in ZC which is used for simple data entry process(name tf2 ). fields: Name Age Mobile I have another stateless form(name stateless) in the same application. Here I'm entering a mobile number and checking whether any record for that mobile number exists in my previously entered data (in tf2). In the stateless form, when user enters a mob. no and hits "Search" button, I'm redirecting the page to show the available records found for that mobile number using OpenURL script.
Customer Portal Customization
I'd like to change the text under the "New User" Sign Up link on the login screen, which says this: "Create an account and contribute to the community.", which is not at all appropriate for the application I'm building. Can this be done? Thanks, Len Len Kamerman Hero Technical Solutions www.yourcrmhero.com
Running a code within html progress graph
I'm trying to make a code that you enter the variable in HTML code, a progress bar, but when I run the code the varible remains the variable name and not as the result: Grafica1 = "step1 visited-checkout-step" <div class = "checkout-progress"> <ul class = "progress bar"> <li class = "grafica1"> <span class = "triangle2"> </ span> <a href="#"> <em> 1 </ em> Order placed </a> <span class = "triangle after"> </ span> </ li> I want to run the code and that it isinstead of to stay as the original. Grafica1
Cannot get "old" data.
In Edit|Verify, Script Builder still has a tab for assigning a value to a variable that says "Old", but the code it creates won't compile. Is it still possible to get and use the previous field values? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Time Zones
I've asked this question before, but I got no responses to my actual issue so I am trying again. I have multiple users who are in different time zones. I also have lots of date-time fields. I know how to determine what time zone a user is in. What I don't know is how to display the date-time fields accurately for the user who is viewing it. So for example I want user#1 on the east coast to enter a time stamp for the current time let's say 8:00 AM EST. I then want user#2 on the west coast to
Drop-Down Error on Subform w/ Mobile
I have an equipment leasing app. The main order form is the order "header" information (customer name, address, phone, etc.). A subform is used to record the individual items on the order. Two pieces of information are entered for each item leased - the item and the serial number of the specific unit that was leased. The application has a table with the serial numbers of each item (a child relationship to the parent of items). On entry of a lease, 1. The user selects the item from a drop-down
Not able to duplicate an application
I have created 3 applications in ZOHO creator. I am not able to duplicate a particular application only. All other applications I am able to duplicate except this one. Is there any settings issue? I am not able to understand. It does not give any error message as well. Please help. Thanks, Milind
How to manually set a file name when I click the pdf button
I created an html page and I enabled the pdf = true. I would like to ask you if there is any way when I click the PDF button and starts download the file to change the name of the downloaded file. I mean if I can manually set the name of the PDF file somewhere in the html page and by clicking the PDF button to set this name to the file
Email a PDF attachment to a specific existing record?
We can create a record with an attachment using the email template but is it possible to email an attachment to an existing record? Thanks...
Insert a report on a form / Record Summary
I have a form to input information on the company vehicles, maintenance and mileage and such. it keeps a log of the records and presents them in a 'record summary' view. \ i have a separate form for tool and item inventory, which can be assigned to trucks through a look-up field that allows you to select the truck number. i would like to have the items for the selected truck in the truck report 'view record' to show the items assigned to that truck. i though about putting the tool and item form in
Search Bar in Zoho SItes Form
hello im creating an onboarding form threw Zoho SItes everything is working fine but i want to know if there is anyway i can have a search bar in the form itself? i have all the companies in a drop down box but i want to be able to hide the companies so other companies dont click the wrong file in the drop box, i know i can use a single line and use if (input.Search = "Company Name") { show Venue4; } but you have to spell the whole word and corretly aswell, is there a way i can create a search
Mandatory Fields through script
hello im currently writing an onboarding form for work but im having trouble with makeing a mandatory field for certain companys but not others ive tried a different couple ways but im absolutely stumped on it if(input.Company = "Company Name") { if(input.First_Name = null) { alert ("Emergency Contact Required"); cancel submit; } } ive tried this and replacing null with "" and it still wont work please assist
hide specific column from attached view
Hello, How can I hide specific column like "upload file column" form view when I attached this view in email. without creating new report without this column. Regards, Omar
Calendar view ('Month' view) question
"Month" view: is it possible to freeze the 'Days of Week' pane/row, currently it scrolls up with dates. I realize that it can't be changed in the report/view settings. A question for developers? Thanks.
Enabled ZC Chat changes colors of the links to black
I have fields in some views that are linked to other views (lookup fields). The color of those fields used to be blue, but now they are black. They are still clickable. but they should be recognizable by color. in the view record they are blue. It happens only when the ZC Chat is enabled.I see that .authorChatPresence in a FF inspector when Chat is enabled. After I disabled the chat, blue color is back. I guess, this is a question for developers. Thanks.
how to create a form from script
I am new to Zoho Creator, I think the concept is cool, but the GUI is a bit clumsy and slow, and there are quite a few bugs. After spending couple of frustrating hours trying to create forms I will try to resort to scripting: When manually creating a form in creator there is an option to save as script. Lets say I edited the script, how can I use the new script to create a new form, where is the "load script" or "create form from script" command? Also, where can I find documentation about the scripting
Can I automate database so I set up one date and zoho calculate other dates?
Hey, I wanted to ask you and perhaps receive a few pointers on automating adding information to a database. Let's say I have a database that I input a main date. There are many date fields that I would like zoho to automatically fill based on this date. For example, the main date I fill is start of event. I would like to know how to make zoho automatically input date in other field, for example purchase a flight, which I want to always appear 2 weeks before the main date. Any ideas how I could do
Trying to customize image width in a list report
Hi there - I'm trying to create a customized list view of the records we have uploaded into one of our forms. Each record contains an image of varying width and height. I want to list view to force a width on the images so that it appears uniform when someone is accessing it. I can't seem to figure out how to do this, are you able to help? I've found ways to force a width AND a height to the images, however this causes a problem because it distorts the image and squishes or stretches it. Thanks!
Remove creator header from edit record custrom action popup window
I have a view with a custom action button that will open up a form and allow you to edit the form. I want this window to open without all the zoho creator header stuff (compay logo, creator tabs etc). Below if the function I am using. I think that there is another way to write the url that might remove the creator header stuff from the top of the popup window that opens but i do not know what it is. Please any help is appreciated. My function: void Quoting.editQuoteItem(int ID) { openUrl("https://creator.zoho.com/<zohoaccountID>/<AppName>/#Form:Quotes?recLinkID="
Create multiple records in blanc form
Hello, I have a question about the insert into function. I have three forms: Form A: containing the fields: Name, group and Number ; Form B: containing the field: Name, group and Number and Message; Form C (blanco form): Containing the field Group and Message; When I select the blanco form I have made a submit button with has to do the following action: Based on the selected group, it has to search in Form A who is in the selected group. It has to input the users who are in the group into form B.
Tracking historical data / trends with Pivot charts
Hi! I am having problems with creating pivot charts used to track historical data from forms that don't have a date in them. I spoke twice to Support but they couldn't help me, so I am posting it here. Let me provide you with two easy examples so you can see what I mean. Lets say I have an online store (which is true!). I have a form (Products) where I describe each product including the price and the total number of units I have in stock. I update manually the field with the price each time a vendor
Understanding Schedule
I am trying to wrap my head around the schedule feature in ZC. Say i have a Task table with contains Date Time when the task is due. I want to send out reminder email 1 day before the due date time. This schedule is good from 1/1/2016 to 12/31/2016. Under the schedule, there is a Start Date option. Is this the "execution start date" or the series start date (1/1/2016)? I assume it's the "execution start date". Am I correct? Now how can i specify this schedule is only good for 2016 only? Am I correct
Pass "input" as function call argument
How come I can't pass input as argument to function calls? A valid scenario is this, in On Edit-Validate, the input is the form before it's persisted to database. Let's say I have form called Company, input is of form Company. I have a custom function that uses fields inside Company to send emails. void mySendMail(Company c) {...} I want to be able to call the function in the following two ways: 1) mySendMail(input); 2) x = Company[ID== 2341252]; mySendMail(x); Now, because i can't pass input as
Drop down field, send e-mail on selection.
Hi, We have a form for members to submit a request to become a member. One of the fields is a drop down with status that the admin uses for approving a member. Status: 1. pending (default) 2. approve 3. inactive When the status changes to "Approve" we would like the system to send a welcome e-mail to the user. How can we do this? Thank you. Sami
Import data and populate source and url fields for an image?
I have an image field (set to link) in our db. Rather than adding records individually, we want to compile records throughout the day into an Excel file then use the import command. But, is there a way we can configure the data in the Excel file to automatically fill in the "source" and "url" fields in the image field? It has me stumped.
trying to get list to display in multi line field
this script returns a single value filed and I need it to display a multi field list. Please help!! a = TZ2WOD_Work_Order_Details [ID = input.Select]; zz = aa.TZ2WODe_Group_ID; bb = TZ2WOD_Work_Order_Details [TZ2WODe_Group_ID = zz]; input.Line_Item_Display = bb.Group_Name; Cheers, Larry
Recycling database
I have a need to create an online database of recycling partners. Each partner needs to be flagged with the recyclable items that they can accept. There are 12 top-level categories such as Paper, Plastic, Metal, etc. and each one has a bunch of subcategories for a total of about 400 or so. What I would like to do is to be able to enter the partner info, then select the top level category to expand it, and then check the boxes within that category for each recyclable that they can accept. It looks
Calling XML RPC API to add a record to a form with sub-form
I am trying to add records to a form with sub-form in Zoho creator using the XML RPC API in C#.NET application. I am getting the error below when using Web Request class to create the request. { "The remote server returned an error: (400) Bad Request." } I am using ASCII encoding and Content Type as application/xml. Can anyone provide me an example with C# code to make a call. Thanks!!
Migrating from Google to Office 365
Dear Zoho Team, We are migrating from our Google Apps platform to Microsoft O365, however we are currently relying on Zoho Creator and Zoho CRM for our support and sales departments. Before I migrate all of our accounts from Google to O365, how do I ensure that none of my Zoho services are impacted? We currently are using Google Apps federation in order to login to our Zoho accounts. Can you please assist me? Thanks, -Jaap
how to load a script into creator?
Hello Zoho, I would like to create a form manually with a script, to take a saved script and modify it, then load it as a new form. How to I load a script into Creator? Thanks.
WEBINARS
ANy new Webinars coming??
how do i enable sms?
how do i enable sms? couldnt find setting-add ons=
Record Summary Report - Multi Select Line Return
Is it possible to have a Multi-Select field ( ${MOE_Multi} ) to return each selection on a separate line in the Record Summary Report Example - Instead of results being display on one line as: Choice A, Choice B, Choice F Display on report as: (with a line return) Choice A Choice B Choice F
Next Page