Attach a document stored on ZOHO Creator to an email
I have a form to upload PDF files to ZOHO Creator I have another form with client name, address and email address I have a 3rd form that does a lookup on the client name to get their email address, and capture further information about that client Is it possile to be able to select a document (from a browse or drop down list) previously uploaded and stored in ZOHO Creator and attach that document to an email to the clients email (from the lookup field) when the SUBMIT button is clicked on the form?
Force Edit in Report?
Hi, I think this has been answered, but I could not find it. I have a field in "FormA" that uses data from "FormB". When I create a new record or edit a current record in FormB, script executes that updates the field in FormA, but it does not show up in the report unless I do a manual edit in the report. Is there a way I can force an edit or otherwise update the report? Bruce "Speedy G" Peaslee The World's Fastest Programmer
HTML in Formula Field
Today I found that my lists which include values with hyperlinks (such as quick reply) are being displayed incorrectly. I have been working on other modules today, but found this specific behaviour to be happening - as of today - to all of my lists displaying formula-based fields. After reading the forum I found that - for security matters - deluge scripts should be used instead of HTML. I have tried to restore a backup from 13 hours ago, but that process threw an error. Could someone please help
Working with multiple applications
If I'm understanding correctly, I can have multiple applications which share and use the same forms (where form is equivalent to a table, or object). This is great, as it helps me organize my thoughts and keep 'modules' of my leggy master application separate and distinct. Is there a way to create a page/screen that links the applications together into a menu? Or is that the generic zoho.creator/home page?
IF Statement in Conditional Formula Expression
I have looked at all the forums and support docs and still am having trouble with this. Currently I have several formula fields that calculate a discount based on the input of the general price. Here is an example of the current working formula expression: ((General_Ticket_Price * 0.1 - General_Ticket_Price) * -1) But now I have a request to have different discounts based on the type of event. For instance IF input.event_type == "workshop" there would a different formula expression than IF input.event_type
Finding all locations that call a function
I think I must be missing something, but I cannot find a way to get a list of all the locations from where a function is called. I used to get this list of locations by changing the name of a function and then saving it - and Zoho would tell me all the places I needed to make the change. But now it automatically changes all the calls to the function - which is good - but I've lost that useful feature. Is there another way to get the information? Thanks Alex
Hide/Show Fields in Stateless Forms
Hello All, Is it possible to hide/show fields on a stateless form based on conditional criteria (user checking a decision box) just as you can on a regular form? Thanks, Adam
Can a form have mutliple related sub-forms?
As the question says - if I have a parent form, such as CITY, and there are related forms (such as Restaurants and Hotels), can the City form have two sub-forms? One for restaurants and one for hotels?
Syncronize fields on multiple forms
I have two forms set up, and I need two of the fields on both forms to always be in sync. For example: Form A: Due date: 1/1/2014 Form B: Due date: 1/1/2014 I need to set it up so that when I put in a due date in Form A, it automatically shows the same data in form B. Thanks
Updating the value of a field in one form, based on the completion of another form
Here’s my scenario and my request; I hope you can help me. My organization does community outreach events, and I’m building an application to track them. When planning the event, we will use an “Add an Event” form, which will record the details onto two reports: a list of events, and a calendar. When the event is over, we will use a “Record an Outcome” form to record what happened at the event. (There is a lookup field in the “Record an Outcome” form, which lets you select any of the events that
Need report to list Table A records with no matching Table B records
Hi I have two tables: Table A (Jobs) has Job Number (Autonumber) and Job Name (single line) Table B (Visits) has: Lookup on Jobs (Job Number) Visit Date/Time I need to create a report that shows all Jobs where there has not yet been a Visit linked to it, but I can't see how to do this in Creator. I can see how to report on visits and link them to Jobs, but cannot see how to reference Visits (or the lack of them) in a report based on Jobs. I have attached a Deluge Script export of a simplified version
Insert an AVERAGE or AGGREGATE Total in a report?
I have a Report Grouped as above by Facility Name Employees enter a STAR RANKING 1 to 5 to rate each facility Is there anyway to show the Average ranking for each facilty in the report as shown above?
To push data into a stateless form temporarily
I am trying to push data of a record in a stateless form on a custom action and then after editing in the stateless form, I am trying to update the existing record. I know how to update the existing record from the stateless form. How can we push the data of an existing record in a stateless form? Is it possible to create an instance of a stateless form?
creating a temp db using a lookup in the form i am creating a temp db from with a field that is not a lookup
In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid this is what I rec = TimeDB[ID == Employee_Name]; input.Regular_Hours = (rec.Employee_Name == input.Name2).sum(Regular_Hours); Employee_Name is a lookup field in the TimeDB Regular_Hours is the field I am trying to update with the sum of Regular Hours in the TimeDB Name2 is not a look up in the form i want to update the sum in
Autopopulate CRM form field based on the selection made to an another CRM field type
Dear All, As we know, in Zoho CRM we can have an account which is possible to have 3-4 or more contacts. Lets say that in a form, I have two Zoho CRM fields. The first Zoho CRM field is an account based CRM field and the second is a contact based CRM field. My quetion is the following: If I choose an account in the first Zoho CRM field, is it possible the second CRM when I click the button next to it to show me only the contacts of this account (and not all the contacts which I have) for selection?
Can you show AutoNumber fields when the form loads?
Can you show AutoNumber fields when the form loads?
Creating a report (view) using data from tables in multiple applications
Our non-profit organization helps sponsor children in Africa. We have multiple applications set up to do separate functions. One application contains tables related to the child, school info and sponsors name. Another application contains tables related to the sponsors and their pledges, financial info. etc. Questions: - Is it possible in Zoho to create a report (view) in the child application that can display all the child/school related data plus access the sponsor table in the sponsor application
Updating a column in one form from another in a form
Hi, I have a master table where the values of ModelNo, TallyID, SUPC Code are updated. There is another form called Tally Stock where there are 3 columns, Tally id, SUPC Code and Stock quantity. Currently these 3 columns are imported from excel, i.e. each and every time, i need to delete the existing all the rows and update it to the table with new values of Stock quantity, but the tally id remains the same. I dont use the submit functionality. Now i want to update the SUPC Code from the master
Is it possible to make a mandatory field, NOT mandatory based on a selection in the same form?
Is it possible to make a mandatory field, NOT mandatory based on a selection in the same form?
Change delete confirmation message
Is there a way to change the delete confirmation message in Report ? I would like to be more explicit as I will have to do other actions if the delete is confirmed. Many thanks ! Guillaume
Can I store a LOOKUP field from a form in a different form?
I have 2 forms/tables One form has Facilty Name, Address etc and the other form has Client Name, DOB, address etc. I want to be able to use the Facilty Name in form 1 as a lookup to populate form 2 and store it in a field named FaciltyKey. The 1st form only has 1 record per facilty and therefore it is the Master. The 2nd form can have many records for each facilty so it should be the child ( a one to many relationship) How do I store the value of the Loookup fiield in to the 2nd form?
Line Breaks in Multiline fields being removed in HTML views
Is there any way to get line breaks in multi-line fields to display when fetched from html pages. I keep running into to this issues over and over. Is it a known limitation that has no plans to be fixed? or a known bug that does plans to be fixed? Does anyone else have this issue and if so how is it handled?
Best way to share apps to clients
Hello, I am starting to develop apps for clients but I would like to know what is the best way to share with them so that they have full rights to add/modify data and test the apps. What is the best way for me to do this? Not sure if this matters but I have two zoho creator accounts. I have an older $25 account which includes 5 users and I also have a a newer Professional Single account. Some of my clients have newer Professional accounts in zoho creator and others don't have zoho accounts. Summary:
Aggregate Sums within records on one form using a Formula field in a second form
Form Job has a Formula fields named Total_Labor_Hrs , Labor_Rate , and Total_Labor_Charges. Total_Labor_Hrs * Labor_Rate = Total_Labor_Charges. Form Log records the hours worked on the various jobs via a Look_up field named Job which looks up to the form Job; and also has a field named Labor_Hrs. Would it be possible to use a Formula field in a Job record to aggregate the Labor_Hrs from all Log records related to that Job? Would the expression below be allowed within a Formula field in the Form Job
Printing Record Summary cuts off part of the page
When selecting "View Record Summary" and clicking the Print button, the right side of the page gets a portion of it cut off. This is happening in Google Chrome, and happens across all my applications where i'm using a Record Summary. Is there a fix for this?
Remove the "View Record" link
In one of my report, I created a custom HTML page to display the record details. I have a custom actions that point to it directly. I would like now that my users always click this button and not the standard "View Record" link. Is there a way to remove it ? More generally, can I remove other options that are not useful for me ? Like "Print" menus or "View as" or "Links" ? Many thanks! Guillaume
Image size in views
I notice when customers download an app that has an image field in the View (report), the size of the image reverts back to it's original. In a View called Employees for example, users can upload images into the employee record and display them in the view. I set the view image size to 60x60 but when they download the app, the image field goes back to 100%. Since my customers don't have access to the code, can you propose a solution?
using a tablet
Hello I need to use a tablet for development my zoho creator application. What do you recommend between Android and Microsoft platforms? Thank you in advance. David
Action when decision box is unchecked
Hello- I have written an action on a decision box that adds a value to a currency field if the box is checked: if (input.Timestamps) { input.Rate_per_minute = (input.Rate_per_minute + 0.25); } What I cannot figure out is now to remove the value (i.e. 0.25) if the box is then unchecked by the user. Note that this is different than doing input.Timestamps == false because I only want to subtract that amount in instances where the box was checked and the user unchecked it, as opposed to situations
Can I Eliminate Bulk Edit Check Box?
My users can edit certain aspects of their profile, but only theirs. To make it easier for folks unfamiliar with Zoho, I have some help text that points them to where to open the edit Form. (see attached image). The first two users did not click "Edit", they clicked the little box, causing the "Edit" to vanish and leaving them stuck. Is there a way to remove the check box? Thanks.
zoho creator Chat Integration
How do I allow my creator user chat with each other ?
Deluge systematic learning
What is the best way to learn Deluge scripting systematically? I mean a complete textbook as a PDF file or a book from a bookstore... thanks!!!
Export and Import data forms with subforms
Hi - I'm not sure that I managed to figure out the process for exporting data and importing it to another app/form, more specifically having forms with subforms. I'll appreciate if someone can post a list that describes this flawlessly. Should I use the backup option? Should I export specific views data? what are the fields that I should select from the subforms? Should I use the migration tool? What settings should be selected to export/import? Do I need to copy formulas? It feels I hit a brick
Sub-Form problem executing a deluge script
Hello, I have a problem getting a deluge script to execute in a sub-form when editing the parent form. I have a parent form that contains a sub-form (master-detail relationship). I also have a deluge script that is intended to execute each time i add a row in the sub-form. The script executes well when creating a new record in the parent form. I am able to add as many rows as I need in the sub-form, and each time the script does execute as expected. However, the problem lies in editing the record
Creator Fetch and Email Forms Help
I am trying to understand this support article: https://www.zoho.com/creator/help/script/fetch-and-email.html I want to add a script on Success to fetch the records with the same email as indicated in the form (as a summary of form activity) and then put the records into the body of a sendmail. The article has this: (excerpted to show the part I'm focused on) ... for each r in Subscription_Form [isUnsubscribed == false] { sendmail ( To : r.EmailId ... Code Explanation ... for each r in Subscription_Form
Field number of characters is different in the view tab
Hi, I made some modifications to an application where the number of characters for one of its field changed. The field max number of characters was 12, now it's 22. The field is a concatenation of 4 other fields (4 chars, 6 chars, 6 chars, and 6 chars), and is updated automatically when adding a new item in the form. This is working fine, and I can see the 22 characters when the field is updated in the form itself. However, when it's submitted, the view only shows the older number of characters (12
how to disable for user - any export of report's entries ?
hi how to disable for user - any export of report's entries ? see screenshot
Share my app with my subscription users only?
Hello, I would like to Share one of my apps with a friend of mine that has a paid professional zoho creator account. It appears that I can only share with accounts that I pay in addition to my single user account in my subscription. Is this true? How can I Share with an account that is not part of my subscription?
how show in reports only entries for last 30 days?
hi there is few full reports (#1) for all entries how can i make "light-weight" reports (#2) so that in #2 there will showing entries of #1 only for last 30 days?
Merge multiple fields into one
The below script updates a string field Details but only with information of 1 record even tough its a for each record script. How could i place all records information into Detalis field? for each EOS in EOS_Report_Form [LTE_Site_ID == input.LTE_Site_ID] sort by Date_field desc { TN = Tech_Names [ID == EOS.Technician_Name]; S = ALU_Items [ID == EOS.Scope]; if (EOS.Site_Completed1 == "Yes") { show Details; input.Details = "Technician Name:" + " " + TN.Name
Next Page