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
File upload thumbnail preview.
We would like to be able to have a thumbnail preview of the image files we upload. For now what we do is to upload a file, go to the list view, copy the URL and paste it on the Image Field, but this doesn't work for different views because the link has a reference to the view and not to the file itself. :( Very disappointing!!! Today all programs have previews for image files. Its ridiculous that we have to do all this work to get a thumbnail up.:( Florencia
May i know the links of material of learning zoho creator from beginner to expert .. it may be books, links of codes , Youtube links ..
May i know the links of material of learning zoho creator from beginner to expert .. it may be books, links of codes , Youtube links ... Thank you, Sidhant A.
Embedding Tableau Dashboard into Zoho Creator
Could anyone please help I'm trying to embed tableau dashboard into my website?
Sendmail with Attachment in Function
Hi Gurus, I'm trying to set up a function that utilizes sendmail with an attachment. I have created an html view to display a record, and my function to 'show pdf' works well. I'd like to be able to trigger a function to send an email with said pdf attachment, but I get a generic "Error in executing SendMail task" error. If I remove the code for the attachment, it works. Can anybody help? void BEO.sendBEO(Events thisEventID) { thisEvent = Events [ID == thisEventID.ID.toLong()]; Title =
Display list of images in form
I have a requirement to attach one or more pictures to a form record. The form view must then show all pictures attached to the form. The images need to show, not the filenames. At first I thought a subform would be the answer, but I cannot get the pictures
Sample code for passing parameters to a form from a view
Can someone please point me to sample code for how to pass a parameter when opening a form from a custom action in a view? I've created a function with an openURL statement for the form I want to open, which works. However, I can't figure out the syntax for passing the function parameter through to the On Load action in the form. The error msg says that the input.RefVar is null in the On Load action. Thanks.
Next Page