Fetch record when data in main and subform are equal or match
Hi I have two forms. One is the mainform and the other is the subform. Main form: Airstrip Profile Fields in main form: Airstrip_name Subform: Amo Profile Fields in subform: Airstrip_Assigned Airstrip_name and Airstrip_Assigned fields are equal. When I edit a record and based on Airstrip_Name in the mainform, it should fetch the record that matches the name in Airstrip_Name with Airstrip_Assigned in the subform. Please can someone show me how its done. Cheers
Can I login customers from a custom mobile app?
We're looking into the possibility of using Zoho Creator as the API for an iOS game that we have. In the iOS game the customers need to be able to login using their username/email and password. After a successful login, they should view records that they previously created in Zoho Creator, if there are records that have attachments, they should be downloaded and displayed in the game. Apparently Zoho Creator doesn't have an API for authenticating customers in third-party apps via HTTP requests. Is
Highlight duplicates
I have duplicate values in cells containing different sets of data. Is there any way to highlight the duplicate values within a column?
Pass Form Text Into Panel
Is there a way to pass values from a form in ZML into a panel? You can access form data but not seeing where if you pass a page parameter you could also pull string data into the panel through ZML. I know you could do this in HTML snippet.
Automate MS Word templates by fetching data/records from Zoho Creator View,
Hi, We need to auto generate MS Word template reports based on the Zoho Creator View/records on a day to day basis, any suggestions. Sudhir
Passing values via URL to a Search Field
Hello guys! I have 3 forms: Manufacturers, Products and Production Requests. The form Production Request has 2 search fields: manufacturer and products. Selecting the Manufacturer it will load the products list from that manufacturer into the search field "Product". I'm look for a way to have a button on my report Products to open a new form "Production Requests" with the values of Manufacturer and Product loaded and selected into the search box fields on that form. Any idea about how to do that?
Update dashboard panel with report filter based on value in a stateless form field.
I have a simple dashboard with two panels. First one is a stateless form. Second is a report. I want to filter the records in the report, based on a field from the stateless form. For example, as user select the customer in the stateless form, the report will shows only orders relevant to that customer immediately. Thanks.
Search for Multiple Values In Field
If I have a field in a View called Name, how would I search for records where Name = "Jones" OR Name = "Smith"?
Stepping into 2020 with a new series — Functions
Hello everyone, We hope everything is going smoothly with Zoho Creator. We are now officially in 2020 - a new year, a new decade, and, a new series to look forward to. Yes, that’s right. A brand new series on Functions in our Creator Community Learning Series. Every month we will take you through a different function that you could create on Zoho Creator to automate a workflow or get a task done faster. We'll pick from a list of functions that our users usually execute on Creator, and each post
Help with shipping request form
HelIo, I have a delivery request form, I make a cut of requests every day at 3:00 pm, after this time I no longer attend requests for the next day, in which way I can make an alert appear, when the user later From 3:00 pm select in the field of date and time of delivery, tomorrow, and tell you that you can no longer request that delivery, that you select or capture on the date of the next business day, and do not let it continue filling out the form or not letting you send the form information? until
Changing form back to Creator 4
I have slowly been moving my application to Creator V5 from V4, and I've noticed a lot of errors popping up. One of them has been no longer being able to edit some forms in V4 for some reason, despite not adding any changes. Does anyone know how to revert this?
How to Upload the XML file and read the XML file in Zoho Creator?
Hi I would like to know about deluge script for XML reading . I want to upload the XML and read that XML file with the help of deluge script in zoho creator. Is this possible in Zoho ? Let me know Thanks
Sub Form Calculations
Hay , i have one form(Product Form) in which Sub form comes first with fields:- Product Name (Drop down Field From Diff Form) Price (Currency Field) Tax (Drop Down Field From Diff Form) Total (Currency Field) Under Sub form other fields are:- SubTotal (Currency Field) Price15% (Currency Field) Price18 % (Currency Field) AP15% (Currency Field) AP18% (Currency Field) Total Elu (Currency
Code editor
PLEASE please make this changes, we have lost hours of Code changes because we hit the wrong Save!!!!!!!!!!!! https://share.getcloudapp.com/X6uDLLm7
Panel - gauge indicators
Thanks to Zoho for this usefull improvment but normally normally the indicators require that the maximum value and the target are dynamic and not a fixed value as they were designed by Zoho. This is why I suggest that these values can be used as a reference of a field in alternative to a simple number written in a page. Thanks.
Printing a custom recepit
Hello, i have a custom made app in zoho creator. here is a view of the report that i want to work on Report : Orders, it has the following items Order ID Customer Name Customer Phone Number Product Code Product Size Product Price every order has the same info, i want to create a function that would print all order for a certain customer . the receipt would look like Customer Name Customer Phone Number Products ordered: Product Code 1 , Product Code 2....etc Products Sizes: Product 1 Size, Product
collect data from multiple forms
Hello All, I have an issue to collect date from two forms into one report. I've created the lookup relationship between the two forms, I can see the fields Would need from the other form, but there is no value in the field in the pivot table. Though if I open the form, and check the lookup field I can see the values I would need in the report. Any tip please what I made wrong? Kind regards G
Problems with image field : Andriod App
Hi, I do not know if this problem only persists with me, but after taking photo in image field through zoho creator mobile app, the photo's brightness is very low, even though the photo is captured with sufficient light, it is being darkened. Also while using ocr field in standalone subform, the related image field is not being saved on submit and is being deleted. Steps to reproduce the issue: 1. Create a form with a standalone subform. 2. Add an image field to the standalone subform. 3. Add OCR
Simple field value change via email
Hi, I'm having real problems trying to create a simple verification system via email... In theory the Agent creates a record which sends an email to an external client containing details of the record. On the email there is a link that the client clicks which updates the value of a field in the associated record. I have tried (with no success) to send the email with the record ID in the hyperlink which points to a stateless form, however this has raised some issues. I don't want the client to have
Customize Layout option missing from Application and Form settings.
Hi Everyone, I want to change the layout of my form and found these instructions in the help. Select Application Settings icon in the home page or Click on the Settings icon in the edit mode of your application. You can select the required layout for your application from the Settings -> Customize -> Layout option. No you can't. There is no Customize Layout option for the form or even the application. I can't find it on the Applications Settings menu. Where do I access this? Also, I have seen in
Column width in table layout should be kept per user
We have multiple Report in Creator, with a lot of columns. My users noticed that when manually resizing these columns, width is not kept when they come back to the same report at a later time. Width seems to be "reset" to a default size. It would be nice that reports keep the user defined width.
Anyone here who managed to successfully get Zoho Creator integrated with Clickatell and send SMS?
Hello Fellow Zoho Creator Community members, I am aware that there is Deluge script available for sending sms from creator using Clickatell integration. I managed to successfully integrate Zoho Creator and Clickatell. Even the message is being sent, however it isn't received properly in my phone. Below are the problems: 1. SMS comes without a subject 2. Though I'm able to see message in preview when I open the message it is blank I have been trying to get this resolved seeking support from both Zoho
Help at developer zone
One of the things that made me dive into ZC afew years ago was the live chat support. If i get caught at a dead end, chating with support quickly puts me back on the road. Now, to sell ZC as a service we were pushed to build solutions at developer zone. Is there also a way to chat with support? Thanks FredVal
Exporting data from an app to other - diferent IDs issues
Hi! When exporting data from one app to other the records IDs change. This breaks lookups and forms with subforms imports because their funcitonality relies on IDs. Is Zoho addressing this issue? How is the comunity overcoming this? FredVal
Stock Update
Hello, I have an application where i want to update the stock. Data is as follows: Design No.: Shade No.: Quantity: 56459 250 35.00 56459 250 35.00 56459 250 35.00 Now i want to dispatch 35.00 meters and it should update the record as follows: Data is not supposed to be deleted Design No.: Shade No.: Quantity: 56459 250 35.00 56459 250
Update Button, replace with on instant cell update (like airtable mode)
Hello I have a property management app i am designing, and the PROPERTIES FORM which is the biggest form (more than 50 fields), when you want to update . First you need to click Edit, Second input the data, and Third, locate the update button in the end. This is not convenient. because a) it is easy to forget to press the button, so all your changes are lost, b) you need to scroll all the way down. So the update needs to be removed or at least to be moved at the top, steady point regardless,
Report Output in Creator
I am told by Zoho support that it is not possible to move sections so that they appear in a custom order that might be more productive. If I create a report and realize that I left out a section entry, when I do enter it, it appears at the end of the report. It might be more useful to be able to sort the order of sections appearing in a report in a manner that might be more efficient for the user. This is an almost perfect tool. But if you forget to add something and need it to appear toward the
Permission denied to view records
Hello, how do I resolve error 2898 - Permission denied to view records when requesting data? Where does the admin go to grant access? https://creator.zoho.com/api/<format>/<applicationLinkName>/view/<viewLinkName> {"errorlist":{"error":{"code":2898,"message":"Permission Denied To View Record(s)."}}}
Count of related records for each parent table entry
Parent Table: Deployment Child Table: staff Deployment has a lookup field (called related_staff) to select however which staff worked on a specific deployment. I need to report the number of staff who worked deployments at various points in time (monthly, quarterly, yearly, etc). First I need to know how many staff worked each deployment. I added a field on the Deployment table (called staff_count) and tried various deluge workflows, but I can not get it figured out. Thoughts? Also, is the zoho
Flexibility of Zoho Creator - Project Management, Task Management, Workflow Management
Hello Just how flexible is Zoho Creator? We currently use Zoho Projects and are wondering if we scope our needs can Zoho Creator essentially build whatever we want in terms of a Project Management, Task Management and Workflow Management Tool? On the Project Management and Task Management side, most of the functionality we want seems to be there, however it is not designed how we would prefer. Can we essentially reconfigure similar elements to our preference in Zoho Creator? Workflow Management is
having a multiple row subform on load
Hello Everyone, When I load a form, I'd like to have its subform with added rows already. I use seven row subforms, one row is for one day of the week. It is an order form with an order details subform. The field name in the subform is "Day of the week" Is it possible to solve this issue by a script? Anyone could help, please? link names: Order form »»»» Order Subform »»»» Order details Main form of the subform »»»» Main
How to create my own log file of errors within an On Success workflow?
I need to capture look up errors (-1 index) when I'm missing good master data in my app. It's creating other records, but I need to know when someone runs it and it throws an error, thereby missing data. I tried to ADD a RECORD to a simple Log File form I created, but it's not taking it, I assume because the docs say you can't add a record in the middle of an On Success workflow? The main workflow cannot be changed. It's complicated. It's has to be On Success. How can I capture those errors so that
Remove duplicates from a List report
Is it possible to remove duplicate rows from a List report? J
Option to add events to calendar
I created a reservation app in zoho creator. When my users receive the reservation confirmation via email they are not able to add to their calendar as a real event. How can I get this to work as a real reservation app with the option for users to add events to their calendars
Related tables in Zoho Creator not behaving as expected
Hi I have imported 2 tables which are related. The first form has a primary key. The second form has a foreign key and both tables were related. I have imported these 2 tables/forms into Creator. The table with the primary key is the main form and a subform is linked to the table with the foreign key. However when I click edit on a record in the mainform, I expected the mainform to populate the data in the main form as well as the subform data....but it isnt the case. Has anyone had this problem
subform details from one form to create another form
Hi Guys, i am looking to add subform details from one form to create another form. i.e Form ONE has a Subform Form TWO has all the same fields as the subform in Form ONE On every row entry of Form ONE subform i want it to insert as a row into Form TWO insert into Form Two [ FormTWOfield1=row.FormONESubformfield1 FormTWOfield2=row.FormONESubformfield2 FormTWOfield3=row.FormONESubformfield3 ] I hope this is easy to understand and im hoping you can help me to resolve this issue. Thanks
Sample app won't install
I am trying to install the Product Catalog app in Creator but can't get past the "Setting Up Application" message. I have tried this in 4 different browsers (Edge, Chrome, Firefox, Brave) but the same thing happens. The last thing I've tried is installing it in a private window in Firefox. I got this error from the Console: Source map error: Error: request failed with status 404 Resource URL: https://js.zohostatic.com/creator/zcs10247/js/dashboard/tp_jquery.js Source Map URL: jquery-2.0.3.min.map
Update Field in Form_A on Success of Update Field Value in Form_B
Hey Everyone! I am a little stuck on this one. Here is the basic structure of the problem: Form A (Add_Case) Lookup Field (Multi-select): Form B (Add_Contact) Single Line Field: Hidden_Permission Function: concatPermField Single Line Field (Hidden_Permission) is connected to the Function concatPermField and Runs On Success of Form A (Add_Case) Form B (Add_Contact) Bi-Directional Lookup: Form A (Add_Case) Decision Box: Permission_to_share_case_information Here's the issue: If user creates a contact
A lookup field referencing the form itself?
Hi, I want to create a Customer form which contains a multi-select Customer field. When I try to create such a relation, I can't find the Customer form in the list of available forms to choose from. See attachment. What I'm struggling with is, some of my customers use different emails address to place orders. Sometimes they place orders themselves, some times their assistant places them. I want to have a way to group the related customers together. That's why I want to create a Bidirectional Customer-Customer
Update Calculated Value
Hi, Firstly apologies if this is something simple but I can't seem to get the workflow to work. I have two forms. Form A - Kits Form B - Assets Multiple Assets can be added to a single Kit. Joined with Lookup fields. Each Asset has a rental value (FormB) which by using an aggregate workflow in form A calculates the sum of all Assets and adds a value to a total field in form A. This all works as it should and gives the correct total. The problem is that if I update the rental value in Form B the
Next Page