Can postUrl be used to make a POST that contains a JSON body?
I am trying to make a POST to a Google Calendar API and I need my POST in the following format: URL TO POST TO https://www.googleapis.com/calendar/v3/calendars/someone@example.com/events?key={YOUR_API_KEY} HEADERS Content-Type: application/json Authorization: Bearer MyTokenMyTokenMyTokenMyTokenMyToken REQUEST CONTENT (BODY) { "end": { "dateTime": "2014-04-19T17:30:00.000+05:30" }, "start": { "dateTime": "2014-04-19T16:00:00.000+05:30" }, "summary": "Trial Event" } Here is the ZOHO Creator code
Using Pivot Tables with Bi-Directional Relationships
Dear All, The context - I have 2 forms (VOWD, and Project) the relationship is 1 to many (1 Project, Many VOWDs) - I have created a Pivot Table based on the Project form - Using this Pivot Table (Project) I want to access the data from the VOWD forms - To do so i have created a bi-directional look-up field (Multiselect) in the Projects form the result is that I amnot able to view the VOWD form entrys in the pivot table! If i change the lookup field to "dropdown" instead of "multiselect" then it works
Weather forecast function or API
Hello all, Has anyone been able to integrate a weather forecast in any way for Creator? With all the events management and planning and calendar / booking applications, I think it would be an excellent idea and fairly simple to have a weather forecast
Can I embed an "edit mode" form on a HTML page?
I want to embed a form on a HTML page passing an ID as parameter so I can edit the given record. Is it possible?
How to pass values from Zoho CRM to Creator address field
Hello, Maybe it is an easy question but I have some issues of how to pass address values from CRM to a creator address field. I wrote something like the below and it did not work.... This is a sample of the code, in general I can pass all the values except
Android - Cannot close popup window following a openUrl call.
Code: // grab cstomer name and create list for current customer's old log popup CustName = Input_form [ID == input.Customer].Customer_Name; openUrl("#View:Popup_Logs?Customer=" + CustName,"popup window"); Problem. Using the Android App - when the Customer popup window appears there is no way to cancel it. The iPhone app has a cancel button to continue on to the main form. Any suggestions? Thanks,
Additional Components / Widgets / Controls
I am evaluating Zoho Creator as a potential replacement for an old Delphi program, but Creator seems to be missing a number of controls and components that are to be found in other development tools. In particular, I'm looking for: A "Tabbed Notebook"
How to remove an uploaded file
In my app TradeMaster (I have shared edit to support), there are many uploaded file fields. An example - "Picture_image_temp" in "SKU" Form. Sometimes, my users want to remove a picture. We have not found a way to do so. Please advise how to handle this request. Thanks.
Calculating Hours between 2 Time Fields in Zoho Creator
Note this topic is regarding the newly introduced time fields in Zoho Creator and NOT the Date-Time Fields. Consider there are 2 time fields in the form 1. Morning_Start_Time 2. Morning_End_Time In order to calculate hours between them, add the following script on user input of both the fields. if(Morning_Start_Time != null && Morning_End_Time != null) { mst = input.Morning_Start_Time.getHour() * 3600 + input.Morning_Start_Time.getMinutes() * 60 + input.Morning_Start_Time.getSeconds(); met = input.Morning_End_Time.getHour()
unique id for students
Hi, I want to create unique Id on load for every new form. Based on old record value I need to create.. for example: 1 ) If I created one rec with EEE-0001, 2) Next record need to show on load side with EEE-0002 Can any one help me in doing this
Deprecating Support for Authtokens
Hello! Zoho Creator's APIs enable you to access your Zoho Creator account and includes an authentication process to secure your data. The v1 APIs use authtokens, while v2 APIs are based on OAuth verification, which is much more secure. To enhance the security of this process, we are now deprecating our v1 APIs (that will reach their end-of-life on February 3rd, 2021) and disabling new authtoken generation in an effort to use only Zoho OAuth authentication. Existing v1 API users If you are using
Community Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. Customize
Single Lookup Field with Multiple Forms Relation
Hello, I am trying to create a new proposals tracking & sales incentives calculation application for my small-insurance business where sales persons sell different types of products (Life Insurance, Health Insurance, Motor Insurance etc.) and earn incentives
How can I fill in an address field with a lookup field's address field in Deluge?
I am trying to allow my user to create a job and select a customer from a lookup field. When the user selects the customer, they have the option to select a decision box "Job Address Same as Customer Address." If this value is true, the customer's address,
Any update on the V2 Bulk APIs?
I have a use case where I need to regularly request all records from a given form, where the number of records is in the tens of thousands. The V1 API allowed me to request and receive all of these records in one pull. The V2 API is restricted to 200
Zoho Creator app without a Form
Is it possible to create a Zoho Creator app without a Form? I'm looking to create a Zoho Creator app that will pull in info from Zoho Books, do some calculations on some of the bills and then create a Journal entry back in Books. The Zoho Creator app
Pre-fill field on the "New Value" popup form
I have a form which has a "Course Category" Lookup Dropdown and a "Course Title" Lookup Dropdown. They are "cascading" meaning that the "Course Title" list will be filtered based on the selected "Course Category". The "Course Title" dropdown also has a "Add New Value" option selected so that I can add a new Course if I want to but when I click that link it opens the "Add New Course" popup but without the "Course Category" selected. Since the user already has selected a "Course Category" in the initial
Embedded report not loading when using HTML/CSS in a page with a toggle switch to view 2 reports in a page based on toggle right or toggle left
I have a requirement to load 2 reports using a toggle button created using Html and css in the page section . I embedded the report like <div elName='zc-component' viewLinkName='All_Orders' params='zc_Header=true'>2 Loading View...</div> .I using this
Automatic Fill Using 2 or 3 Forms !
Hello, does anyone know how I can do an automatic field filling using two or more forms, as a source of information? I have this code, and it works perfectly for a single form search (In my example: Student1) but I want 2 or 3 more forms. I hope someone
Create an alert, email, log if CRM to Creator does not import.
I have a custom workflow when a new "lead" is created in CRM it is added to a creator application. Occasionally the process will not work, because of missing data, misaligned dats, etc. What would be the best practice, or if anyone has a suggestion
How to access Zoho Inventory Warehouses in Zoho Creator
It's not listed as one of the modules available in getRecords, how would I best be able to access that information in a Creator app? Looking specifically to create a dropdown on our order form that pulls in all of our Inventory Warehouse locations and
Record Templates
Hi , How can we create Record templates with Form submit Data? Need whenever any client fill the form and submit then the data of that client send through email using record template. And if client update any field later then updated data again send
Allow multiple actions in Web Report Actions
Currently, it is possible to add more then one Action in the "tap of a record" for the Quick View in Mobile and Tablet mode. Combined with adding custom actions based on conditions this allow for complex behavior. Example : On tap of a record, if record
Importing CSV : no update ability available
After seeing the fantastic new options to update via import, I've gone to test it and can't find the option ... When reading the document it said that the option should be under settings, but it's just not there https://www.zoho.com/creator/newhelp/reports/import-data-to-reports.html
Improve Creator Widgets Functionality
Some functions on Creator Widgets are lacking and would be great for expanding the usability and limits of Creator. Here are my suggestions: First of all on public Widgets the retrieval of data could be permited obtaining data from published reports so
Update Record Without Creating a New One
Hello, I'm definitely a newbie so any help would be appreciated. I have a form where we collect documents from new hires. When employees are filling out the form the mandatory fields are the Candidate ID (pulled from Zoho Recruit) and email address. All
On creating new table record, autofill field from URL parameter
Whenever I add a new record to the Intervention table, I would like the lookup field to be autopopulated with the value of the SearchID parameter. How do I do this? I've tried row.examplefield = input.URLparameter but this doesn't seem to work.
API Access to Sandbox
Hi there, is there any chance to access zoho creator sandbox via API? many thanks
function - datetime comparison
For deluge scripting, is there a datetime comparison function to see which one is of the earlier/later time? Is the operator built for datetime comparison or is it only comparing it as number? Also, is it possible to have multiple function within a script or do I have to create multiple script and have one call(not sure if this is even possible) the other?
How do I populate a Subform with data that already exists from a lookup field in the main form
I have searched the help options for information about this, but can find no example that fits what I'm trying to do. I have a main form with several subforms for which I need different reports (already set up). Each of these reports needs to be sorted by the same fields which recur throughout, Client, Course, Provider and Trainee (all have their own forms). How do I avoid having to enter this information separately in each subform? It all appears as lookup fields on the Trainee form where the subforms
Error when deleting autofill fields
Hello, I am a beginner and I did a program to fill in fields automatically, but when deleting a record in the front end marks an error. Does anyone know how to put in programming to avoid this error? Thank you so much. https://www.awesomescreenshot.
How do I see the files(pdf,etc.) in a Zoho Creator Report instead for a file link using File Upload?
The usage of file upload filed in zoho creator forms is to upload a file link but I have a doubt that this field value in report can show the whole file like image field instead of file link (attatchement). Is this possible to do or not? I am new to Zoho
New Import Interface - Paste Data & Run On Add Scripts
Since the new Import interface has been pushed out, the ability to Paste Data directly has been removed. This was something we were using very regularly to quickly and easily import information. As far as I can see there is no way of doing this at the
Redirect on logout
Hi, I am using Zoho Creator forms and views embedded into my own website. I would like to include a logout link on my own website which triggers zoho logout but then redirects back to my homepage, rather than Zoho's homepage. Both the URLs 'http://creator.zoho.com/logoutpage.jsp' and 'https://accounts.zoho.com/logout' leave you on Zoho pages. Can you please tell me the correct URL to use to logout and redirect to my homepage? Thanks, hdptcar
Add rows to subform (Form B) with dynamic data comming from another form (Form A)
Form A is a Requisition form where People select products to get Quotes from suppliers. Subform in Form A looks like below- Form B is a Quotation form where vendor submits quotes for productsAbove data in subform A needs to be displayed in subform B(this
Send email with value of a lookup field
Hi everyone, Is there a way of sending an email with the recipient (the "To: ") taken from the value of a lookup field? i.e. I have a form with a lookup field called "Email" that has a value taken from another form, and I want to send a confirmation email to this recipient... is that possible? Thanks!
Custom form colors, hide header, etc.
It would be wonderful if we can choose a background color of forms and customize the header based on deluge script! I know this is possible if the form is embedded in a page. But doing so makes it very time consuming, and it is not 100% effective because
checkbox
Hi, I m stuck since a couple of hours on deluge How can I code : " If the checkbox return to the state "uncheck" then... The thing i wanna do is 1 if the user check the checkbox : show the field 2 if the user uncheck the checkbox : hide the field (following a previous check) The following code is not working if (checkbox != null) { show field } if (checkbox == null) { hide field } thank you in advance
Is it possible to use an external API in Zoho Creator Cloud Functions?
I would like to use Node.JS cloud functions to use an external API for web scraping. I want to scrape a website and then use that scraped data to create a record in my Zoho Creator database. How would I go about doing this using Cloud Functions in Zoho
Customer Portal : "Unrestrict" Access
Hi, I have a report that I want to set up so that multiple Customers of the same company can see the same records - rather than just the AddedUser. However I can't seem to lift the restriction and when I view this report as a Customer I can still only
Next Page