Control sort order of subform
how do I control the sort of the items in a subform? for example, in the attached image, I want the dates to be chronologically accurate
Add line breaks to this formula
Hey Everyone, I'm having a hard time trying to figure out how to add line breaks to this formula. input.Notes = "Sets = " + SingleWorkout.Sets + "<br>" + "Reps = " + SingleWorkout.Reps + "<br>" + "Instructions = " + SingleWorkout.Instructions; It should look like this... Sets = XXX Reps = XXX Instructions = XXX but instead it just inputs the values as one line and the <br> as text. Any help would be great. Thanks!
Is it possible to create unique records in a form with multiple dropdown fields?
I have created a form which includes 3 dropdown fields. This form allows me to enter the selection combinations of these dropdown fields more than one time into it. I'm trying to create unique values (combinations) on this form which will then be used as a subform and each unique value (combination) will be assigned to multiple records on the main form. How can I achieve this task?
How to specify Digest Authentication in HTTP Header for POST Request?
I can't tell what the requirements are to establish Digest Authentication session with the creator Post URL function. I see a number of examples for basic, but none for digest.
Cannot capture data in form, I already fixed this.
error Error details: Error in executing On Add - On Success script Usage Limit Reached Line:(1)
Add Task if based on sub-form input
Hello, I have Brands containing a Voting sub-form. Voting contains the following fields: - User - Rating I would like to create a workflow so that whenever I add a Voting User to a Brand, it will create a task for that user if the Rating is null. I have
ZOHO CREATOR RUNS SOOO SLOWLY!
Anyone else have regular issues with this? Trying to edit records is painful and unusable sometimes
Report Columns width
Is there any way to control the width of a column in a list report? limit num of chars? Thanks
CUSTOMISE REPORTS LOOK AND FEEL
Hi, Is there a way to customize the report format in terms of giving color code to header line etc.. while exporting it or while sharing it through schedules. Thanks
Customer Portal Page Customization
About the customization of login / signup / password reset pages in Customer Portal. I am trying to reflect the clients brand, but there seems limited options. How to change the styling of the included forms. Eg default light blue colour of titles and buttons? I am confused by this post https://help.zoho.com/portal/en/community/topic/customer-portal-improvement where I see screenshot of highly customized signup page. This is my interface attached. Can I load additional CSS somewhere in the page?
How to have list of dates
I'm wondering how to have a list of dates and times, where they can be entered using calendar display functionality. The purpose is a tracking/logging app.
Trying to create a lookup field formula for text and I only get numbers
Newbie here. I have a Project application and in it is a New Project form where there is a text field for the title of the project. I have an Assignment form that has a lookup field for the title of all existing projects. It also has a field for the person I want to assign a task to. I have a formula field that is supposed to give me the name of the project and the person assigned to it (So I can use that in a To-Do form later on). Every time I select a project in the Assignment form it returns a
Submit form to web service - can it be done with Zoho?
I love the drag and drop fields on the web form, and I'd like to use Zoho as my custom form builder. Is Zoho Creator capable of submitting content to a Webservice URL? Here's the form: https://creator.zoho.com/jcsieben/portal/form-perma/Web_Submission Thanks in advance, Jeff
Mobile numeric keypad not showing for decimal, currency or percentage field types.
Normally a numeric keypad is presented in mobile view when the input field is a numeric value. This works with the "Numeric" field type, but when the "Decimal", "Currency" or "Percentage" field types are selected, they revert to the normal qwerty keyboard.
Zoho Creator API - Get the value of the logged in user
I have an api that I wish to return a list of sites where the added user matches the zoho.loginuser. I can write the criteria: https://app.zohocreator.eu/api/v2/XXXXXX/APPNAME/report/Location_Report?criteria=Added_User="zoho_username" but is there anyway
Creator Ver 5 Keyword Extraction and Wordcloud
I am using the new AI feature of Keyword Extraction to capture the keywords used in data entry. I then want to create a Wordcloud to visually display this data over a set of records. Zoho Sheets can generate wordclouds by requires each row to capture
Password protected form?
Is it possible? I'd like to invite outsiders to get a survey/poll. Airtable has this ability.
Sort Column chart X Axis
I have a chart where the X axis is Months. How do I sort it so it is in the proper order?
Subform file insert
Is there a way to get a subform file field insert to work ? The same script works ok for other fields but not if the field is a file field Deluge show the file field as string, and it works to copy across forms but inserting in a subform fails with this
Sync fields in different forms
I have a form called Clients and a form called Policies, which has a lookup field "Client Name" One client can have multiple policies. Both forms have a "Inactive" decision box field as well as a "Inactive Date" field. What I need is when the inactive
Is it possible to create a dashboard button to invoke the data import routine directly? Thanks
I would like to bring this up directly: Thank you. Patrick
Can we set "Don't Import Data" as the default on the second screen of the import routine?
Can we set "Don't Import Data" as the default on the second screen of the import routine? Thank you. Patrick
Show fields in Pivot table
Hello. I have a Form with 3 fields: Task, Role, and Responsibility. For each Task, a Role can have different Responsibilities. For example, having Task1 and Task2, and Role1, Role2 and Role3, the data rows could be: Task1, Role1, Responsibility1 Task1,
Updating custom fields in creator
I'm trying to update a sales order with the id of the component that is linked to it in our creator app when a new item is saved. However, the custom field that I made for the id isn't being filled in. Does anyone have any thoughts as to what I'm doing
Finite State Machine
Having worked with Deluge for a few weeks now, it's become clear that Deluge isn't a programing or scripting language. This inherently means that they don't include features like counted or conditional loops, infinite recursion, or other features that
Filter report by current month
I have a report with a dropdown month field. I need to filter the report to only show records for the current month I have tried: Renewal_Month == zoho.currentdate.getMonth() Renewal_Month == zoho.currentdate.toString("MMMM") I also created a formula
Script dependant on radio button selected
I cannot define my radio button... How it is setup now: When the user selects the "Recall" radio button as the "Appointment Type" the hidden field "Recall W.O.#" shows.... this works great, however, I need the Recall W.O.# to be filled out by the user.
Filtering Related records
I have a forms named Clients, Policies and Renewals Each record in Clients will have 1 or 2 records in Policies and each Policy will have multiple records in Renewals. There is a lookup field in Policies called Client Name (Clients Form) and 2 lookup
Formula field showing record ID instead of name
i have a formula field with the expression: input.Policies.Carriers I am trying to pull the Carriers field from the Policies form into this form. However, It pulls the ID number and not the Name. How do i get it to display the name?
how can i disable this option of my report?
sorry, new to creator , i cant find where i can disable the "more options" of my report i just wanted it to display as a list and that's it., thanks
download file from report
Hi, Good day to you! I want to download a file from the report by clicking the button in the page. Say, I have a button in html page in creator. By clicking that button i want the file to be downloaded into my desktop/laptop. The file is available in the report of same application where the page reside. Thanks, ITKES
Grey-out ( disable ) past dates and today date in Zoho creator calendar for Date-Time field.
Hi, I want the user to choose a date only after 24 hours. To explain this point, If I am filling in the request form today I can only choose a date 24 hrs from now and the date prior to 24 hrs will be greyed out. How can this be achieved ?
Bug with WF User Input of Date Field
I have set an alert message on User Input of a Date Field. Date Field Deluge Script Bug Type 1: Step 1: I select a date. The alert message is shown. Step 2: I delete the date and click out of the field, the alert message is shown. Step 3: I click on
Managing task on zoho creator.
How to manage task in zoho creator and make other owners so that they can see their own task but not of others.
Average record values of sub-form
Hello I have a Form called Opportunity with a sub-form called Voting, containing fields called Number. I would like to have a field showing the average of the voting numbers for that particular opportunity. So I created a formula filed on the Opportunity
Fetch Field value from another form based on Lookup value
Hello, I have a Form called Opportunity and another one called Contact There is a bi-directional lookup relationship where an opportunity is related to one contact and a contact to one opportunity. On the Opportunity Form I would like to Display the Contact
On Success form open another form and populats fields
Hi, I am a newbie and I am trying to develop an app for my business. One of the many problems I am facing ... : 1/ Form "New_Request" is the form where a fill up some basic info of a new client. Among various fields I have "client_name". 2/ Form "Tour_Program"
can we delete any Deal From Zoho Creator
Hello Everyone Thanks so much for Reading this Problem Actually i have facing a problem I am not bale to delete any sales order from Zoho Creatore. Please Provide me a Solution. if it is Possible Wih Deluge then please how can I do it. Thank You
Deluge insert row does not trigger "On add Row" Workflow
Hello, i have a Form with a Subform. On Load, i add some Rows to the Subform dynamicaly with: row = Meetings.People(); row.Selected="Bob"; input.People.insert(row); there is a Dropdown field in the Subform. On Add Row, i filled this Dropdown with: row.dropdown.add("Value1");
data import
Hello, I have a difficulty with data import to Creator. I have a sales form with a subform with sale details. As far as I know two excel sheets are needed to import data to Creator in such cases: - one for form fields, - the other with subform fields.
Next Page