Set Expiry Time of Web Content ...
Hi: I have a Stateless Form (let us call it myForm) that looks for the value of a parameter (let us call it param1). 1) When I enter this in the Address Box of my Browser ... http://creator.zoho.com/scriptedlogic/myApp/#Form:myForm?param1=123 ... I correctly receive 123 as the value of input.param1 2) If I follow this up with ... http://creator.zoho.com/scriptedlogic/myApp/#Form:myForm?param1=12345 ... I correctly receive 12345 as the value of input.param1 3) But if I follow this up with ... http://creator.zoho.com/scriptedlogic/myApp/#Form:myForm
Reference a single script for several different events?
Hi, I have a script(Same script) that needs to run during several different circumstances (onload, on edit, on user input,etc..). Right now I have that script in 4 different places to run when various actions take place. Is it possible for me to write that script once, and reference it when each of these different events take place (onload, onedit, on userInput) ? I thought maybe a customFunction would do that, but when I wrote one, all it did was give me a button to press to execute the function.
custom action - delete entry
hi! how to make a custom action to delete an entry? there will be a button in report.
Create Invoice in HTML view or page with information from form
Hi! Is it possible to generate an HTML view, that looks like can invoice, with autofilled fields from the ID of the form that I am filling our/editing out? I would like to have a button on the form that will pop up a page or html view in an invoice format with all the information I created a PDF of a blank invoice template, is there anyway to convert this to an HTML view? Or can I drag and drop fields to create a view or page that looks like an invoice that I can print?
Create relationship between Form / Subform after import
I have imported our customers and their addresses from 2 separate files into zoho creator. I now have two forms: one customers and one addresses. I have defined addresses as subform in the customers form. What I haven't found out however is how to restore the relationship between customers and their addresses. The data was in an access db before and relationship was through a primary / foreign key 1-n realtionship. Thanks for any hint on how to achieve this (also by deluge scripting, if necessary)
No signature field in Stateless Forms?
Hi, I need a signature field in my stateless form to update it to my old report. For example, i have an order from a customer. And having a signature field in order form., I want my customer to be signed in the form when they received their orders. Thanks, George
Update iFrame with parameter when I click record
I want to create and HTML page with a report widget up and an iFrame with parameter bottom. When I click on a record I would like update iFrame bottom with a parameter that is a field of clicked record. In alternative could be a button in every row with a custom action that update iFrame. Any idea? Best regards Maurizio
Zoho Developer Wanted
We are looking to develop an cloud based app that allows our business to manage our client projects across multiple devices. We have a team of project managers that need to collaborate on keeping projects moving forward and this app will allow for projects to be tracked and modified by multiple project managers. We already have a design partner, we are looking for a development partner to help us build the idea. If you think you can help please reply.
zoho creatoer developer wanted
I'm looking for a zoho creator developer to help create a standard pdf report with a table of contents.
file upload size limit
Can I set file size limit for upload fields? This is very important as in my application, some users have uploaded monster files, and it wastes a lot of storage space as well as ruins download speeds. Thanks.
Embedding filtered report in Html page
Hi , I am looking to embed one report into html page but want to include only 2 columns of that report and records which have bookin date as today only. Please let me know how to achieve this . regards Anubhav
Default entry of today's date?
How can I make a date field produce a default date entry of today's date? Thx
download my Creator
Hi Is there a way to download what i have created on Creator? I would like to download my app in order to protect it in case of loss is it possible? If not how can i protect it ?
limit of fields
Hello the world is there a maximum quantity of field per form? because i can't add a new radio, the field is "adding" forever only the checkbox is adding well is that normal? thank you
Startup form
Hi! I was wondering if there is a way to change the first item that opens when accessing my application. Currently when I access my application for the first time of the day, I am taken to the first form I created. This is the main entry form but I have built a dashboard and would like that to be the first thing seen when accessing. Thanks in advance.
Confirm submission option for stateful and stateless buttons
Changes to data that have large consequences should have 2-factor confirmation. It would be useful to have the option to enable a 'Confirm Change' for buttons in both stateful and stateless forms. The button editor could have a toggle to turn confirmation on/off along with a text box to configure a custom message that would display in the modal confirmation dialog presented to the end user. The modal dialog would have 2 buttons: OK and Cancel.
Auto populate
If we have a "Start" Date/Time Field, how can I auto populate the "Finish" Date/Time Field on entry of the "Start" Date/Time Field in the same form as a default value to allow me to then edit the "Finish" Date/Time Field?
Add amount every time form is submitted
Hi! I have a report of contractors and I also have a form to record each time I pay them. I would like to see the total amount paid on the contractors report. Below is the Pay_Contractors form And this is the report of another form called Contractors I would like to see the total amount paid for each contractor. How do I accomplish this?
Adding line breaks in Chrome, Firefox, IE, Safari with Rich-Text troubles
Dear ZOHO, The Rich-Text fields gives me a lot of trouble. When I try to use the data of these fields, it depends on the browser whether or not line breaks <br> or </ br> are added to the field. This makes it currently undo able to use the content of this field in html-page views and the like. It seems that depending on the browser, creator adds <br> and/or <DIV> elements to the field or not. Chrome adds <DIV>, Firefox and Safari do not. I cannot tell what IE does because it will not show the RichText
Simple way to track rent received from tenants
Hello, First off, I'm totally new to databases, forms and the terminology so please bear with me. I manage a property with 50 tenants. I'm trying to create a way to have a list of current tenants that includes name, site number, monthly rent amount, and what they are paying for. I then need to be able to track the date we received their rent, amount received, payment form (check, cash, credit) and their rent paid through date. Some people pay multiple months in advance. Then ultimately an easy
How do you make a custom theme in Zoho Creator?
I've tried to look up how to make a custom theme in Zoho Creator, but all the answers I'm finding are for the old layout. It says that the "custom theme" button is under settings > customisation, but I do not see it. How do I make a custom theme in the new layout? Thanks in advance.
How do I parse JSON to use variable? toMap and getJSON are confusing...
Hey Everyone! I would love some help with this. I'm stuck. I have the following JSON. { "result":[ { "bearing":-1, "currentStateDuration":"00:53:14", "exceptionEvents":[ ], "isDeviceCommunicating":true, "isDriving":false, "latitude":34.9946861, "longitude":-106.659889, "speed":0.0, "dateTime":"2017-03-02T19:31:44.000Z", "device":{ "id":"b1" }, "driver":"UnknownDriverId",
Pass dates to OpenURL
I am trying to create a stateless form that has two fields a Start Date and an End Date. The idea is to pass these dates to the OpenURL and generate a report based that includes all the dates between Start Date and End date. but when I follow the example on the functionality based URL's, my report does not filter the unwanted records out. openUrl("https://app.zohocreator.com/notjustanothername/order-management#Report:ALLORDERS?Order_Date=input.Start_Date;input.End_Date&Order_Date_op=58","same window");
Need help with rule criteria for checkbox
I need help with a rule creation. I have a check box field for yes/no. I then have another field that I want displayed if the check box for yes is checked. I understand that the criteria has to be set as true for yes. but I'm having trouble seeing where and how to set that. Under the criteria section I have selected the field name, but under the operator menu I see the choices as EQUALS NOT EQUAL TO STARTS WITH ENDS WITH CONTAINS DOES NOT CONTAIN How do I set the criteria for a TRUE or FALSE? And
Rich text fields in Subforms
Hello. When I create a field in a subform, I get the following type options: As you can see, Rich text doesn't appear as an option. Is there an alternative way to use Rich text fields in a subform? Thanks in advance.
What does it mean "Error at line 0"?
Here is the function that I wrote: map externalapps.GetCurrentSymptoms() { symptomMap = map(); for each Symptom_ID in Symptoms [notContains(Symptom_Name,"Deprecated")] { symptomMap.put(input.Symptom_ID,input.Symptom_Name); } return symptomMap(); } When I try to save, it gives me this error: Error at line number : 0 Mismatch data type for function 'put' at argument index 2 expected data type STRING found data type SymptomsI don't really know how to debug this one? Symptom_ID
Display Image from Another Form.
Good Day, I created a form with an image and on my second form, when I select the product, I would like the image to display. Please advise. Thanks Safraz
Prevent duplicate item on same date
Hi! When I am adding a new record, I would like my dropdown menu (that is in the form) to grey-out the items that are already recorded on the same date as the field in my form. In other words, I would like to prevent an item being double-booked on the same date. How do I do this? I would like for the dropdown of "Facade" to grey out any other items that are being used on the same date. The date is in "Date of Event". I should also mention that "Facade" is a lookup field.
Google Drive function?
I've find this Google Drive function in deluge script... any news?
HI
even though i publish my website i cannot access my website :( it indicates that web site cannot be found (DNS PROBLEM )but the site publishes sucessfully
19-digit number replaces the original data in report column
Hi An error has shown up yesterday in a report. Instead of the proper data - in this case the name of the assigned caseworker ("sagsbehandler") a 19-digit number shows up. Same goes for the assigned consultant (konsulent-kontaktperson). When I group the colums by caserworker or consultant it will readily display the name but not when they are just data in a column. Please have a look at the attachments. I thank you very much in advance for your help. Best regards Thomas
Can't delete profiles
I have created an app and shared it but they can't log in. An error message pops up saying that they are logged in but they can't access the app. Your suggestion on the topics is to delete the profiles, "Deleting the roles and profiles for the user will solve the issue. Please click on the below link and follow the steps to delete the profile. https://www.zoho.com/creator/help/security/clone-profiles.html#Deleting_Profiles But there is no "X" to delete a profile and the edit is greyed out. I only
triple column
Hi Is it possible to create a triple column as it is possible to create a double column on the form of zoho creator? thank you
Customer Portal & Ipad App & other issues
I have a few questions about the customer portal We created a customer portal user, but: A. The customer can not log-in using the iPad app. Does a user of the customer portal not have use of the android and ipad creator apps? B. When they log-in the old version of zoho creator is what appears. What needs to be does to insure that the new ui appears when a user logs in through the customer portal?
to populate a subform based on a form
Hi, I have a form named "inventory" with product_name and quantity. I would like to have a new form named "inventory entry" with a subform that populate each product_name in order to fill the new quantity to add. How can I do it? Thanks, David
Free form Deluge code displayed differently than it is saved and executed. Subsequent edits cause errors.
First example: If I switch to Form Builder view and then back to workflow view, the line: lstAnswerChoices = recAssessment.subAnswerChoices.ID.getall();is changed to: lstAnswerChoices = recAssessment.subAnswerChoices.getall();If I then try to save without making any changes I get an error. Second example: If I save the following line and navigate back to the function, it is displayed without the first set of parenthesis which returns a completely different result: strDisplayName = (rec.rtfQuestion
Can I create an App to calculate Selling Prices?
I want to be able to calculate selling prices for Items in Zoho Books/Inventory, based on a number of factors including: - The buy price in currency - The Currency Type for a Vendor - The exchange rate - etc Can I create a Zoho App using Creator to do this, perhaps triggered by a custom button in Zoho Inventory? John Legg Owner: The Debug Store
Precreator.zoho.com unavailable anymore?
I remember being able to access https://precreator.zoho.com/ to get the latest features in beta for ZohoCreator. However this morning, the link is dead. What happened ?
Functions within a form (Form scope, not application scope)
Wondering if it's possible to create a reusable function with form scope only. It appears Creator only allows application scope functions. Form scope functions would make it easier to reuse code that is specific to the form and make for less lines of code and easier maintenance.
Show/Hide events on calendar view
Hi, I have a create_event form and it has 5 different types_of_events. How can I code such that the report can show or hide events pertaining to the type_of_event selected as a custom function? Thanks!
Next Page