Problem with Custom Filters in embed view
Hi, I have created an app (with a free plan) using Custom Filters in some views. It runs propertly accessing the App throught Zoho Creator, but It doesn't in embed code. Selecting the filter the view's update delays forever and does not show results. Anyone knows why? Is there any solution? Thanks, Jordi
Parameters and HTML pages?
Can you pass a parameter into an HTML page (with an embedded view)? I would like to search my database for a specific record and then display my HTML page with the embedded view, (I dont want to write the HTML code if possible as the embedded view is all that I need. Any examples much appreciated.
Subtotaling Multiple Records from a different DB
In Zoho Creator, I have a Project DB with each project having a unique ID. I have another DB for Price Estimates of various elements of a given project-- each estimate is entered separately as a record in the Price Estimate DB with a Project ID pulled from the Project DB. So, in the Estimate DB I have several records with the same Project ID. How can I have the SUBTOTAL of all the Estimate records with the same Project ID appear in a field in the Project DB? Thank you!
Header option in HTML view
Hi, I've created and HTML view which includes an image. In the HTML view I have the print and pdf options = true. When I click on the print option in live mode the image is displayed with the rest of the data, but when I choose pdf the image doesn't render. Any ideas?
lookup fields with autopopulate
I have a database that has Club Numbers along with the members in each club. What I am trying to do is when they choose the Club Number from a drop down it then goes to the member number field and I can choose the member number associated with that certain club and then it autopopulates the rest of the information in that member record( for example their 20 scores on file). Also there may be duplicate member numbers not in the same club but within the database. So what is happening is when they
Fetching a record from a dropdown/multi-select/radio List
Having trouble fetching a record from a dropdown/multi-select/radio List. I read somewehre that this is a known limitation. For Example) Form A has a field "Customer Status" with 4 radio button choices Form B want to pull the selected status into a new field Does anyone have a workaround. Thank you.
Run schedule on certain days of a week?
Hi, Is it possible to program schedules to run on certain days of the week such as Mon, Wed & Fri? Thanks! Vishal
Initiating many records - HELP
UPDATE::: I seemed to have found the issue, but it bring up another issue. First off, what i thought was a limit on the number of records that i was able to initiate at a single time, was wrong. The problem was in the special charters that existed in the zoho reports database such as [ & , - \ () ]... After I manually removed them, the record initiation worked as it should... Now my next issue is how do i get it so it will except the special charters listed above? ------------------------------------------------
Relationships between applications?
I am using the free version and have created three applications - inventory, orders, and customers. I have tried using lookup fields to automate the orders form (bringing in data from products and customers), but cannot seem to get access to more than the single field I choose in the lookup field. Creating formula fields, or criteria in other types of fields, in the orders form does not see have a way to access other fields in the Products or Customer applications, except the single field chosen
INserting (fetching) email via API
Hello, Is it possible to insert (upload) and email via the CRM API? That should of course include the ability to define which object to "associate" the email with, and all the relevant email fields (Subject, From, To, CC etc) with the body (in HTML or free text). If yes, is there a sample code available? Thanks,
Script Builder view truncated - no scroll bar
When I go to write script in Script Builder the right hand side of the screen is truncated slightly. The scroll bar is missing, as is the right side of the SAVE SCRIPT button. The result is that I cannot scroll, and so it is very slow to move around long scripts, which is a nuisance. If I switch to Free Flow Scripting the view is fine. Any suggestions? Is it a problem with the browser, or is it at the Zoho end? (I use Internet Explorer)
Desperately seeking assistance
I'm working very hard to make Zoho Creator work for me. I must be very dumb, but things just aren't working out. I am a volunteer book review editor, and I need to maintain a database of which reviewers have which books. There are some date calculations, easily done in a spreadsheet (I've been maintaining the list in Google Docs), but a database would just work better for me -- reports, etc. Is there someone out there who will volunteer to write the field specs for the calculated fields? I don't
Using Record ID to fetch data - Is there an issue?
I am trying to fetch data from a table using the record ID. Is there a problem with this? The script below is On Load script in a form.. The first 2 lines successfully find the record number from a form and populate the Record_ID field. The last 2 lines are supposed to use the record ID to fetch the customer name (CustName) but Test_Field remains blank. I have checked that the Record_ID is valid. It was generated from another script. I can't see why this doesn't work. EditData = (Record_ID_temp[Key_Code
Edit records using stateless form - Do I need a regular form to pass data?
I am struggling to find a way to upload the data from a table to a stateless form without creating a new regular form to pass the data. Is there a simpler way to persist the data? This is what I planned to do: I would use a 'Custom Action' that is selected from the dropdown against the record to edit. This calls a function to which I can pass the record data through the arguement to the function. Then I want to use the existing data to populate the Stateless form, but I can't see how to do this
Creator API Error 2832: [application owner] parameter is not available in the request
I have a PUBLIC form and I am trying to add data to it via the Creator API. Since the form is public, my call to the API is unauthenticated so I am passing in the zc_ownername in the call parameters. Yet, I keep getting the 2832: [application owner] parameter is not available in the request error in the response. BTW, I am passing in the authtoken and scope parameters in the call. Has anyone run into this problem? Regards Moiz Tankiwala Smart Training & IT Solutions
Custom function with openUrl to open URL that has been entered in form does not work?
I am having some issues with the custom actions. I have a form called "Suburbs" in which I have two fields, "Suburb" (which is a text field) and "RPData" (a URL field). I want to create a view which has two columns, the "Suburb" field and a custom action "View Suburb Profile" I have defined the custom action: I then have created a view, where I can select a suburb, and then click on the custom action View suburb profile, which I want to then launch the RP_Data URL for that suburb. However, when
Custom Actions and Edit menu problem in popup views
Hello ZC team, If a view is opened in a popup window, using zc_Loadin=dialog parameter, and the view has Custom Actions dropdown, look what happens I have to go to bottom of the page to access custom actions. Also, when I access Edit menu, I get a similar result and even worse, not all items are visible. Please solve this as fast as possible - it is a problem with the new views layout implementation which simply broke existing functionality. Also, even if I think that overall the new layout for views,
How to Redirect to a URL instead of getting xml response while adding records using REST API method ?
Hi, I am having a web page using which i am entering the data in to zoho creator using the "REST API Add Record" method.I am using the xml as request method and getting the Response as an xml when submit is clicked. But i want the page to redirect to another page insted of getting the xml response after clicking on submit button. Please provide me information on how to get this done.
Zoho iCal feed
Okay I want to create an iCal feed to the zoho calendar. I have been able to create it, but I have a couple questions about ways to use it. My first question is whether or not it is possible to feed multiple fields into one handle. For instance if I have Customer_name, Job_Type and Sales_Person and I want them all to go into the DESCRIPTION= part of the iCal url. Then on top of that is there anyway to seperate those by newlines when they go into the Description. This is really all about changing
POST data to external server.
I have been tasked with making an anonymous suggestion box using Zoho Creator. For example, there is a multiline textbox called input_box. Now when the user presses the submit button on the application, what should the script look like? I would like to take this data to a specific connector and then have the data go into a Cassandra server.
View design
In embedded a view in an html view (div tag). This works fine but two things are very ugly and probably a bug. 1. When I mouseover the edit button of a record (no dropdown as everything else is disabled) it turns black. The attached printscreen did not capture the mouse pointer itself, but it is right over the black box. 2. There is a big bar of dead white space where the view header was (I disabled it with zc_Header=false). See attached pic. Any help appreciated (edit access enabled; application
How To Add Product Details into Invoice Section Of Zoho CRM using Map() ?
Hi, I am currently adding the data from zoho creator to the invoices section of zoho crm. I using the following process shown in the url below, https://kbase.creator.zoho.com/crm/push-to-zoho-crm I could able to store the data related to the Invoices like Account Name,Subject.But i am not able to add data to the Product Details Section of Invoice.I want the "Product Name","Qty","List Price" to be stored along with the invoice data. Below is the script i have written for mapping from zoho creator
predefined path in URL export of CSV
I have a form in which on submit i export a CSV file containing all the data for that entry, which is driven by the URL. I wanted to know if there was anyway i could predefine the path in which the csv is downloaded to. There is only going to be a single user of this form, so the path should already remain the same. Thank you
How to Send Email's Seperately for every user record using a Scheduler?
Hi, I am using schedulers which will send an email upon a given date in my application.The To Address is having the admin address and i am getting those mails. Is it possible to have the email sent to the the email address field associated with that record? Please let me know whether there is a solution for this.
Modeling a Budget Sheet
Is there any advice available on modeling a two dimensional budget sheet? I am planning a sort of bid and budget management platform for jobs. Here is an example created in Excel: The items in column A will be anywhere from 100-200 items and are NOT set by designer/contractor but by my company. Designers will be able to edit column B. Contractors will be able to edit column C and D. Administrators will be able to edit A, E, and F. I would like to emulate this look in both the form and the view. Is
Embed google gadgets in HTML view
I want to embed google gadgets like clock , calender etc in HTML View. How can I do it
Problem with the Dropdown Show choices in alphabetical order
Hello, I am having a problem (may be a bug), where I have created a dropdown that onLoad gets all the account names from the CRM, I have checked off the checkbox that says "Show choices in alphabetical order", but it is not alphabetizing them. Is there a way to fix this please? Thank you for your time.
Can't find the error...
Here is my code following a tutorial on the forums about mapping variables. I have followed line through line of the code and am getting an error with the "void" function. In the script editor, the error reads: "Encountered "void" at line 17, column 1., Was expecting one of:"if" ..."for" ..."delete" ..."insert" ... "inserthtml" ..."share" ..."unshare" ..."%>" ... fields=getFieldNames(); form_map=map(); for each field in fields { value=getFieldValue(field); form_map.put(field,value); } void
ZC Mobile - HTML view
Hi guys, Am new to ZC. Is it possible to set 'native' views and forms to be visible to mobile only, while the desktop user will see only HTML views? Appreciate your prompt comments, Gidday Idan
combining string records
I have two string records, "first name" and "last name", and I want to group them together to make a single "full name" string. How can I do this? I've tried assigning variable, but it doesn't seem to work.
Over Limit notification for Developer
Two of my clients had problems with their applications last month because they had gone over limits. One hit the limits of records in their account. The other had executed more than the allotted schedules. I assume an email was sent to the application owner when they neared their limits. Can you also send a notification to the email address listed as the developer on the Applications Settings page? Herb Wexler
Summing days to a date field
Hi, how I want to send a email if the present day is due 10 days from the "Data_de_Registo" when the form was inserted, the problem is I can´t define the 10 days here, as it gives me the next error. The Left expression is of type TIMESTAMP and the right expression is of type BIGINT and the operator + is not valid here if( Estado == "Avaliação") { if( zoho.currentdate >= (Data_de_Registo + 10:00:00)) . How can I develop this? { sendmail [ from:zoho.adminuserid to:"xxxxxxx@xxx.pt"
Deleting record from lookup fails to save selection
I'm trying to use uses a form "choice_remaining" to present users with a list of items (Say a list of cakes for a pot luck) I've setup a form called sign_up that lets them write their name and using a lookup field pick an item from the list. As each submit record makes a selection, I want to remove their choice from the list of possibilites. Eventually the lookup would be empty. All this works well except the selection from the lookup field (input.Selection) is never saved in the sign_up
Select/Deselect use
If I understand correctly, Select/Deselect of multiselect fields (including linked multiselect) can only be used in the script section of the OnLoad and OnEdit of the form. If that is true, how can a record be modified via script from a custom action button, for example? If that is not true, what is the syntax for its use? Can anyone provide a sample code?
Corrupt form?
Dear Zoho Team I have only one form in one of my applications. When I open an existing record, the onLoad script does not fire. When I add a new one it does. Furthermore, if I add a Notes field to the form, it is only visible when adding new records but not when opening existing ones. Please advise. Regards, Filip PS: the app in question is dsm; edit access is granted
dialer
additional assistance requested Hi, You can create a formula field and place the call link of the Phone as "<a href='callto://" + input.Phone + "'>" + input.Phone + "</a>" Ruben Zoho Creator Support 0 Best answer Comment gorlando5 Re: dialer 1 day ago thanks ruben, i just created a form and view and it does create the call to but nothing happens when i click on it. how to link up to dialer? thanks
Edit records using Stateless Forms
Could someone point me to where I can find out how I can use a stateless form to edit a record? I feel that this must be such common requirement in most applications that there will already be some documentation on line, but I haven't spotted it yet. What I envisage is that once the form is open there would be a way to launch a script (a button On Click?) that will fetch data from a record and populate the stateless form. And then, of course, when you 'Submit' it needs to update the existng
If then script
Hello. I am trying to figure out the Deluge Script in Zoho Creator. The result I am trying to generate is this: Through inputting, these variables are defined. vs (this is a percentage) Week_Gross (this is a decimal generated through a formula by adding several previously inputted numbers) Guarantee (this is an integer) In plain speak, the result I want is If vs * Week_Gross is greater than Guarantee, then output vs * Week_Gross, otherwise output Guarantee. I have generated the following
Setting Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. Does anyone know how I can
Creator added auto-filter on pre-existing applications automatically
As of yesterday I went back to check some pre-existing applications and noticed that auto-filters were applied randomly (and automatically with-out my input) to my various applications. On top of that some of the views will not show up and I get the following error [ServletException in:/jsp/edit/view/viewedit.jsp] null' Please look into this problem and get back to me Thanks
Next Page