Remove creator header from edit record custrom action popup window
I have a view with a custom action button that will open up a form and allow you to edit the form. I want this window to open without all the zoho creator header stuff (compay logo, creator tabs etc). Below if the function I am using. I think that there is another way to write the url that might remove the creator header stuff from the top of the popup window that opens but i do not know what it is. Please any help is appreciated. My function: void Quoting.editQuoteItem(int ID) { openUrl("https://creator.zoho.com/<zohoaccountID>/<AppName>/#Form:Quotes?recLinkID="
Create multiple records in blanc form
Hello, I have a question about the insert into function. I have three forms: Form A: containing the fields: Name, group and Number ; Form B: containing the field: Name, group and Number and Message; Form C (blanco form): Containing the field Group and Message; When I select the blanco form I have made a submit button with has to do the following action: Based on the selected group, it has to search in Form A who is in the selected group. It has to input the users who are in the group into form B.
Understanding Schedule
I am trying to wrap my head around the schedule feature in ZC. Say i have a Task table with contains Date Time when the task is due. I want to send out reminder email 1 day before the due date time. This schedule is good from 1/1/2016 to 12/31/2016. Under the schedule, there is a Start Date option. Is this the "execution start date" or the series start date (1/1/2016)? I assume it's the "execution start date". Am I correct? Now how can i specify this schedule is only good for 2016 only? Am I correct
Pass "input" as function call argument
How come I can't pass input as argument to function calls? A valid scenario is this, in On Edit-Validate, the input is the form before it's persisted to database. Let's say I have form called Company, input is of form Company. I have a custom function that uses fields inside Company to send emails. void mySendMail(Company c) {...} I want to be able to call the function in the following two ways: 1) mySendMail(input); 2) x = Company[ID== 2341252]; mySendMail(x); Now, because i can't pass input as
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
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!!
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.
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.
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
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...
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
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?
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
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
Unable to download zar
I took the zoho training that was done in Atlanta. When I am in Creator and I attempt to download a solution all I get is 3 dots on my screen (see attached file). Is there someone in the US who can help me ? Hal
Push CRM Data to Creator
I have customers and prospects in Zoho CRM. I have a Zoho Creator app for sales and servicing in my business - when taking an order, I want to retrieve the customer info from CRM. No problem using Creator's CRM Lookup type field EXCEPT that I have three users of my app who are shared users. They do not see my Contacts because they are not signed in as me. I'm told I have to use workflow and APIs to send the contact data from CRM to a form in my Creator app and then do the lookup via the data in
HTML Link with parameter variable
Hello All: I am starting to develop a HTML page for a dashboard. I am completely new to HTML but it has gone well so far. I ran into an issue when trying to insert a HTML link to a report that I want to pass a filter parameter to. I am able to make the link work if I set the parameter equal to a value but cannot get it to work when trying to use a variable so the link adjusts based upon the information on the HTML page. Here is the code for the link that works when I set <Job_Number>=851005.
Sending from Users email addresses
Hi, In an application I'm working on I find it necessary to send an email from an email address other than zoho.adminuserid. Is it possible to use an email address of a User who is not currently logged in? Thanks, Damien Cregan Hire an Expert
Embed form or report in website problem with mobile
Hi. I'm attempting to embed a form in a website. The website has both desktop and mobile versions. When I open in mobile version the embedded form/report displays as the desktop version. Anyway to get the mobile version? Thanks Arlan
Is this even possible with Zoho? - Pull data from one site with their API then push orders to another with their API
Hello, I've been trying to learn Zoho, but before I get too far I'm wondering if any gurus can tell me if this is even possible? Basically I'd like to connect into the Etsy API and import my orders and customer information then I'd like to use that data to create corresponding dropship orders on Shapeways with their order API. Can Zoho both pull in data from one site, allow minor manipulation and then push it back to another website? Thanks in advance, just want to make sure it's worth my effort
Error: Unable to update Template Variable
Hi - I have been using the following code for over 12 months User_Email=zoho.loginuserid; crmContactMatches = zoho.crm.searchRecordsByPDC("Contacts","email",User_Email); alert (crmContactMatches); for each contact in crmContactMatches { accId=(contact.get("ACCOUNTID")).toLong(); accountResp = zoho.crm.getRecordById(("Accounts"),accId); System=(accountResp).get(("Parent Account")); siteResp=(accountResp).get(("Account Name")); facilityResp=(accountResp).get(("Account Site")); Site:ui.add(siteResp);
Amazon SES + ZOHO Creator: Now Live
This is a continuation of my effort to use ZOHO Creator as the front-end interface to Amazon Simple Email Service. I had posted an update to this recently, but removed the post due to a sign-up issue. The issue is fixed and the whole application is working! This really stretched my abilities as a programmer and I'm happy with the results. I invite you to sign-up as a subscriber and help me test the application. https://creator.zoho.com/niskypto/cloudmail# Note: When you get to the subscriber profile
How to read my full name from the API
I'm using Zoho API in my application. Users are getting access tokens by providing their email and password. Everything works great. I'd like to improve my GUI and display user's full name. Currently, after successful authentication, I'm showing them the email. Is there any method in Creator CRM API or general API to get user's full name?
Limit exceeded
Hi, I'm getting the below error while updating one of my record. Record ID No: 190193000013538102 Form url: https://creator.zoho.com/piju2111/penta-crm-15/#Form:To_Do_Form Error Message: The number of deluge statement execution limit exceeded the maximum limit. Solutions tried: Tried using different variable (input3. ), getting same error. Note: I have given access to support to solve the issue. Thanks
How to Allow user to dynmacly create options in a checkbox field?
I'm using customer portal and have many people log in and access form. I want them to be able to set what the options are for a checkbox field. Then when they come back to that form and use it later it will have their options in the checkbox field. How would I do this? Thanks Scott
User defined checkbox choices
I'm using the portal to have individual users fill in the their own forms. How would I allow my users to define the choices in a checkbox field on a form? Thanks, Scott
Display subforms like forms
Displaying subform forms as if they are list reports can make data entry unwieldy on smaller devices. I'd like the option to present them in form view (like the forms they belong to). A collapsible list displaying an identifying expression for each row that would expand when selected to display the subform would make it more manageable.
Customize or override CSS in Reports
Is there a way to override the group row color on reports? Currently it's yellow and I'd like to change that. The CSS class is zc-grouprow.
Send email from action
Hi, I am trying to create a simple Stateless form to send email to selected records. the main form: 'Register' includes email field 'Email' the Stateless form: 'Emailtoselection' includes mulltiline field 'RegID', and Email_Subject and Email_Message fields. I basically followed this post where Cyril M explains and my code looks like this: function to open Emailtoselection form and below that the sendmail function for the Send button: void SendEmail_toselection(Register rec) { openUrl("#Form:Emailtoselection&RegID="
Zoho creator api query where field blank or null?
I tried posting a long question related to this but it was marked spam so I'll just have to post multiple smaller questions. I can't seem to figure out how to do an api query where a value is blank or null, not sure how zoho stores it, whether it's blank or null as the underlying value. What's the proper way to query with criteria this way?
Record Audit search by Record ID
Is there a problem with searching the Record Audit by record ID? I tried with Firefox and Chrome and could not limit by the record ID. When searching by the email address sometimes it worked and sometimes it didn't.
Next Page