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
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
Record Summary View: Visual separation of rows needed; borders display wrong with empty cells
Hello, I have a record summary view with a number of large tables. I need my client to be able to read a single row all the way across easily. However, there is no integrated way to add internal borders to a table, or display rows in alternating colors. I've resorted to adding a border to each cell, which works fine until there's an empty cell. In these cases, the border 'collapses' so that there is just a black horizontal line across the middle of the cell, which makes reading it even worse than
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
Auto Populate Fields On Sub-Forms
I when data is entered into one single select field in a sub-form, I need the value for the other fields in that record automatically populated. For example, if the Main/Parent Form is the "Order Form" and the Sub-form/Child Form is the "Products Form", when the user selects the product name in the "Product Name" field in the Subform, I need the application to automatically populate the other fields, such as "Product ID", "Price", "Product Description"- fetching this data from the "Child Form/Products
Problem Editing a Form with a Subform
When I edit a Form that contains a subform, most of the fields are missing. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Change title of printed doc.
Dear Zoho Creator team, Users have requested to change the title of a report upon print - is that possible? -it means in the app the title of a given report is 'X' and they'd like to have it displayed as 'Y' when printed. thanks, Anat
Using vars to fetch related data
Dear Zoho Creator team, I am using a variable to fetch data from a source form via a lookup field, and have it appear On User Input in another field (see script example below). the thing is, i've been using the same method in another app and it works fine - somehow, what works in one app doesn't in the other... script example: TempName = Employees[ID_Number = input.ID_num].Employee_Name; input.Emp_Name = TempName; /*Where Employees is the source form, ID_Number is the source ID field, ID_num is the
Can't submit an issue & formula field wrong type
I've had a paid Zoho account for years. I'm trying to log in to the support area, but I can't find a way to register. Also, I called an left a message with your support. I used to just send an email. What's up? Next, I have created a form with a formula field that is a product of a currency field and a numeric field. The formula is defaulting to 'text' type (see attached), but should be currency or numeric type (since it is just 'Cost * Quantity). How to fix?
Need to combine two fields into another
I am creating an appointment log and I am using a drop down field for fixed times and a date field to choose the date of the appointment. Is there a way to combine two fields of date field and a text field togeather in a Date-Time Field so I can create an appointment in a calendar view and see my appointments in a calendar view.
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?
Report Filter
Hello, I am trying to filter a report based on zoho.loginuserid. I have the PM field in the Job_Number table to use as part of the filter criteria. Basically, I put the following in the criteria area on the Report Summary: PM equals emp_list.PM[zoho.loginuserid = = Email] I run the report, the filter does nothing, and it deletes the criteria. I'm sure due to an error or syntax. Let me know if there is a better way to do this, is there a way to write a script for this in the report? Thanks.
Adjust font size in Zoho Creator
Dear Zoho Creator team, Is there an option to change the font size in settings? thanks, Anat.
Two-factor authentication for zoho login
Hi, I have been using Zoho over a year now. This is my free account I also use a paid account. What I find missing is two-factor authentication. I don't want to login to my admin account only by a password. For example it would be better for optional use, if users can generate a pass code from their smartphones(or similar) after they entered their password. If pass code generated wrong or blank user can't login his account. I really would like to see this feature in Zoho as I think it strengthens
Formula field not saving
Any help? I add the Formula field to my form. I try to change the name of the Formula field and try to add a calculation, but the new name and calculation do not save. I see an AutoSave popup window flash, but when I go to access the application and back to the form builder the Formula field goes back to the title "Formula" and the calculation is empty. I've tried to delete and add it again....sometimes the Formula field just says adding.... and never shows on the form.
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.
Link to a particular record in an e-mail
I want to send an e-mail when a record is created on a form. In the e-mail I would like to have a link back to the record that was just created so the e-mail receiver can view it. I could not find a way to do this. Any suggestions on how I can accomplish this?
Put image on application
Hi I want to put an image on the start page of my application.... How can I do that?
Who has tried to access zoho
Hi, I recently set up a process of giving all users from theatre company access to a form. They obviously have to sign up to zoho, They login and the form they see is filtered on their email address. Unfortunately I haven't had much success with updated forms. Is it possible to somehow see , who has at least logged in to the site to try and update their details. Thanks Tim
Pivot Table/Chart Filter
Is there a way to program filters for pivot table and charts? I am looking for a way to filter the data for the previous and current work week. I can do this without an issue in list reports, but fail to see how to acheive this in pivot reports. Thanks.
"params" properties does not work
why "params" properties does not work ?? <iframe height='500px'width='100%'name='reportEmbed-Copy_ofbase_de_donn_e_produit'frameborder='10'scrolling='auto' allowTransparency ='true'elName='zc-component'params='zc_AddRec=false&zc_HdrFontClr=Blue&zc_HdrFontSize=20'src='https://creator.zoho.com/pere...xxxxxx></iframe> any idea ? Cheers
populate text feild from lookup in new ui
Want to populate a text field from lookup field value in the same form. E.g. Brand & Category both are lookup field. input.Item_Name = input.Brand + " " + input.Category; This return number instead of name...
Next Page