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,
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)."}}}
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
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
Search Feature not working
Everything has been working fine with my Zoho Creator database, until, today, when the search feature brings up no records, when I know there are many. Every other aspect of the program is fine. Is there a system issue today with the system upgrade? Thank you.
render image on embedded form
I have a page I have created in Zoho Creator with HTML and deluge to walk through a form and display images. I then published the page and view it embedded in an IFrame on another site. Unfortunately the images don't render. Is there a way to publish the images so they render?
Count Function
Hello, There is form called Delivery Challan where there is a subform in which there are 2 lookup fields Design No. and Shade No. Now the problem i want to validate whether the particular design no or shade no exist in the stock or not and for that i believe count function is the only feasible option (if there is another do recommend). Now i have tried the code but it seems to doesnot work with subform i guess. Following is the code: if(Outward_Type == "Fabric") { for each rec_Fab in Fabric { Fab_Obj
Conditional Panels
Hello, My company needs a customer dashboard that shows the status of submitted documents. Is there a way to have a panel on a page show only when the document has been submitted? And we also need a way to show a certain icon when the document is submitted (like a check mark or an alert if the doc is expired)
What is syntax for adding a CRM field into Creator
I'm trying to fetch the email from the CRM field into Zoho Creator form. can someone help me with the syntax to be used for fetching records from CRM to creator. Thank you.
Export Excel Workbook with multiple spreadsheet tabs
Is it possible to export Excel Workbook with multiple spreadsheet tabs?
Cannot find parent ID in a subform
I have a subform that is linked back to its parent form by ID. Although the ID and other fields of the parent form record could be presented in reports, I cannot find the ID (the foreign key) when trying to reference it from another form. I can create a new field that copies the parent ID form but this would be a redundancy. Any other solutions? Regards
Share/Invite not working
Hi, My client invited me as Developer for his app. But, I didn't get email. When I check my Home page, I don't see that app. My account is in the domain "creator.zoho.in" My client's account is in the domain "creator.zoho.com.au" Is that an issue?
quick question re: api call by url
Can I make an api json call with the following url instead of via a form element as laid out in the docs here: zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html ? creator.zoho.com/api/json/<ApplicationName>/view/<ViewName>?&authtoken=<myToken>&scope=creatorapi&zc_ownername=<myOwnerName>.json I'd imagine I'll also run into CORS problems. FInally, how do I add criteria to an api call like the one above? In particular, how to url encode a date field. ( e.g. &criteria=myDateField==12%2F14%2F2019
Syntax in deluge to reference a field in another application
What is the correct syntax to reference a field in another application in deluge script. e.g. recordToSelect = somehowReferenceAnotherApplicationAndForm[fieldName == "somethingSomething"].ID; Thanks! Brady
Subform Report Template
Hello, My data is recorded in subform and i want to print them as follows: Design No.: Shade No.: Meter: Design No. Shade No. Meter 56459 240 25.00 55830 210 50.00 23430 1 35.00 23437 2 35.00 what i want to say i want to make 2 columns
Hidding Print Option in Report Detail View
Hello, I have Report emmbeded in HTML Snippet on Page. I succesfully hide Print/PDF option in Quick View with Style URLs but i can't find any options for Print/PDF in Detail View
Preventing users from office A viewing reports from office B or vice versa
I have only 1 form for data entry that is accessible by office A and office B. One of the fields is the Office Site where users select from the dropdown either office A or office B. I would like to prevent users from office A seeing data entered by users from office B. How do i achiveve that?
2020 Wish List for Creator
Seasons greetings! Dear great Zoho team, here are my top 5 enhancements to Creator for 2020 Give us some formatting options on List Reports especially on headings - word wrap especially Give us some more styling options on Form designs. They are ugly today The ability to customise Alert and use in all locations. Alert (warnings, error, information) different colour different icon On Workflow list, show modified date (not added date as if I am modifying 100 scripts I need to know when they were last
Update Aggregate Total
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
Sent emails in MS Outlook
Hi, I want to see the emails sent via ZOHO Creator app in my MS Outlook's sent item. Is that possible?
Create a custom function in ZOHO Creator using deluge script
Create a custom function in ZOHO Creator using deluge script : You can create custom function using deluge script in ZOHO creator app. Please follow below steps to adding a custom function...
Audit Trail - search by login ID
Hi If we are using an audit trail to view changes to records, it would be useful to be able to see what a user has done by searching their login ID, rather than just the unique ID of the field.
My Creator API Get response gives me a 200 result but no records.
Hi! I'm making a GET request as follows: https://creator.zoho.com/api/json/medlemsregister/view/Medlemmar?authtoken=XXXXXX&scope=creatorapi&zc_ownername=Erik.Ekblad note: authtoken is hidden above. The response code is 200 but the output is empty. I have currently 3 records in the view. What am I missing here? Thanks! Erik
Test for blank 'Time' field
How do I test for a blank time field in script? The below doesn't seem to work, I've also tried the isEmpty() function, and == "" with no luck. It does work with date fields, so i would assume it would be the same? If (time_field == null) { time_empty = TRUE; } Thanks
Pass URL parameter to a function. Not work in mobile application
Through the url I pass a parameter to a page that contains buttons. The buttons executes a function for which the parameter passed through the URL is required. If I do it on desktop it works perfect. In the mobile application argument of the function = null. Why is the parameter lost along the way? Any solution...
API Lookup Field Criteria Broken
When selecting a record to edit using a lookup field value, all I got was "Failure, No Records Found With Specified Criteria.". I've double/triple/quadrupal checked my lookup field name. Adding records via the API with the lookup field name and criteria value is fine.
Get rows and send Email
How i can import some rows to zoho creator and send these rows by email to a specific user. I made this but send separated emails by row. I need to group all rows and send as list or some other option but in ONE email. Is this possible with zoho creator?? data = Invoice_Tracker[Fecha_Emision == "02-Oct-2019"].Folio_Dte;
sendmail
[
from :zoho.loginuserid
to :"xxxxxxx@gmail.com"
subject :"lista facturas"
message :data
]
Displaying All Fields in a Subform When Viewing Report
I have created a form that is going to be used to track employee goals. The form itself has information about the employee and manager, and then there is a subform field that is used to list individual goals and related information about each goal. When setting up the associated list report, I checked the box "Create a link to show all fields," for the subform field which then creates a hyperlink for each goal in the report, that when clicked, is supposed to show all the information about that goal.
Next Page