Record limit reached - count inaccurate
Hi, I am getting the record limit reached error but am certain I have not reached my limit. I am trying to import data that keeps failing. However, I think the record counter is increasing even though no data has been loaded. I have topped up my account and attempted to load data again but it failed. However, the "Records Count" went up by 740 even though there were 860 records in the original file for import. When I go to the view, there is no data. In the past, I kept topping up more records but
How to Display Data in the Following Manner
Sorry the title is not too helpful. But I need logic help. I have the following two forms: TERMINALS - Terminal Name - Cleared Carriers (this is a multi-select lookup field) - Zone CARRIERS - Carrier Name - Setup: Terminals (The bidirectional lookup of the field above) What I am trying to do: I would like to generate a report that shows all of the unique (distinct) carriers in a zone. TERMINALS.Zone CARRIERS.Carrier Name 1 CARRIERS.Carrier Name 2 CARRIERS.Carrier Name 3 CARRIERS.Carrier Name 4 CARRIERS.Carrier
How to combine information in a grid with 2 fields into a single column?
I need to put both the information from the drop down box and the information from the text box and put it into a single cell on a grid. how can I merge the information from both? Thanks, Fraser
Sub Form lookup field width
Hi, I have a sub form with a lookup field. When I view the sub-form through its parent form I cannot adjust the field width of the lookup field, how can I set it to be displayed wider? thanks
Application
Hi sir, I have created a sales application in zoho trial version, yet 1 day for that version . So i want that application in another user in trial version,Becoz i want to knw abt this application more .please help me to solve this problem
Look Up & Complete Fields
I have been trying to figure out how to use the lookup field where once the data is selected other fields from that database are also added. In other words, If I have part #, Part Name, desc & price. If i lookup part number, all other fields for that part will show up with it. Its probably right in front of my face but I cant find it.
Possible to copy a stateless form?
I know I can create a form using a Form as a template. Can I duplicate or clone or copy a stateless form?
Populate field value based on View/Report
I have 1 form, with 3 reports/views. If the user uses View A, I would like the value of Form1.FieldX to be populated as "Blah" If the user uses View B, I would like the value of Form1.FieldX to be populated as "Blick" If the user uses View C, I would like the value of Form1.FieldX to be populated as "Brack" Can I do that, and how?
Are workflows triggered on customer portal
Is "On Success" script triggered when the record is modified on the customer portal?
Reg retrival of data
Hi all Am new to zoho and actually planning to create a APP for my business and have been working in that for days and have lot of query now.so came here for help q.1 I need to how to populate one look up field with data, which is actually not in this form already for example LET FORM-1 have a field called GC number Let FORM-2 have a Look Up field of FORM-1 with GC number. Here i want form-2 lookup field to display records which is already not entered in form-How do i do that. Q.2 In one form 1 ,
How to prevent hackers?
I am publishing two forms and embedding them in my Google Site (soon to be made available to the public). I want to make sure I take all necessary measures to prevent hackers from gaining access to my database. I am concerned that someone could insert HTML or other malicious script into form fields to break in. I considered using getAlphaNumeric() to strip all possible scripts but that would disallow me from using special characters. I noticed that if I try to input the HTML script <br> in the name
how to send a group email?
Hi, I'm not good at sripting. I need to send an email to all customers in my Customers database. How do I do that? Please do not just tell me to use Fetch and Email scripts. Please provide details, as much as possible, best with examples scripts. Thanks
HELP
Hello I have a question, I want to add my total Subform "Recibo de Gastos" and add up the totals appear in the "Totalde Comprobación use is script is correct? Recibo_de_Gastos.Total11 = (input.Recibo_de_Gastos.Subtotal + input.Recibo_de_Gastos.IVA + input.Recibo_de_Gastos.Otros); input.Total_de_Comprobacion1 = input.Recibo_de_Gastos.Total11; for each order in Recibo_de_Gastos { if (input.Recibo_de_Gastos.Total11 != null) { input.Total_de_Comprobacion1 = input.Recibo_de_Gastos.Total11;
Stateless -> insert into FormA -> Field Actions don't happen?
A stateless form has script that inserts a row into FormA. Very cool. FormA has script in Field Action -> On User Input. But, when the data comes in via the Stateless Form, the Field Actions don't kick in. Should they? Or, do I need to fetch the associated values before I do the insert into FormA???
Zoho Calendar Delete API
Is there a way to delete a calendar event via the API?
can't make page private or limit to certain users???
i have been using creator for 4 to 5 years. i have always been able to share to certain users only the three items ( forms, reports and pages ( used to be html) . The new app builder works fine for forms and reports BUT DOES not obey my share for pages. No mater what i do ALL pages are public requiring no sign in????? please help?
Formula does not refresh
I have the following formula "LP." + Project_autonumber, where Project_autonumber is an autonumber field. when I create a record it works fine but when I subsequently edit the record the data value changes to eg LP.null any ideas why??? thanks in advance
Summary View with only 1 label
Is there a way to have the summary view, but only have the field labels appear once, frozen at the left? For example, if I have models of cameras, and I want to select several of them, and view them in Summary View (to compare the many features, side by side) Alternatively, is there a way to script a pivot view of the data, when it has non-numeric values? The Pivot Table doesn't work since the data being compared is not numbers.
Report Settings: tell us the Section
From the Report Settings General screen, I would like to know which section the report resides in - Without that info, I need to navigate to Settings->Section - and then search for the report name. Also ,for apps with lots of sections and reports, I would like the Settings -> Section interface to be easier to navigate; perhaps via tree component.
Subscribed, and now I'm locked out!!
I finished my trial, decided to commit, subscribed.... and now I cannot access my database!!! Any suggestions?
HELP SUBFORM ACTIVE
Hi! Someone can help me fill in fields with a subform where the main form fields are lookup´s
Replace function
I have a field called post code I want to do 2 things 1. If the user inputs the post code as DA81HG or DA116DF I want to convert these to DA8 1HG and DA11 6DF 2. I want to be able to convert DA8 1HG to DA8+1HG for google map purposes. Cheers for any help.
zc-footer
How do I edit what is displayed at the bottom of all my creator aps? Live example: Page source: Cheers, John Whitney
Comma-delimited list in Deliuge
Child form has fields for State, City: Example Ohio | Akron Ohio | Toledo Ohio | Youngstown I want parent form to show: State, CityList Ohio | Akron, Toledo, Youngstown Can I script that with deluge and how?
SubForm Limitations
I understand that a sub-form's deluge scripting don't happen when data is posted. I'm finding this problematic, but surely there are work arounds.... 1. Can a script run separately to do the necessary updating (eg, updating fields with related values) 2. Can data in a sub-form be shown in View Only? So that the data is posted by other reports, but I can still see a master form with its related sub-form information? 3. Do you create buttons from the parent form, that open up child forms? It's
Field Setup
I have created a application in sales management.Its a Property Management.So I created a property entry form.I have a apartment name field .My requirement is i entered apartment name, then address filled automatically.
External connection from Tableau
I'm using Tableau software (www.tableausoftware.com) for all my reporting and data analysis. Is there any way I can make an external connection to my Zoho database from this software or is this planned for the future?
Fetch record
Hi guys, I need fetch record that match the criteria of total of request submitted for day are < 100 and alert that which is the first day with less than 100 request submitted. How can I set a complex criteria that collect Day = input.Day < 100 and then return first day available? I try some count function and expression without success. Any suggestion? Thanks Mike dayavalaible = Form [ID != 0] sort by Day range from 1 to 1; dayavalaible1 = dayavalaible.Day; alert("First day avalaible"
Control column width of fields in sub-form
I know how to control the column width for columns in a list I know how to hide columns in a subform How do I control the width of columns in a subform?
Date Expression help - Next_Day(date,weekday)
For any given date, I need to know the next Sunday date - for example, in Oracle the formula would be: NEXT_DAY('18-JUN-2014', 'Sunday') would yield June 22 2014 I could create a lookup table with every date, and the corresponding Sunday, but I prefer to create a formula. Any suggestions?
Emailed data to Form, Captured Attached Images, Need to Update them to Image Field
I have successfully emailed data to my form using it's unique email address. This is a great feature. I have also captured the images attached to the file using the ZC_file field name. What I need to do now is update another forms image field with the above captured image files. I've tried using the update deluge script but the image field is not updated. See below entx = Entries[Entry == input.Entry && TrialID_Entries == input.TrialID_Entries]; entx.Image_1=input.ZC_File0; entx.Image_2=input.ZC_File1;
Phone Number
Hi, I have created a number field for phone number my no format is :943848343812 but in zoho creater phone show like this :9.940057402E9 How to change this format.
creator formula for lookup value
I am using zoho creator and doing some really cool things with the formulas, one thing i am stuck on in creating a field with a number from data I have added, for example, my input field value would be something like "54" - 1372mm" but i would like a filed to look at this and automatically enter "1.372" also it would need to also be able to convert "30" - 762mm" to give a response of "0.762" ... many thanks for looking at my post :)
Update value in subform before submit
Hi I want to put numeric values in a sub form and total up the values in a separate field before pressing submit. For example i have 3 fields called Size 1, Size 2 and Size 3. a fourth field called Total of size. When i use this as a sub form i want the total to get updated as i enter a number in size 1 and than that total to get updated when i enter another number is size 2 and so on. Thanks
Hide/Show based on values from Checkbox field
Options is a checkbox field, with Option1, Option2, Option3. Based on the selections, I want to show or hide the subform fields (named Option1, Option2, Option3) This is what I tried but doesn't work: if (input.Options contains "Option1") { show Option1; } else { hide Option1; }
@Martryl: Autofill Subform sample
thank you for sharing your Autofill subform sample. I've learned from it and can reproduce it for my application - however, I have a question. If the user selects Vegetables, the sub-form is loaded with the single value of bean. If the user changes the selection to Fruit, the child form RETAINS the value of the Vegetable, and ALSO adds the fruits. That might be nifty in some instances, but I would like the child values to go back to blank if the user changes from Vegetable to Fruit Can you (or anyone
toLowerCase Problems
My application includes several forms which each ask for the users name and email address. The email address is used as the identifier to cross reference records on all forms for fetching data and lookup fields. Everything was working fine until I realized that is a user inputted their email address with different capitalization, the scripts would not be able to match up their records because strings are case sensitive. I looked at these hep articles <string>.toLowerCase() and Built-in-functions
Not a valid currency error
My client reports: I continue to experience errors when attempting to import currency from my excel files. The issue began about 4 weeks ago. Previously, for the past year, I never had an issue. I have not change anything in the excel files we import from. Seems Zoho has changed something. I am having to edit 9 excel files each week so the Zoho application will accept the import. Then I have to change each excel file back to its original format so I can email to customers. Wow, what a pain! He
Column does not show as option for report?
I have attached screenshots for reference. The column "Agency-Vendor Id" is not appearing in the pivot table I am creating, while the "Status Category" column shows up and works great. Does anyone have any insight to why this is occurring? Thanks.
Zoho Creator calendar popup
When using a date/time field in Creator, the program puts a calendar popup for the user to choose the date and time. Unfortunately, in Creator, the popup is kind of awful. It looks ugly and it is horrible at selecting the time because you can't scroll through the time. You have to click. I'm sure you know what I mean. (I'm sorry if that was a confusing description.) The date/time popup in Zoho CRM, on the other hand, is much more user friendly and looks a little nicer. Is there anyway to use
Next Page