Please clarify maximum fields on a form, and the max data a form can contain
Please clarify the maximum #fields on a form, and the max data the form can contain. https://www.zoho.com/creator/help/general/known-issues-or-limitations.html#Limit_on_maximum_number_of_fields_in_a_form We are evaluating Zoho Creator towards an Enterprise Express license and although we don't have plans or desire for crazy-large forms, the wording of the page above seems to limit a form to 80 text fields leaving room for no other fields of any type? Plus, we'd like a clear and complete picture
Subform not updating when changing selection in lookup field
Hi I can select my lookup field selection:'quoted service' from one app, which is looking at all records in another app, that match this client and are accepted. The problem is if there is more than 1 accepted quoted service. I can see it in the lookup field selection:'quoted service', but no matter which selection i choose , it is only retrieving the data from one of the accepted quotes to populate my subform data. Any ideas?
My function to insert records based on record in another table is inserting a record ID instead of a field value
Hi, I need to populate a table with new records based on another table. I have written this function to do this: void createOrder() { insert into New_Order_Header [ Added_User=zoho.loginuser Supplier_ID=Suppliers[Supplier_ID = 3].ID Supplier=Suppliers[Supplier_ID = 3].Supplier_Name Order_Entry_Date=zoho.currentdate ] When I view the result in the New_Order_Header table I see the correct value for Supplier_ID (which is a lookup field in that table), but instead of Supplier_Name I see a rather large
Upcoming updates - Mar 2019 - part 1
Hello App Creators, Continuing with our recent post on Feb-2019's updates, we're here with a few more updates for you. In the coming days of March, 2019, the Zoho Creator team will be rolling out the following feature updates: Zia-powered smart data import
Auto-refresh of related elements in pages
Ability to drill down data points in pivot charts
Application of field-level permissions when viewing related data
Domain restriction
In addition to our changelog, we'll leave a comment below as each
Upcoming updates - Mar-2019 - part 2
Hello App Creators, We're almost done rolling out updates mentioned in the Mar-2019 - part 1 post. Here's "part 2" - the remaining items that we'll be rolling out by or before the end of March, 2019. Email authentication using SPF and DKIM Deprecating "Switch to old version" for new sign-ups In addition to our changelog, we'll leave a comment below as these items are rolled out. - - - - - - - Email authentication using SPF and DKIM Availability: Accounts that have registered using their own domain's
Multiple connected subforms in one form or a suggested workaround
I have several objects that are 1-many related objects in a kind of vertical hierarchy so for example Courses have several Units and Units have several Objectives and Objectives have several Criterias etc. I would like to make it easy for the user to add this structure in one form since a lot of the information is common so no need to repeat the whole hierarchy again every time they want to add a Criteria for example. I created a Add Course form which allows adding Units (as a subform): I was also
Thousands separator ","
The thounsands separator "," is not being recognized by Zoho Creator when in mass uploads. Also the Zoho Books accounting application does not recognize the separator either. This is not very convenient to say the least. Thanks guys
Number of Business days between two date values - minus public holidays :-)
hi i know there is a possible way to calculate business days (mo-fr) between two date values... but has anyone tried to deduct also public holidays ..... best would be to use a public available service somewhere. second best solution would be to import a table with the holidays to a creator record..... thank you Lambert
Need a way to build public application on creator
Hi There, We need to be able to publish app without login, basically publicly accessible. No sign in or registration required.
zoho.crm.getRecords("Users");
I want to get records of CRM but this not response when try to get information of Users table, this issue is provoke for permissions or not is possible to access at this information for security reasons or why? varUsersList = zoho.crm.getRecords("Users"); This return "null" when try to access at this information in applications in Zoho Creator. Thanks for your time to help to explain why not access this data.
Limit searchable fields in published report
Hi, I've created a database with 1000s of records and published a report (un-editable by agents) that only shows 6 fields (of 26). I want agents to be able to search ONLY within those 6 fields. The report only shows 6 fields. I've created a print template to only show those 6 fields. The problem arises when the agent clicks the search button. It shows all 26 fields. How can I limit the search options to only those 6 fields? Thanks!
images in Notes Field
I am having Form A which contain 5 note field to display 5 different images. That displays Correctly. I am having another one note field that is 6th note field which should display the all the 5 images in a table format fetch from previous 5 notes field. How can be it is Possible?
Not able to get Query Parameter to work to show related tasks to a project
I have an app that have Projects and Tasks. I created a page that shows related project information that you get to by a function that goes to the page with the RecID as projectRecId. I created a panel that shows the number of tasks and for the action, I want it to go to a report for Tasks that are related to the project. In the Add Task form, there is a Project lookup field and it pulls the Project Name. I created a Query Parameter for the pane action as Project=${projectRecId}. It pulls up all
zoho books integrations issue
Hi , I trying to integrate zoho books and zoho creator. I am getting error. {"message":"JSON is not well formed","code":1038} sometimes I am not getting error but the record is not inserted in to books if (((request.Customer_Name != null) && (request.Invoice_No != null)) && (request.Invoice_Date != null)) { itemDetails = map(); for each rowprodetails in Product_Load [ID == request.ID] { proName = Product_Master[ID == rowprodetails.Enter_your_product_details.Product_Name].Product_Name;
Archiving data into an off line copy of a creator application
We have a large database which keeps data relating to our customer's use of our services it consists of a main contact record (parent) and then a series of other records that relate to what services they use from us. We operate on a yearly cycle but for practical and customer services reasons we want to keep these records live and generally active for our call centre staff for 2 years. So far so good. However, as soon as a record exceeds 2 years from it's creation we want to move all the records
Auto Calculate Shift From Timestamp Field(In Subform)
Hy , I have one sub-form with 2 fields on it. First field is Timestamp , which is Date and Time field . second field is Shift , which is drop-down field with values (a)Early Shift , (b) Late shift. needed whenever form opens automatically Timestamp field fills up with current time and date , and accordingly if in Timestamp field time is 7-12 then with Early Shift and if Time is 12-6 then with Late Shift . Please Help me with this . Thank you in Advance . Hope i get reply soon . Have a nice day
notify when record updated
Hello! I have an app set up for our teachers to view records for their students (I have a filter set up so that teachers can only see the students assigned to them). Is there a way to set up a notification such that if one of our administrators makes changes to a student's record that an email can be sent to the teacher to let them know that there were modifications/additions, AND what those edits were? I'm hoping it's possible, and not too complicated.
Equivalent of JavaScript's encodeURIComponent() function for mailto: links?
Hi folks, I need to take a few variables (to, cc, bcc, subject) and a small amount of text (from a Creator rich text field, with some very simple formatting, line breaks, etc.) as a message body, then parse it into a mailto: link to pass to the user's browser so that their default email client opens a compose window with the relevant details filled - ready to edit and send. If I were working in JavaScript, I'd pull the rich text out as HTML, add the variables in the relevant order, and throw the
Can I define a precise page size other than A4,A5 in record template ?
I need to print a label with precise page size ie. 60mmX40mm in record template. But the custom setting only show Width, padding and Margin. I can convert mm to pixel, but where is the length?
Adding values to SubForm through Script
New to Creator: I have a single line field in a subform called added by. I would like to be able to articulate who added the new entry. My code is simply input.addedby = zoho.loginuser; However, this doesn't work in the subform. Only in the main form. Is this somehow not supported? Dale
How to pass existing subform records to another subform
Please let me know if you can provide assistance with the following problem: I have a form that lists building materials. Each material type has its own row where its general features are recorded. Because each material is offered by more than one vendor, the vendors and their description and code for the material are listed in a subform within the material record. All working properly. The problem is on the ordering form, I have had difficulty extracting the vendor code and description on an Order
Importing Dates
I am trying to upload my XLS spreadsheet. Dates are as follows: "2-Apr-19". When importing, I set the format as "DMY". When doing so, each one of these records fails. Zoho seems really buggy.
Setting up different clients in creator
I have a Microsoft Access database that I sell to Accountants. They have numerous clients that they have to set up, import the client's information and make changes to the information. So new clients are created and information is imported, and the Accountant can open up any of the other clients and work on them as well. Does Zoho Creator allow for managing separate clients within the app? Each client's information is unique and the user has to switch between the clients. Thanks, Richard
Possible to add a related record from the + (add record) option in a filtered report list?
I have built a page that is accessed but a workflow to view details of a project and the page is for a specific project passed with a variable. I added a report widget on the page that shows the Add Task report and is filtered to that specific project record. The report shows only the related tasks to that project which is great, but when you click on the add button in corner, it opens up the Add Task form but does not carry over the Project ID for the Project lookup field. Is there a way to have
calculate working days number based on given criteria from master
Hi, I would like to calculate the number of the working days. FormA: "Submit" - will be storing the periods Fields: Beginning_on (date_field) Ending_on (date_field) Days_off (number_field) FormB: "Calendar_master" - storing the working day info on day level Fields: Date (date_field) -- the whole year uploaded Working_day (number_field) --- 0 if not working day and 1 if it is a working day Can you please advise, how it can be automatically add in the Days_off field (Submit form) the number of the
Associating SubForm Records with a Second Parent Form
I'm a bit lost on how to associate a subform with a second parent form. Im my use case I have three forms: Parent Form 1: New_Potential_Tract Parent Form 2: New_Working_Tract SubForm: Ownership_Details New_Potential_Tract has a bidirectional relationship with Ownership_Details via a field called "Tract_ID_Code". New_Working_Tract has a lookup field "Potential Tract" allowing the user to select the Potential Tract to convert to a Working Tract. A Deluge Script then pulls field values from New_Potential_Tract
Insert data into fields based on a condition in another form in Zoho Creator
Hi All I am having problems/issues with the following so hope someone can assist. Here is my scenario: I have 2 forms. Form 1 is called All _Airstrips. Form 2 is called Airstrip_Profile. Both forms have 7 fields which are common or with same structure. The common fields are called Airstrip_Name, Lat_Deg, Lat_Min, Lat_Sec, Long_Deg, Long_Min, Long_Sec. On the form All_Airstrips, there is a dropdown field with 2 options. The 2 options are 'Verified' and 'Unverified'. When a user edits or adds data
Code error 4600 message : You are using unsupported lower version of TLS. Kindly upgrade to TLSv1.2 or above
PDF document emailed via an API is being generated with the following error message: {"response": {"uri": "/ recruit / private / json / Candidates / downloadFile", "error": {"code": 4600, "message": " to TLSv1.2 or above "}}} It has been verified that TLS is updated in version 1.3
I deleted the default Zoho Signature by mistake
Hello, I deleted the default Zoho Signature by mistake and wanted to know how to restore it? Many thanks.
Update Form Entry by a client
Greetings, I created a form that I share with clients. If CLIENT create an entry, he is able to update it. if I create an entry, client is not able to update it. How should I manage, for my client to be able to update the entry, whoever has created it ? Thanks, Claire
Best way to update 26,300 records at once
I've added a new multi-select field to an old form so that I can share one same report with different clients and each of them will only be able to see the records that are relevant to them. The multi-select field is called 'access' and basically it will have the zoho.login email of each user that can view that record, and then the report will have a filter using the zoho.login that will check who is accesing the form and show those records. Since this form has existed long before I needed to add
hiding and showing fields at a subform
Hi! I have a form "orders" and a subform "order details" at "order details", depending on the selected "product type", some fileds should be shown. the subform has all the fields possible for all the products types, wich are all hiden on load of the main form i was thinking to show the necessary fields on user input of the product type field, but it seems like it isn't possible as it gives me the following error: "invalidTaskInSubForm" Any ideas on doing this some other way?
MD5
I'm working with a client to integrate ZC with an api-enabled service. When a user registers with ZOHO, I also need to POST the user's contact data to the api. The api requires a checksum value in the POST request. The checksum is a combination of my admin name, api account name, and user email. However, it's created using the MD5 command. In PHP this is: $test = "buzzap123256joe@gmail.com" ; echo md5($test); Gives a checksum: 9cc309fef02d2dc5e49c612838dbe20b Can we get an MD5 function for strings
Avoid duplicates
Hi, I've got a subform with basic details like Client name, Suburb, Address etc. It appears in two forms. I want there to be a single subform record for each Client name. So if no subform record exists with the entered client name, create it. But, if it does exist, update it without also creating a new subform record. I think this is simple, but i'm having trouble figuring out where to implement this. Thanks Levi
number auto generate
There is a basic need for a function to auto generate numbers. Presently the help pages layout several confusing and non-working ideas. You will not get my subscription without a simple auto number function.
Variable row not defined
For my orders form I am trying to auto populate price field (sourced from product form) in an order details subform based on the selected subform product choice. A very common requirement. I have tried using the code below (found on a zoho blog) but it isn't working for me. I keep getting the error message on the second line of code Variable 'row' is not defined //Fetches the information from the "Products" table selected_Product = Products [Code = row.Order_Items]; //Updates the value of Unit
Cannot make scripts in sub form work
I created a simple sub form with some simple math between fields. When i test it in the Forms area it works perfectly. However, when I try it as a sub form of a master form, the script is ignored. Here is the script attached to the On User Input event of a field: input.HST = (input.Product_total * 0.13).round(2); input.Total = (input.HST + input.Product_total); Any help appreciated. Kerry
AutoSum a field in a subform on the main form
Hello, I have a form called “Projects” which contains a subform called “Invoices”. In the subform I have a field called “Amount”. On the main form I have a field called “Total Cost”. When adding, editing or deleting records in the subform I need the Total Cost to auto sum the “Amount” column in the subform. Could you tell me step by step how to do this? Your help is greatly appreciated :)
EMERGENCY: Customer Portal Reports are Missing Fields in the App's Report
Hi, I urgently need assistance with an Emergency issue concerning our Customer Portal reports. I got a call today from our CEO and he said he was unable to see a variety of fields in reports on the Customer Portal. I was surprised as I had not changed the reports and I am the only user with access to the reports. I checked the App’s report and found them to be configured correctly, the fields missing on the Customer Portal reports ARE in the App’s report. However, when I open the report in the Customer
How to do calculations with value from Formula field? Getting NULL from formula field
I am trying to figure out costs of field which is the price per sqft times the amount of SQFT. I have a length and a width field, create a formula field and then have a cost field which runs a workflow to multiply sqft and price per sqft but I get a null result from the formula field. If I do a workflow that calculates the SQFT, then my form does not work offline.
Next Page