Setting dropdown contents on programmatic row creation
How do I set the options for a child dropdown list in a subform row when I create the row based on a template from a parent row. I've tried a few methods, but it seems like the UI for the row just doesn't exist until the function exits. e.g. for each
Calculate Value - Distribution
Hi, I am not sure how to exactly explain this but I am needing to take an input value and allocate it based on a number of lookup values. Input Value: $100 Select Team Based on Team Name lookup, there could be 1 to 10 subvalues to look up.
Q: Need to Calculate a Value for Each Subform Entry
Hi, I have a form with a subform that represents x number of entries. I am needing suggestions on how to best calculate this formula for each row in the subform. for each row in SubFrom subForm Owner1% x main.WorkingInterest
Several MAJOR Zoho Creator Issues Since the 7th Of December - Anyone Else?
Hi, I have been developing several apps for my business on Zoho Creator. I have spent 100's of hours learning to use the system and develop our ideas. We now have some of them running and we use them all the time. But on the Morning of the 7th of December,
Books Invoice, how to change status from "draft" to "sent" using creator
Hi, I am working on a system to manage my invoices in books from creator. I need to be able to either create the invoice with status "sent" or be able to convert to "sent" from the default "draft"... when I create the invoice from creator, it always creates it as "draft" regardless of what status I put in the parameter. Probably this makes sense as "sent" implies an email to the customer has been actually sent... just need to understand how to manage this process from creator... thanks for any help
Remove Page Lines & Delete Report Data
Hi all, I have 2 questions in this topic: 1) I have a page with 2 HTML Snippets and a Form embedded. I would like to know if there is a way I am able to remove the lines covering those snippets. Please refer to the picture (RemoveLines.jpg) for a better
How to auto calculate hours for start and finish times.
I am looking to solve 2 problems with calculating times. 1) An auto calculation of times with an input of Start hours and Finish hours for individual jobs on projects. 2) A running total of these times like you would do with =SUM() in a spreadsheet
Button configuration doesn't show custom functions
Hello everyone, I have created a custom function that I would like to be executed at the click of a button. The function works perfectly; however, the button's configuration settings do not allow me to have that button execute any actions, as it states
How to add date and time - Order Management
Good day experts, I am just wondering before i upgrade my account, in the "Order Management" app that was provided by Zoho Creators, it's already a template. Is it possible to add time, since this is very crucial to my small business, to the 'Estimated
How do we hide the report view menu but keep the record search?
When changing a published report appearance, there does not seem to be a way to show the record search icon without showing the report view. I would like the published report to have the search feature but not the change from the list view feature.
Fetch data from different form on user input
Hi, I'm trying to do something simple (I think) but can't quite figure out the Deluge syntax after researching topics on fetching data. Form A is a "source" table for investments, including these fields: Symbol Price Form B is for entering stock positions,
Twilio Lookup API solution
This had me frustrated over past couple days, trying to find a solution to what should have been a simple issue, so thought I would drop a line to put something in to this pool of info that I draw out of so often. Wanting to use Twilio Lookup tool to
restrict file size on upload
Hi, is there a way to restrict/validate the file size of an item being uploaded? Kind Regards, Ray
Subform field "Price" calculated on every row
I have a pricelist of items As in the screenshot So the idea is to have function that is used when adding rows in a subform. The subform is pretty much a price calculator, that has 3 fields: columnValue ( which is integer, 1,2,3..8), rowValue(also integer,
Workflow Does Not Execute In Subform
Hi all, I have a form workflow that is working as a stateless form, but when I use the form as sub-form the workflows does not work. I have added a workflow in the form, but the workflows only works on the first row, but not the additional row I add
Does js api in widget take up the number of calls?
Does js api calling data in widget take up the number of api calls?
Restrict Record Access To Assigned Customer
Is it possible to restrict form files to specific customer users? E.g. customers can only view records and reporting data related to records that are either created by them or assigned to them.
Populate Creator from with CRM fields
Hi there, I tend to make things more difficult then they need to be as I have proven multiple times while setting up my back-office in Zoho. So before I delve into deluge I would like to know this. I am setting up a customer portal through Zoho creator
Change color of report action buttons
I have created a field as a flag to whether a document is pinned or not. I've worked out how to do this from the report using action buttons, and am currently using another field to show if it's true or not. Is it possible to conditionally format the
Creator Multi Select
How do I add and remove data from a multiselect field with deluge ? I want users to tick a box to "pin" a row so I have constructed a lookup multiselect box that addes users who have pinned.... if they untick the box I want to remove the current user
Populating Form's Subform from unrelated Report
Hi Guys, I’m trying to make a button in a report that, when multiple records are selected, it will run through the records, collect some of the fields from the records, then open up another form in a popup window and populate it’s subform with said fields.
put record to zoho CRM in zoho Creator
Hi, How put records to zoho CRM Invoices Module of Product Details in zoho Creator ? Please write an example with me,Thank you very much.
Zoho Creator making REST api calls to a Moodle Web Services Module
Hi all, I am interested in hearing whether anybody else has tried to... Create a user account in a moodle system on the fly by REST API calls. I understand that someone in the Moodle camp was making a REST API Web Services module available within Moodle 2.0. Refer http://moodle.org/mod/forum/discuss.php?d=33521 It would be great if this could be accessed from Zoho Creator using many of the same techniques that are used, say, to make calls to Zoho CRM. Love to hear from anyone who has made headway
API And multilingual show ????? as document title
When uploading a Hebrew document manually - there is no problem. When uploading a Hebrew using API (Zoho creator deluge call - zoho.workdrive.uploadFile(<file>, <folder_id>, <file_name>, <override_name_exist>, <connection>); The title of the document
Conditional fields?
Hi, in Creator, is it possible to have a conditional field? In other words, if there is a choice between option A and option B, and I choose option A, then a specific menu appears related to option A? Or, similarly, if I use a Lookup field for the Company
Subform Display -- Multiple Lines
Hello, I'm hopeful someone can tell me how to display subforms with multiple lines, rather than a row of fields which requires scrolling left-right. Thanks!
Fetch and display rows results in a sub menu & Happy new year.
Hello everyone, Thank you in advance for your answers I am new. - Is it possible to fetch and display row as menu items in the sub menu of my application? - If so, how can I do that. Thank you and happy new year!
Appointment duration?
How do you add the duration of an appointment to a calendar entry? I can see the appointment date and time, but how do I specify that the appointment lasts 3 hours, 10 minutes, all day etc?
Display data row on a page
Hello everyone, I am trying to display data of an entry from a form in a page. I could not find any information about it. Basically I want to have a link to my page like: https://creatorapp.zoho.com/xxxxx/xxxxxx/#Page:opportunity_entry/{{entyID}} Then
View all emails sent from sendmail function
Hi, I would like to view all of the emails that have been sent using the sendmail task. I do not want to create a form/report for this, as this information will not tell me the exact time the email has actually been sent. I have a stateless form that sends mail, and the email sometimes is not sent until 40 minutes after invoking the function. Where can I see all of the emails that have been sent using the sendmail function?
IT"S TOO DAMN HARD
I went through all the help guides and this is not for anyone. i want a simple form to integrate with Zoho CRM. The sign up forms in Zoho CRM suck big time, I just want custom fields for my website form to collect data into Zoho Leads. So simple yet so hard with Zoho. Can you create a Zoho Creator for Dummies who want simple shit done simply.
Refresh Report on a page
Hi Everyone I have a form composed by two components Component one: Form to add data Component two: Report of the data added on the component one. When I add a new record on the component one, I want that automatically appear the recently added data on the report (component two) My question is: How can I do that? Thanks!
how to work javascript on zoho creator page
hi just made new page and add on them javascript embed code from another system this code do not appears on zoho creator's page for example, put code on webpage on my website - all works good what to do on zoho creator page side so that javascript embed code will work?
How do I create multiple customer portals?
I have multiple customers using the same app we going to develop. Each customer will have their own set of users and data and even their own domain URL. Each customer much not access other customer's data. How do I set that up? What subscription level do I need to supports this?
Image size in the report
How do control the image size in my report. I want the image to be about a quarter the size it currently is showing.
Tip 29: How to automatically trigger messages from Zoho Creator to Zoho Cliq
Hi folks, Hope your holiday season has been a good one! We're back today with our next tip—how to automatically trigger messages from Zoho Creator to send to people and channels in Zoho Cliq. What is Zoho Cliq? Zoho Cliq is a business messaging app
Find unique entries, count them than iterate for each row in html table.
Hello, I have data within my form, we'll call it base_data, in the following format: Reciept_Type (string/picklist) status agentid (picklist stored .toString() in input.agentid, thus stored as record ID) digital active 23115441 no receipt inactive 231154323 digital active 231154323 paper active 231154323 no receipt active 231154323 no receipt active 231154323 paper inactive 23115499 no receipt active 231154102 paper inactive 231154323 no receipt inactive 23115499899 I have an html view in this format
Link data to 2 customer portal accounts
I have the following forms, "Driver", "Owner", "Customer", "Loads". A "Driver" is assigned a "Load" that delivers to a "Customer". And the "Driver" works for an "Owner". I am trying to create a form and filters that will allow a driver to login to the
Show a percentage of total records in a Panel component on a Page
Hi, I want to provide a rating which is based as a percentage of the number of records in a report. E.g. there are 10 records, the total achieved in Score is 5. The percentage is 5/10 = 0.5 (or 50%) The thing is I can't see how to use these type of calculations
Upcoming Updates - December 2020
Hi all, The year is coming to a close and Zoho Creator brings you the last few updates for the month of December. We will be rolling out the following feature updates: While creating report workflows, the listing of apps will be based on the user's
Next Page