Spreadsheet style data entry form: is it possible?
I want to create a six-row, four-column matrix for data entry. I can do this a little clumsily using a subform. Has anybody managed it any other way?
OnLoad Set variable "Name" to correspond to Loginuser.ID?
Form A has a list of users with details such as Name , Phone number etc and includes the unique Loginuser.ID for each user record. Form B is related and on load sets variables to show the current date, user id an so forth. How can I set the Name variable on Form B to correspond to the particular loginuser. ID. ? In other words retrieve the real name of the submitter for Form B. I guess that it is a "Fetch records" problem but I cannot get it to work properly.
Cannot add subform feild to my view
this bug I will refer to in a support request - cannot add subform field to my view
populating a field in a parent form based on a field in a subform
I have a parent form with a subform, and I know how to have fields on the subform populate based on the parent form. But is the reverse possible? That is, can a field on the subform be used to update a field on the parent form, upon either user entry or submission of the subform? If so, how would I script this?
Recognizing fields
I'm noticing that when I make a change, add or delete a field in a form, if I go to workflow, the fields are not available for use. If I switch to free-flow scripting I can type it in myself and it works fine. Also in the new app builder, the ability to select fields or user variables in the dropdown does not always work. Third is an issue with the image field. If i go into Column Properties and change the image size from Actual to a anything else, when my app is downloaded, it changes back
new user registration/login
I'd like to build a bulletin board type site where users can submit posts, but only after registering an account. How would I go about implementing user registration and login? Thanks.
Deleting subform data
Hi All, I'm looking for some advice please ... I have a master form with several subforms. Depending on choices made from dropdown lists, these subforms are hidden or shown. If a user enters some data into a subform, then changes their mind and selects another option from the master form; how can I clear any entries they've made in a subform from the master form so they don't get persisted? Many thanks indeed for your help! /Chris
More colors in customize
Dear Zoho Team, at the moment there are 5 colors available for applications under customized view: grey, black, orange, green, blue. is there a chance to add purple, red, maroon, yellow, light green, brown, etc.? thanks, Gil
Filter dropdown from another dropdown on a form in on Load
I have two drop downs on a form. The second is filtered by information from the first drop down. It works perfectly however if I prefill the first drop down in the On Add On Load section the second drop down is always blank. How do I trigger the second drop down that there is a value in the first drop down.
Problems with Script Builder and HTML Pages
I am having a LOT of problems trying to create an HTML Page. If I use Script Builder, it works fine to embed a Form, but if I try to use "Insert HTML" the whole screen goes grey and freezes as soon as I drag the "Insert HTML" icon onto the script area. In other words, I have no option but to use Free Flow Scripting. In Free Flow Scripting, I often make some changes or additions to the code, click 'Save Script', and it seems to save OK. (First I get an annoying Internet Explorer popup asking
!!! Recalculation without infinite loop !!!
Hi there, I have build a simple calculator which calculates some plastic specifications called MFI (each has got min and max, compare the screenshot). There are 3 different types of MFI (Melt flow index) MFI 2, MFI 5 and MFI 21 / HLMI. I have got all the functions to calculate each of these types, if you have got one of them given. The aim: If you type in a value in one of the fields, all the other fields should be calculated automatically. So far so good. The problem: If you change one of the values,
Need to populate first five digits from a number field to another number field
Hi, I have a Product Serial number field and a Product Batch number field in my form. Batch Number is the first five digits of the Product Serial No. User should either enter the Product Serial No. and Batch Number should automatically be populated in the Product Batch Number field or if the user does not have the Product Serial No., he should be able to enter the Batch No. directly in the Batch No. field. Can someone help? Thanks
Row Too Large Error
I have a created a stateless form with 100+ questions and am building the database form to accept the answers of the stateless form and store them in the table. I am using single line fields and understand the limit of 80 fields at 255 characters each. My single line fields are mostly 3 max characters but I'm getting errors at just over 80 fields. Am I missing something?
How to best create an On Add Validate script to include only 1 record per day?
I took a stab at this but couldnt seem to figure it out. I have remote users (on smart phones) entering data into the forms. It seems the delay after hitting submit is quite long at times causing the user to hit it again. This enters in duplicate forms. With what I am doing I could limit them to one form per a given criteria. Here is an example of the fields: Home Address - Dropdown (based on another list of 60 properties) Notes - Simple notes field Time/Date stamp How would
Email a copy of an uploaded file to admin user?
Is it possible to automatically email a copy of an uploaded file on success? I know that it is possible to email a link but would prefer the actual file.
Display image from dropbox
Is it possible to display an image that is stored in dropbox? I'm using an image field an putting the dropbox url of the image in the link field. I can not get the image to show in the view. Images that I uploaded from my local computer display correctly.
Need numerical data from one form, count from another form, to provide a "Total"
I have a form "Events" used for training and outreach scheduling. There is a field "Total Scheduled Event Hours". I have a second form "Registered Attendees" with a Decision Field "Attended". (This field was added to swiftly identify the number of actual attendees from the list of registered attendees.) I have a third form "Trainings" with a Lookup Field "Event_Title" that retrieves event title, total scheduled event hours, training topics, and training method (Training_Title, Total_Scheduled_Event_Hours,
Deluge: How to return the first 3 letters of a string and capitalize them..
Thanks
Need help with "The number of deluge statement execution limit exceeded the maximum limit."
I am getting the following error, which is stopping my schedules export: Execute Script Help Execution Failed Error details: Error Executing the workflow Owners Operational Reminder script(Custom Schedule). The number of deluge statement execution limit exceeded the maximum limit.
How to transfer text from one form to another one
I know that with the usage of lookup field I can create relationships between the forms. We can create checkbox, radiobuttons etc. My question is: If I have a form with two fields ROOM(single line) and DESCRIPTION(single line) with the following data: ROOM DESCRIPTION single This is an amazing room double I love this room then I want to display them in a new form dynamically: with the usage of a lookup (dropdown), I can choose the type of the room but my problem is than I dont
How do I turn off the "add new" in subform?
I want to get rid of ability to add new, and the ability to delete
Issue with dynamic picklist
I'm having trouble getting a dynamic picklist to work properly . Here are the specs for the 3 forms: Form 1: Supervisor Fields: Super_Name, Super_Location Form 2: AC Fields: AC_FirstName, AC_LastName, AC_ID (unique), AC_Supervisor (dynamically from form Supervisor.Super_Name) Form 3: Input Fields: PreCall_Supervisor (dynamic dropdown picked from Supervisor.Super_Name, working ok), PreCall_AC (dynamic dropdown to show only AC_FirstName, AC_LastName based on the selection in the previous dropdown,
Fetch data and data format in email notification
Two questions: 1. I need help figuring out how to fetch data. I have watched videos, read articles....all to no avail. It worked on the old app builder but I can't make it work on the new builder. Here is my situation: Form 1 = Contacts Fields: Name Email Address Form 2 = Projects Fields: Project Manager - Lookup and select from Contacts form, Name field Email - Fetch data based on Project Manager selection ****How do I do this?**** 2. The email notification I receive upon submission of a
Record summary - related form, different fields
Hi, I'm trying to create a record summary for a list view based on a form which have multiple fields related to the same form containing employees. But when ever I add the "Name" field from the related form identical values are returned, even though different employees IS selected i the different fields, and is shown correctly in the list view. A simplified example of the form: "Created by" -> Employees.Name (Value = "User_A") "Assigned to" -> Employees.Name (Value = User_B") When I just add one
Chrome extension for interface localization - what laguages to add
Hello all! I like Zoho Creator)) But it still only on English For my users very important to have Russian interface elements (Buttons: Add, Edit, Delete, Column headers menus: Sort, Group, Search, Additional menus and so on) becase some users don't know English well (( and we need to waste time to explain basical functions of working with interface. So we've made Chrome Extension, which translate these interface elements: It's looks like: you install once this extension and then all pages of Zoho
How to De-Activate Two Way Authoraization??
I have activated Two Way Activation. Now, as it sends codes and asks for the same everytime, I want to de-activate it. How can I???
Date-time "eomonth" ignores the year component.
Executing this on 06th Dec 2013, both the alerts print "31-Dec-2013" while the expected result in the second print at line:5 is "31-Dec-2008". dateParam = "13-Dec-2013".toDate(); alert eomonth(dateParam,0); dateParam = "13-Dec-2008".toDate(); alert eomonth(dateParam,0); For now, I'm using the following work-around with expected results: dateParam = toStartOfMonth("13-Dec-2013".toDate()); alert dateParam.addMonth(1).subDay(1); -Varun
How to Check if an upload field is empty?
In scheduling an action on a form, in this case to send a copy of an uploaded file to a user, how can check if the upload field is empty?
Suppress duplicate values in picklist: can it be done?
I have a Lookup field that shows a person's name, drawn from another form. The person can have more than one record in the other form, so the picklist in my lookup field shows the same name more than once. Is there any way to suppress this? I see the same question in this forum five years ago, with the answer "no". Just wondering if anything has changed.
Put image on application
Hi I want to put an image on the start page of my application.... How can I do that?
Not Null question
what am i doing wrong here? I get an error on the if statement. Help if(input.Lineman_6 != null) insert into Employee_Time [ Added_User = zoho.loginuser Date_Field = input.Date_Field Name = input.Lineman_6 Overtime_Hours = input.Overtime_Hours Regular_Hours = input.Regular_Hours ]
Zoho very slow??
Is anyone else having problems with Zoho Creator going very slow? All forms & views, submitting, etc. Everything is slow to the point that it hinders our business greatly. It might speed up for a little while, but overall has been very slow for the last week. Anyone else? Support is not being very helpful. I am already researching alternatives to Zoho but the transition would take very long.
What happen to the Number function reference link?
Folks, The Deluge Script Reference page for Number Function under the Built-In function page is missing. It only has Math function listed now. I am talking about the page that shows functions such as toLong(), etc. That page is missing in the Reference -> Built-in Function section. It uses to call "Number Functions". So can the Zoho team bring it back please? Thanks.
how to add search button in the view header?
how to add search button in the view header?
Lookup Filter in subform
Hi, I am working on a fairly basic form for placing orders. There is a lookup field from which the client can be selected, and a subform containing order items. As the products which can be ordered are unique to each client, what I am trying to do is to have the "Product" lookup fields within the subform only display products from the selected client. To achieve these I have added a client lookup field in the subform, and when the client is selected manually the product filter works as expected,
Fetch and update
Would like to select data in a look up field and have it populate data in another field in the same form. Example Select an individuals name via look up in form2 and have it fetch the data from pay rate in form1 and populate pay rate in form2.
Subscription problems!!
Hi, I've been subscribed to the Professional Edition for over a year now, never with any problems. But today as I wanted to create another Application, I get an error message which reads: "You have reached the limit of 10 apps in your free edition, please upgrade." Please fix this. Carsten Eckelmann Director, TripleAcs Expert Cloud Solutions http://tripleacs.com
Adding form data via e-mail in user-defined format
I am reading this documentation, https://www.zoho.com/creator/help/forms/email-data.html and I want to add records via e-mail. "Adding form data via e-mail in user-defined format" works fine as described, but is there any way to add more values from the email? Subject, Content, and Attachment are no enough. In our case, I want to store Data/Time, From and To address. It should be possible, but the documentation does not explain further. Any idea? My goal is to archive all incoming messages in one
Email data in user-defined format.
I want unidentified users to be able to email stuff to my database in user-defined format - and it is working fine, to a point. I can extract the subject line and body text using ZC_Subject and ZC_Content. But I don't understand how I can find out who sent me the data. I hoped I might be able to use ZC_From, but it didn't collect anything. Can this be done please?
Continue on next line: what is the symbol?
If a line of my code is very long (such as in a lengthy alert), is there a character I can use to break the command among two or more lines? (Note: I don't mean newline in the alert. That is \n.)
Next Page