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
Download Attachment Need Actual File not a Link
I tried using Image Upload app. I can upload an attachment. However when I download to excel I have the following: <img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/1272213556146_Ev_YMCA_Testimonal0001.pdf&sharedBy=sampleapps'/> However I really want the contents downloaded. How I am able to get the contents downloaded instead of the info above? If it isn't possible then is there any additional workarounds. Thanks
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
Creating a new record
Hi, I am trying to figure out the custom function for the automation rule trigged when an invoice is created in Zoho CRM using Deluge scripting. The custom function should create a record (Operation) in the custom module Operations with the Operation Name = Subject (from the Invoices module) and Quantity for this Op = Quantity for the main product/the first in the list (from the Invoices module). I wrote something like this, but it doesn't work: void CreateOperationForOrder ( string invoiceID )
Upload Spreadsheet created in ZohoDocs
Im trying to upload a spreadsheet created in ZohoDocs to my application. I can select the file but when I hit NEXT to go to Step 2 nothing happens
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
unable to regenerate this report
Hi, I am unable to regenerate data in my report. When I select regenerate I see the message 'Sorry we are unable to regenerate this report'. This error has been encountered on all charts and pivot tables. I have allowed edit access. Our URL is https://creator.zoho.com/zoho_zubin/collision-accident-recovery-services/#Report:Settlements_per_month Please advise. Thanks, Zubin zubin@statelaw.com.au
adress
Hi every one, does anybody know how to include an address in a form. I explain what I mean: the users of my application must inform their address. I need the application to "detect" or to 'auto-completion" or to "list" all adresses in the world. I already use this kind of forms on the net but I don't know if this module is available in Zoho Creator. Tks in advance
Creator
I've shared a form with a member, but this person is unable to edit records. I have a Standard subscription. How do I allow this user to edit records?
sign in to support
Why can't I sign in to review my requests Tells me my user name or password is incorrect. User name (my email) is correct. Tried to reset password and get message no such user (which is my email)
customer portal redirect between pages/form
Hi, If I use permalinks in the link there is the login name... this means that the link is fixed for that user and the same permalink doe not work for all the Customer Portal User. Imagine I have an Html Page that is a sort of "menu" and redirect to several html pages. Customer Portal User has to log in, access to the menu and then navigate and access to the html pages... how to do it? tks, Pippo
How to add a button
Hello, Sorry for such question but I can't find answer anywhere. I found that buttons can be added to Stateless forms, but I can add them only to the bottom of my form. How can I do it near columns? Or take form fields to the bottom part?
Changed record owner "added user"
I have found that I am unable to use the "users" field in a subform for record owner. I have set the record owner of the main form with the user field. When the user update the subform Project Status,the user field is unavailable and does not synch to the main form. The workaround I believe is to remove the subform et al, and call it with a url but I have already put a lot of work into the application so it is not easy to disengage the subform. Any other ideas? Thanks
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
Calendar Events Do Not Span Multiple Months
I have created a calendar report in Zoho Creator with specified event START and END dates. When viewing the calendar, each event starts on the correct date. If the END date spans into the next month, the event spans until the end of the month it began, but does not appear in the next month. Has anyone had this issue? Thank you! Steve
Merge email fields from records
Hi, I have in Zoho Creator a lot of contacts emails fields. Is there any function that will allow to create an email to multiple receipients based on this or s function that will consolidate the email addresses in a new field and/or report?
How to create custom formula for shopping list
Hi there - Here is what I am trying to do. I have a business that allows people to shop with us I would like to create an application, that uses Zoho Creator, where users can click a check box and then get a report of the equivalent from our store. So for example If the form had a section called Bathroom supplies and there were a series of checkbox like like Soap Shampoo Mouthwash Shower Cleaner When the user chose a few products and submitted the form it would show our product and price based
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
Radio Field
Is it possible to have a radio field that eliminates displayed options as they are chosen. For example, I am setting up a form that has multiple date/time selections using the Radio Field, but I want the time slots to disappear as they are chosen. Any suggestions?
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
aggregate sum on field populated from lookup
Hi, I have a table [A] that contains currency values (€) in the field [cost_A]. the Form [B] has a field [cost_B] that is filled using a lookup on table [A] , field [cost_A]. Now I have to do a query con Form [B] with numerical condition on field [cost_B] and sum on the field [cost_B] to obtain a float (or a currency). It does not work, each field [cost_B] is fetched as 2894241000000618044 !!! any hint? tks, pippo
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
Setting default value for Lookup Picklist
Is there a way to set the default item from a lookup picklist so that it appears automatically? This option is available when it is just a simple drop down, but is not available from a lookup picklist.
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
Customer Portal - All Portal Users
For some reason when I edit a report, restrict visibility changes and it keeps adding all Customer Portal User group to the visibility group....not good. Is there a setting I need to change? I don't want to check visibility every time we edit a report.
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
Adding user name
I have a peronal account, which I'm using to try to get a buy-in from management to adopt Creator. When I want to add a ne user I can only enter an email and there is no way to change the name of the user. Is adding a user name part of the upgrade?
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
Users suddenly cannot access public files
Since today my users cannot access files that are public (both views and forms) WHAT IS HAPPENING??? THIS IS THE 3RD PROBLEM OUT OF NOTHING YOU CREATE THESE LAST 15 DAYS EXAMPLE: https://creatorexport.zoho.com/DownloadFile.do?filepath=/1435610456738_Sistema_CNJ__Processo_Judicial_Digital_-_PROJUDI_.pdf&sharedBy=raffbr2&appLinkName=cjuridico&viewLinkName=Arquivos_View_com_parent_ID When the users click on the file they are asked to login!
Call Main Form from Subform
I have a Main Form "Projects" and a Subform "Project Status". Each PM updates "Project Status" -- details of the project status. In some cases, they need to update the Main Form "Projects". I am able to create a url for the user to click to access the Main Form "Projects" record id from the subform "Project Status" when it is necessary for the user to edit a record on the Main Form "Projects". However, this does not work if there is a filter used in the report per zoho. The filter that I use
turn initial value to null in hide fields
Please suggest me how to set initial value to null in hide fields, if i don't choose them. For example when a rule is triggered form will show me field with initial value but if rules isn't triggered, initial value will set to null and will not show in report.
fetch lookup data in email notification
Hello. I don't understand what's wrong, please help: I have Form1 named "ICD" with lookup field "surgeon" to field "surgeon_add" in other form named "Surgeons_add . So i tried to fetch data to show the actual data in lookup field on email notification form ICD > On Success: surgeons = ICD [ID == surgeon]; test = surgeons.surgeon; then in sendmail I tried all variations sendmail [ from:zoho.adminuserid to:"ill@gmx.com" subject:"123" message:test + "<br />\n" + surgeons + "<br />\n" + surgeons.ID
Request: Report "Subtitle" and "Intro", that show on the Live view, and optionally when printed.
Please consider adding to the definition of a report an optional "Subtitle" and optional "Summary". Or similar. Subtitle: A text field. On the report, both in the Live view and when printed, shows near the report title. Summary: A rich textarea field. It shows on the report, both in the Live view and when printed, near or below the Subtitle. Could be used to clarify to the Live user (or the printed reader) the purpose of the report or to give some instructions, etc. Rich text is best so can
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?
Multi column responsive form
Hi Guys, Thank you for your work. I try to use form on my site and customize it to match the design. On desktop I need form in 2 columns and I set it in Zoho Creator. But on mobile it should be 1 column. How can I do it? And similar issue - how to do fields full width not fixed? Thank you
Next Page