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...
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.
Lookup field refresh
Hello, I have a form which uses lookup fields to gather records from a given (editable) date range. However, I find that when the date range is automatically updated (i.e., I change the month string to "November", which causes a function to execute that updates the 'Report_Start_Date' and 'Report_End_Date' to the first & last of the month), the lookup field doesn't update to show records in the new date range. However, if the date range is updated manually (i.e., I click on the 'Report_Start_Date'
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 a sublist in a subform based on other variables selected in the subform?
Hi , I am a new user to Zoho, and non programmer. So far so good, and it is intuitive. However: How do I create a sublist in a "sub form" , based on whether certain variables in other parts of the sub form are selected? The sublist I'm trying to use is similar to a multi-select list in forms . regards Stewart
how to add search button in the view header?
how to add search button in the view header?
how to add a search button in the view header
Could you please clarify how to add a search button in the view header? I appreciate if you can give more details and step introduction.
How to add search button in the view header?
Could you please clarify how to add a search button in the view header? I appreciate if you can give more details and step introduction. Thanks
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.)
multi row reports
Is there a simple way to generate multi-row reports from a View? When I try to print a report from a view all the data from each record is printed on one row. Is there a way to get each record to print on two or three rows so the report will print on Letter size paper?
Users cannot edit records
I am a newbe with Zoho but have created an application for tracking care issues at our church. I have 5 users who are able to input data, but are not able to edit that data or anyone else's data. Anyone have any ideas? Thanks, Dick Bickings
Creator Application, Calendar view does not work correctly in embed
When viewed with the Creator App the calendar view shows arrows to go forward and back in months or years. I have embedded the report as a calendar view but the forward and back arrows do not display, I have no way to navigate from the current month. How do I make the arrows appear in an embedded view? Thank you
Next Page