Use zoho creator page to fill PDF.
Hi team I have created a HTML page in zoho creator. I want to fill that page and on submit that page it will generate the pdf file which containing this information. How can I generate the pdf file with this information or please tell me alternative for this.
Is there a way to define dropdowns (not lookups) as value-description pairs?
Hello. I have searched the forum, but found no solution. It would be very useful to have this feature, specially when you have to take different actions based on the user selection: instead of checking against a (probably long) string, you could check against a key or ID. Is there a way to accomplish this? And if not, would the Zoho Team be so kind to include this feature in future releases? Thanks in advance.
Record Template - Yet another half baked feature
Please, stop adding half-baked features to ZC, you're driving us crazy! Record template is amazing, but at the same time, useless in so many ways. Here's a basic scenario: 1. I have a Staff form with a relation to a Tasks form. Tasks are assigned to a Staff each. 2. On a regular basis, I want to email my users a list of Status="critical" tasks they need to complete. Stupid as it sounds with record template I can't: - Filter records based on a field, so all the tasks will be included in the email
Duplicate Values
Hii, I have an issue regarding No Duplicate Value option. I have a Field that is in lookup. How can I apply No duplicate value Option to filter that field?
Fetch Records
Hello, i am having an issue and struggling to resolve it. I have a form with a subform inside that has static data with an increment number. I also have another form with a date field and a number field that allows the user to input a number in a field which is embedded in a page. I am trying to pull values from the static subform and display some of the values on the page based on the date and increment number <= the value entered in the second form i am struggling to display the results on the
How can the data in the multi-selection (Lookup) field be sorted uppon the original sequence I selected?
Hi, In a form I create a lookup field with multi-selection from another form. It works. But when I picked up my choices and saved and reopened it, the sequence of my choices is changed and by random. I contaced support, he says it's order by the ID(created sequence) of the form which is referred. But I checked and it's not true. Any idea about this? Random order is really a mess to user.
Embedding form on web page
Hello, I've created a form for public use, and I've embedded it on our Wordpress site. Everything seemed to be working great, but I just noticed one item that will be a huge issue... I have a video upload field where people can either send us a video file, or they can record from their webcam. When testing out the form on its own (not embedded), everything works great - when I click to record a video I get the message saying that I need to allow the browser to have permission to use the webcam -
Is Realtime access to Zoho creator from MS Access possible?
I have a client who wants to be able to view data from their zoho database inside MSAccess in realtime for reporting. I can see API calls in the zoho help documentation about writing zoho records from Access and web sites etc but nothing that allows me to pull data into an Access database or just view it in access. There are two things being asked for. 1) The ability to view realtime data in MSAccess for reporting. 2) Pull data data directly from zoho forms into corresponding forms from MS Access
Troubles setting up Webhooks
Hi Zoho Creator team! I'm facing some difficulties setting up a request from an external application (Docparser) I setup a 'on succes' action to send a PDF file to Docparser. When the document is parsed, I want docparser to send me the parsed data. This data should be updated in the record the file was uploaded to. While sending the document I also provided a remote_id to identify the record for updating the record values. At first it looked like a straightforward thing to do with the creator update
URL parameters: subform
Hi, I'd like some help passing values via URL I know i can add ?Fieldname=value to the end of the URL to pass a default value. However, is it possible to do this to a subform? I've tried ?Subform.Fieldname=value with no luck. EDIT: You can pass the value to a placeholder field in the main form, and have it copy across to the subform on load. Still would like a direct solution, though. Thanks, Levi
Auto Fill Field In Custom Module Based on Lookup Field
I have built a Custom Module called Products Leased that is related to Accounts. It also contains a lookup field to Products Module. I am wanting to store all of the Products each account leases from us. When I lookup a Product I also want to bring over the Unit Price of the product into the new Module Products Leased. Is there a way to auto-fill a field based on the lookup value?
Method call tracing
We have a form that has a subform, and when we add rows to that subform, we want to initialize it with values from the previous row. This works perfectly for *most* of the fields in our subform. However, there are a couple of fields which appear to be getting cleared AFTER the subform "On Add Row" method is called. The problem is that I cannot for the life of me determine which method is clearing the values for these fields. I have commented out calls in other methods that clear these fields even
Importing flat file with 160 columns into Zoho Creator
I have a flat file with 160 columns and about 200,000 rows.... what is the best way to upload this file to Zoho Creator? It has a 70-columns limit for mass uploads... is there a way to get around this? Thanks.
Math functions in Creator
Is there a more complete list of available math functions for use in script builder? The current list is pretty small, and doesn't seem to cover everything that is available: https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-number.html for instance, only sine and tangent are on this list, but cosine works as well. I was hoping for a more extensive list, the current list just isn't enough to calculate most things. As an example, once i geocode an address in my database
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
Next Page