report merging several tables
Hello There I am trying to build an application to manage payrolls. I built several tables such as: Companies Company name (field) Company ref (field) Departments Company name (lookup) Department name (field) Employees Employee Name (lookup) Employee number (field) Contracts Employee (lookup) Company (lookup) Contract # (field) Salaries Contract (lookup) Salary (field) Bonus type Contract (lookup) Bonus (field)
[API] Uploading file via API to existing record by ID
Hello, I'm trying to uploasd a PDF to an existing record using its ID via API as written in the instructions (https://www.zoho.com/creator/help/api/v2/upload-file.html ). I succefuly created records on the form in my app. Then I took the record ID from
Zoho Creator - [Free Webinar] Creator Tech Connect - Creator's Latest Release Updates
Hello Everyone! Gear up for our next session in Creator Tech Connect Series! About Creator Tech Connect Series Creator's tech connect series would comprise of pure technical sessions in which we delve deep into key essentials and technical nuances while
Dynamic Filter on a look up field on a form based on the input of another look up field
Hello, I am trying to set up a dynamic filter where a look up field "Sending_Entity" in a form can then filter the drop down list of another look up field "Sending_Account". I tried setting the filter for "Sending_Account" as "Input.Sending_Entity", but
Title and Link Color Changed?
yesterday I could have sworn that the title color and link color were blue. now they are red. can this be reversed?
Did anything change recently with Zoho Creator?
I have been using a few contact forms on my personal websites. I have been away for a while and Zoho Creator account went dormant. I logged on and reactivated the same. However when I quickly tested my contact form got this notification. The actual content
Zoho Creator Embed Code is being Blocked
I am able to test the embed code as a direct link on the webpage. However when I try to embed the same into the Iframe I am getting the belowsaid error message Should I enable any settings for embed within the iframe?
How to compare records collected in creator to outside data
I have built an app in creator that gathers user input data that I need to check and see if it matches an outside data source for quality control purposes. It seems like doing this within Creator is not a great option, so I am looking for a way to do
OAuth 2.0 authentication compatibility with Creator as the client
I have been stuck for awhile now on this. I am using data from the Tyler Data & Insights API to autofill fields in one of my forms, when a unique ID is passed to one of the fields. Since some of this data is private, I am using their workflow for OAuth
Change of multiline fields behavior in templates
Until a few days ago, the multiline text fields of the templates made the corresponding line breaks to adapt the text to the width of the container. Recently, without me making any changes to the templates, the behavior has changed and now the text doesn't
Auto Add Subform in Zoho Creator
Hello, Could you please help me with how to auto create subform in Zoho Creator? Here is an example: Mainform Start Date is 14.11.2017 End Date is 17.11.2017 No.of Overnights is 3 nights. Is that possible to auto create 3 subform (based No.of Overnights). First one "Date (Overnight)" is 14.11.2017 (the same as "Start Date") Second one "Date (Overnight)" is 15.11.2017 Third one "Date (Overnight)" is 16.11.2017 Please check the below photo. Thank you in advance for your help!
can't create report with connected datasource Form
Am I correct that in creator can't create report with connected datasource Form (or even add record from another form) I connected my form with zoho sheet and can't do anything more than send data to the sheet Is there any other option?
Zoho Creator - [Free Webinar] Learning Table Series for Logistics
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
How do I filter a subform lookup based on a main form lookup?
We represent multiple vendors as commissioned sales reps. We track our sales by entering them on a Purchase Orders tracking form. One of the fields on the main form is Vendor, a lookup from the Vendors table. The form has a subform to select the Product sold, and enter the cost and order quantity. The subform field Product is a lookup from the Products table. I would like to limit the list of Products in the dropdown to only those sold by the Vendor that was selected on the main form. I can't figure
Migrate from C5 to C6, what synchronisation I should take care of ?
Hi, We have multiple applications in C5. Goal to is migrate to C6, but these applications have connections with other Zoho apps (CRM and Books), and also external websites with incoming and outgoing webhooks (REST API). When migrating to C6, how these
Build a table from an API request
Hi! Do you think it is possible to achieve this functionality in the Creator? On opening the app, it loads data from Books (recently Shipped Packages). Basically, just one API call. Using the data, it displays a table with the packages and buttons. Tapping
Zoho Creator - [Free Webinar] Creator Tech Connect - V2 API and Open API - Latest API Offerings in Zoho Creator
Hello Everyone! Gear up for our next session in Creator Tech Connect Series ! About Creator Tech Connect Series Creator's tech connect series would comprise of pure technical sessions in which we delve deep into the key essentials and technical nuances
Zoho Creator - [Free Webinar] Learning Table Series for Real Estate
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
Zoho Creator - [Free Webinar] Creator Tech Connect - Custom AI Models - No Code AI Offering in Zoho Creator
Hello Everyone! Gear up for our next session in Creator Tech Connect Series ! About Creator Tech Connect Series Creator's tech connect series would comprise of pure technical sessions in which we delve deep into the key essentials and technical nuances
Zoho Creator - [Free Webinar] Learning Table Series for Manufacturing
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
How to create lookup field that only list unique records
Hi, I have several single line fields in my form of which most have duplicate records, but I need the user to go through a 4 step process of selecting from a lookup list, then the next 3 fields will be a dynamic pick-list based on previous selections, but I don't want the duplicates to show up in any of these drop downs... I've tried to configure the lookup field with a distinct aggregate record function, but it either doesn't work or I'm doing it wrong. Is there a better way? Cheers Eric
Calendar Resource View
Hello, I'm considering Zoho Creator for SaaS development and wanted to know if its possible to create a calendar (resources view, image attached) in soho creator?
Updating a file field without giving edit access to users
I have a form that includes a file field where users upload a document. Sometimes they don't have the document at the time they create the record, and since only the admin has edit access for security reasons, only the admin can edit that record and add
Passing multiple parameters in ZML
How do I pass multiple parameters in ZML. This does not work. <%{ %> <panel><pr height='fill' width='fill'> <pc width='100%' bgColor='#FFFFFF' padding='20px' hAlign="left"> <button text='<%=searchresult%>' size='3' color='#ffffff' bgColor='#0072F4' type='rounded' action='OpenPage' target='same-window' componentLinkName='test' cornerRadius='60px' parameters='test1=true&test2=true' /> </pc></pr> </panel> <% }%>
Error: Internal Exception
Hi Team, I'm trying to convert a page to a pdf file and send the attachment in an Email. It is working fine but sometimes it gives an error saying Internal Exception. I got to know that this error is due to the time limit it takes to execute the invokeURL.
Invoke URL to get Record Template
Hello, I am wondering if anyone else is having issues using the invoke function to get record templates. I have used this in the past with no issues, but it is now not working. file_to_fetch = invokeUrl [ url: "https://creator.zohopublic.com/<adminUserName>/<appLinkName>/record-pdf/<viewLinkName>/<RecordID>/<PreferredDownloadFilename>/<encryptedKey>"
Record Template with dynamic content?
We are trying to build a record template for Quotations. Some variables are involved in how a quote should appear when printed, such as: -Include or exclude Bill of Material (subform data). - Include or exclude multiple Bill of Materials -Include or exclude MSRP column in Bill of Material - Include or not include Scope of Work (Rich Text Field) Can we dynamically choose what elements appear in a template, or can we create multiple templates to choose from when printing a
calendar view
Hi, To work with the calendar it would be very useful to configure the calendar report view where the date are specified dynamically via URL. The idea is to be able to display the calendar in one day view. At the moment, it is possible to set the view
Add Javascript on Workflow -> Send Email Notif ->HTML
Hi Zoho Team, Requesting to add Javascripting on HTML edit field so we can expound and apply more functions to it. As of now, it seems dead-end on our part as we don't have option to iterate table rows upon submission of the form. We will not take the
Help with scanning a barcode serial and transferring the scanned serial to another lookup field in Zoho Creator
I have two fields, same form: a barcode field and a lookup field. I want to scan a serial with the barcode field, and then put the serial in the lookup field, but I keep getting an error. The barcode field is a string field apparently and the lookup field
Location Field not found for use
I am wanting to use a Location Field that I've seen in some solution templates however in my list of Basic and Advanced fields there is nothing called this. I don't want anything as specific as an Address and unfortunately the Address field type requires
One big app or multiple small connected apps?
I have a question for everyone on their thoughts and knowledge with app design. I was originally using Appsheet before coming back to Zoho Creator. I am building an app or apps for my house flipping business and it has many facets such as CRM, project management, logistics, material lists, etc, etc. With Appsheet, the more tables, forms, and data you had in one app, the slower it became and would take minutes for the backend to reload after each edit. Creating multiple connected apps was way too
How to setup Tasks for multiple sections
I have various sections that could each have their own set of tasks associated with a record. For example for Projects there can be tasks, for Contacts there can be tasks and for Opportunities there can be tasks. Is it better to create a a single Task
Building for Multiple Organization Usage
I am creating a single solution where I want to be able to have multiple organizations with multiple users use it but not be able to see each others records, and have their own logo, etc. I haven't found any topics or knowledge base articles however I
Storing strings larger than 64KB in creator forms
Greetings in my application i'm working on a widget where the user can input large amounts of text (screenplay scene outlines and actions), after the user is done with writing i want to save the input as stringified JSON in my form. the issue is that
Dynamic Geo-fence
It would be amazing if we could dynamically setup the Geo-fence for a form from deluge.
Custom Creator App continually breaking
Our ZOHO Developer created a ZOHO creator app that my field techs use every day. It has become an integral tool to dispatch my Field Techs and provide Customer Information, GPS, Crew Data, Time keeping, Sales Orders etc.. It would seem that anytime there
Figma Screen Import Procedure
Hi, How can I import and build functionality in screens imported from Figma and build logic above that.
Form-Style Properties
Hi, Is it possible to customize the style properties (height, margin) of the form fields?
Timer function in Creator
Zoho Projects and Zoho Desk make use of a little timer gadget. The user manually starts/stops it. I have a need for this type of control in Creator. Any plans to add it?
Next Page