Cannot add subform feild to my view
this bug I will refer to in a support request - cannot add subform field to my view
No initial value option radio field
Hello, before the zoho changes my application allowed an initial value setting for the radio field. Now I've updated my radio field and the initial value field option is not there, and the initial field value I set is not working. Please help!
Need help making upload field look right.
My upload fields are all about half as tall as they should be. You can only see half of the word "Browse" I have sent support tickets on several occasions but just keep hearing that they do not see the problem or asking me to send info I have sent many times. I have opened the form with several browsers and still have the problem. I am getting very frustrated. I have sent screen grabs, asked for help many times, provided access, direct page, but no one does anything. Any suggestions would be
Customer portal user sign up problems
Hi I am trying to test the customer portal but having trouble assigning new users. I send invitation but when new customer acceptas invitation and enters email username and a password it just hangs and nothing happens. Any ideas?
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?
Zoho Form Formula Question
Hey guys, I have created a form for my business and so far I have enabled it to calculate the product price (based on the product selected from a dropdown list of products), the warranty price (based on the warranty selected from the dropdown list) and taxes (based on the province selected from a dropdown list). What I am doing now is I am trying to calculate the Total Sale. So basically the Sale price of the product + Warranty Price * the Taxes for that region. I am having a lot of trouble since
What happens to my records when downgrading ?
I have am constructing a database with 10000 records, please tell me what will happen to my records if one day I downgrade to free version ?
Migration Tool Login Problem
I've downloaded the Zoho Migration Tool - attempting to upload some spreadsheets onto my account but it keeps saying "Username or Password is incorrect". I've tried various iterations but nothing seems to work!
Display submitted information on HTML page?
Is their any good tutorial for getting started with HTML pages that will display records i.e. user submitted information? For example if when filling out a form I enter firstname=john lastname=smith When the submit button is hit I can direct to formsubmit.html however in the code of the page I want it to display the entered record so it will come back with "Thankyou for submitting your information <Form_Field_Firstname> <Form_Field_Lastname>" The scriptbuilder is confusing the hell out of me, I've
Error by lookup update
In field actions Customer_Name On User input I have: if(Factory[Customer_Name == input.Customer_Name].count() == 0) { clear Factory_Name; } else { factoryList = Factory[Customer_Name == input.Customer_Name]; Factory_Name:ui.add(factoryList.Name.getall()); } When I start it, I get follow error message: Error executing GENERATEJS_TASK task (in else block)
Can't delete a record
Suddenly, I find I cannot delete records on Creator. I have exited Creator, reloaded and same problem. I have rebooted computer - same problem. When I click on delete and that I am sure, it comes back saying record was deleted successfully, but it is still there. I have discovered this sometimes works and sometimes does not. I made a quick record, and was then able to delete. But the two in particular, still report as successfully deleted but never disappear from the database.
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.
Can I work with Zoho Creator without Google Apps
Hello! I'm starting to lerano how to work with Zoho Creator. But there is one thing that I can't understan. Can I work with Zoho Creator without Google Apps? It is mandatory to have google apps for bussiness to work with Zoho Creator? in which cases you advise using google apps for bussines with Zoho Creator?
Protected lookup
I have a one-to-many lookup where I want to assign a customer a batch of keys, but once assigned those keys are not available for any other customer to select. When I set this up it looks like a new customer entry can select another customer's key and take it from them, which will not work for my application. They need to be permanent one-time assignment, preferably non visible in drop down list for subsequent customer assignments. Form 1 Customer Form 2 Keys Thanks for your help.
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
Lookup drop down too large
Hi I have a Company table and a Contact table. I have used a lookup field in the Contact table to link to Company. However since there will be 250 Company records, this will result in a drop down which will be unworkable. Is there another way or do I need to use Deluge and develop a script to work with record IDs? Thanks. Dave
How to tell if email sent using sendmail is returned?
I have a function that sends an email to several people at once. If there is a bad email address in the list, how can I tell which one is bad (returned). I tested by including a bad email address in the list and I did not receive and error message or a returned email notification. Any advice is appreciated.
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?
Creating a Pie Chart
I am trying to create pie chart for employee vacation tracking. In the "add employee" form there is a field for total accrued vacation. In the "add leave" form is used to track leave requests. I want the pie chart to show total accrued vacation with the total approved vacation as the smaller inside of the pie chart. I have tried using the pivot table function. using the add aggregate formula function, I made a formula to total all leave requests. but it wont create a pie chart out of the two data
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
Authorized users can no longer print or export reports.
Hello, I have shared the apps to some users. The problem is since you introduced some changes in Zoho, they could no longer print or export reports. Hope to hear from you on this as soon as possible. Thank you. Tambayan Center
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
duplicate form
is it possible to duplicate a form in creator?
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
Work around lookup drop down with too many entries
Hi I have a Company Form and a People Form with a lookup so I can associate People with Company. (one to many relationship). But since there will be about 150 records in the company form, the lookup drop down would be unworkable. Is the only option to use Deluge scripts to associate the records with the ID field? Thanks. Dave
Customer Portal Flexibility
The Customer Portal is a great addition to Zoho Creator. However I'm having difficulty getting the flexibility I need. Here is what I'm doing: When someone signs in they go to a stateless form. In the On Load section I check if the the login email address is in a membership database. If not then a registration page is opened using the openurl statement .When the form is opened the zoho.loginuserid is null so I can no longer detect who is logged in. This is the statement I use to open the registration
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
Feature does not work since changes, please help.
Since Creator was updated, a feature I created now does not work and I don't know why. Can anyone help. So on my project I have jobs that are grouped into dates that the jobs will be done. Now also within the grouping I added Map_Location which gave a listing of all the post codes attached to that date.The purpose was so I could cut and past a whole days activity into Google maps to work out my route. The formula used to achieve this is code=""; for each r in Signing[((Run_Number == input.Run_Number
Next Page