Updating data in one form based on condition in another form
Hi Here is my scenario. I have two forms. One form is called Airstrip Profile. Thats the form we INITIALLY entered data and we have about 50 records to date. Recently I have imported a Excel file and as a Form with data and called it Rural Airstrips. Its has about 600 records. Common fields in both forms (Airstrip Profile and Rural Airstrips) are: Airstrip_Name, Lat, Long. The Rural Airstrips has a dropdown field with 2 options. The 2 dropdown options are 'Verified' and 'Not Verified' Now I would
Break Line in HTML Forach
Hello I am trying to list records from a form in a page but currently they show all subform valuesnext to each other rather than as a list underneath each other. is there a way to achieve this? currently: gate duties, gate duties required: gate duties gate duties here is the code so far <%{%> <% for each record in RMP_Requirements_Parameters [ID != 0] { name = record.Requirements.Task ; %> <%=name%> <% } %> <%}%>
Suggestions for Zoho Creator
Hi, I have been using Zoho Creator for about a week now. It seems like a promising tool but I have come across a few blocks that were quite frustrating especially since it seems that they could have easily been added to the current feature set of Zoho Creator. Maybe these features are available but I have not been able to find them or at least not in a directly convenient way. If not, then I would like to list them here as possible feature requests which I think would give ZC a big umph. 1 - More
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
Next Page