Publishing a page with a widget in it causes the widget interface to error
I've just done a test publish of a page that contains a widget, however in the console log it tells me that the authorisation token has expired. What is the correct way to publish a page with a widget? What we want to do is allow a customer to review
Sample angular service for zoho widget api
After a week of frustration getting this to work (granted I'm still a newbie at web development) I thought that I should share the fruits of my development. Below you should have the basics of an Angular service written in Typescript that you'll be able
How should i Remove starting space using deluge ?
How could i Remove starting space using deluge ? like if a = " ABC DEF"; then output should be ->ABC DEF , remove starting space only if available how ? Remove all spaces from starting before first text. Thanks and Regards, Sidhant A.
Looking for Zoho Creator Mentor.
Hello, I am looking for a Zoho Creator mentor that can guide me to what I needed. I want to learn it myself so I prefer a mentor rather than a person who will build it. I am also paying for mentorship if that is how it works. Our project is to create
Get a URL parameter inside a widget
I've written a widget that will use a URL parameter to search for a booking, however at the moment this doesn't seem to be translating through to the widget on the form. How can I make this work?
Conditional Formatting bug
Hi, Conditional formatting does not appear to be working in reports. In the example below, i have created two conditional formatting criteria to highlight a record either red or green based on its value. However, when running the report it simply applies the formatting from the last criteria to all records. (It is as if there is no criteria at all and it is simply applying the formatting to all records). Further to this, when i create a conditional format with a criteria, save it, and then edit
Is there a way to do an "OR' search on a column, using normal Search?
Is there a way to do an "OR' search from the normal Search? Such as to find tenant name (text field) that contains "starbuck" OR contains "coffee" OR contains "brew"? If it is possible, please reveal the syntax. (I see that the Global search allows OR. But Global search does not assume wildcards and does not work right when wildcards are used with OR. And, global search has limits vs. searching on the actual report.) (And, using an automatic Filter requires a Lookup field, and this is not practical
Showing Subform Field based on Subform Dropdown
Hi, on my main form "Contact Info" I have some dropdowns that will show a single line field based on what is selected in the dropdown. i.e. In the "Distribution Method" dropdown, I select "FedEx", and a "Tracking #" field appears. I have tried to do this same thing within a subform, but the subform just displays all of the fields and won't use the rules/logic I've setup in the form ("Contact Info Subform"). Do subforms not use the logic that are specified in them? Is there another way to have a subform
How can i update the value using deluge (dynamically) ?
How can i update the value using deluge (dynamically) ? The thing is we had already did insert task; but as we added 2 new fields later , so we wants to update these 2 fields into other report and there are lots of data there. How ? Thanks and Regards,
Is this code right ? Because only fnsku, sku and asin values are not updateing
Here is the code, lstv = input.FNSKU_SKU_ASIN; if(lstv != null) { lstV = lstv.toList(" "); info lstV.size(); info lstV; if(lstV.size() == 3) { a = lstV.get(0); info a; b = lstV.get(1); info b; c = lstV.get(2); info c; } if(lstV.size() == 2) { a = lstV.get(0);
get values differ and store in variable
Hi, For example , we have a text as - abc def ghe in that , i want to store - as a = abc b=def c=ghe like this , based on space. because only space is common for all the texts . How can i do this ?? Thanks and Regards, Sidhant A.
How to Fetch report of Subforms with a Lookup field in form 2
I have created an app, due to field limitations, I have to divide my app in 2 forms. My First form also contains a subform to add data according to the user requirements, but that subform fields are not accessible in the report of 2nd form with the lookup
Error
Hi, Getting this error as attached .. Please check asap Code - fet = Form[ID != 0]; if(fet.WEEK != null) { for each rec in fet { // info rec.WEEK + " :: " +rec.ID; sat = rec.WEEK.addDay(5); if(zoho.currentdate > sat) { rec.WEEK=zoho.currentdate.toStartOfWeek().addDay(1).addDay(7);
Including field data within a URL
Hi, I'm trying to embed some fetched data into a URL to send out in an email but struggling. I have a field against a user called Calendly Username which i'm fetching from that form. That is all working fine. What i'm struggling with is using that data
Cannot Find Payment Module in Zoho Creator
Hi, I'm trying to integrate payment processing into a form I have on my application, but cannot find the option to add the relevant field anywhere. I have configured a Stripe connection (see first image), but there is no option to use it in the Integration
Multi-Page Forms
I have seen this question asked numerous times over several years, but it seems that Zoho still has not addressed it. It is possible and easy to create a multi-page form in Zoho Forms, but this functionality is still missing in Zoho Creator. Are there
Terms and Conditions Field
Is there a Terms and Conditions field in Zoho Creator like there is in Zoho Forms?
Automatically moves to next Blueprint Section
Hi, I created a blueprint where I have a Stage A, in the After section I'm executing a set of actions and depending of the result of these actions I want that the blueprint moves to Stage B if success or Stage C otherwise. I noticed that I can´t update
Set Custom Function to Open "Detail View" of a record
This may be an easy solution, however, I am looking to create a custom function button that will directly access the "Detail View" of the same record I'm viewing in another report. I assume this will be some variation of an Open Url script? i know how to create the function, just not the particular code needed to access the record detail view. Any help would be greatly appreciated.
How to show/hide fields depending on their values from another field
I have a Products form I use to insert products to my custom application (built with Creator). There are 8 checkboxes for each product... we manually mark the checkboxes (or leave them empty) during input. Then I have a "WorkOrder" form which also has
Zoho creator account slashed and de-featured after a decade of being a loyal subscriber
Zoho decided our plan, which we had had for almost a decade, needed to change. They informed us that, to keep using Zoho the way our five person company had been using it for years, we would need to pay a 500% (5x) price increase. Well, we decided we
for loop of widget - API.getAllRecords
Hi, so i have a widget and i need to get all the records of my report - more than 200. so i can call getAllRecords twice, because each time i get a 200-records page. if i don't know how many records i have, i need to use a for loop of records and loop
Angular support in widgets
Has anyone successfully used angular in their widgets? Is it possible? This is what it looks like in local debug - ng serve This is what it looks like in zoho creator
Multiple date fields in Calendar
I would like to be able to have different events (read: date fields) to appear in a calendar view. Even fields across different forms. An extra cool feature would be if each field could get it's own color for the multi-field-calendar.
How to create serial number in sub-form without using if condition
hi.... How to create s_no on deletion of rows without using if condition (or) using auto number fields. Thanks in advance for your help. Raja
Line break code assistance
Hi Could anyone advise how I could code the below to add a line break between each: This is the code: input.Trial_Class_Booked = input.Trial_Class_Options.Class.Class_Name_for_Customer_Enrolment1; This is the workflow: https://creator.zoho.com.au/appbuilder/laura_shireelite/shire-elite/workflowbuilder/Input_Trial_Class_Booked_/edit
Developing widget with real data
Is it possible to configure zet to connect to the app that we're going to be attaching a widget to. I want to be able to develop this without needing to keep packing, uploading and refreshing the page with the widget in it.
Integrate Google Maps with ZOHO Creator / ZOHO CRM / ZOHO Reports Data
HI all , On another forum discussion I told there is a workaround to integrate ZOHO Data with Google Maps . then I am getting lots of email but I could not help enough b/c of my work pressure. so I thought It would be good if I could post the process then other developers can help ZOHO users. However before proceed you might want to watch video that I posted on Youtube.com so you can see what can do ? Video link : https://www.youtube.com/watch?v=_kW1DJAf1x8&lc=z23wvvbxjkngvjf0lacdp434r453uiuqfzv0qcgb4ypw03c010c
autonumber displays "null" instead of the number
I have a formula that refs an autonumber field, the result is fine but when I thereafter edit a record the autonumber part of my result changes to display "null". Any ideas?? if((Legacy_Project_Number == ""),"LP."+ Project_autonumber ,Legacy_Project_Number)
Add Record To Form A in Application A when Form B in Application B is submitted.
Problem: I'm not able to select any forms in ApplicationA in the insert record task I'm adding to FormB in ApplicationB On Success action? I know it is more complicated to lookup a record in another application than it is to lookup a record in another form in the same application which i was able to figure out but I can't seem to find any information on "adding" a record from a form one application to a form in another application and I'm not able to select any forms in ApplicationA in the insert
"\t" is not working
Char syntax "\t" is not working since new year, is there anyone with the same problem?
Can i get a zml snippet to show a value that is generated by a function
Hi All, Any help would be appreciated, i am trying to show the last record of data on a dashboard page and below is my code used but i don't think it will allow me. Before you say i know the text value is incorrect, but i was trying different methods. <%{ last_record = Digester_Data[ID>0] sort by Date_field desc; a = last_record.Water_Temp; {%> <panel> <pr height='fill' width='fill'> <pc width='100%' bgColor='#FFFFFF' padding='20px' hAlign='center' vAlign='middle'> <pr height='auto' width='auto'>
Deluge - Quarter Inches - Remove Leading Zero
Hi, I am taking an API reading that is in total inches. I am converting to Feet, Inches, and Quarter Inches. I'm using the following code to round the quarter inches to (.25, .50, and .75) // Routine to Check for Quarter Inches vNumber2 = vTotalInches
Branding
Hi All, How do i remove links and branding of zoho from the template i print?
Lookup Fields need to show Image fields
Please add images selection to a lookup field. I have spent much time trying to piece together information from knowledge base articles dating back as much as 8 years ago, however, I am not clear on the interesting workarounds that were offered. What
Changing the standard "Invalid entries found. Rectify and submit again" message?
Is there a way I can change the "Invalid entries found. Rectify and submit again" message? I HATE THIS MESSAGE! It is VERY unclear and users are usually lost with it. Thanks
Open URL with POST
The OpenURL task allows us to open any website, however any parameters have to be encoded in the url. Is there any way to do the same thing with a POST request. I'm asking as I send JSON data to a third party for debugging purposes by using it as a beautifier.
Duplicate app *with data*
I created a copy of my app to allow an external developer to access it and do some tests. However the copy has no data. How can I create a copy with data included, or how can I move some data from my live app in a single export (not having to go to each and every form to export data)?
Alphabetize column
Why doesn't one column give the option to alphabetize the entire column? It used to do that, but after making a small change it no longer gives me that option. All I have in the drop down menu is Search.
Print
Hi All, I have written a code to print a page and content is feeded from a particular form but when i print something is overflowing and going to second page and i dont know what please help me here. I have attached the issue png as well. Style Code
Next Page