href with View worked for me till a few days ago and suddenly stopped.
Hi - Till a few days ago this line worked well for me: htmlString = ((htmlString + "</br>" + "<a href=" + zoho.appuri + "'#view:customerRecordCompleteHtmlView?customerIDParam=" + custIDStringTemp + "' target='calendarIframe'>") + custRecTemp11.Formula2) + "</a>"; I noticed that in particularly any variations of the href-value that includes column " :" makes the url href value to be stripped when in display on the page. I think this seems to be relevant for Form's html fields .. So this is rendered
Pulling Data from Zoho Reports
Hi Guys, Have read a few forum posts and documentation trying to determine how to pull data into a Creator Form from Zoho Reports. I know how to store,update and delete records in Zoho Reports from the form, but am struglling to get it to pull data and populate a dropdown list. What I currently have is a form that is for inputting orders. The field I want to populate is "Supplier". In my database/reports, I have a Suppliers table. I want it to pull in the Suppliers Name for display in the dropdown
One of my forms is taking a very long time to submit....
This form used to save in a very short amount of time. I have made no modifications to the form and now it is taking forever to save a new record. Is there something i am missing? it is actually NOT submitting.
Creating a Relationship Between an App in Creator and CRM
How do I go about creating a relationship between a from created in Creator and Contacts in CRM? I want it so that when I submit a form for a customer, it will be listed under their name under contacts. Thanks
Export Permissions
Hi, When I set the export permissions in some profiles. In my mind, I have disabled the export permissions for one kind of specific employee such as "contractor", Unfortunately , I found the contractor still can see the "export" in the menu and it can work. What is problem? BTW, I both disabled the import and export permissions to contractor. The import disappear but export still be there. Please help... Hero
Using product module information as criteria.
When creating views and selecting criteria, I'm only offered to search through the criteria of the main account information but not the information of my checklist product information (The module is a list of products and a check if they are customers for that type of product). How would I ago about make this information accessible through the criteria functions when making a list. Thanks, Joe Ogoley
Import Data into Subform
Hello, I've already thoroughly researched this topic within the site, including https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095, to no avail. Does no one have a simple solution to this problem yet? I cannot import data into my subform, only my main form. Note: The fields that are receiving the data in my subform are lookup fields
how to set popup window size
Hi, Can anyone tell me how can I set a popup window size? I tried to follow an example in the forum where they put the size in the parameter field: "height=500px, width=500px" but it does not work. Cheers
Novice & Need Assistance
anyone available to help me, i know exactly what i want my app to do but having trouble putting all together. nayaalacy@gmail.com; 9519992539
Type Required "Int", Type Found "Long" error
I am calling a function from within a function. They function that I am calling needs to receive and Integer, however when I I try to send an Integer (specifically an ID from a related drop-down) I get the attached Error expression type does not match: type required:int type found:long
Auto fill changed fields
Hi Lets say I have 1000 records I add a field 'Week of year' I have a field called Visit_date which has an on user input Script that reads ' Week_of_year = Visit_date.getWeekOfYear()' Script works fine My problem is how do I populate the 'Week of year field' without going into every record and activating the script in the field by changing the date. Thanks
Twilio configuration
Hi, I am just in the middle of designing a Zoho Creator app and note that you integrate with Twilio. Please could you enlighten me on the following: 1. How to specify the sender name? 2. How to configure Creator/Twilio so that replies can be sent to an email address? Thanks Shaheed
Zoho Creator Respose
I am using your Zoho creator form in my site. First I trying to test using API in my system. But problem is that in response i got download XML or JSON files from browser. Database entry is done successfully , but I need response in my site from which i can update different status in my system. don't want to download any file in Response. Can you please give me proper guide line for that.? I am using below code for add and submit form. ------------------------------------------------------------------------------------------------------------------
How do I grant admin rights to another Zoho Creator user?
How can I grant admin rights to another user of our zoho creator? There are two of us who use are currently using it, I am able to edit any of our applications while the other can not. The application is shared with the other user, and they can access it and enter data but they are unable to edit the app. We are currently using the free version of Zoho Creator. Do we need to upgrade, or is there a step I have missed? Thanks!
android
Is there a form of ZOHO Creator for Android ? If so, where may I find a download ?
interaction subform fields
Good afternoon, how to get the index of a row in a subform. is possible in a subform add a field having the conditional in another field. For example: row1 = field1 = 1.1; field2 = computer; field3 = 1000 row2 = field1 = 1.1; field2 = notebook; field3 = 1700 row3 = field1 = 1.2; field2 = brick; field3 = 50 to sum the values in the subform field3 if field1 = "1.1" another query could delete a row subform via script thank you
HTML View transfer inputted data between forms
I am working on an application in which I need to allow users to type in a passcode that is unique to specific groups to add or edit a record in a form, that passcode would be recorded in each record to show which group the person belongs to. I want the user to be able to type the passcode once and be able to add or edit multiple records, without typing the code multiple times. My idea was to create an HTML page with the embedded report and an embedded login form. Would it be possible to pass the
How can I add a table into a form?
Is it possible to add rows and columns into a form that looks like a table where people can enter text and numbers?
Forms have disappeared from Android app....
So...all of a sudden all my forms that have subforms have disappeared from the list on the Android app. They are still there on the mobile web browser. Anyone know what happened? Thanks
Popup Window v New Window on user input actions
I have an app whereas I created a function to add record that autofills a related form field and then script in that form (on user input) fetches the information and autofills additional fields. I set up the function to open as a popup window. This works to initiate the "on user input" actions when the lookup fields is autofilled via the function. I get an additional popup window that is blank when I submit the form. I then changed the function to open the new form in a new window, however,
Form - Failing to Publish
I just wanted to inform everyone that if you try to publish a form with a font size that is not a whole number (such as 11.5, 12.5, etc.) it will not work. For some reason Zoho developers did not add an alert that tells you why the form failed to publish. Anyways, as long as everything else is okay, it should publish if you use whole number for font sizes (such as 11, 12, etc.).
trim spaces without ending up in a loop?
If a user enters a space at the beginning or end of the field, I need this space removed. .trim() will do this, but.... the script input.value = input.value.trim(); creates a never ending loop. is there any way to get this done? Zoho creator doesn't treat a space like a regular character (eg: Creator ignores spaces), so all the tricks I could think of so far fail, like if (original_value != trimmed_value) {input.form = input.form.trim();} //doesn't work :( or if (value.beginsWith(" ") {} //doesn't
changing spacing between fields
Is this feature available with Zoho Creator? Is so where? If not is there a workaround? If not, is this feature being worked on? Thank you...Allen S
How do I push data from a Creator form to my CRM?
I have a number of enquiry forms on my site and I want them to automatically create a lead within my Zoho CRM. I have been reading through all related posts and can't come up with any answers to this question; is it even possible? I am new to this system so please forgive me if it is a silly question and if possible keep answers simple, I am hoping not to need a translator! Jade:-)
Add new record by clicking the name of record
Hi...i am a new user to Zoho:) I am poor at coding but have some experience with ms access.Ok, i want to ask whether it is posibble to add new record by clicking the name of the record. Let say i have to table Form A: List of services (To show all services of my organization) Form B: Related to the services but it a rating form to the selected service So i make a report base on Form B but showing only item in Form A,List of services so that user can add record to Form B,rating the selected service.Is
About zoho create "Customers"
"Customers: The persons who can access the information on the Customer Portal. They are usually your customers, vendors or re-sellers." I try to create 2 agent manage applications on zoho create, 1 have 8 users, and the other have 10 users, then have more then 120 agents(re-sellers) will use the system. So, if i register as a Enterprise plan, shall be 8+10 x 15 dollars for every month, but what about the 120 agents? shall pay as user or they are just customers? if they are customers can access the
subform row deletion - prompt for confirmation
Is there a way to prompt users to confirm deletion of a subform row/record within a master form? For example, a pop-up message such as "are you sure you want to delete this record?" with options to continue or cancel. I'm assuming such a thing would go in the On Delete Row section for the subform in the master, but can't sort out if it's even supported, or how to code it.
Pivot Chart Custom Formula
I'm trying to create a chart using the difference between two dates in the record. The attached screen shot is the error I get. Where is this "Custom Formula" option?
return records between two dates
I would like to add another criteria for the records. I would like for it to return all of the records based on the following criteria and add another criteria. I would like for it to return the records between the following input dates. input.Week_Start_Date and input.Week_Through_Date basically I want to see how many hours an employee has worked for a particular client during a time period I select. this is what I have...... rec = Employee_Time[Name == input.Employee_Name && Company_Name ==
Select some values from multiselect lookup
Dear All, I have a multiselect lookup which includes some values. What deluge code should I write to select only 3 values? I mean, to limit the selection only to 3 values. If I try to select a 4th one, then I do not want to accept it.
Send Mail to Added User NOT Modified User
Hello, So, I'm trying to write a short script where users adding data into our forms can receive an email if it was approved by the administrator. This is what I have, if ( input.Approved ) { SendMail [ From : zoho.adminuserid To : zoho.loginuserid Cc : Bcc : Reply to: Subject : Description + " has been approved!" Message : "Your message" Language: English Content type: HTML Trim tags: true Attachments: ] } The problem with this code is who I'm sending
What type of images file types are supported in ZOHO?
What type of images file types are supported in ZOHO?
Backups won't Restore
I get the following when i try to restore any backups com.zoho.workengine.parser.exception.PopulateException: Error at line number : 2560 Number of arguments mismatches
Developer access when report is filtered on zoho.loginuserid
I'm sure this is obvious, but I'm not thinking straight. I have a report that is filtered based on: email contains zoho.loginuserid, and that's great for the user. How do I set the filter criteria for a report so it is filtered on email contains zoho.loginuserid OR user is a developer????
Is it possible to auto populate existing records with new information?
Our Creator database consists of a main form with several sub forms linked. We use the main form to collect demographics and the sub forms to collect specific information about the product purchased. We would like to be able to pull reports that include information from the main form and a sub form. I believe the easiest method would be to add the demographic information to the sub forms (I have worked out the code to auto populate this information moving forward) but I do not want to have to go
How do I only allow the record owner and his/her superior can view the record on the Travel Expense application?
Hello! I am having trouble figuring out how to allow employees only to view their own expenses and no the entire company, (every person who as entered expenses), into the Travel Expense application provided by Zoho Creator. I don't want them to see the expense of others, just their own! Is there any way to make this happen? I tried using Users & Permissions, but I couldn't figure out how to make it private in this way. Any help would be appreciated! Thank you!
Aggregate Records Average Function Issue
When I use the aggregate records average function the result looks to be inaccurate. Exporting the report to Excel or Google Sheets and averaging the column returns a different result than Zoho did using the aggregate records average function and displaying the results in a html page. I believe it might have to do with blank fields within Zoho's averaging range that might not be ignored. So what can be done to fix this or increase the accuracy of the returned results? Additionally is there anyway
Subform Bug- Adding New Entries in a Lookup Field
Hello, I need assistance with a problem relating to the subform. When I add a lookup field in the subform while checking the choice to "Allow new entries," I have to refresh the page whenever I add new entries into the database for it to show up in the list. The problem only occurs in a subform, but not if you do it in the actual form. This would not be user-friendly for our suppliers, as a result. Any assistance would be greatly appreciated. Regards, Mohammed Alhaj
send email to Group (as defined under USer Management, not as a form in a creator application)
what is the script for referring to a Group if I want to send an email to that group on a field-update action. the group is not a list of emails in a table in the application. The Group is defined under "User Management" I know zoho.adminuserid refers to "me". but if the group name is "Cost_Change". then what is the deluge script to find this? thanks
Calculated date field causing error that disappears when field is hidden
I have a field "Art Due Date" that is calculating a date for 5 days before another date in the form. It's been workin for 2 years and then last week every time someone tried to edit a record using the form with this calculated field they would get this error "Invalid Field Found Field Name : Art Due Date" and would be unable to save the record. I changed the setting on the field properties by unchecking the "Make the field visible in the Form" and I was able to successfully save/revise records.
Next Page