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.
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
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
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. ------------------------------------------------------------------------------------------------------------------
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
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
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
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.
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????
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!
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
Lookup Sort Order with Hidden Field
I have a multi-select lookup list called "Categories". Within Categories, I have two fields - a "Category" (string) field, and a "Sort Number" (decimal) field. The purpose of the Sort Number field is to manually allow the user/admin to re-arrange the Categories on display/print. I would like to display the Category field of Categories as a multi-select, checkboxes lookup in the order of the Sort Number for each Category, but I do not want to display the Sort Number. How do I do that?
Missing Column on "Click to See Data" from Pivot Chart
When I click on the bar of a chart to see the underlying data, one of the columns is missing. What determines which columns are visible or are all columns supposed to be shown?
Import Files
I am using a stateless form to move data from one form to another. I want it to create a new record in the first form from existing records in the second form that don't already exist in the first form. The share a common field. I know I am missing something here.
i need to view a file or image in a stateless form that was uploaded to a regular form
I am trying to view an image or pdf file that I have loaded into a different form in a stateless form. example: I load a doc or image into Form1 but I want to fetch it and view it in StatelessForm1 How do I do this?
Help with code to view an image in a stateless form
I've read the reply by Gregg and Herb, but still can't get the code to work. <field type> Note: Here is how it's adapted from an user input. <Description> <on user input> Parts = Master_Inventory [ID = input.Description]; if (Parts.Image.contains("/image/")) { alert(Parts); Image_filename = Parts.Image.getSuffix("image/").getPrefix("border").replaceAll("\"","").trim(); Image_link = "https://creator.zoho.com/zoho_alan18/atelier/Manage_My_Inventory_Add/" + input.Description + "/image/image-download/"
"insert into" code not working
Yesterday, I set up a form so that when a subform row is deleted, its contents are automatically archived in another form. It works great. Today, I attempted to do the exact same thing for another subform, using the exact same syntax (only changing the form and field names) and IT DOESN'T WORK. This is driving me nuts. Any thoughts on what's going on here? The code below is in the On Delete Row section for the subform. insert into Deleted_Training_Records [ Training_Record_Number = row.Training_Record_Number
Form automation
Hello, I've heard it's now possible to disable the red "X" on subform rows. I'd like to do it for all users except admin based on login user. Can someone give me an example of script and instructions where to place the script? Can't seem to find the form automation tool. Thanks
Cant duplicate my application
When I select Duplicate, It does not seem to be working.
Reporting with a Date Range
Hello all, I am attempting to create a Report or Form that will perform a simple task. I already created a form for reporting Incidents and have input data into this. I would like to create some type of report or Form that pulls from that data and run a simple calculation. I would like the form to pull all Incidents in a date range and count them. Take that amount an divide it by a user input number. Output that answer into a text box or something on the same page. Number of Incidents in Date
Formula field strips off trailing (zero) 0
I have an inventory form. There are two fields one is the (Item Cost), the other is the (Pack Quantity) If I have an item cost of 19.50 and the Pack Quantity is (1) and you divide the Item cost / Pack Quantity ie: ( 19.50 / 1) the result in the formula field is 19.5. Is there a way to always round to 2 decimal places and show a trailing zero (0)? hence 19.50.
Left pane side tabs opening in expanded display. Would like to open them collapsed. anyone know if this can be done?
Hi, I'm using the Left pane side tabs, they always open in expanded mode. I don't see anywhere to have them open "collapsed". When the app opens I'd like to have them all collapsed. Is there a way to do it by adding some code? or is there a setting I'm missing somewhere?
Getting data from user.
In a function, how do I prompt the user for and collect data such as an exchange rate?
Published Search Query - Failing to Load
I have this simple application (ds file attached) whereby I have a form (titled "Search") that acts as a basic search query with one field, "Name", in order to direct me to data in a report (titled "Form A View"). My search query works fine when I use it in the admin panel -- if I search for data it properly brings me to my report. However, when I go to the published/public version of my search query, the report always fails to load any data -- it just says "Please wait..." for upwards of 20 minutes,
How do I customize the Zoho URL to myDomain URL?
Appreciate your help. I am in the Standard Plan. How do I customize the Zoho generated URLs to a myDomain URL? Some of our application users are put off by the long Zoho URL when they are submitting their personal information. They have a trust issue because of the long Zoho URL. How can we sort this out?
BIGINT / STRING error when trying to fetch data from another form
I have a situation where I need to populate a text field (Assign_To_Email) with data based on a selection made in a dropdown (Assign_To). These are both in a form called Support_Tracking. The values in the Assign_To dropdown in Support_Tracking correspond to values in another dropdown also called Assign_To, but this one is in a form called Names_and_Emails that includes one other field, Assign_To_Email (a single line text field). When someone selects a value in the Assign_To field in Support_Tracking,
Report - Averages Not Working
Hi, I have a table with multiple dates and a value of 0+ for each date. Some dates have 0. I created a report and if I use Sum, everything works great. Most days are in excess of 100. However, if I change to average, the value in the report is always < 5. At first, I thought it might be related to many dates having 0. I created a filter and said all values of 0.01 + and that still didn't work. In fact, I tried to even say only average values of 25 - 50 and the report still displayed ~5. Any
Creator API - access View data
I am brand new to Zoho Creator and am trying to create and access a View on an existing application developed by others that can be accessed via the Zoho Creator API. The view is named: myob_student_record I am submitting the GET request in the form: https://creator.zoho.com/api/xml/ownername/view/myob_student_record?scope=creatorapi&authtoken=xxxxxxxxxxx In the "general settings" area of Zoho Creator are two fields: Application Name and Application Link. In our case the application name is "Record
openurl criteria to related table
I am using an openurl to filter a view. It works fine if the criteria is on a field that is part of the form that the view is based on but I can't get it to work if the criteria is for a field in a related table. Is there something special I need to do to search records based on the value in a related table? Herb Wexler
creating a temp form based on field variable, then insert all records in the temp form into another form
creating a temp form based on field variable, then insert all records in the temp form into another form i keep getting an error, is my syntax incorrect? rec = SR_Import[Imported != "Yes"]; { for each row in rec {insert into PS_Work_Order_Purchase_Order [ Company_Name = rec.Company PS_Work_Order_Purchase_Order = rec.WO_Number Description = rec.WO_Description AFE = rec.AFE Site_Code_Location = rec.Location_Full Field_Ticket_Signer = rec.Field_Ticket //= rec.PS_Contact Attention_to_on_Invoice
Trouble calculating the number of days between two dates.
I have a last service field in a customer form. Using a formula field I'm calculating zoho.currentdate minus the last service date. (This is a date field) / 1000 * 60 * 60 * 24 The result gives me 169.95833334. I've changed it to a decimal field with a decimal length of zero (0). and get the same result. 169.95833334. If I change the field to a number (no decimals) I get an error telling me the zoho.currentdate is a bigint and and Last Service date is a date field. All I want to do is have a result
Form filtered by zoho.loginuserid
I know that I can have a report in a section, and the report can be filtered to only show rows where an email in the report matches the zoho.loginuserid. If the relevant data is a person's profile, theoretically there would only be 1 row per user for their profile settings. So they don't really need to see a list .... Is there a way to include a form in a section, so that the form is filtered based on zoho.loginuserid? Or, is the 'solution' to use a Summary report, rather than a List report?
Next Page