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.
To fetch employee details
Hi i am developing an application for my company in which i need to access the employee details. I have created a function where the output of that is my employee details but i am not knowing which input field in form design i have to use to get employee
Page with multiple reports with filters from a record's data?
Hi, I'm trying to make a page that will show a single record from my form Designs, and show a report of Components filtered by information in the Designs record. For example, all components rated for 3-5KW, all components for 200V, etc. What is the most
Translation of language on Page Components
Hi, has anyone had experience to translate language on Page Components? I notice that Zoho doesn't support this part of localisation (https://www.zoho.com/creator/newhelp/app-settings/understand-localization.html#language_options). Just wondering if I
Localisation of Page Components
Hi, has anyone had experience to translate language on Page Components? I notice that Zoho doesn't support this part of localisation (https://www.zoho.com/creator/newhelp/app-settings/understand-localization.html#language_options). Just wondering if I
Zoho Creator Page columns
Is it possible to adjust the width of columns on a Page either on the elements (Panel/Button, etc.) or through a ZML snippet? There are a couple of sample applications that seem to should this where there is a 4 column width grid of items but some of
javascript:///alert(9)/
"><img src=x onerror=prompt(9)><" "><img src=x onerror=prompt(9)><"
How to add a Fliter in a report that is called inside HTML page
My Dashboard has a search on top where user can search record by entering ID called as "Request ID". It opens REPORT for the entered ID but there is an ADD record button on bottom-left which I don't want them to see, although records can be added by them.
Iterating through records and sending email message to distinct email values
Hi, I am trying to iterate through records based on a criteria and that will give me multiple records. However, I only want to send email the the email value once if the email is repeated in the records. This script will email the same user multiple times.
Conference Room Booking App
Hi, I am trying to use the prebuilt Conference Room Booking app in Zoho Creator. However, I realised that the app allows overlapping of booking of the same room at the same time. Please help me with scripting some validation to prevent overlapping of
image gallery
we are building an application for real estate and need the best way possible to display a property's images. what is the closest or best way to replicate an image gallery using zoho creator?
Setting "Remind At" Date in a CRM Task via the Creator CRM API
Hello， From Creator I have satisfactorily been able to create a CRM contact record, and assign a task to that person. However, I would also like to be able to set a 'Remind At' date for 3 days after the contact record has been created, to remind me to contact that person. It's not clear if, or how, this can be done from the Creator API...because within CRM, the 'Remind At' field has, I guess, a number of sub-fields....here is the sample code that I am working with... tomorrowDate = zoho.currentdate.addDay(1);
Next Page