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?
Rich Text Data by Email
Sending a rich text email from GMail to a Creator form results in plain text data being transferred. However, if you send the email from a Creator form using the rich text editor field to another Creator form, the rich text data is transferred! I have identified that this discrepancy is due to how Creator sends an email. In most "normal" emails, there are two MIME blocks, one for plain text and one for rich text. For example, the parts will be separated and designed by this: Content-Type: text/plain;
Print customised view or form
Dear Sir I am using Zoho to keep data of enquiry, quotation, purchase order etc but I wonder how can I make up my own layout and can pull whatever data I want on a single A4? For example, how can I print the data with my own template where I can choose to pull which data I want to print out with my own letter head?? So I can print Quotation Form to my customer or Purchase Order to my supplier?? Please kindly advice Boyd
reports not updating
It seems like, more often than not, my reports are not being generated correctly. I have to always go back and regenerate the report. Is there a way to do the regeneration via a deluge scripting preferrably in in the schedule environment. IE. when a schedule is invoked it will do a "regenerate" then it will send email.
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
On submission, can the form go back to the previous website?
Here is our website... www.newlifeinfo.com After someone fills out the forms we have online and clicks "submit", how do we code the "submit" button to make the form go back to the originating website? Right now when you hit submit, the form just restarts again with a confirmation message at the bottom. To go back to the website you found the form on, you have to click back a few times and we would prefer it to just automatically adjust back to the page before it rather than clearing the data and
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
Select Records valid for a Date
Hi, We have a form which has fields such as From_Date, To_Date plus few more. This form serves as master data which is used by other forms & application. To get the required information for a specific record from master form for any given date i.e. we would like to search for a record in master table for a date which should fall in between from & to date fields. We have tried fetch record command ( Xdate >= from_date && Xdate<= To_date) but it returns a null. The data in master is like We would
Help with script please
Hi. In a form I am working on i have the following requirement. One of the fields in the form is Date Another field is Post_Code Another is Map Now lets say I have 6 records that have say 6/4/2013 Google maps uses the format https://maps.google.com/maps?q=from:sl45sf:to:da81hg:to:me103de Now what I am trying to do is when ever I make a change to the Date field doesn't matter if I am creating a record or amending one I want the map field for each record with the same date to recreate the same entry.
Not able to set criteria
When I try to set the criteria I receive the following message: "Exception ocurred while publishing message to the topic :: [DataModelTopic]" it was working ok and suddenly it didn't let me do it.
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
Adding numerical values to drop down options in conditional statements
I am making a custom form through the dynamic content that deals with buying items through paypal etc. I'm trying to make it so that I can add in financial aid meaning a discount is given and the amount of discount depends on the option they select from the drop down. Currently, when I submit the formula, it does not give me an error message, but instead, erases my IF ELSE statements with no notification. I have net amount on the bottom as an amount the form calculates based on the price of the item
Can't Copy the Application
Hi All, Need help with high priority I have an application which i can't make a back up (Copy or Duplicate). kmkr :)
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
Upload image from my own website and own form
How can I use my own and external form in order to upload an image to my Creator database? At this moment I'm able to upload text fields, for example the image name, but I can not find the way to upload the image file itself. Can you help me with this issue? I hope you can understand me because my English is not so good as I would like. Thank you very much in advance.
Next Page