How can I access a particular field of a record of a List type subform, in the main form using deluge?
Need to access a field of a record added in a List type subform, in the "Action on click" of the main form.
CRM Integration Tasks
How do you map a recurring crm event / task? Do you set the default key "Recurring Activity" to "true" (boolean) since it is a decision box field? And what about the other recurring info needed: "Start Date", "End Date", "Repeat type", "Repeat for <field> weeks", "Monday" "Tuesday", etc (checkboxes)? Thanks Kevin
DB Relationship Chart
I'm enjoying the Zoho Creator experience so far. Being an old MS Access guy, one of the things that I miss is the ability to view and print a relationship chart. The application that I'm building is eventually going to be pretty complicated and being able to use a visual aid like that would certainly help. Any thoughts on something like this?
Overcoming max # of fields on a form...
I need to create a form/set of forms to handle the collection of over 300 fields of information for a Credit application. In reading, it looks like there is a limit of 80 fields on a form, or less if you're using drop down lists. How can I overcome this? I can break the questions into groups, and put each on a different form, but I understand that each form creates it's own file/table. And I need all information to be in one record, at least ideally. Any suggestions would be appreciated.
How do I script to do something for each week between dates?
And where can I find documentation on loops? I have something like this Start_Date End_Date I need a loop like this for every week between Start_Date and End_Date { do stuff for week [ i ] ... } is there something built in? But also if I can extract n, like this n = End_Date.getWeekOfYear() - Start_Date.getWeekOfYear() and do a loop like this (I'll give it c++ style) for (int i=0; i< n; i++) { do stuff for week[ i ] }
How to adjust the page margin when printing an html view?
When I print an html view, there is a 3/4 inch left margin. How can I override this so that my data prints with only a 1/4 inch margin? I have not been able to find a way to modify the default css, although I have seen reference to an "external css" capability. Can anyone point me in the right direction? ~Steve
Calling a view or form in a Function
So I have a view that I have setup and a custom action that calls a function and works (function is just some simple test code) What I need to be able to do is two things: 1. I need the syntax for calling a view from the Function 2. I need the syntax for calling a form from the function. Help
How to convert javascript to deluge script
Hi, How to convert javascript to deluge script. Eg Code : <div id="vm"></div> <script type="text/javascript" src="https://www.swarminteractive.com/js/vm.js" ></script> <script type="text/javascript">client="4740"; width=580; secure=true; vm_open();</script> Please help me out of this.
Re use Formula field
Hi Can I add bellow code to Formula field? r = formkhzl[xsdm == input.xsdm]; openUrl("https://creator.baihui.com/lg8888b/jk/formkhzl/record-edit/view17/" + r.ID + "/","Popup window","height=600,width=600"); Thanks Stanley Guo
Platform update may have effected dates?
An application that was working perfectly for months stopped working today around 9:30 am NY time. At this same time, the app started to experience a very long duration upon submit actions. After spending hours diagnosing things (the logs did not show any errors), I decided to remove this bit of code (submit action) if((input.DELIVERY == zoho.currentdate) && (input.REMINDER == null)) { // some code that sends an email } to //some code that sends an email and observed two things: 1) The code
General Creator Question
Working on my first Creator project. I have a credit application I want to add to a Lead record in CRM. There's too many fields to just add these to the Leads file. So, I think the best solution is to use creator. But I'm concerned that even in creator, there are too many fields to have on a single form, so I want to divide up the questions into logical groups and then be able to navigate between these groups easily to collect the required data from an application. But it look each form and view
if you do a lot of deluge script
... is there a better app to code with? I hate the scripting editor. Is there something for mac?
tooltips do not like "
Tooltips are getting truncated if there is a " character. Are there other characters that should not be used in a a tooltip? If you put he following in a tooltip it will truncated after the a This is a "tooltip" Herb Wexler
using checkboxes in script
In my form I have checkboxes for days, Sunday through Saturday, field name is Days I'm trying to check if day was selected then do something for that day ... lets say set day to number of the week it is, as I try to do here. for each selectedValue in input.Days { if (selectedValue == "Sunday") { day = 1; } if (selectedValue == "Monday") { day = 2; } // ... Tuesday ... Wednesday ... Thursday .... Friday ... Saturday ... alert
Implementation of right join within Zoho Creator
I need to implement the equivalent of a right join in a View in Creator and then display with grouping. Here is an example. Imagine two tables, Supervisor and Employee. Each has a primary key and a Name. There is a one to many relationship such that an employee may have only one supervisor, but a supervisor may have many employees. This is implemented in forms in Creator my adding a lookup table in the Employee form in order to choose the Supervisor. Now imagine that some Supervisors have no
referencing a multiply linked field in Deluge script - how many link levels can I go?
I am working in a stateless form. I am trying to reference a field that has been linked through regular forms via 'lookup fields'. This is what I have done and I believe I got this code from an earlier inquiry of public example app: Here is only an example to illustrate what I want to do. The user enters a unique customer ID (not the record ID) in a stateless form field. And suppose the customer has earlier selected one Product in a lookup table on the Customer form. And there is a Product
Merging rows of multiple data - similar to mail merge Help :)
I want to create a form that resembles a 14 labels per page form, I will print on to labels paper. I have the following script which only produces a page of the same data(address) I cannot find a Next record command or similar to add to next block of data - what do I need to add/do htmlpage dALEMAILHTML() print = true content <%{ fetch = Prospects [Email.contains("@")];%> <div class="WordSection1"> <table class="MsoTableGrid" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none;mso-padding-top-alt:0cm;
Anyone else having problems with saving scripts tonight?
Steps to recreate: 1. Views > Select a view to modify 2. More Actions > View Definition > Save Script Green message area just spins saying "Updating script..." -Jeff
Date list variable returning as a string
I have created a date list and I am trying to use the dates stored in the list to fetch records from a form. I use "for each element" and create an Instance variable called tempDate. I then try to use tempDate in "fetch records" but it shows that tempDate is now a string variable. How can I pull records that match the dates stored in my list? Thanks, Walter
Referencing a record with a lookup field
Hi Everyone.. I have been getting a lot of great feedback from the forums and its been a good response time so I thought id put this issue forwards, maybe its a limitation or maybe i'm just doing something wrong; okay so the following is my setup Regions Form Region - Single line for each region (Europe, ME, Africa) Customers Form Customer Name - Single Line Region - Lookup field for Region in Regions (Works Fine) Project Form Has Lookup Field for Customers Customer Name (Works Fine) Region - Lookup
Really struggling to set up a domain account in Creator
Hi Team I am really struggling to set up a domain account in creator. I have edited the CNAME field with my domain provider to the value requested and have left it for several days but verification still returns the error message "CNAME Verification failed for the domain itmooti.com.au". My domain provider is www.crazydomains.com.au - do I need to contact them? My domain is www.itmooti.com.au I have sent several emails to support but am not having much luck with responses. I am desperate to get this
Simple Excel formulas
Hi, I have uploaded my excel file into creating and it created a form to add new data automatically. However, it didn't import the formulas as well. For example, Number of items: 5 Price :10$ Total Amount:50$ I got the total amount result automatically in excel however, I couldn't get it in the creator. How can i use the simple math formulas in the creator? I couldn't find a satisfied documents which are giving brief information about these issues. By the way, I extremely suggest a guide which is
what makes fields unique in a form?
I am adding records, by using script in FormX On Add/On Success script block I am duplicating records of FormX but modifying a few fields weeklist = {0, 1, 2, 3, 4}; for each week in weeklist { var = insert into FormX [ EmployeeID = input.EmployeeID someField = input.SomeField +1 ]; } New records are not created and I get the error "Some of the fields are unique" I did not intentionally make any fields unique. I don't understand why I am getting this error
Formula Field not Updating with Large Data Sets
Hi, I have a data set that is about 2300 entries. I have added a simple formula field to this form. Unfortunately the formula field does not update for any of the entries. The same formula field works fine with smaller data sets. How do I get around this? Thanks! Mike
Pull Multiple Fields from One Form to New Form based on Lookup Field Selection
I have two forms - an Event form and a Volunteer form Event form has Event Name, and includes Coordinator Email Address . My Volunteer form has lookup to Event form. I want to create a field so when the Event is selected I also pull in the Coordinator Email Address so I can send an email notification to the Coordinator when a volunteer signs up What is the best way to do that?
Can I enable real time column Filtering in Views for Related Fields
Filtering the data in Zoho Views is a convenient feature to allow the user in Acess mode to customize the display. I have just recently added some Related Fields to Views, which allows one to view related data in a 'lookup' field. However when I choose 'Set Filters', I see no options to enable filters on the related fields and in access mode, there are no filters for the related fields. Is there any way to enable filters on Related Fields? DJ
Grouped items get broken up for no apparent reason
I have a problem with a view https://creator.zoho.com/ecgnet/ecg-work-programs/#View:Sector_Thematic_Evaluations I am displaying items by group (specifically, Sector/Thematic Subclass as designated in my database). I am not sorting the items by any other means. As you can see, some items that should be under one subclass (in the screenshot, it is Climate Change) are listed apart. Another group, Climate Change, Social Development, cuts into the list. Am I doing something wrong or is this a bug? Thank
Captcha not working?
I have gone through the Captcha help files and successfully added the function to my bespoke web lead form but whilst testing if I enter the wrong code in the Captcha field it still allows me to complete the form request. Can someone help as we are having a large amount of spam currently?
Style based URLs Embedded forms
Hi, parameters looks to be omitted in certain cases of embed forms : for example, in a HTML view, we embed a form with : <div elName='zc-component' formLinkName='FormName' params='zc_Header=false&zc_LblFontSize=18'>Loading...</div> The parameter in bold works correctly, but is omitted when we use the permalink of this HTML view (zc_Header=false is ok but not zc_LblFontSize - not tested with other customization parameters). There's no problem when we use Iframe instead of div. That's minor but good
Maintaining Links when exporting html to pdf
Hi, 1. Is it possible to maintain the <a href="link"> when a html page is exported to a pdf? 2. Does anyone know of a solution using creator/zoho to create a report/document in html and then turn it into a pdf with links. I would like to have thumbnail images that link to larger files if the user wishes. I realise that the application has to be public if I want to be able to export the images. 3. Is it possible to export a html page to pdf and then attach it to an email? Thanks,
Script Won't Save?
Hi, I came across this issue multiple times, and it is starting to get really frustrating. Basically, my script will not save. No error message shows up, it just keeps saying "Updating Script", but it never actually updates or saves. It happens when I am using a conditional statements where I use "&&" to add another condition. For example, this script will not save. //Alert Box that shows a pop up message if the user tries to select a bike that is already online x = Bike_Listings_Current[Bike_Serial
Basic Budget Application
I am trying to create a very simple budget application. When I submit a purchase in my Add_Purchase form, I want to send the Cost of that purchase to a form that tracks the Expense Account. In the Expense Account form I already have the budgeted amount for the year and I have a remaining balance formula field that will take the Budgeted_Amount and subtract the Amount_Spent from it. However, I cannot get the purchases once submitted, to shoot that Cost over to add into the Amount_Spent. Instead,
Twitter content
Dears, I'm using "html view" in Zoho Creator in order to show some content on my website. I have 2 questions: 1) How can I show the latest twitts sent to my Twitter account on the "html view"? 2) Can I add the latest twitts to my database as new records? Can you provide some code examples or scripts in order to do these tasks? Thank you very much in advance.
Monthly "snapshot" of data
I've built a PPM (project portfolio management) tool that tracks pending projects, active projects, complete projects, etc. Naturally, I always have a live view of how many total projects are pending, active, when they were last updated or other data. However, I'd also like to take a monthly "snapshot" of some data to show trends over time. Can anyone help me with the best way to approach this? Would I need to create a new form that captures the current state of data using the Scheduler? Is this
Best way to launch a Stateless Form from a View
I want to display a set of records in a view and have a custom button on each row that will allow the user to choose the record, then open (in the same or new window haven't decided yet) a stateless form for that record. I will have it display the entire record, but also expose about 5 buttons that will do more complex stateless database functions and send emails, etc based on the button push related to that one record in the stateless form. I have not seen any particular info on this in the Deluge
On edit script issue
Hi there, I'm recently getting an error that has not happened before. When I edit an existing entry and try to add a new Subform row, I get something along the lines of: " Error in executing On Add Row script of XXXX. Error. Error in executing Set Variable task. Unable to update variable XXX. Error evaluating NUMERIC expression: ... " Adding new entries does not produce this error. I suspect this might have to do with a recent update since
Google Calendar API
I am trying to learn how to use the Google Calendar API to add an event created by Zoho Creator form to a Google Calendar. I have a main calendar set up in Google with subcalendars. I would like to be able to add an event to the specific Google sub-calendar when the form is submitted in Creator. I am currently using the Creator Calendar Feeds which work great, but I am not happy with the lag (calendar is not updated immediately). I have seen this post: https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html
My Zoho attempt
Hello Zoho community, I'm new to Zoho, but certainly not new programming. Unfortunately, I have a hard time figuring out how Zoho could be used for creating any kind of application given the limitations I have seen so far in the level of flexibility of how views and forms can be mixed and the fact formulas don't update themselves as they should when lookup fields are involved, thus creating a large need for (OnInput) code, which is a far cry from the promise of drag and drop design, and requires
Deluge Script - Atomic test & set operation with concurrent users
Hello, I have an application which will be used by several users simultaneously. Each user can edit the same data e.g. same record may be removed, updated, etc. Is there some method to address the problem (i.e. race-condition)? Are there any atomic methods that provide "test&set" funcionality?
Feeding a date to a Custom Action function
From a view I need to modify several records at a time based on a date. I want the user to check the records in the view and then call a custom action that asks for the date and then performs an action on each of the checked records. I am feeding the checked records to the function as a form object. What is the best method of getting the date for the function? Herb Wexler
Next Page