ZC and ZS integration issue
res = zoho.support.create("Requests", "test", "test", { "Name" : input.Name, "Contact Name" : input.Name, "Subject" : input.Request_Category }); Trying something like above, but got this error {"message":"Invalid Ticket Id","code":"1000"}
Problem with the function for each
I have this code and I need you "for each i in input.R" run Only with Certain records, but when i keep the record is saved as "R" is not input. Then when i select That box Belonging to a subform, I changed all the fields INSTEAD OF only of the subform Those That are inside. (Including the data That Already Been HAD registered Earlier) I have the same code and another field and in this if the input is saved. I do not get it. if (input.Clientes1 != null) { if (input.Correo_Electronico != null)
field rule for if a field is empty or not
I'm setting up a DB for keeping track of product photos. One of the fields is "Date received", meaning the date we received a photograph back from the photographer. I have another field which is to be a "Do we have the photo, Y/N". This field will be used on another related DB so we can see if a photograph exists for a product or not. I'd like to set the "Do we have the photo" field with a rule that says "If Date received is NOT blank", then set this field to Yes. Is there a way to do something like
Changing the Date-Time format
How do I change the format of a Date-Time field? I don't want it to be 13:00:00 -- instead, I want it to show 1:00 PM. Also, is there a way that I can have the date also show the day -- so ideally it would read: Mon Nov 3 2008 1:00 PM Thanks. Ellen kidspace
Fetch Data
Absolute beginner but I've spent hours trying to get Fetch Records when selecting a field in Form B. I simply want other fields in Form B to be populated based on selection of data in Form A. The example in the Zoho help is clear but doesn't seem to work when I transpose the fields to mine. Form A so far is a basic Product List (Manufacturer, Model Number, Warranty). Form B are Devices we actually have installed (so potentialy multiple Products of the same type), so want the Form B to reduce double
Prompt for parameter for a header-level custom action?
I've got a header-level custom action that works on all the selected records in the view. Is there any way to prompt once for a parameter that should be used for all the selected records? From what I've read in the forum, it sounds like I could use a pop-up stateless form for the input parameter but it would appear for each selected record. Thanks. - Craig
Wordpress User ingeration
Is it possible to integrate Zoho Creator into wordpress and manage the users access their rather than having to purchase the user portal in zoho.
Add CRM Event from Creator Form
I am trying to add an event in my CRM calendar based on the field Bid_Due from my Creator form. The creator form is not relative to any account or lead in our CRM nor does it need to be. Maybe this is an issue? So On Add -> On Success I drag and drop CALL FUNCTION from deluge tasks and select CRM integration and Create Record. Module Name is "Events" and I have mapped the field like so. crm_Resp = zoho.crm.create("Events", { "Subject" : input.Title, "Start DateTime" : input.Bid_Due, "End DateTime"
Pushing information into lookup via custom action
I have a form called Account in which we're tracking Accounts we do business with. I also have a form called Order in which we create orders. The Account and Order forms are linked via a lookup on the Order form that links to the Account name. On the Account report I have a custom action that will create a new order, the action does the following - void Order.Create() { openUrl("#Form:Order", "Same window"); } I was wondering if I can then populate the Account lookup field on the Order form
Deluge statement execution limit exceeded the maximum limit.
Hi I have a schedule performing a daily routine using a "FOR" and I get this error in the schedule log: Error Executing the workflow Vencimiento Cotizaciones script(Custom Schedule). The number of deluge statement execution limit exceeded the maximum limit. Why is that? I need a solution or turnaround to accomplish the routine Thanks!
Security: Customer Portal & Users & Permissions in Creator
Hi, I'm confused about the Customer Portal & Creators Users's and permissions links. I have the "new" account setup So under Application Settings i have links to the following: Users & Permissions: Which has Users, Roles, Profiles and Field Permissions Customer Portal: which also has has Users and Profiles etc So when a customer registers for access i can see him in the Customer Portal and he gets assigned a profile from the Customer Portal. So what is the purpose of the Users/Roles/Profiles under
How can I set date to date-day?
How can I set the date format as: 'Apr 05, 2016, Tuesday' ?
Embed view without html head and body
Hi -- Is it possible to embed only the content div (id="zc-component") of a view without html head and body?
store text
I’m trying to store some text from fields (i.e. Submitter_Email and Quote_Serial) in my Job_Information form and then recall that to use the built in sendmail function. I simply can’t get the text to store properly for recall in the email. Here is my test script for a send email Function. I know what is circled in red is completely wrong. What do I use here to store those form fields/text properly?
How to connect two forms with a custom function button
Hello, I've configured Zoho CRM to address all but 1 thing for my company. I'm trying to use Creator to address that one thing using a Creator App that consists of two forms. So far I've created the two forms within my app. I'm struggling with how to put a button that works (custom function?) on the report view of form 1 that will take a user to the data in the report view of form 2. I've attempted to create the custom function but I'm not doing it correctly. The custom function's button appears
Customise Email Notification
In the customise email notification panel does the TO need to be: zoho.loginuserid Or can it be one of my business email addresses
Sorting records by date - how to only use day/month?
Hi, We are currently trying to sort our subscriber database so we can see who has birthdays this month, and whose membership will expire in the coming month. However, we have found that trying to use the search filters does not work. This appears to be because the sort filter is looking for the next 30 days this year - not the next 30 days of any year. Is there any way to fix this? Currently our admin team is having to repeatedly export the db to Excel and then use Excel's sorting to find the relevant
UK VAT calculation in Creator
Hi, does anyone know the simplest way to calculate VAT in Zoho creator
Cannot close Live Chat popup
Hi, Whenever I use the "Live Chat" there is no option to close the popup window, see: http://prntscr.com/atooyl Please fix this. Damien Cregan Hire an Expert
Mass-import date values
I found it hard to understand what date format to use when mass-importing rows into a view. Looks like it has to be : dd/mm/yyyy . Looks like : mm/dd/yyyy or yyyy-mm-dd would not work. How is this configured for the view? Or is this configured at the account level?
different logo for multiple applications
I will have multiple applications in one acccount I manage them for different companies. They all need their own logo. How can I add a logo to one application and a different logo to another application all within the same zoho account?
Calculation of Values
Calculating values from 2 forms I have searched high and low for examples on how to calculate values from multiple forms. Im trying to calculate a running total from a staring balance field + deposit amount field + withdrawal field from 3 forms and display it in a Control Page, im in the process of creating an application that hopefully i can roll out to many members in the future and the formula above is an example of how majority of my field values are calculated. If i can get an example then it
How to Find a Field in Deluge Script
I want to delete a couple of fields, but I am not sure where in the deluge code it is referenced. How can I see where a field is referenced in deluge? And what if I don't want to delete a field, how can see where in the code a field is referenced?
can not add user to Zoho Creator
Hi, I had two users attached to Zoho Creator but deleted one so that I could add someone else. I added her to Zoho CRM and she can access that but when I attempted to add her to zoho creator - which we have two user permissions for and only one showing it says both are being used and I need to buy more. This is clearly not the case, what is going on? I have left it a day to allow the system to clean out and it has not worked.
send post url
Hello, i need help for some questions. I need to send data from table (For example: from row1 the sum of the all values, from row2 the sum of the all values etc) to web merge url. Url is: https://www.webmerge.me/merge/54626/7irksc Test data: ?&initial_users=My_sum_values_from_row1&growth_rate=My_sum_values_from_row2&arpu=My_sum_values_from_row3 But i really don't understand, how i can do this. So what i want to create [button], after clicking on this downloaded webmerge file from my data Thanks!
subform field won't trigger
Hi, I am trying to get a on user input script to copy information from a emergency contact form into the join table that is part of a subform. The master form is Call_Sheet, the join table that is part of the subform is Emergency_Contact, the form where the information is held is in Emergency_ContactsINFO. Basically the alert doesn't trigger which means my if isn't working- and I don't know why. Another user has suggested that it is a zoho area. if (Emergency_ContactsINFO[ID == row.Emergency_Contact].count()
Increase Column Width in Record Summary
I have a number of large text fields in a record summary and I can't see a way to increase the column width. My report comes out 3-4 pages long because the column is only 25ish text columns wide. How can I utilized the whole page? Thanks
Calculation of Values Through Mulitple Forms
Hi i have been banging my head over and over again for the last few days and i seem not to be getting anywhere, apart from building forms and hiding specific fields in deluge scripting thats as far as i have got. I have read that this is supposed to be easy and everytime i try to create an application i'm hitting the same wall and keep wanting to go elsewhere to create applications. I get replies for my posts saying if i need help then follow links to professional developers! hold on a minute if
Gmail Invite from Creator
Is there a way, based on input from a Creator Form to send an email invite to a gmail account for input in the gmail/google calendar upon saving the Creator Form? I have search and read the forum and support pages, but am confused. I was hoping someone could point me in the right direction or answer the question with some guidance. Thanks! PS And yes I've read this Topic - https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html
Refer Fields link deprecated?
I logged in yesterday to my account to continue doing some app development work and I could no longer find the "Refer Fields" link on the top right corner of my free flow scripting window. I emailed support asking what happened to "my window" and here is there response: "The "Refer Fields" option in the free flow mode has been deprecated. The names of the forms and the fields would be auto populated when you start typing the script in the free flow mode." So I tried today to see what they meant by
Post to URL Xml Json $50 for solution
I have a formwith basic contact data - first name , last , address , age etc I need to post info after submitted to my db to external site as XML or JSON - I have tried everything all I get back for response is Bad data type errors . I got 50 bucks for who ever gives me a working solution - Instructions below- Our services follow RESTful standards fairly strictly. A successful api call is indicated by a http response code in the range: >= 200 and <= 299. Any other http response code is a failure.
Does anyone know where a non coder can learn deluge script? Deluge for Dummies
I just get so frustrated being dependent on developers to do everything for me in my apps. I have absolutely no idea of how one would go about learning deluge script. The platform that is made to teach just makes me feel totally stupid as I have no idea what I am doing. I can't get beyond the first 2 or 3 exercises and the ones I get right, I have no idea why they are right or wrong. There has to be a way to learn this supposedly easy language. Does anyone have any idea to share regarding this subject?
Getting a list of the contents of a field for all rows of a subform
Hi, I want to make a field in the parent form which lists of the product names fields in all the rows of a subform So if someone has bought a TV which is one row, a stereo which is another row and a microwave which is another row the parent form's field would return "TV, Stereo, Microwave" How'd I do that - I can't think of a search that doesn't use the word 'list' which gives me the wrong sort of answer thanks
Test User can not access database
Hi, my secondary user can not access the creator database I have created. When it attempts to log in to the creator site and select the application the messages says you have logged in as vicandreuben@gmail.com. You are not allowed to access this application. But I have selected them in the user settings to be able to use it. When the user attempts to use the apps through Zoho CRM, which is how they will be using it when it is live, they can view the forms I have linked to, they can see the test
How to hide fields in subforms based on input in other fields in the same sub-form?
I use a subform in my mainform that contents a row with 4 fields. How can I hide some of these fields in the row based on the input added into this row-fields?
Insert an image (created QR Code) in to a form or report from a url
I currently use a formula to generate my QR codes in excel through goo.gl which is : =if(isblank( A4 ), "", image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="& A4 )) in the above code if A4 ( which is th item name or number or code or what ever) is blank then the cell with the QR code is blank. if there is text then a code is generated with that text. my question is can i set a field in a from or a Deluge task to display the same ? thanks
getting information for a Subform join table
Hi, I am trying to get a on user input script to copy information from a emergency contact form into the join table that is part of a subform. The master form is Call_Sheet, the join table that is part of the subform is Emergency_Contact, the form where the information is held is in Emergency_ContactsINFO. Basically the alert doesn't trigger which means my if isn't working- and I don't know why. if (Emergency_ContactsINFO[ID == row.Emergency_Contact].count() > 0) { emginfo = Emergency_ContactsINFO
making picklist for sub field
Hi, I have tried to get a picklist to pick only the equipment related to a type dropdown but it only lists one of the choices when there are three available. So the type lists Camera, Sound and Lighting The names would be Reuben's Fs7, Gregs A1p equipmentinfo = Equipment1[Type = row.Type].ID; row.Equipment_Name:ui.add(equipmentinfo); Thanks
Error: 'BIGINT' trying to update 'STRING' data type
Hello, I'm trying to fetch data from a report to auto fill a form. When putting in the code, I get an Error. Can someone help me fix this? Error at line number : 5 Variable 'First_Name' is already defined of data type 'BIGINT' but trying to update 'STRING' data type if (OC_Information[ID == input.Employee_ID].count() > 0) { ocinfo = OC_Information [ID == input.Employee_ID]; //input. refers to fields in current form input.First_Name = ocinfo.First_Name;
Can´t submit a main Form with subform
Hi, I'm trying to create an order sheet with fields like: "authorised by", "request by", "department". Then a subform with: "Product", "Quantity", "Price" and a "Subtotal" field per row. And finally a "Total" field in the main form which sums all Subtotal fields in every row of the subform. Right now i have this scripts: On user input: input.total = 0.0; row.Subtotal = 0.0; for each row in Orders { if (((row.Quantity != null) && (row.Price != null)) && (row.Subtotal != null)) {
Next Page