input.user
hi Zoho Support Would like to check whether will this deluge work? input.users="abcd@zoho.com"; Regards
Function calling a condition
I'm trying to set up a function to set a variable based on the current logged in user. void fuction_name() { if (zoho.loginuser == zoho.adminuser) { path = "path_1"; } else { path = "path_2"; } } But I'm not sure how to invoke this function when loading a form. The form will need to do things with the variable "path" but after invoking the function, it errors saying "variable path not defined". thisapp.function_name(); Single_Line=path; What am I doing
On Update Form Script Not Working On Multi Select
Hello Zoho Community! I'm having a bit of a problem. I've got a deluge script that runs on update in one of my form fields. At this point I'm just using the following script for testing. info 'Can you see me?!?'; If I edit a single record from a report and edit the appropriate field, I'll get my 'Can you see me?!?' prompt. But, if I select two or more records in my report and update them, I'll see no info box at all. Am I missing something here? I thought the code in the "on update" section
Email Updated record
HI I'm new to Zoho so sorry if this is a basic question, feel free to point me in the right way of some documentation to read. The issue I have is the database (A facilities management database) emails certain people when a record is added. This works well using the email notification setting with the default template. The issue I have is making it recreate the exact email when anything is changed or updated in the record. This might be contractor assigned or notes added. I want it to send all the
Changing Field Name value
Hi Everyone, Is it possible to change the field name on a form base don the value of another field ? So I have a drop down where I select the account name and then based on that account name I would like a particular field name to change. Field deluge is "Reference", can you change the field name So for account 1 the field name would be "REQ#" For account 2 the field name would be "TASK#" Thanks Matt P
Brain Fart - Simplest way to update many records in another form with my current form?
I feel like I should know how to do this, but my brain mapping of how to solve this just isn't working, or maybe I'm overthinking it, or probably both. So I have a form for my products, called "Add_Product". This is where data is stored about each product, like its name, size, quantity on hand, etc. Then I have another form for quick inventory updating called "Add_Inventory". In this form, I have a field for each product (I know this probably isn't the best way to do this, but it seems to work
How to insert records in a HTML Page/custom created HTML Form in Creator?
Hi, I created a custom HTML Page. I have 3 fields namely name, email and contact number. Using this custom page, I want to insert records. Basically, I want this page to mimic the behavior of a standard Form created in Zoho Creator. I tried to put the Deluge scripts to insert, however it is not working out. Also, tried to use a function with parameters, did not work out. Please let me know if this is possible in Zoho Creator or not. Unfortunately, the documents to create custom functionality
calendar report filter
hi, i have a calendar report based on a form "task" in which there is an user textbox and a partner multiselect. we are 4 colleagues, and i'd like to make a filter that shows record in which the user is selected in "user textbox" OR in "partner" multiselect. thanks
ZOHO CREATOR NOTES (CRM STYLE)
Hey guys! I'd like to create a notes field in my Zoho Creator form that automatically time/date stamps the note...and allows me to continue adding more notes by clicking a button such as "new note". This function is available in Soho CRM...BUT i'd like to build a similar function within my Zoho Creator...is this possible? Thanks!
How to bring other fields from Zoho CRM when choosing one contact?
Hi, Im not the most experienced in Zoho Creator so any help is well received!! I have been trying and still cant figure it out. When I build my form, I am able to choose a Zoho Crm Contact Button to put in my form. I would like that when I choose my Zoho Contact, some information such as the Mailing Address, City an Email are brought to my zoho creator form automatically. I have read about getmyrecord by id but haven been able. Can anyone explain better than just posting the link about getmyrecord?
Section doesn't show on menu
I have created a new section and added a couple of reports to it, but the section does not show up on the menu bar at the top. I am the administrator/owner of the application so I should see everything. What am I missing?
Inventory in zoho?
how to make an inventory in Zoho, do you know any tutorial? thank's
Sorry Public, you are not allowed to access....
I created a page and made it public. I also created a report and made it public. Both links work for users with no password. When I embed report in the page and try to access the page from the published link I get This report is not accessible. Sorry Public, you are not allowed to access current_dogs. Please contact your administrator to get access. current_dogs is the report that is public on its own.
How do I remove time from dates
I have three different date fields in my database and all have a time associated with them. I do not need times included. Is there any easy way to remove the timestamp from each?
Cookie disabled error accessing application
I've just created my first form. I've clicked the "Access this application" button and I get the message: Note : Cookie is disabled in your browser. Please enable the cookie to continue. I'm sure cookies are enabled. Another thread suggested this was the website, so this is the URL: https://app.zohocreator.com/zoho_david2253/railway-article-database/#Form:Railway_Article_Database Thanks, David
Populate Lookup Field Based On Previous Field Entry
Greetings, I have created a form and need to populate a lookup field based on a previous selection. This is the example. I have a form that has client information. The client information form has 5 statements provided by the client. In the evaluation form, we select the cleint from a lookup field. The next field needs to look up the 5 statement from the client information form based on the client that was selected. Is this possible?
Form Schedules with bulk records
I need to send messages in bulk messages at different times of the day. Is Form Schedule right way to do this? What will happen when bulk records scheduled at the same time?
Unable to share applications
I have not been able to successfully share any Creator applications with other Creator users. We have all walked through the "Share Application" resource documentation, but have still be unsuccessful in being able to share any of our apps with each other. The message we often see is: You have logged in as --UserName--. You are not allowed to access this application. Please click here to login as a different user. Click here to go to your Home Page. We are currently using the Professional edition
Fetch records from multiple subforms
Hi, my set up is as follows: Form1 >Subform1 (Name) >Subform2 (Address) >Subform3 (Bank Details) Form2 >'Name' Lookup field to Subform1 (inputs name from Subform1 'Name' field) >'Address' field (Want to input corresponding address that was entered into Subform2 at the same time as Subform1/3) >'Bank Details' field (Want to input corresponding bank details that were entered into Subform3 at the same time as Subform1/2) How do I link the subforms together? Can I fetch from a combined report? Unless
Website designer is unusable.
Most of the uploader pages stay stuck on a continuous loading screen. I left the picture uploader on to see how long it would take - 45 minutes before I gave up. I have Zoho Mail and I love it. I've been wanting to use the website designer for quite some time because of the price and all of the features. This is extremely unfortunate that the website designer is so unresponsive. I checked the status page, everything is running fine on their end, but on mine, terribly.
Shall i use ZOHO @ Offline
Hi, How can i use ZOHO in offline mode. If any Setup is there please share to my mail id narendaran75@gmail.com
Date Field
Hi there! How can i make a date field where the user only selects month and year, but no day?? Thanks!!
Text orientation for PDF export
Hi everybody! I´m trying to get a record summary to export some headings written vertically when sent as pdf via email. i introduced the next code to the html editing box for the heading: <h1 style="text-align: center; writing-mode: vertical-lr;"> <font color="#ffffff" size="2">PRECINTO</font> </h1> I have to issues: - When the email is sent it delets the code leaving it like this: <h1 style="text-align: center;"> <font color="#ffffff" size="2">PRECINTO</font> </h1> - I whant
Occasional Invoice Fails to Generate
Hi, We've recently started using a laboratory information management system designed in Zoho Creator, which is connected to Zoho Invoice for billing. I've just noticed two instances of tests ordered in Creator which did not generate an invoice. What's the best way for me to trouble shoot this? Thanks, Chris
Remove minutes from dates
I have 3 dates in my application. I do not need minutes on any of them. Is there any easy way to have those removed from the reports?
Populate other form fields based on a dynamic Dropdown selection
I am using a dynamic Dropdown field to pull in filtered records from the CRM Vendor module e.g. CRMresponse = zoho.crm.searchRecords("Vendors","(Vendor Name|starts with|A*)"); for each vrs in CRMresponse { Dropdown:ui.add(vrs.get("Vendor Name")); } reference: https://www.zoho.eu/creator/help/fields/add-to-picklist-dynamically.html I now need to Auto-populate other Form fields based on the selection made within this drop down. e.g. pull in the "Email", "Phone" etc fields from CRM for the selected
Rebranding not working
Two problems (so far) with the rebranding feature. 1. When I try to upload a logo, I can browse my files and select an image, but when I click "Upload" either the three blinking dots blink momentarily or they blink indefinitely without result. 2. When I enter a company name and click "Save", the company name disappears and is not saved. I have an Enterprise license. I have tried this on two browsers, both on Windows 7, Chrome 34.0.1847.131 m and MS-IE 11.0.9.9600.17041.
Subform Update Problem [Solved]
Hi, I have a Form ("Residents") with First_Name and Last_Name fields. On Success or Edit, these strings are added together and put into the Full_Name field. I use this Form as a subform. When I add or edit a record through the Form itself, this concatenation works fine and shows up in the parent report; but it does not execute when I add or edit a record via the subform field nor does the record update in the parent form. Edit: Here we go. https://help.zoho.com/portal/en/community/topic/update-records-within-subform
Is there any Custom Function execution time limitation?
I need to send bulk sms messages through a custom function which invoked when a form is submitted. Is there any execution time limitation on custom functions? Any Timeout time?
Link a zoho user to its correspondent record
Hello, how come can I link a zoho user, i.e. "user@application.com" with its correspondent record in my data base, (which has more information) than just the username from zoho? I'd like to have a record with its zoho user and also the name and other information which is related to that specific zoho user
question on deluge script usage limit
Let's say I call a custom function in my html view does it count for 1 deluge script action and my script got its own usage limit or every line in my script count toward my html view script limit ?
How can I set a form to automatically fill a time/date field when a decision box is marked?
Hello, I am trying to set up a field that stores the time and date when a decision box was marked positive. I tried a couple ways in workflow but I couldn´t get it to work. Thanks
dynamic changing default value of field
I have a form which is used to track inventory activity. There are 4 options in a dropdown. (can just as easily be changed to a radio) two of these options are "parts received" (added to inventory) and "parts used" (deducted from inventory) The default is "parts used". When a record is saved, a new blank record is presented with the default value selected. Here's what I would like to be able to do. When a record is saved and want the next blank record to default to the previous value. When I
Regular Expression help
Hi, Can anyone please help me to write reg expression of below. I want to validate a string field so it will not allow user to enter any of the below special characters Characters : ~ # @ * + % { } <> [] | " \ _ here is the example something I have been using for validating phone number : phoneNoFormat = input.TFN_01.toString().replaceAll("^[0-9]{3}-[0-9]{3}-[0-9]{4}$","correct"); if (phoneNoFormat != "correct") { alert("Phone Number should be in the format of " + "<b>"
Box.com Integration with Creator
I see on this feature list that there are in-built Integrations for Box.com. https://www.zoho.com/creator/images/zoho-creator-pricing-comparison-in-usdollar.pdf Where can I find the documentation on this? Thanks! Patrick
How do I get my reports to automatically refresh with updated information in forms?
We currently use reports to store and sort recipes... If the cost of goods changes and we change it at the source, I would like for the reports to reflect the most current price. Is there code I can add that tells the report to refresh with updated values when opening?
Subform - get value from the row above
Is there a way to fetch a field value from the row above in a subform and input into the row below? Basically - on user input, we need to fetch a field value from the above row, modify it, and input into the next row? Any ideas much appreciate Thanks!
Using tablet
I can't seem to edit a form when I'm using a tablet. What am I missing?
Sign out from Portal
Is there any command that will sign out a customer portal account? I have a page embedded in my website that requires a Customer Portal sign in. But there is no option to sign-out. Even closing the browser does not sign the person out. This can be a problem on public computers!
stateless form embedded in html page to input a parameter
Hi, I have an html page that has to make same queries/calculation based on a parameter. This parameter has to be defined in a stateless form. Is it possible to embed the stateless form in the html page and use a form's field as parameter for the html page? tks pippo
Next Page