Mass emailing after filtering
One of the things we're wanting to do with Zoho Creator is to run reports and then mass email. Example: Filter out the people who live in Dallas and send them all an email. Is that possible within this program? Thank you!
ZOHO UI Is User friendly or not
i saw all your webapps that was cool stuffs but your UI is not user friendly ,and lots of stuff you are dumping on 1 page is there is any reason behind your UI or you will develop Rich UI,
Can forms in html page be placed side by side?
Here is the code for my html page: htmlpage THIS_WEEK_Timesheets_and_SMSs() displayname = "THIS WEEK Timesheets and SMSs" content <%{%> <table width="1200" border="0" align="center" cellpadding="1" cellspacing="1"> <tbody> <tr> <td> <div elname="zc-component" viewlinkname="THIS_WEEKs_Time_Sheets" parameters here </div> <div elname="zc-component" viewlinkname="TimeSheetTexts_Report" parameters here </div> <div elName='zc-component' formLinkName='Paid_Holiday_Amounts'
Not showing the form when editing from views
If the report has a criteria like this: " Added_User == zoho.loginuser" p ointing and clicking a record should open the form to enable users editing, but it only shows the "close" option. If I drop the criteria (ie selecting "all records") the form is opened.
Embed the app
Well, I've read the forum here high and low but I can't seem to find the answer to this question which leads me to conclude it isn't possible or at least not in the way I'm trying to do it. Anyway, I would like to embed the entire app, not just the individual forms and reports... the whole thing with the panels and everything I've designed in my editor into my website. I've tried a number of different variations via the "Links > Embed in Your Website" but all that does is give me the link for the
Can't copy this application
https://creator.zoho.com/sampleapps/split-forms/# I am trying use the feature that is in the application but the system does not permit to copy... Any idea? Thanks
No login required for dynamically generated html page
I'm creating an application that generates contracts. The admin can set parameters that determine what is displayed on a html page using the record ID. This is very similar to the Order Management "Generate Invoice" function. My issue concerns the link to view the contract page that is included in the sendmail function. I have the sendmail functioning correctly and assigning the record ID to the URL (https://creator.zoho.com/<appuser>/<appname>/#View:Generate_Contract?orderRecId=XXXXXXXXXXXXXXX)
Help with geotag function
Hi folks, I'm trying to write a function I could invoke through a custom action to geotag my contacts. The idea is to pass the full address of the contact at the end of this URL: http://maps.google.com/geo?output=xml&q= The result from Google is returned as XML, so I want to grab the "point" returned by Google and write it to a string field called "Point" in the contact's record. Here's what I have so far: void display.geotag(int id)
{
contact = Contacts [ID == input.id];
gMap = getUrl("'http://maps.google.com/geo?output=xml&q='
Creator shared user can add records but not edit existing ones
My shared user of a Creator database can add new entries through a form but then cannot edit them because he doesn't get the 'Edit...' popup menu when he hovers over the entry in the list-format report.
Any way to sort list report by group by field totals
We have a receivables table that contains every transaction for any donations received by specific donors. One of the reports we have is where this information is grouped by the donor's name and there's a summary total for monetary columns like total amount donated. For example: John Smith donation# Total Amount 1 50.00 2 35.00 85.00 Sam Spade donation# Total Amount 1 1000.00 2
Form rendering error. Developer comment causing bug.
A Creator developer has left a HTML comment and unneeded carriage returns in the rendering of forms in Zoho Creator. This is causing an extra line to be placed between all elements unnecessarily. The HTML comment and returns are being placed in between table tr elements. This is a no no and should be removed as soon as possible. If you were wondering why forms look sloppy with extra white space, this is the reason. A simple change to the server-side render code would fix this, and have immediate
Search across all fields (or more than 1 field but with logical OR) and display Summary Record
I can't seem to figure out one thing: a) When I access one of my reports all fields of the database are shown there. I can search within certain fields by clicking on 'search' next to 'add': now above every field/column the search field is shown and I can enter a search in one or more fields (logical AND). Then I can view the summary record of each result by using the context menu in the first column at the very left. That's fine. However, I would like to: b) search one term across all fields and
Thumbnail
Hi, want to use the thumbail function explained elsewhere in the forum. When I write this expression in the formula field "<img src='http://creator.zoho.com/DownloadFile.do?filepath=/" + <UploadFiledname> + "&sharedBy=<Username>' title='" + "' alt='" + "' width='64' height='75'/>" save and then reopen the formula field editing window, the expression was cut to: "<img src='http://creator.zoho.com/DownloadFile.do?filepath=/" the rest of the expression was completely deleted and therefore the thumnail
Splitting a lengthy form into multiple forms (Problem with linking forms together)
I'm developing a registration form for our company and it has too many fields; I'm thinking of splitting the form into three separate forms (i.e. Contact Details, Skills and Services). I tried to link these forms together by pointing to a unique user_id field/variable in the first form however I need this linking to be done automatically and without the need for the user to select anything.The Skills and Services forms are stateless and would not store any data.Could you please advise what is the
Radio Lookup Field Shows as Dropdown
I am migrating a field called "Group" from a dropdown field to a radio lookup field. When creating this new field ("Group1"), even though I select the field type as Radio, it is created as a Dropdown (picklist). Even the form definition says it is a radio field.... Group1 ( displayname = "Group" type = radiobuttons values = data_profiler.Group[(Group.contains("Web") || Group.contains("Data"))].ID displayformat = [ Group ]
Signature in email notification
Hi, When I submit my form, I would like to send an email notification which would include the Signature image. Is that possible ? If I add the Signature field in the email (or in the view template), I get the name of the image file. Many thanks for your help.
I Lost my data after I changed the field to a drop down from a single line
I used a field as a "single line" to enter data for almost the whole year. I just recently changed that field to be a drop down and then when I went back in to view my "animal report view" the information previously entered is gone. What can I do to get it back?
File too large to upload
why don't we use some algorithm to reduce the size of the image, if size is greater than 1MB and let user upload the image and let him compromise on resolution instead of showing file is too large to upload ................!
Help me in a way to Hide or Show a field in a records report based on script condition of the radio button
I edited my original post because I felt it may have not been fully understood by the advanced users / SOHO support team. Hi, I am very new at using ZOHO. I am creating records with several radio button fields having two buttons (yes) and (no). I would like to show or hide (omit) these fields in my report/view records conditionally, depending on if their input was Yes or No. ***Any help would be greatly appreciated.
Documents in creator
I need to make documents available within creator, somewhat like the document feature in CRM. Can you please tell me how to achieve this. E.G. on any given record in creator I need to be able to upload multiple documents and allow users to download the same documents and upload their own. Your document feature in CRM looks like what I want from Creator. Thanks
How to send email from a new 'From' email ID in zoho creator?
Team, Zoho creator uses the admin email ID to send trigger mails. How can I use a different mail ID to trigger email in one of the application? Please guide!
Disabled field on grid view
Hello, Is there a way to disable a field under the grid view? On the guidance (grid view section) there is an example, please see picture below, on this example one column (category) seems disabled, like a read-only column, this is exactly what I would like to achieve. Can you please tell me how I can do this? Many thanks
Differente Information Form Application and Form Edit
Good day, I have a bug in my app, the name of some forms displays other name than the edit app. Support is enable App Compras e Inventario Form Subformpadd Fields "Requerido" "Enviado" "Pendiente" Form Shipping Field "Tipo Envio" on live mode it duplicates two times "Colaborador" Always in the App Bar Menu "Almacenes" should be displayed as "Crear"
Adding Doc/sheet links in Creator Dashboard
Hello, Is there a way to place links in Creator Dashboard to Docs and Sheets? For e.g. supposing I've created 2 docs & some sheets, I'd like them to be placed in the Creator Dashboard to make it easy for my users to access them without opening separate browser windows. Is this possible? Thanks.
Trying to Auto Populate error message
Hi I get this error message while trying to create an autopopulate - the SKUUnformatted is a alphanumeric string, I am not sure what BIGINT is. Thank you for your help in advance
Publish Report View - Public can still edit via "View Record"
Hi All, I have a report view that I have published so that it may be viewed by anyone I share the link with. I'd like there to be no edit capability from this view so I have set all options under "Record Permissions" to Hide in the publish menu of the report settings. This removes the edit/delete/duplicate options from the record menu however the "view record" option is still available. If a public user clicks "view record" a new window is displayed that now has the edit/duplicate and custom actions
Re-arranging forms in Zoho creator
I had a quick question about re-arranging forms for creator. I find now that the forms we have created should exist in a couple of sections to make the workflow cleaner. If I go into creator and create a new form I can place it under an existing section. However, I can't find a way to re-arrange forms which have already been created either into existing section, or under a new section. Is this possible and how it would be done? Thanks
how to do this
I am wanting to create a database to show the following: top 100 sales consultants, top 100 in points, show stats of order history, each level completed and moved to the next one, active or not active depending on criteria, Total commission earnings. Do I need to setup the forms according to the info on the webpages? Then it will pull the data from their when connected? As for the product displayed on the website, do I need to create a form that lists all the products according to how they are
Filter in a view embedded in a HTML View
Hello. I have a main HTML view that include some views. I pass in the url a filter to the html view (something like https://creator.zoho.com/....../#View:NEW_Week_Report?dateFrom=03-Mar-2013&dateTo=21-Mar-2013). Using Script Builder I embed some views in the html view. For example: <div elName='zc-component' appLinkName='myAplication' sharedBy='myUser' viewLinkName='myView' params='zc_Header=false&zc_SecHeader=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Filter=true&zc_Search=false&zc_Paging=false&zc_SumRow=false&zc_ColMenu=false&zc_Summary=false&zc_RecSelect=false&zc_AltRowClr=false&zc_SaveRec=false'>Loading
Employee Database with Skills
Maybe someone can give me an advice here :) I would like to know what is the best way is to do this. I am creating an employee database with forms: One form has all the employee basic data (name, birthday, join date, ...). In addition every employee has certain skills: java, c++, Windows, Linux, ... Each skill should have a different rating for each employee with 1-5 (1 = poor knowledge, 5 = excellent knowledge). Example: Employe 1: java 2 Windows 4 Linux 5 Important is: Finally there will be so
Uncheck how data is stored in creator
I created a form using creator. I used the default to store the data within creator... How do I change this option to save it in a reports table? I am trying find a way to uncheck the store data option... Can anyone help? Thanks
mass adding / registration users
hi new users add in next manner 1) register user as new user in creator.zoho.com via their email 2) each new user add in my app via share access how can i automate such operation for prepared list of users (more than 100)? for example, operation of registration of users
Search all forms
Hi, is there a way to search all forms to bring up details of a specific registration. Let me explain. I have 8 identical forms that each contain the same fields. There is vehicle make, vehicle registration, driver, mileages, service due etc. Each form has a different name. I would like to have the facility to search all the forms for a specific registration number without having to open each form. Can someone help me please Thank you very much
Automatic report sorting by hided column
I would like to sort reports by columns what are not showing in report.. is that possible.. How?
create relation between 2 forms on existing fields
Hi, I imported two forms from excel (table1 and table2). Now I need to link the two tables using existing fields but I do not understand how to do. The table1 and table 2 has field "id" to be linked. I've read this, but don't run: https://help.creator.zoho.com/Creating-relationship.html#Creating_relationship_from_existing_relations Can you help me?
Get data from reports into creator
Hello, How can I do a query on tables or views in my Zoho Reports account in deluge (from Zoho Creator)? Thanks David
Fetch Product list inside a QUote in zoho crm to zoho creator
Is this possible?
input text to search box
Hi, I am trying to create a URL link so when user click on the link it will open a specific page and input the respective field entry to the search box of the page automatically. Here is the details what I am looking for - - In the above screenshot you can see "FCC MVPD" link which redirect the user to the below link https://apps.fcc.gov/coals/forms/search/cableSearchNf.cfm So in the above link you can see several search criteria where I just want to enter the MVPD name ( here comcast) in the
Can you pass field filter parameters in embedded Form/Views in HTML Views?
Is there a way to pass field filter parameters to <div elName='zc-component'...> embedded forms in HTML Views? I thought it could be passed in the params property, but it seems to ignore anything but zc_ parameters. e.g. <div elName='zc-component' viewLinkName='Tasks_Dashboard' params='Project=parProject&zc_Header=true'>Loading Tasks...</div> Thanks, Walter
Lookup field returning strange values
Hi there, I have a lookup field drop down, pulling values from another form which are displaying simply as 1, 2, 3 etc. I want to use a deluge script to do certain things based on the value of the lookup field. However, when I get the value of the lookup field in a script, I'm not getting the visible value of the field (1,2, 3, etc) but getting another strange number eg. 1365899000000572499. Can someone advise how I can get the displayed value of the lookup field rather than this strange number?
Next Page