Send email to multi select fields
I have to send email to checkbox if selected, how can i do that? if i put input.Email_Copy_of_setup_to == "email list" error in return
Adding notes to a form!
Is there a way to add to a entry i have already saved, without updating the original form i made for example if Mr smith bought 100 apples on Monday and i have logged that. Then on Wednesday he says they are bad, i need to be able to go to his entry and add a note saying this.
Group multiple fields as variable
Hi, I was wondering if there's a way to group multiple fields as a single variable. For instance, if I have a form that has these billing and shipping address fields: Billing_Name Billing_Address Billing_State Shipping_Name Shipping_Address Shipping_State and Shipping_Same_As_Billing it would be great to define, somehow, Shipping_Fields = (Shipping_Name, Shipping_Address, Shipping_State) if (Shipping_Same_As_Billing) { hide Shipping_Fields; } else { show Shipping_Fields; } Instead of
Subform Drop Down Field Width
Hello everyone, This is one of the most common form fields - a lookup to another database referencing products/services/products etc within a subform. However, as it stands now the width of the look up field is extremely narrow and even though there is a horizontal scroll bar on the bottom of the drop down users have a VERY DIFFICULT time selecting the correct record. Please try to address this as soon as possible or as a quick fix until they can be customized just increase the default width....
look up field or drop down with numbers
Is it possible to have a loop up field or drop down with numbers and then work with those numbers on a pivot report. Right now even If I have a look field as number on my pivot is reflected as string and I cannot work with those numbers. see my attached
Center the data in Reports in zoho creator
Is there anyway to center the data on the columns? The current is too much left align
count() is automatically replaced by Zoho platform with count(null) in html views
In a html view I have the following code: <%=users[ID>0].count()%> When I close the edit mode and open it again and return to the view, the code above appears as <%=users[ID>0].count(null)%>Of course, if I try to save the html view, an error is displayed "Field null does not exist ... " So .count() is automatically replaced by Zoho platform with .count(null) - which is a wrong syntax . Regards, George
Manually empty an upload field via script?
I have a file upload field that is hidden or shown depending on whether a radio button is checked as "yes" or "no". That is simple enough to do: if (Radio.contains("Yes")) { show File_upload; } else { hide File_upload; } But, along with hiding the field, I also want to flush it of any files the user may have uploaded, since he could possibly be doing that by accident, and after realizing it, chooses not to click the "[remove]" option next to the field, and instead
Any way to get Minimum Date in a Creator report?
I'm trying to figure out some way I can use a minimum aggregate function (or conceptually comparable approach) on a date field in a Creator report. If there were a Min/Max option like there is for numeric fields in a basic list report with grouping, that would work - but there's not. I tried to use a pivot report, but date fields do not appear to have a min/max calculation option here either. Is there any way that this can be accomplished with reports (I know it can probably be done with custom html
Validate Textbox with scripting builder
hello friends I try to validate a textbox, using a for ech. So i have hte next example: 1.one form that contain a textbox (user) 2 the second form contain different field, dependencia grupo user valor I need to find the textbox's value of the second on the other form, that contain diferent data. I used a for ech y the FORM ACTION validate, but it does not execute nothing. thanks for your help. regard Jorge Caro
Hide form fields from users who are not logged in to Zoho
I have created a form within an app I created using Zoho Creator with numerous fields on it that I don't want non-zoho app users to see. I set these fields to "Admin Only" in the form builder so that now only I (as the admin) can see/edit them from a view when I'm logged in, but I want to be able to invite others to login to my app and see/edit them from a view who are not admins. Is this possible?
Update Lookup based on Dropdown selection
I have a stateless form with a lookup, dropdown and a number of single line fields The form currently works with the lookup pulling back an object when an item in the lookup dropdown is selected, this then populates the dropdown and single line fields with values in the data repository. I'd like to improve the form by allowing a pre-selection in the dropdown list which acts as a filter on lookup. Is this possible?
Export to Excel template
Can anyone tell me if / how I can export a report into a pre formatted excel spreadsheet? I want to be able to manipulate the report using VBA and macros....anybody help?
New to creator - help needed
I am creating a booking form to go on my website. I have a number of questions I have created a client database and want the cient to be able to access the booking form without them having to enter their details or see the names of my other clients. So far I am using look up butthat shows all my clients. I also want the client to see a calander showing dates of their bookings - I dont need to see time as the service I offer is restricted to anytime on a day and is not time sensitive. Can anyone
Zoho Creator Lounge - Whats cooking?
We have a few avenues from where we reach out to our users. An all formal blog portal at Zoho Blogs where we make the high profile announcements and the Forum which is our 2 way communication platform - our users voice their opinions, ideas, suggestions etc and get help from us and other power users when they are stuck up at some place. We felt that other tiny announcements, geeky tips and tricks, ways and means to make any application jaw dropping, informal posts – bordering on technical stuff
can i insert data in subform (Blank/Inline subform) by code???
I have a parent form with a subform. The subform is called "conceptos". i am trying to copy records from parent form, but i can not copy the subform data. i am using this code: propuesta = formPropuestasProveedor[ID == idPropuesta]; //-->The record that i want copy insert into formPropuestasProveedor[ codigoProveedor = propuesta.codigoProveedor codigoPeticion = propuesta.codigoPeticion proveedor = propuesta.proveedor letra = propuesta.letra conceptos = propuesta.conceptos //--> the subform data
Form doesn't show in browser
A small percentage of my users say that my form doesn't appear on their view of my webpage. My form may be viewed at http://www.jaxareagolf.org/index.php/meeting-notice/. My form does use some deluge script. Can this be a browser issue? It shows for me in IE, Firefox, and Chrome. Is their anything I can suggest to my users that they may try? Barney
RFP for Vendor evaluation
Hi, I'm looking to implement IT software and would like to invite vendors to respond. I'm going to put list of questionnaires (which can be designed through zoho creator) with different forms & pages I'm planing to notify vendors to direct to the zohoform, so that they can login and update the information - They should be able to save and come back at a later stage to edit (obviously need to create user) - They shouldn't be looking other vendor responses (restricted to their own entries Can
Failed to Update data
Trying to save and it won't let me, everything I edit gives me "failled to update data.." messages, please help!
Limited editing for users
I want my users to be able to edit their data entry without being able to edit the application. How can I achieve this?
Mandatory attachement
Hello, how to force the user to attach a file to validate the recording? Regards,
Cannot figure out how to fetch data from a subform field (on_user_input)
Hello, I am a new to Zoho (just bought the license) but I am an experienced programmer and database developer. Yet I could not figure out how to fetch data from a field in a subform. I am following the documentation, in my subform, my lookup field execute a field action script on_user_input. The goal is to fetch an unit cost for the selected product - very basic stuff ! So my script is the following: selected_ingredient = Ingredient_form[ ingredient_name == row.ingr_name ] ; Ingredient_form = name
Problem to join a group when account was created through Google (federated login)
Hello, We have users in Zoho with federated accounts (Google login). In creator i created a group and added the users I wanted to join. They received an email invitation to join the group, but they cannot proceed with the invitation request since they have to log and only an username/password is asked. They cannot log with their Google federated login credential. Is there another method?
Record Limit Workaround
I'm working on an app for a client that holds practice SAT tests. They want the app to be able to create and store 200 question long tests for up to 100 students (currently, although they plan to expand in the future), and each student may have up to 5 different tests. They also want the app to include a variety of Zoho Reports showing breakdowns of statistics about types of questions, responses, and so on. Right now I have it set up so each separate question on a test is its own record, as is each
Email Notification via custom action - Urgent Request
Hi, Is it possible to send email notification via custom action for a particular record and include user submitted data template (custom record summary) as pdf? Please let me know your answer at the earliest. Thanks! -V
Help required field (mandatory)
HI I have a required field that is hidden. But when I send the form I got an error because the hidden field must be filled. How can i do? Thanks
I need help in report.. Formula Field Logic
I'm using 3 formula field. One time commission, Monthly Commission and Grand total (total of 2 ) It is working but i need to ask what if One time payment is Paid, How can i put logic to formula field that it will not add The onetime commission to the grand total and it will just show a 12usd instead of 232usd.. please see picture pelow One time Commission is made up of 2 number fields Monthly Commission is made up of 2 number fields Grand Owe is made up of 4 Number Fields This is what i want
Anyone know the Zoho Invoice Status Codes?
If I do a call to Zoho invoice and want to return the status of a particular invoice, all I get is a string number as opposed to the actual written value of it (i.e. "5" for "Void" etc) I've been searching far and wide, but have yet to find a resource that contains the translations for these... so far I've been able to extrapolate two and script them like so: i = Invoices [ID == c.Select_Invoice]; s = zoho.invoice.getInvoiceInfo(i.Inv_IDN); st = s.get("Status"); if (st
Issue with Summary View- urgent
Hello, I have an urgent issue which has recently occurred on our Zoho Application. I have two or three views set on 'Summary View' which are no longer viewing correctly. Results columns are out of order from where they should be. Please see this view for an example: https://creator.zoho.com/rachelogg/kiwioz/#View:Job_list_UK For example the result for the Job ID field should be MF1D (it is correct if you view in "List" view) however instead in summary view it says UK- London South. Please advise
Print PDF
Hi, I want to capture some details in Zoho Creator form and on submit, it should print 2 copies of data, 1 of the printer can be Google Printer. How is it possible? Any Ideas?
Subform and Mainform relationship when using creator remote api
I have a main form and subform with subtotals the subform. If I want the main form to be updated when saving a record to the subform, where do I attach the script? I realize 'On user input' when I'm using the web interface, but where do I place the script when I'm adding records through the API?
Adding the totals from two reports
Hello, Does anyone know if it's possible to add (and subtract) the grand totals from two reports? I have two reports, each showing totals of the figures for a list of stock items. Both reports show totals of the same items... one is stock in and one is stock out. What I'd like to do is deduct stock out from stock in to give me a running total in a new report or page. Any help on how I might set this up would be appreciated. Many thanks.
Fields don't update on edit
This is listed previously in the forum under "field don't update" with no solution. Major portions of my application are broken and this is causing huge delays. Very simply: Technology_text=input.field_of_technology.toString(); this works on initial entry, but does not work when re-entering a form in edit. The string goes to an invisible field and comprises the data we are collecting. Production is at a standstill, and all the work done in the last week will need to be reviewed. This is a MAJOR lapse
Need to pull data from multiple tables into an HTML Page
I have a database containing student data. Within this, I have an html page to display (and allow staff to print) data from 15 tables. These tables are linked via a FullName lookup field. There are multiple I have created an html page and now need to: 1) Insert the zoho creator field names into relevant sections 2) Create new rows where needed to display multiple records in sections (eg My Family Contacts, My Daily Requirements, etc). 3) Enable users to be able to filter the Student
creator auto backup?
Hi how can i turn creator app to regular auto-backup ? for example 1 time every week
Possible bug with drop-down field (picklist) created with UI:ADD when editing an db entry?
I created a form with a drop-down (picklist) generated from a call to a Zoho Invoice account. I run the form, add a few entries. (see image below the Client drop-down is generated using an Zoho invoice API call on Contacts and populated using the deluge UI:ADD() ). The bug is when I edit an entry, the drop-down value is not selected. The form show the drop-down and below an input box with the value. If I edit any field other than the drop down and want to save I will get an error message (Invalid
Wrong criteria search on system fields for today ?
hi just make new view for working app there is about 26 today entries but with criteria "Added_Time == today" system finds 12 entries and with criteria "Modified_Time == today" system finds 0 entries in all entries report for today (for example) are 26 entries how can i make criteria field to view current today's entries?
Option to prevent search engine indexing of public views
I make a lot of use of public views that clients access via a url we send them. The url has a filter parameter so that they only see there own data. Ideally, I would very much rather this data was not indexed by search engines. An option to do this would be fab.
Zoho Creator send Email with rows attached
I need to send an email to each user with all the rows in which they have been assigned. The idea is to send a mail per person every Wednesday with all rows belong. How can I do it?
Stateless form issues
This is almost copied out of the examples with changes reflecting my forms. I am trying to create a stateless form so that when cnumber is selected it will display name and account as well. But somehow the script yells at me whenever i try to save it and i get this error with a long list of what it was expecting...including that it was expecting "form" hmmmm. I tried form = Transfer and it didn't mind that but it didn't like { Encountered "form Transfer" at line 1, column 3. Was expecting one of:
Next Page