How to pass url parameter value to a form's text field
Hi, I have been searching for ages but I couldn't find it. I have a stateless form (but stores record in Customer View) After filling up the form, there is Submit and Add Record so it's redirected to another HTML form (with embedded zoho form) using this url. I succeeded on this. https://creator.zoho.com/christianjoy/sample/#View:Add_Session?CustID=789456233 My Problem: In my Session Form (inside Add_Session HTML View), i have a Customer_ID text field. How do I fetch the CustID=789456233 from the
Populating fileds
My question is how do you fetch the data from the CRM by calling the recorded Then populating the a field Eg test = Test [CRM_Lookup == "8000210000000000 "]; // do i call name or the id input.my_input_box = test.field_name_from_crm ; but get the error test.field_name_from_crm dose not exist How do I know if the lookup has made a matched ? is there a simple example to get started using the scripting as i have not found anything Thanks
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.
How to get the Record ID of Zoho CRM object from one stateless form to the other, in order to update the same record in CRM from the other form in Zoho Creator?
I am having 9 stateless forms in zoho creator. In the first form, I am creating a Lead record in Zoho CRM. From the 2nd form and so on, I want to update the same Lead record with the input values. How can I do that? Is it possible to get the Lead ID in all the forms from the 1st form?
Sub Forms
Hi, I created a form to be used as a subform. In that form I have scripts to hide/show certain fields depending on selection criteria. They work fine when I test the application. However once I use the form as a subform those scripts no longer work. Is that normal? Is there anyway around this? For example I need to create a Survey for visiting bakeries. A lot of the input is about the store itself but then we need to start recording the product range and costs etc. I had hoped to create the main
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
PDF export does not respect landscape mode using 'New PDF generation'?
Hi, I have an issue with PDF export of HTML views. As you can see from the below screenshots, the PDF output looks good with the "New PDF generation" disabled, but an extra page is added at the start of the document. With the new PDF generation enabled, the extra page is gone but the table looks cramped and unattractive. Is there a way to have the best of both worlds - no extra page, plus report looks nice? It looks like the new PDF generation does not respect landscape mode or otherwise it is not
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?
RSS Feed into MAC OSX Widget
Hello, I have a created a RSS feed widget using the program Dashcode. The widget takes the feed from my zoho application and plugs it in to nice little display of my app info. However the widget doesn't seem to be updating whenever I make a change in my zoho application. Has anyone ever done this before and had it update? I read in the help section that the rss feed could take anywhere from 5-10 minutes to update but that didn't happen. A
Adding Users
I'm still having problems adding other users. I've added the email address of the user I want to invite, but he doesn't get an invitation. Please confirm the process required to add new users. Thanks, martynhale
long forms
Hello I need help with a very long form, that i would like to split in several small forms, but still using the same recond on the table. Thanks!!
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 ] }
Displaying previously defined relationships in forms / tables
Hi, Hoping someone can help me with my problem. In my database, I have Form A & Form B. In form A, I have linked a "Name" with a "Region" that person lives in. In form B, when I use the lookup function to select the person's "Name" from form A, I want it to automatically display (on form B) the "Region" the person lives in (as previously linked in form A). Can somebody help me? Thanks, Andrew
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
URGENT :: PostUrl has been broken by a platform change as of today
In our app we rely heavily on the PostUrl function to call various third party APIs to generate emails and SMSes to clients, among other things. As of today this function has suddenly broken which is having a serious impact on our small business. This must be a platform issue as I have not changed the relevant script in our app. The format I use is as follows: the_response = postUrl(url, json, headers,false); The error generated (as of today) is: Execution Failed Error details: Error in executing
Trying to populate e-mail address from another a form and send e-mail notification to that e-mail
Hi, I have two forms. 1. "Staple Goods Project Purchase 5" 2. "SG5 Registration Form" In my "Staple Goods Project Purchase 5" form, I added a "City, State" lookup field which is attached to the respective contact e-mail address entererd in my "SG5 Registration Form". I want the "coordinator contact" field in the "Staple Goods Project Purchase 5" form to populate the respective e-mail address so the form can be submitted to that particular person's email in the notifications settings. How can I achieve this?
Get value from parent form in Add new entry form
I'm using the standard look-up fields with the "Add new entry" option enabled. However, I'd like the add new entry form to grab a value from the parent form it was opened from. Any ideas? Search across the forums and help and just can't work out how to do this. Many thanks! Greg
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
Is there a problem with Zoho servers?
Hi, we've been having intermittent problems with Creator all morning across a couple of applications. The applications are either slow to load, don't load at all or the html views are incomplete (ie only some of the forms and views in the html view will load). We are using Firefox, Opera and Chrome. We have tried logging out and logging back in again. The problem is occurring across multiple sites as well so we have established that it is not a problem with our ISP. Please can someone have a
Help with updating record in a different form.
Good Morning All, I am having a little difficulty getting something to work. I am trying to update a length across two forms. One is an inventory master and one a usage pane. After it is used I need deduct it out of the inventory master. I have tried the example of the Library which lead me to. Overall 2 Forms Tally and Material_usage. Length_field is Length of product in Tally Remainder is Material Left over and to be re-written over original length field after Material_Usage is submitted.
Form post to two tables
Is it possible to have the fields in a form post to two tables. I have a set of checkboxes come from another table. I sort of want to mimic an "other - please specify" type approach where I have the select boxes and then have say 5 text fields. If the one or more of the 5 text fields is filled in the values of those should update the main table for the form they are on but also update the table where the checkbox values are coming from. Not sure if I'm explaining that ok. Many thanks! Greg
Importing to Public Applications
Is it possible for a non-user to mass import to a form in an application that is made public? I do not see the header option available to do so.
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
Data not being updated
Hi. I have a strange problem when I'm running my app where the updates I make to a record are lost after the 'Update' button is pressed, even though I get the "Data updated successfully!" message. Here's what happens: 1. If I edit the record by choosing "Edit" from a view which shows the list of records for that form, everything works just as it should: I update some fields, click 'Update' and get the "Data updated successfully!" message. The changes I made are permanent. Excellent. 2. If I edit
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
Scripting Question
Hopefully this is a simple solution, but I'm attempting to take the information from a drop-down field to calculate the field of a single-line to help automate the entries for our techs. Basically if a tech selects Drop-down1, 1st result, I want Field2 to populate with 100. If the tech selects Drop-down1, 2nd result then Field2 should be populated with 350, etc. Thanks in advance,
Special Character (German)
When importing an .xls file zohocreator doesn't recognize special characters - I mean be special characters those that are not part of the English alphabet like German alphabet (ö,ü,ä,ß) or accents. Instead of the symbol � should appear the following letters. Is there a way to solve this problem without editing them one by one?
HIPAA Compliance - update?
Previous posts indicate Zoho was developing a HIPAA compliant service. Any news on that front?
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
Nonprofit newbie needs creation help
Need to quickly computerize call records/resources for our new, very low-budget crisis helpline. Am trying to do it in the free version of Zoho. No problem creating the call intake form for our volunteers, but can't figure out how to create/link our resource sheets -- similar to how the appear in the Emergency Resources links at: ChristChurchLink.com (I can simplify the tables to only 5 columns) Would love to have a form for each resource page - ideally so that the volunteers can check off
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;
upgrading formula if result value is too small
I have a formula in my calculation form that caculates price from certain measurements and displays the result. (dit_x / 100 * dit_Y / 100 * dit_q * dit_pricem2).round(2) I would need to upgrade it conditionally in a way, that if the result is less then 2 it would display number 2 in the field (which is the minimum we charge). Is this possible, how? Thank you.
Scheduler and getUrl
I put the following in a scheduler: HTML = getUrl("http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_Stockholm.html?mod=topnav_2_3002_europe") ; where can I view the data?
Next Page