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
Update values in the table based on another table.
I have a table(Stock) where the values are populated from an import excel option (say 10 records). I have added an additional field in the form for ModelCode. Now the value for the ModelCode in the Stock Report is empty. Another table(Products) has the value for ModelCode. Based on the condition as model no same in both the tables, i were to update values to the Stock table for ModelCode. Pls suggest me how can i do it.. Thanks in advance.
Pasting in FreeFlow gives a Null error
I am trying to make a near duplicate of a form. I went to FreeFlow scripting and when I paste in a working segment from the original form it gives me a null error when I try to save. I am just trying to do segments in the Form Definition without Action. I don't remember this behavior 4 months ago. My brackets are correct. The new form is a stateless version of a state form.
Comparison Website with user logins
We need to make a comparison website to compare features of around 5000 products. This will be based on type of product and then model comparison within a type. Users will be able to get registered to the website for detailed features. Therefore this website will be based on a database which will hold types of products, models of products, manufacturers, suppliers and different types of users (with different user levels) Professional with similar portfolio please contact ASAP Many thanks
how - view field but can't edit?
hi for app there is few users who works with incoming entries. need functionality: 1) for new incoming entry there is auto-fulfillment of entries (already works) 2) user for assigned to him view can open and edit entries (already works) 3) how can i make access restrictions for fieldA so that user can open and view inside this fieldA, but can't to edit text of this field ? example - fieldA is phone field. this field auto fulfilled via web-site. user can open entry and view all data, but he can't
Dynamic Picklist based on radio button selection
I can't get the following code to work. if (count(Surface[Type == "Film"]) == 0) { clear Top_Surface; } else { film = Surface [Type == "Film"] sort by Type ; Top_Surface:ui.add(film.Film_Tafetta.getall()); } It seems if i change the above code to the below code, i do not get an error but i have another problem instead. if (count(Surface[Type == input.Membrane_Configuration]) == 0) { clear Top_Surface; } else {
Reports module in Zoho Creator is not working properly after adding a field from another table to a report
I have problems with reports based on a "Transactions" table. For instance, the reports and graphs don´t show all values in the field "State" and the aggregation of a column "Amount" is not given the same results compared with the same operation made directly over the table view. The problem arouse after I added a column called "budget" to the table, which is the ID to link to a new table where we have another field called "budget amount" (money type). After that I developed a new report based
Help. Form should trigger invoice, however on public hosted website this isn't happening.
Hi Team I have an inspection booking form in ZC. This form creates an invoice in ZI and sends it to the client on submission of the form. This works perfectly if I run it in the same browser as my admin account. However, if I submit this form from a clients machine (or any other computer) the invoice is not created. I can only presume this is a security issue. What security settings do I need to set to allow a form that is publicly hosted to generate an invoice? My account is under vic@thepestmanager.com.au.
Fetch Records Explanation
I am not familiar with coding and I'm having some trouble understanding the Zoho documentation for how to fetch records. Would someone be so kind as to break down this function for me in a way that is easier to understand than what Zoho documented?
Improve connection between Notes and Tasks
Apologies if this has already been raised - could not find any reference to it. Currently in ZohoCRM Notes and Tasks are two separate areas. As a work flow, it is common that while entering Notes there is usually a direct Task that needs to be added as an Action . As an improvement, it would be cool to invoke a Task directly from within the Notes section and link them too, to avoid having to close and save the Note and then start a Task separately. (Currently if you maintain lots of notes on a
WHY is Developer Status No Longer Available??
WHY is Developer Status No Longer Available??I have been a developer for 2 1/2 years. I have always had my clients assign me developer status, which makes it very easy to provide on going support. I found out from a new client that Zoho no longer provides developer status for applications. This makes it much more difficult for me. I have to log on to the clients account with their userid and password. This is very unwieldy and cumbersome, and makes the clients uneasy about security. Existing clients
Eliminate Table Borders in Rich Text
Hi, I create tables through code in rich text fields to get data to line up. It works well, but I cannot find a way to eliminate the borders. Any suggestions? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Update parent status
I have two forms, Vehicle and Log. Vehicle form has two fields...VehicleNumber and Status while the Log form has Employee, CheckOut Date, CheckIn Date, and VehicleNumber (lookup) as the fields. Now every time I check out a vehicle to an employee using the Log form, I want to update the Status field to 'Out' in the Vehicle form. We just signed up for Zoho and I am trying to come to terms with Deluge scripting and its syntax. Appreciate if anyone can help me get started with the code.
Next Page