Issue creating app
Screen displays are all over the place when accessing app to edit and such. Screens are all jumbled up. Cannot access field values to change, screen stays on Form tab. Refreshing screen just jumbles everything on my screen worse. Emailed app comes in as SPAM and shows this on email. Firefox 39.0
What is the best practice for editing fields of a form from a list on an html page?
I have an html page. In this html page I have a table with iterated records from a form. I need the ability to click a button on one of the rows, which will then allow the user to edit only a few of the fields from the form. The primary field that will be edited is a dropdown. What is the best way to do this? It seems there are multiple routes to go: From the page, create a stateless form that pops-up or iframe with the fields to edit. Have buttons that use url variables that correspond with the
Alert Box on HTML Page (Creator Page)
I would love the ability to quickly debug my code in a html page by using the alert(); function. But it can only be used on a form in the onload section. The only workaround is to email to myself. BUT, its more than the debug function though. I would like the ability to alert my users as to change they made. Like, you just updated your subscription preferences. How have others been able to do this adequately? Is there a workaround?
User Field with zoho.loginuser
I have a main form with User field that is populated with zoho.loginuser upon add. As an admin, when I change the user field to another user, I want my subform to reflect the same loginuser. The subform has a field called User_name and it is a string field (not a user field). In the On Update of the User field in the Main Form, I wrote a deluge script to populate the User_Name field (string) of the subform so they are in synch. It does not appear that the functionality is present for User fields?
Custom Action Sendmail and set field value
I have my sendmail function setup and working so that when the user selects multiple records they are emailed. However, i would also like these selected records to be marked as "emailed" so that another user does not come along and email them again. How do I accomplish this? Here is my sendmail function if it's relevent: void sendemail2(Add_a_Container records) { msg_content = "<table border=\"0\" style=\"\" width=\"90%\" cellpadding=\"5\">\n <tbody>\n <tr>\n <th align=\"left\"
Form created to filter records in report
Hi, I have created a search form which is supposed to filter the records in an existing report. On this search form, I have the option to search by three different criteria (you can only search by one given criteria). For example you can choose to search by Name. I am not sure what I am doing wrong here; I would like to use the public link of my published report. This is what I have: if ((input.Search_by == "Name") && ((input.Name != "") && (input.Name != null))) { openUrl("https://creator.zohopublic.com/zoho_jchan5/copy-of-requests-for-purchasing/view-perma/New_Request_Report/Xy2yfT1JP48sAa9ZbTmP6Yh8qtPAXvYBVvOgrxnkABdnrjU2f3Tat66zKN8V7XUz3xUTugdx2OnMMsBMP2k0fr4GxBSQqN9nJ5fv?Requested_By="
If... does not contain in sendmail
Hi, This is probably going to be the most simple thing, but I just can't seem to figure it out. I have a sendmail function, in which I want it to be triggered if a certain field DOES NOT CONTAIN a certain name. I am not quite sure how to go about putting this down in code. So right now, I have: ((input.Location == "Toronto") && (input.Department_text == "Head Office")) and I'd like to add the criteria that input.Employee does not contain "Celeste" Thanks in advance! Joy
Top to Bottom Deluge Help, Real Newbie Creating First App
Hello, So I'm designing an app for my business coaching company and planning on buying the paid version for all of my coaches. My plan is to offer an "Accomplishment Report" to my clients that populates the "Coach Report" for my coaches. So far I've gotten a handle on creating the fields for both forms, creating simple lookup fields, creating/implementing rules and tasks (i.e. populating certain fields when a drop down choice is made), and managing the "Report" that every click of the "Submit"
Outputting images in Creator
Hi, I am having a problem with how images are being outputted in Creator and also when the app is linked to my Zoho CRM. It is a product database and the products are linked to the client account in CRM. When the image is outputted in the report in creator it is huge (dimensionally) so the report is impossible to use efficiently. What I was hoping is that a thumbnail would be outputted and when clicked would be bigger. I tried changing the dimensions on this screen https://www.dropbox.com/s/9fon0mh6thl15k1/Screenshot%202015-07-09%2013.51.43.png?dl=0
Link in email notification to edit one record
Hi, I am unable to figure this one out. When a user fills in a form and submits it, i would like a link to be available in the email for them to edit that record that they just submitted. I have used this as the link, but it does not work! Please help! I have published the form and used the public URL that is provided in Zoho. https://creator.zohopublic.com/<public URL>/record-edit/<ViewName>/Request_Number=input.Request_Number Thanks in advance!!! Joy
Adding data via email
I have a main form called New Request and a stateless form called Update Request Status. Employees will enter requests via the form on our website. The details are then emailed to the employee for confirmation. Is it possible to have the employee add data to their existing request (i.e. record) via email? Or is it only used for adding NEW records? Thank you in advance!
quickbooks create error evaluating MAP Expression Probem
I have tried to follow the instructions for setting up zoho creator api with quick books. Instructions are found here: https://www.zoho.com/creator/help/script/quickbooks-add-record.html It seems even when i copy the example i am getting the following error message. Seems that there is something wrong with my map variable but i cant see what. If i put the map variable in an alert box it seems to look fine to me. This is located in my Purchase_Request_Form on the Order_Number on User input field.
Filter by conditional formatting
Hi With conditional formatting we have the ability to format table cells in particular ways. It would be good to be able to filter records by the way they are formatted. For example if I have two rules which both color a particular column in a record red, an option to filter that column to show records which are red or not red would be good. Thanks Craig
searchRecordsByPDC and datatype mismatch
The following code gives me the following error Mismatch data type for function get at argument index 1 expected data type BIGINT found dataType STRING The error occurs when setting value of cfirst and clast. I don't see what this should be happening. These variables have not been set before and they should be string values. Why is zoho saying they should be BIGINT? CRMContactSearch = zoho.crm.searchRecordsByPDC("Contacts", "email", Client_Info.Email); cfirst = CRMContactSearch.get("First Name");
ZOHO CREATOR ADD RECORD JUST SPINNING...15 MINUTES AND COUNTING
TRYING TO ADD A RECORD...WHEN I TRY TO SUBMIT, "PLEASE WAIT" IS ALL I GET....HELP!!!!!!!
Start Page or Default Page for Customer Portal
Where would I set-up a default page or the start page for after the user logs-in from the the customer portal. Once I figure that out I can create a generic page that depending on the permissions can forward them onto the correct page, but I have not idea what page/report/form it will show by default. Any help is greatly appreciated.
Returned input not inserting into a field
Hello, This morning I wrote a small script to look up the ID of the users selection and put the result into another field on an on click [create] button. My returned information will display in the alert box i added to check, but the returned value in not being placed into the field... at least not that a user can see. Any thoughts would be greatly appreciated. Here is the code. // Match the Customer Information with the users selection. // ThisSite = Customer_Info [ID = input.Select_Site]; //
Download attachement with WEBCLIENT()
Greetings Im trying to download an attachement from a survey made it on zoho Creator, im using webClient to download the file but it only download 42kb from the file, is there any restriction about it?
Download attachment from zoho creator via API
Greetings Well i already make the link from the attach is the next one : https://creatorexport.zoho.com/zohoadmin221/claim-form/Aeroprotect_Form_Report/2729692000000957031/Attach.File_upload/download/1435693103969_Test.pdf?privatelink=TFtNwDdkDBJ1juZjnrJKFaAmHXm5qjppS2webRF9s5z8UaZ8kSFyzUC0JVdKNvOTEkmgEvOqs4rYrr1dV5u268J10pngtbZOyWGt So i want to download this url-file to my computer via code, but im having an issue .. Does any body can help me with this... How can i download this url into my machine
Referencing a Form in a Function
Hello - I have a function (call it "check_for_dups") that is currently used to identify potential duplicate records on a form. I have recently created a copy of the form, modified it slightly, but the field names that are used in the check_for_dups function are all the same. I'd like to re-code the check_for_dups function to work for either of these two forms by referencing a form as a variable instead of using the actual form name throughout the function. However, I don't see a method to declare
How to access items of dropdown
hi Suppose i have 2 dropdown a and b i want to hide or show items of dropdown_b on the basis of the items selected in dropdown_a. so for this purpose if (input.dropdown_a == 'a1') { // hide b1 and b2 of dropdown b , lets say dropdown b contain b1,2,3,4 } please provide me the syntex for accessing item i.e. b1 , b2 of dropdown b Thanks and Regards
One page, two forms, update a dropdown
Hi I've got a data entry HTML page with two embedded forms so that users can enter data to two different forms from one place within my application. However form 2 has look up fields linked to records in form 1 When a user enters a new record in form 1, I want to update the dropdown lookup fields in form 2 so that the new data is added to the choices. In other words, how do you force an embedded form to refresh from an HTML page? Many thanks
Error Evaluating MAP expression in previously working forms.
I have been having errors in my application saying the following: Error in executing Set Variable task. Unable to update template variable xxxxx. Error evaluating MAP expression : I was getting this error for a quickbook integration i have an open request for help on. Now this error just has appeared on an old form that was working as of last week and now not working... I'm beginning to wonder if i have an application problem rather than a coding problem going on. The new error has appears in my
How to access items of dropdown
hi Suppose i have 2 dropdown a and b i want to hide or show items of dropdown_b on the basis of the items selected in dropdown_a. so for this purpose if (input.dropdown_a == 'a1') { // hide b1 and b2 of dropdown b , lets say dropdown b contain b1,2,3,4 } please provide me the syntex for accessing item i.e. b1 , b2 of dropdown b Thanks and Regards
Insert Data into view by Stateless Form
Hi I am trying to insert data into a collection of records based on Criteria by Using Stateless Form. Below are the screenshot of What I am trying to achieve by Using stateless Form -- on Success Action. Screenshot -01 : Here is the data view , There are Seven Columns : one is Market Name and rest are the MVPD names under the market . Screenshot 02 : This is the Form that will be used to insert a MVPD to all Rows of above View. screenshot -03 : This is the Final output on Action of Stateless Form
Edit link to record public portal URL!
Hi, Using "https://creator.zohopublic.com" in URL to link to edit a record works fine, but when I replace this with the customer portal URL it ask for login. How to construct the URL to edit a record using public portal URL? Thanks, Damien Cregan Hire an Expert
Picklist to determine content of another picklist
I have since resolved this by following the guidelines here: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html I have created an order entry form based on the New Order Form in the Order Management application. In time we could have many hundreds of products and the prospect of scrolling through these in the Product Name field looking for a single product will be somewhat daunting. Image Add Product At the time of loading a new product we also assign it to a Product
OpenURL: Error message Improper statement
Trying to use OpenUR with the following but I get an error message. ZC with Google Apps url points to a document on Google Drive in the apps domain url will work in Safari Document is shared with anyone in the domain for viewing openUrl(https://drive.google.com/a/homesold.pro/file/d/0Bxt4E-nnZA0cUUVpc1BESTNpUnFPSzBMaXlZMVBPbkVqUk5r/vie","New window"); Thanks for any assistance
Default Date (Future Date)
I have a project status form. In add row, I need the start date to be a future date. I can do this easily for current dateh but don't seem to be able to code this for a future date i.e.09-01-99. any assistance is appreciated!! Thanks Edith
Create an app : how to create picking list
Hello, I would like to build an app with Zoho Creator, that looks like the "Events" app already provided, but with others capacities. I want to reproduce the function of "picking list" for invitation (cf. screenshot). I've already tried to put the "Lookup" and the "Zoho CRM" field in ZCreator, but it only allows to choose one contact or one account, but not to pick severals. Does anyone have a solution to help me please ?
java.lang.NullPointerException error
Everytime I try and add a "To:" email other than zoho.adminuserid, it returns the following error: Improper Statements/Expressions found java.lang.NullPointerException
Set Value of CRM lookup Field in Creator
I cant seem to figure out how to use deluge to set the value of a crm lookup field in my form. The look up field refers to the crm Leads module. I already have the lead id that the creator record is referring to in the crm but i dont know how to use this to set the creator crm lookup field. How do i take the crm lead id and set a crm lookup field in creator? The Deluge Name of my creator crm look up field is: Customer_Name The Field ID Name is: Customer_Name_ID If i use the following code the crm
Link to a Picture/file uploaded to creator
Hi, if a file is uploaded to a form in creator, a link to that file is created. if I want to change the file even though I keep the same name for the file, the URL link changes (a numeric part of the URL separated by an underscore to the file name) http://creator.zoho.com/DownloadFile.do?filepath=/1435263555952_practicorte2.png&sharedBy=yaxche&appLinkName=catalogo&viewLinkName=Fotos_Lista my question is if there is a way so that we keep the same URL for an uploaded file even though the file changes
HTML Template Page
Hi all, I've been digging around for ages trying to find ways to make my application less redundant. Basically, I've got a header, footer, and css block that's been copy/pasted across many different pages in Creator, and I'm wondering if anyone knows of a way within Zoho to generate html/import it from another source such that I could create a template of sorts? Also within that realm, does anyone know how to access external stylesheets on pages, as the html <link> tag doesn't seem to work for me?
URGENT: pusblished content not showing up
Hi, I have an urgent need. some public content is not showing up to the public. If I log in I can see the content but this is for public use. This was no problem two days ago. Please help. say for instance this: https://creator.zohopublic.com/yaxche/catalogo/view-perma/Productos_Page/TRBRXUCHQZCQU1y4dsV66KZa1ZMsDRkpzS6TJZxfKPDwXOX56UdZEuYMF5w3FSH9SZh0xn07BRNhFy1MsTWtBpxDZ53y92GRbtvy/Tecnica=102 data is showing up fine, it is the picture what does not show despite the view it refferes to is in fact
Email Notications - Are they Stored?
Hi, Can emails sent from Creator be stored or attached to the record it went from? We need to see the email after it has gone? Or can they be attached to a contact in ZCRM? Or if thats not possible....is it possible to send an email from ZCRM...or would i just set up a workflow in CRM when a field got updated......? Chris
Internet Explorer does not insert Turkish Characters inside CRM InsertRecords API Calls
Dear All, Anyone have problems in executing Zoho Creator apps inside Internet Explorer? We have a Creator Application that inserts records to Zoho CRM with PostURL XML calls. We have identified the Creator app works fine on Chrome and does not work on Internet Explorer. That means, Creator Application inserts correct records with Turkish characters on Chrome but not Internet Explorer. We presume that Creator codes are executed on the client side and use the client language & international parameters.
how to detect that NUMERIC field is not filled any data?
hi! there is NUMERIC client_mobile2 in form try on "on edit - on validate" make some checks for filling fields task - to find situation where client_mobile2 in not filled any data. how to make this check?
Incrementing numbers on Add Row, based on value in previous row (in a SubForm)
Hi there, I'm building an inventory/order system (yes, yet another onw :-) and when we receive goods, we add serial numbers to them. I will often get 20-30 new items with running numbers and I'm looking for a way to automatically increase the serial number for each new row I create... so something like if (row[-1].S_N != null) { row.S_N = row.[-1].S_N+1; } Can this be done ? Cheers, David
how to count how many checkboxes has selected?
hi! need count how many checkboxes has selected in entry it will work at "on edit - on success" how to make it?
Next Page