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");
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN
AGAIN - MY USERS ARE HAVING DIFFICULTY TO ATTACH FILES IT IS THE SECOND TIME THIS HAPPENS - I M REALLY GETTING SICK OF THESE PROBLEMS ZOHO IS SUPPOSED TO OFFER ME A PLATFORM FREE OF THESE PROBLEMS
Cannot attach files
This morning we started experiencing a problem when attaching files to our forms. The form has 2 spots for attachments. 1 is a basic upload field, the other is in a subform within the main form. Neither work. When pressing submit, we just get the "Please Wait" icon. Please advise on when this will be resolved. Thank You
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?
Do not send Report if empty
Hi, I would like to create a schedule to send a daily report as an attachment via e-mail but I would like to avoid sending a report/View a blank report with no data. any help will be greatly appreciated Thank you. .
How to downlad attachment From xml API
I have the link for the attachment for example this: https://creatorexport.zoho.com/NULL/claim- form/Aeroshop_Refund_Form_Report/2729692000000788007/Attachments.File_upload/download/1433869617150_Aut_credito_cuenta.pdf I know that in the url the word null needs to be replaced by the userName but when i want to download this file this path ask me for a user and password .. The question is any chance to send the userName and password into the URL by parameter and download the file? I will like to know
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
Next Page