amyway to retrieve my work lost by the Sandbox feature in zoho curator
errror publishing keeps poping up. I filed a support ticket with no response in 12 hours. every time i press the Publish button I got a "errror publishing". These were minor changes. Support says 10 hour response but not every day I guess. This is a rather useless feature if I have to wait days or weeks to interrupt my workflow. Does everyone rely on the back up and restore feature instead or is that just as unreliable? ty
How can I allow users to upload more than 1 file at a time?
How can I allow end-user to upload more than one file if given quantity is more than one? For example: I've created a form where user can put quantity and I want them to allow as many file uploads a quantity amount. Right now, if the quantity is more than 1, it still only allows only one upload. Thank You
Add Business Days BUT excluding holidays and sundays only like workdays
Hi! Please, your help with the following: Please, use the example bellow to understand my idea: Initial_Date: '20-12-2019'; "Add" 32 "business days" to "Initial_Date", but with the following criterias: - 1st: Considering like workdays from Monday to Saturday. - 2nd: Considering the following Holiday list: Holidays = {'25-12-2019', '01-01-2020'; '15-02-2020'}; My problem is that the function "addBusinessDays()" do not permit both to exclude holidays like other functions (i.e. workdays) but to
Password Field in Zoho Creator
I need to know that whether a password field can be created in the Zoho Creator. Is their way to create a password field using Deluge Script.
Feedback Analysis by rating field in Zoho Creator
Namaskaram Zoho Creator team, Good if form builder contains a field for Rating with stars in Zoho creator form creation, to find customer satisfaction level - it is useful for feedback analysis specifically in products sales Now, form builder contains a field called sentiment analysis to analyze entered customer feedback from a single-line field. But the rating stars are often used in web forms and apps for feedback analysis. So people are familiar with using this one instead of using AI for
Functionality Issue in Zoho Creator - While opening the Deluge Script Editor
Namaskaram Zoho Creator team, Refer below image. Whenever opening the script editor from workflow editor [ref:Image 1], It should open the script editor page [ref:Image 2], Instead of that, it shows the 'Add New Action' page[ref:Image 3],. if we tried to close it by tap on the cross symbol 'X', It shows an dialog box with two options as 'Close' And 'Cancel' [ref:Image 4],. If we choose 'Close', it's not performing any action. while selecting 'Cancel' the dialogue box closes. To go back, we
UI Issue in Zoho Creator - 'Refer Fields' side bar is hiding the code content in HTML Snippet - Zoho Creator
Namaskaram Zoho Creator team, While using the refer fields side bar in HTML Snippet editor in Pages. It hides the code content. Image 1 shows the HTML snippet editor before using Refer Fields and Image 2 shows that the code contents are hidden while using Refer Fields.Also it is not showing any scroll bar below the HTML Snippet editor to view the hidden code content. Image 1: Image 2: Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho
UI Issue in Zoho Creator - While using conditional formatting tool tip should not be shown there
Namaskaram Zoho Creator team, In field configuration settings it shows 'i' icon (Refer Image 1) near the fields and while using conditional formatting for any field it shows a list of created rule and in that the 'i' icon is also visible which is in behind the conditional formatting setting (Refer Image 2) also it shows tool tip when we hover the 'i' icon which is in the conditional formatting setting (Refer Image 3) Image 1: Image 2: Image 3: Crafted with
Functionality Issue : Filtered keywords not containing space are not shown above Reports while using Open URL
Namaskaram Zoho Creator Team, While using filter in open URL to open a report the filter is applied properly. But its not showing the filtered key words above report when the key word used in filter has no space after are between the keyword.(For example: when we use current_status= 'Draft' as filter then the report shows list of entries having Draft as current_status but the applied keyword was not shown above the report.If we use current_status='Draft ' (Here
Customers - Timesheet - Calender
* Sorry moved this to the Zoho Creator Forum Hi, I'm trying to make an app where a user can see an appointment schedule (the user has a customer permission) for his workweek or month. The customer can only see his schedule. So far so good. But i want to make a timesheet where the user can add the real time spended during that appointment. Forms/Reports that i made are: - Customer - Employee (in this form i have a User field with customer permissions) - Appointments (in this form i have a lookup
ignore duplicates in for each
Hi, I am using the following programme to return values (Bin Numbers) and dates that have been used in the report. a = Collections[Bin_Number != "" && Site_Name.Customer_No == "WXH" && Date_Time > zoho.currentdate.subMonth(1)]; b = Master_Bin_List[Bin_Number not in a.Bin_Number.getall() && Site_Name.Customer_No == "WXH" && Ignore_in_count1 != "yes"].Bin_Number.getAll(); c = Collections[Bin_Number in b] sort by Date_Time desc; d = Master_Bin_List[Bin_Number not in c.Bin_Number.getall() && Bin_Number
Sending file via PostURL
I want to postURL data that includes a file that has been uploaded to a record. I created a simple function which should do it but I get a server error from the receiving web service. Probably because Zoho Creator automatically uses a Content-Type of application/x-www-form-urlencoded when what I really need to send is probably a different content-type (multipart/form-data?) to the url. Any ideas on how I can post a file using postURL?
Planning material with stock
Hi all, I'm trying some things with the conference room booking system, to build a crew and materials planning application. So what I did was changing the conference room page to a materials page. I love the way that it checks the availability. What I want to add is the following: 1. So lets' say I want to add a camera. I have 5 of these, so I want to add a number field in which I input 5. 2. Now when I make a booking I want the option to say I need 2 for that date/time. 3. Great! Now I have 2
Close Browser Tab
I am opening and editing a record via a link in an HTML page. I would like to close this window once the record has been submitted and return to the HTML page. I have tried a couple of options but have not found one that works. I am not opening the new window via openURL(), rather the <a> tag in HTML. Thanks for any suggestions.
Logic-based form calculations - Conditional Formula for Zoho Creator
Hi, I see Zoho just introduced a Conditional Formula for Zoho Forms. It would be great to implement the same feature on Zoho Creator Formula Fields. Here the details of the this new feature introduced in Zoho Forms: https://help.zoho.com/portal/en/community/topic/logic-based-form-calculations-introducing-conditional-formula-for-zoho-forms
Ability to define the appearance (currency, decimal, etc.) on Formula Field
The Formula Field does not allow the user to define the appearance/format option, it would be great to add it so that the user can define the appearance for this field same as currently supported in Number/Decimal/Currency fields: Post discussing this topic: https://help.zoho.com/portal/en/community/topic/how-to-display-formula-result-as-currency
How to update a form with data from a crm look up field in another form in the same application so that it shows as a text value rather than the ID number?
Hi there, I need to create update a form called "US Customers" with data from a form called "Customer Cancellation Form". This works fine using the Data Access/Add Record /"insert into... procedure . The only problem is that one field I need called "Organisation name" is a look up field to zoho crm . This field in the new form displays the Organisation ID not the name of the organisation insert into US_Customer [ Organisation_Name=input.Organisation_Name Contact=input.Contact Email=input.Email
In-App Notification Counter on Menu
See attached screenshot. Would be really nice to have a "counter", especially on the "Approvals" workflow tab.
Barcode Scanning
Hello, I would like to integrate hardware barcode scanner with Zoho creator, how do i do it?
Using addbusinessday formula with holidays and weekdays
Please, your help with the following situation. I want to use the formula addbusinessdays() but I cannot enter both holidays but specific workdays ranges. In my case I need to add some business days to a start date but considering workdays from Monday to Saturday and a short list of holidays... Please your help! Some formula example?
Enter value for input arguments
What does this mean? "Please enter the value for the input arguments." Room and Bed Registration is the name of the form I am trying to run this schedule on. I don't know what it is looking for. Thanks so much to all you who understand these things
Workflows with translated dropdown fields on mobile
Hi, I tried translating the values of a dropdown field to sapanish and found that my existing triggers related to the options chosen on that field still work while using the web but fail when using the mobile version. Is it a known error? Thanks!
Cancel subform delete
I have a form with a table of subform rows. I need to allow users to delete rows but not all rows. The capability to delete a row needs to be determined by a value in the subform record. I understand that I cannot conditionally enable/disable the delete function but was wondering if there was another way to achieve what I want. The onValidate function of a form provides the ability to 'cancel submit'. A 'cancel delete' function in onDeleteRow could give me what I need but alas it doesn't exist. onDeleteRow()
Menu - Sync Across Platforms
Hi, I've just noticed that my menu's are different across the different platforms. Is there a way to sync them all to my laptop view? Thanks
Data Limitation
What is the real limitations of size data and columns of a table in Creator? How many rows of data can it handle in a real production environment? At what point the performance of an app starts suffering because of size of table or total data size of an application?
Amount in words
Hi, Is it possible to get Currency in Words ? for e.g Total Amount is Rs 100 In Words: One Hundred Only.
Is there a way to send Uploaded Files from one application to another using postUrl?
I need to send a file from an application on one account to an app on another account, possibly using postUrl(). I'm currently getting an error when attempting this. Is there a way to resolve this?
Timeline in detail view
Hi, How do I create a more rich details page about, for example, a project. So when you click on a project in a list it goes to a new page which shows the information about it, but also a timeline for that project only. I think the pop-up sliding in from the right isn't big enough for large projects with lots of information. Thanks, Stefan
Zoho Or Knack
Hi, At the moment i'm creating an app with Knack that needs to handle team scheduling, equipment reservations / bookings (with stock on certain dates) and combined with this a ticket system (and maybe in the future time tracking). With Knack i'm running into the issue that it doesn't handle time/reservation systems very well. Does Zoho do this better? In the system I want to have multiple types of data that all needs to be combined: Team / Crew Projects Freelance crew Equipment (with the possibility
Statement Execution Limit Problem
Hi, I'm trying to fill some drop down boxes based on a previously entered value, where it has to search through just under 1000 entries. here is the code: for each AT in Asset_Types { if(input.Asset_Type = AT.Asset_Name) { for each AC in AT.Asset_Components { for each CT in Component_Types { if(CT.Item_Name.contains(AC)) { prefix = CT.Component_Code_Prefix; for each comp in Component_Stock { if(comp.Component_Code.contains(prefix)) { if(i = 0) { input.Part_1:ui.add(comp.Component_Code); } else
Changing Subform Fields via Script
Hi I have a process that basically confirms an order, the MainForm sends Email, the Email links to Stateless Form, the Stateless Form changes the Confirmation Field on the MainForm. This all works wonderfully but I now need to change the value of a field in rows on a subform in the main form when the Confirmation Field is changed. I've tried daisy chaining the scripts via 'On User Input' of the changed field but this only works when I change the field manually in the form, how do I get it to change
Passing a parameter to a drop-down field
Hi Zoho, How can I pass a parameter through the URL to a drop-down field? Thanks Ravid
SaaS Challenge - No Admin or ability to preload data, what are my options
Dear friends As we all are aware Zoho is launching a SaaS model, and I know there has been quite a heated debate - and as it is still early days, more debate to come. Personally I think it is a good move, but it is posing some challenges. You might be aware there is no Admin function (from developers point of view) so only the customer has access to their instance. This is mostly OK. You may not be aware that there is no Audit function, nor is there the ability to preload a form with data. The audit
Error with json response in REST API - List Forms in Application
While working today on an application, i needed to fetch all the forms in my application, using the REST API - List Forms in Application to perform some functions on it, then i noticed the json format ruturned - the "display-name" was interchanged for the "component-name". here is the response in json below: {"application-name":["chservicesalesmgt1-ide",{"formList":[{"formCount":20},{"linkid":26,"displayname":"Add_Invoice","componentname":"CheckOut","type":1},{"linkid":27,"displayname":"Add_Discount","componentname":"Add
What is the difference between customers & users
Hello, I don't understand the difference between customers and users. Can someone explain it to me? What are the limits for customers? Thanks, Stefan
Write a common function for invoice calculation.
I have an Invoice form. I need to calculate invoice totals every time there is change in some fields (for eg. product, quantity, price). Is it possible to write a common function to calculate the totals instead of doing the calculation in every field.
In zoho creator do we have search with barocde scanning for form detail page?
i want to create an app from which a person can read the barcode of prouct and get the details of that stored in form detail page
Access MainForm dropdown selection in subform
Hi I have a lookup in a subform that i want to filter based on a lookup selection in the main form. how to do this? e.g Main form i have a dropdown called Customer - based on the customer selected, in subform, i want to show only products pertaining to that customer. I did a set_filter for the lookup in the subform: Customer == Main.Customer This doesn't work. If i hardcode a value, Customer == "abc" it filters correctly and shows
Pivot Table - Query - Last Records
I have a log of sorts. Each log has a unique key pair (two values) and based on random dates, I add an entry. For example: Item 1 - Sub Item 1 - 01-01-2019 - value1, value 2 Item 2 - Sub Item 2 - 02-13-2019 - value1, value 2 Item 1 - Sub Item 1 - 06-05-2019 - value1, value 2 Item 1 - Sub Item 1 - 07-01-2019 - value1, value 2 Item 2 - Sub Item 2 - 04-14-2019 - value1, value 2 I only want to produce a report that is based on the key pair - Item # plus Sub Item # for the last date. So the report would
Change Text Color for each choice in a drop down box form.
I have attached a partial image of my form. Under the Status Field, I have 5 choices in the drop down box. Is there a simple way to change the background color for the text? I would like to have a different background color for each choice in the drop down box Is an html page used? If so, how is it done. Thanks so much, David
Next Page