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
Open url in iframe
This should be pretty simple. I have an html page where I'm trying to use openUrl to open another HTML page from another app and so far it doesn't open in Iframe. Any help would be appreciated. openUrl("https://creator.zoho.com/pcrs2013/pcrs-studies/#View:Variable_Collector", "iframe", "thisFrame");%> <iframe name='thisFrame' height='700' width='700'>Loading View...</div><%}%>
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"
fonts
Where/how do I change the fonts on my reports in Creator ? They are too large in the reports
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
Limitation for updating records
Hi I have 19000 records.I want to bulk update these 19000 records through custom actions.Is their any limit for updating these bulk records. Thanks.
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
Record Summary Print Error
I have a Record Summary that prints out as an A4 label that is used in a warehouse to identify stock. Each time the stock Qty is changed, a new label is generated. This has worked perfectly for 18 months but today the view looks perfect but when I try to print the text is compressed and overlapping. It is happening on different record configurations. I haven't changed anything at all and the problem replicates on other PCs and printers. I use Google Chrome. Can anyone help? Update: I've temporarily
Zoho Creator Marketplace not responding?
I am not able to choose a category, or Popular or Most Recent options in the Zoho Creator Marketplace - nothing happens - it simply stays on the Main Page (Featured Applications), and Search doesn't appear to work either. I've tried IE, Chrome and Firefox.
Market Place not responding
https://creator.zoho.com/marketplace All the options to navigate within the Marketplace are not working. I have seen other people commenting on the forum about the same issue. Francisco Riojas Creator Scripts Smart Software For Maverick Entrepreneurs www.creatorscripts.com
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN AGAIN - MY USERS ARE HAVING DIFFICULTY TO ATTACH FILES IT IS THE THIRD TIME THIS HAPPENS - I M REALLY GETTING SICK OF THESE PROBLEMS ZOHO IS SUPPOSED TO OFFER ME A PLATFORM FREE OF THESE PROBLEMS
Calendar sync with Google
I was wondering if there was a way to sync my Zoho Creator calendar with my google calendar?
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
Next Page