Calculate Age
All post on this are 10 years old or so (at least what I can find). I gotta be missing something like YearDiff(Date1, Date2). I found this: (((zoho.currentdate - input.DOB)) / (1000 * 60 * 60 * 24 * 365)).round(0) it does not work correctly. How would I calculate a person's age?
Link a Creator Form to a Zoho Forms form
Hi, I'm wondering if it's possible to auto populate a Zoho Forms form on submit of a Creator form? The end goal is to create a document in Writer using 'Merge on Form Submission', which as far as i can tell, can only be done from a Forms form and not from Creator. Any answers/ideas/hints would be helpful. Thanks.
How do I make a check for an existing record Not case sensetive
If I'm checking to see if a record trying to be entered already exists, how do I make ignore the case? The code below works for checking my records, but if a user doesn't capitalize their entry, it gets added to the table/form. if (count(Region[RegionName == input.New_Region]) > 0) { alert(("This Region already exists, please select from the list above")); input.New_Region = ""; }
Calculation in subform
Hi everyone. I have my subform as with an struture of a product, and I need to calculate in this way: Inside of the form "MODELOS" I have subform "ESTRUTURA" That means that I have a field "Consumo_Unit" that means consume, and I have a field "Custo" that is the total cost, and I also have a field with name "Custo_Unit1" this mean that I need this calculation: "Consumo_Unit" * "Custo" = "Custo_Unit1" So, how I can do this ? Thank in advance.
How to edit /delete Page Parameters in Zoho Creator under Zoho Developer?
Team, We are unable to edit page parameters or delete them under "Page properties". Could you please provide direction? See snapshot below:
Zoho Developer Custom Solution - Dashboard Does not Load - Script Timeout
Team, After importing a .ds file, the dashboard for our Zoho Developer custom solution does not load. Every other menu item on the left hand column works, except for dashboard. See snapshot below: the load progress blue bard on top stays blue all the way and nothing loads. What may be causing this issue and what do you suggest as a resolution?
Can I insert rows (add records) using criteria in a multiselect field?
Hi fellow zohoers, Thanks to some help from a moderator here. the code I used below allowed me to insert rows in a different table given certain criteria: The decision box "All" had to have a value of "true" (if (input.All))- and the input.client id had to match the client id selected in my URLs table (in my SEO order tracking app, this script is executed in my Orders form and inserts rows in the Order Lines form for each URL a selected client has. My question is: can I adapt the following code so
Using REST API insert to subform !
i have a main form call as Employee in this form has subform with Name: Employee Adress is a Subform fo Adress now i using REST API ................... <input type="text" name="Employee Adress[City]" value=""/> but did not work ! so how to format a subform data to work with ReST APi thanks for support !
Passing URL query string to embedded form
Hi there, I have an embedded (Iframe) Zoho Creator form on my external website which I am trying to pre-populate via a URL query string. The query is populated from merge tags, meaning the value changes depending on who clicks the link. I'm having trouble getting the web page to pass on the parameters to the embedded Iframe.... Example as a link from an email (where the name values would change given the merge tags: <mywebsite>/edm-enquiry/?fname=Emily&lname=Smith Iframe embedded into my website:
Zoho Creator XML RPC API - Add Record NOT WORKING - returns 200 success with empty response object
Hi, I am trying to add a new record to a form using the Zoho Creator XML RPC API and it's not working. The API always returns a 200 success code with and empty <response /> object, but no data gets inserted/added, nothing happens. (If I use the REST API, it works but REST doesn't support adding data to subforms) Here's an example request to a basic form that has only 1 field : XML RPC API (Not working) : REST API (working but cannot add subforms) : Si essentially I have 2 questions : 1) Can someone
Redirect Customer Portal to external domain
Hi, I posted another question but perhaps this a better explanation. I have a domain say https://www.mydomain.com . I want customers that go to that domain will be redirected to my Zoho Customer Portal. I verified the domain that works but this just seems to concern mail. I really want a redirect, My hostingcompany asks for ipadres and such for a dns redirection. Where do i find this ? Please help i'm on a deadline and dns resolves will take long. Thanks !!!
Print out a report page ?
Hello, In Creator I build a page with multiple panel and reports. I'm asked to have a PDF version of it, or at least the information. How can I acheive this ? There is apparently no way to print this page. Thanks
Hide / unhide custom action button with conditional statement
I have a custom action (to call a function) on a view. Is there a way to hide / unhide or enable / disable the custom action button based on a conditional statement (ex. IF statement)?
How do I remove a creator app that was shared with me
Hi, Someone shared an app with me but I do not have access to it. They are no longer around and I have no way of contacing the person. How do I remove an app I have never seen or used from our account? Thanks
Subform as a pop up box
My subform contains too many fields for the width of the screen. It looks terrible and is hard to use. Is there any way to have the subform come up in a popup box with the fields stacked vertically instead of horizontally, when one click on "add new" in the parent form? See pic. ?
Sign in to databases
It seems I never know if I will be required to sign in to my Creator databases, or not. Some times I don't, but lately most all the times I am required to sign in. Cookies are enabled. No one touches the databases but myself, and I'd prefer to not have to sign in every time I open one for changes.
Zoho Creator Functionality issue - Workflow triggering on Stateless form
Namaskaram Zoho Creator team, When we tried to create a workflow based on a stateless form, there are two options are available for triggering that workflow. One is 'Button click' and another one is 'Created'. Initially 'Created' has selected. When I click on the 'Button click', the 'Choose button' option has started to visible. After that, If I select 'Created' then the 'Choose button' option should be hidden. But it is being visible after selecting the 'Created' Option. Please have a look
Problem with Report Filter in Zoho Creator
Namaskaram Zoho Creator team, we have found a problem with Report Filter in Zoho Creator. We can't set a filter based on an image field from 'edit' mode of the application. But we can do the same from 'live' mode of the application. After setting it from 'live' mode, we have tried to edit the filter of the same report from 'edit' mode. Then we saw an error in that filter editing window that is the filter what we set from live mode based on the image field has been cleared automatically. Please
hyperlink
Hi, I wanted to insert website addresses in zoho creator. How to just insert a name, and then add link to instead of writing the full hyperlink address. Thanks Budcare
Line numbering / background toggle in PDF template
Hi, I'm currently building a Print & PDF template for one Report. The related form has a subform I'm inserting in the PDF. Customizing the page is quite difficult as I try to customize the HTML code. Customizing the subform field is even more limited it seems, and not html can't be changed as it's rewritten each time. My goal is to either add line numbering to each record, or display a gray background every 2 lines. Is there a way to customize this field and how ? Also, how can I write my own column
Urgent Help with Sending Attachments on Emails
I have a form where the user can upload a file. Once the user submits the form, an email is sent to a group of people with the fields completed by the user. Is there a way to attach the uploaded file with this email? Thanks!
Remove Customer Portal
HI, As a test I created a customer Portal for one of our Creator app. Now, I like to remove the feature. Not only disabling it, but removing the full access and URL. How can I achieve this ? thanks.
Pivot Chart not Showing Form Fields
I have Table Called Material Used. There is Date_Created Field Which is not able available While Creating Pivot Chart Report. I need to created Weekly Material used report But this Field is not Available in Column Section
Send Multiple Records in Record Template Format as email attachment
Hi - I know it is possible to send a single record in Record Template format as an email attachment on success, such as an invoice attached to an order confirmation email. Is is possible to create a custom function or scheduled email to include multiple records in a form as an email attachment in the Record Template format? Currently, we can do this manually by printing the displayed records in a report as "Print as Summary" However, it would be very helpful to automate this process so that multiple
when was the custom domain feature changed ?
the feature was changed from premium to ultimate subscription???, we needed to change our payment method and resubscribed the next day and suddenly that feature is unavailable, we had all these past years the "premium "subscription and we were able to use custom domains, so what happened?
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
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
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
Can't see headings in subform when adding multiple lines
Hi guys, My users are having trouble when entering more than about 5 lines on a subform. As more lines are entered the field headings are scrolled out of view on the page. I fixed this in the old version of Creator by adding a tooltip to each of the fields. When the user hovers over the field it displayed the tip. However, now I am using Creator 5, the tooltip only appears next to the heading which is out of view, not in the field itself. Any thoughts as to how I can keep the field headings in
Prevent 'via usermail.zohocreator.com' in email header
Emails sent from Zoho Creator to GMail have this "via usermail.zohocreator.com". I have tried setting up the SPF record to v=spf1 mx include:zoho.com ~all as suggested in https://help.zoho.com/portal/en/community/topic/which-spf-should-i-use and it doesn't work. This may be because the DKIM for usermail.zohocreator.com domain is present in the email header and Google identifies that to be more representative of the sender's domain. I have contacted tech support and have received frivolous replies
Notification senmail action does not work
Hi, I appreciate if you can help me with this problem: When forms submitted, success message work. The confirmation mail to the form sender work. But the notification mail to the form manager does not work. Im using the sintax below: success message "custom message"; sendmail [ From :zoho.adminuserid To :input.email Subject :"custom message" Message :input.fieldname ] sendmail [ From :input.email To :"myemail@customaddress.com" Subject :input.fieldname Message :"custom message" ] Everything works
Creator 5 reverting to Creator 4
Hey, All of my companies apps keep reverting to Creator 4. We starting using Zoho after Creator 5 was already implemented so none of our apps have ever been on Creator 4. We went to edit the forms and they forced us to "Move to the New Builder" and they moved us to Creator 5... the only one we have ever used. This fixed all problems for about 30 minutes until our apps got reverted back again. This is causing people to be unable to access all kinds of reports, pages, and forms. Is anyone else having
Page - Maximum Value
I can only place manual number in Maximum filed for numbers in pages. Is there way I can fetch value for that ?
Using Added Time in a Pivot Chart
I am trying to find a way of using the Added Time field in a pivot chart. I thought you could previously create a pivot chart on a view (which contains the auto Added Time field) but it seems that now I can only create charts on forms. Can anyone help with how I can achieve this?
Create solution and sell to multiple clients
Dear gurus, Is it possible to develop a full suite solution and sell to multiple clients? Let say i develop a complete HR product and sell to 20 clients, how is the charging to be like? Zoho charges me and i can charge my 20 clients? How's the relationship? My ideal case is, i have full control (in term of payment) on my customer and zoho only deal with me.
Many contacts
What if Company has many contacts in New Client form? And what if Individual has relation with several Companies? How to relate that?
Intergration Zoho Forms with Zoho Creator
our system utilises both Forms and Creator the some data that is input into Forms is also required in Creator. is there a way to integrate the two so that when a Form is submitted it automatically sends the data needed to Creator. btw I have attempted to use Zapier, it is not great at recognising and setting fields, there are constant errors it is not user friendly AT ALL! any help is apprecited
Display calendar report more than one field?On any chances?
Hello, I have a seminar date form and It has 3 different time value. I want to show these 3 dates on same calendar. What I read that it is not possible on calendar view? I also tried add zoho calendar events but this time I can't add seminar names to event name because It shows only string data :( I also use .toString() expression but This time zoho calendar shows me just long numbers because seminar names are lookup data :( I spent lots of time for this, How can I found a better way instead of
Deluge Skript Send Mail by Date
hi, I need a Deluge script that checks on schedule if a date in a form is reached and then sends me an email with the corresponding form title. But I can't get anywhere with the Deluge script. Can anyone help me? I have the schedule already Can someone write me an example of a Deluge script? I dont understand it.
Next Page