Drop down field, send e-mail on selection.
Hi, We have a form for members to submit a request to become a member. One of the fields is a drop down with status that the admin uses for approving a member. Status: 1. pending (default) 2. approve 3. inactive When the status changes to "Approve" we would like the system to send a welcome e-mail to the user. How can we do this? Thank you. Sami
Import data and populate source and url fields for an image?
I have an image field (set to link) in our db. Rather than adding records individually, we want to compile records throughout the day into an Excel file then use the import command. But, is there a way we can configure the data in the Excel file to automatically fill in the "source" and "url" fields in the image field? It has me stumped.
trying to get list to display in multi line field
this script returns a single value filed and I need it to display a multi field list. Please help!! a = TZ2WOD_Work_Order_Details [ID = input.Select]; zz = aa.TZ2WODe_Group_ID; bb = TZ2WOD_Work_Order_Details [TZ2WODe_Group_ID = zz]; input.Line_Item_Display = bb.Group_Name; Cheers, Larry
Recycling database
I have a need to create an online database of recycling partners. Each partner needs to be flagged with the recyclable items that they can accept. There are 12 top-level categories such as Paper, Plastic, Metal, etc. and each one has a bunch of subcategories for a total of about 400 or so. What I would like to do is to be able to enter the partner info, then select the top level category to expand it, and then check the boxes within that category for each recyclable that they can accept. It looks
Calling XML RPC API to add a record to a form with sub-form
I am trying to add records to a form with sub-form in Zoho creator using the XML RPC API in C#.NET application. I am getting the error below when using Web Request class to create the request. { "The remote server returned an error: (400) Bad Request." } I am using ASCII encoding and Content Type as application/xml. Can anyone provide me an example with C# code to make a call. Thanks!!
Migrating from Google to Office 365
Dear Zoho Team, We are migrating from our Google Apps platform to Microsoft O365, however we are currently relying on Zoho Creator and Zoho CRM for our support and sales departments. Before I migrate all of our accounts from Google to O365, how do I ensure that none of my Zoho services are impacted? We currently are using Google Apps federation in order to login to our Zoho accounts. Can you please assist me? Thanks, -Jaap
how to load a script into creator?
Hello Zoho, I would like to create a form manually with a script, to take a saved script and modify it, then load it as a new form. How to I load a script into Creator? Thanks.
WEBINARS
ANy new Webinars coming??
how do i enable sms?
how do i enable sms? couldnt find setting-add ons=
Record Summary Report - Multi Select Line Return
Is it possible to have a Multi-Select field ( ${MOE_Multi} ) to return each selection on a separate line in the Record Summary Report Example - Instead of results being display on one line as: Choice A, Choice B, Choice F Display on report as: (with a line return) Choice A Choice B Choice F
Related to Stateless Forms
I am new user of Zoho creator.I am facing problem to fetch data from Main form to a stateless form with a look up relation between them.Can some body help me.Thanks
Show all months on graph even if data = 0?
We have an application that tracks shipped product, each shipment is a row of data. however if no shipments for that product occured in a given time period the graphing engine does not display those months,. Is there a way to set it to show months even if there is no data in them? below the line graph is a running summation of product shipped. There were no shipments in October or November so it doesnt show them on the X axis. Ideally this would have flat lined for Oct and November.
Send SMS as custome function?
How do I send an sms as a custom action in a report view? I'm using Twilio and would like to send an SMS to the number listed in a form field named "mobile_nuber". I would like this function to also add the text "yes" in another field called "sms_sent". Thanks!
Return Function date-time to text
I would like to make a function that if a date and time box is null, the become "". For there is nothing in place that says Null. I'm doing this function a new page, so I do not have the "Return" and I think I must invoke the function. Example If F_Registro is full { F_Registro = ""; } I am no expert in this type of functions, I have a similar function, but allows me only in numbers and I want to date a specific word, Nulltext string (string texVal) { orgVal = "0"; if (input.texVal! = null) { input.texVal.toTime
Create Zoho Calendar Event on another uses's calendar
The guide here only shows how to create an event on one of my own zoho calendars. Is there a way to create an event on another zoho creator account's calendar? The scenario is that we have a scheduler who uses zoho creator to assign tasks to technicians. We want the scheduler to create events on the technicians' calendars, not on the scheduler's calendar.
Publish settings are not saving
I've created a form and have published it. But the settings on the right hand side, background colour, headers, field sizes, etc are very flaky trying to save them. Every now and then it works, but most times it doesn't save any of the changes. Any chance someone at Zoho can look at this please? Thanks
Show all months on graph even if data = 0?
We are using Creator to track shipment of products. Each product shipment is a row. The line graph shows a running total of that product shipped over time and the column graph shows shipments by month. No shipments occurred in October or Novembers, so the graphing utility is not populating Oct and Nov as intervals on the X axis. Is there a way to have the graph still show the months when activity = 0?
Autofill
I'm new to this and struggling with a specific requirement (mentioned below): I have created a form in zoho creator. After which I have entered some data using the form. The data I have entered shows up in the list report which was auto created along with the form. What I'm trying to do: I want to enter a mobile number in my form, which is already present in my data (was entered before) and all other data related to that mobile number should be populated in all other fields. Example: I have the following
API Integration
I want to fetch order details in the form https://creator.zoho.com/zoho_admin1311/copy-of-oms/#Form:Add_Sales when i enter Order Number fields from unicommerce. Their API doc link is given below. http://support.unicommerce.com/customer/portal/articles/1467822-api
How to receive by email the entries made in a contact form?
Hello, I have created a contact form in my site using the standard supplied one. When I enter some details with it on my website, nobody is notified, I need to go to the 'Contact Manager' tab of my Site to see what was entered. Is there a way to receive an email notification when the contact form was used? Thank you. Alex
ZC user management bug
Hi all, I noticed my email address: lexshan@walkintour.com is associated with multiple ZC accounts. one is: lexshan1, the other is lexshan5 Here is what happened: i created an ZC app on lexshan1, then i added another user (bayarea.bo@walkintour.com) as Administrator while keeping my account as Admin. Then when byareay.bo logs into the app, lexshan1 lost access right away, although Settings->Users & Permissions still show lexshan1 as admin. When I login normally with the email and password, I get
Close html view popup from a form in the html view inside of a iframe.
I have an html view that opens in a zoho popup dialogue box. The html view has a series of record views and forms all inside of separate iframes. When one of the stateless forms inside the html view is submitted i need the entire zoho dialogue box to close. I cannot seem to get this to work. I have tried the openUrl functions but they all seem to apply to the iframe that the form is in rather than the whole window that the html view is in. I cant seem to get the whole dialogue box to close. Please
I have tried making a script in Creator to push data to CRM but it is not working? Why???
Creator does not recognize the CRM field (of course). But why is this example script not working? https://help.zoho.com/portal/en/community/topic/push-data-to-zoho-crm
Attendance Data Entry using a report view.
Hi all, I am new to Deluge scripting and Zoho Creator....I created a database with a table for Contacts, Classes, Class Schedule and Attendance. I am wanting to track a students attendance to a class they are enrolled in. I was hoping to do this by having a report with the date field empty but the class and student names pre-populated. Then we can simply do a batch update on the selected students and enter the date. Thus the student record would be held int eh Attendance table which pulls names
XPath Returning Error on JSON Data
I am trying to import some JSON data via the XML Path Builder. The content looks like the below, and I am trying to get an XPath to the "spend" level { "data": [ { "lifetime_budget": "9837", "insights": { "data": [ { "spend": 2.97, "date_start": "2015-12-07", "date_stop": "2015-12-07" } ], "paging": { "cursors": { "before": "MAZDZD", "after": "MAZDZD" } } }, "id": "6034498439074" }, However, the XPath builder returns this error: ERROR: The Number of Nested Child Nodes is Exceeding the limit...
Sorting .count() by something other than ID
Hi Guys, Hope you can help as I’ve spent hours on this and still have no solution. I have a picklist in Form A that brings in a number of separate records based on Form B depending upon their particular status. These records are then selected in the Form A picklist and when submitted they are given a reference number from 1 to however many records are selected which populates a field back in Form B. This is all working great apart from one thing. When the records are counted using the .count() function
Need better explanation of Usage Limits on Deluge Statements, and options
I've written an HTML View to display daily timelines for staffing for an client organization. To do so requires iterating through a loop for each half-hour of the day for several employees, with the scheduled staff times coming from a Creator form. But if I try to display more than one day of staffing, I get the following message when the application is run: Following the link leads to this extraordinarily unuseful information: The information above is not only confusing and impossible to monitor
subString Function Error
I am trying to get a part of a field using substring function. But when execute the function, zoho returns an error. My function is void mediodepago.PegaCobro() { RegVisa = FileV [Fecha_de_Proceso == null]; if(RegVisa .count() > 0) { for each Rec in RegVisa { sLinea = Rec.Linea; sFec_Compra = sLinea.subString(71,6); } } } Linea is a Single Line type. The error is Execution Failed Error details: Error occured please contact application owner. Does anyone know what´s wrong in my function?
Copy data in same form/record
Once a year, need to move or copy data in one field to another field - same form, same record. Example: Membership form, criteria is [Status1 == "Member"] Last_Year_Paid needs to be updated with value in Current_Year_Paid Want to do this to all forms with the criteria of Status1 == "Member" Any help with a scheduled (01/01/2016, 6:00 a.m.) script in Workflow? Thanks, Stephen J Voss Houston Outdoor Group
Subform row change event
Hi all, i know there is a event for "On Delete Row" for each field in the subform. This event seems to get executed in real time as the user interacts with the form. What I'm looking for is the event when the user finishes changing the subform and hit "Submit" on the main form. That's when data gets persisted for the subform, correct? At that point, i want to compare the previous subform content and the new subform content and send out an email about the changes. Is this possible? If not, any workaround?
Barcode scanning with mobile app
Is there any way to use the zcreator mobile app to scan a barcode? Thanks
variable just bring me a value on user input action
Hello, i try to find the error in this code, but i give up.. i have this in a user input action: sum = 0; for each s in input.invoices { search_invoices_mount = Ingreso_de_Facturas [dato == s]; sum = (sum + ceil(search_invoices_mount.Monto_total_US)); } traeinfocanal = Ingreso_de_Clientes [Canal == input.Cliente]; traeinfocanal.Cartera = (traeinfocanal.Cartera - suma); works fine, but if i cut and paste this in form action, on success, dont work, show me the log Error evaluating
Add sum to form from numeric fields on other forms
Hi. I have a form called "Properties" where I add info about work sites. I have a second form called "Building Section" related to the "Properties" form by a lookup based on the property name. For each property there are several build section records. On the building section records I have a currency field for annual repair budgets for each section. What I want to do is to add a currency filed to the "Properties" form and show a total repair budget based on the total sum from all building sections.
HTML Report filtering
Hi, If I have 10 different reports and all of them have the customer name in common, how can I create a dropdown on the HTML page that displays all the different reports? The dropdown contains the customer name (lookup). Is there a better way of doing this? The goal is to see all the reports on one page, but filtered out for each customer. /V
Copying string values between the same field in succeeding row?
In a subform, how do I copy string values between the same field in succeeding row? Sound simple but has me stumped...help thanks Larry
ZOHO AppBox?
Can anyone shed any light on this app and what it offers? https://play.google.com/store/apps/details?id=com.zoho.zohobox https://itunes.apple.com/in/app/zoho-appbox/id968411132?mt=8 This seems like something I can use based on the reviews but I cant find documentation anywhere.
Converting Excel Formula
Hi Team, I am struggling to get a conversion of the following Excel formula to work correctly and wondered if someone could offer some advice. = IF ( G8 = 0 , 0 , IF ( AND ( G8 > 0 , G8 <= 5.3 ) , 12 , IF ( AND ( G8 > 5.3 , G8 <= 9.3 ) , 16 , IF ( AND ( G8 > 9.3 , G8 <= 17.3 ) , 24 , IF ( AND ( G8 > 17.3 , G8 <= 21.5 ) , 32 , IF ( AND ( G8 > 21.5 , G8 <= 33.5 ) , 44 , IF ( AND ( G8 > 33.5 , G8 <= 45.5 ) , 56 , "CANT DO" ) ) ) ) ) ) ) G8 is replaced with my field named B0 = IF ( B0 = 0 , 0 , IF (
Is it possible to add webhook in zoho creator
Hello there, Whenever data is inserted or updated in zoho creator, I want Zoho will send me notification to my applications URL endpoint. Is it possible to set webhook in Zoho creator, so my custom application will get notified each time new records inserted in Zoho creator?
Parsing string from integration
Hi all, I'm working with ecwid.com an eCom site that formats their data in the following way: [u'Desired Date', u'Desired Time', u'Sqft', u'Address Line 1', u'Address Line 2 (Optional)', u'City', u'State', u'Additional Spaces*', u'Access Instruction (ie. meet agent or combo code)'],[u'Domain Choice 1 (123Main.com)', u'Domain Choice 2 (123MainSt.com)'] If I parse it manually, I would get the following structure: [ u'Desired Date', u'Desired Time', u'Sqft', u'Address Line
Auto update
I have created a field that reports the number of days between a date field and the current date. How can I get this value updated automatically each day to reflect the change in current date? Thanks, Martyn
Next Page