report filter criteria based on secondary related view
Hi, I have created 2 forms , which are linked via a lookup. Is it possible to create a view/report that will just show records that are in the first form, that have no link in the second form ie in database terms Select d.* from details d left outer join subscriptions s on d.id=s.membership_id where s.membership_id is null Thanks
Need same functionality as the Zoho CRM field (relationship to CRM data)
I want to duplicate the logic and functionality of a look up like the CRM look up field uses. The related Look Up field has drop down but when there are lots of records, that does not work. Have table of records that need to be related from the parent form. Only one record needs to be selected and shown on the parent form. I've tried subforms but can't get it right since the subform is only for the selection not the display in the way it is used for the CRM data relationships Can anyone point
Remove duplicates from a list?
I have a list variable with hundreds of phone numbers. There are duplicate numbers in that list though. How do I remove the duplicates from the list? Thanks.
Custom user roles
Hi, Is there a way to provide more customization for user roles? I believe I need something beyond page level permissions and user/designer roles. For example, I have a group of 6 people: -I want NONE of them to have designer capabilities. So, 6 "users". -I want ALL of them to be able to see all the same forms/tables. -However, I only want TWO of them to be able to edit records in the table. (to update information as we receive it) Any help?
Refresh CRM lookup fields?
I have a form that has multiple CRM Product lookup fields, below those fields are Quantity fields. Anyway I got it to work that when you choose multiple products and quantities it auto calculates the total in real time. So that works, it is great. (All 10 CRM Product lookup fields on the form have this script on user input. It works fine.) crmResp = zoho.crm.getRecordById("Products", input.Sample1_ID); input.Sample1Cost = ((crmResp.get("Cost (L)")).toDecimal() * input.Qty1); input.CostTotal = (input.Shipping_Cost
Federated Login with more services
Hello. I am working on connecting WordPress and Zoho Creator. One of my headaches was how to sync users' data between them. Fundamentally, if Zoho Creator accepts more services for Federated Login, that would open a gate wider to accept more users. Is there any plan to add more, such as AOL, Windows Live, etc? It seems to be getting popular to user FID. Even WordPress has a couple of plugins to accept 20+ services. http://wordpress.org/plugins/oa-social-login/ http://wordpress.org/plugins/loginradius-for-wordpress/
XML Documentation has missing information - 'Page not Found'
Whilst the discussion forums are a great source of knowledge, many of us rely on the on-line documentation. The documentation I require is relating to XPATH and loading XML into ZOHO, but vital images are missing. The page in question is : https://www.zoho.com/creator/help/script/execute-xml.html I count 6 images 'not available' which is like trying to follow a recipe with pages missing from the book....! An example of one missing image : https://www.zoho.com/creator/help/images/xml-execute-ui.JPG
Using lookup fields in "Display as" for lookups
Hello, Do you plan to make availiable to use lookup fields in Display as for lookups fields?
Subform code disappearing
Over the last few weeks, I've noticed that Field Action code has been disappearing for subform. The latest example is Application: https://creator.zoho.com/essistmgmt/form/1713/scriptbuilder/ Subform: INITIAL_SERVICE_AGREEMENT Field: SITE_ID Note, the application is shared for support editing I've previously added code but it has disappeared. Not only has the subform field actions disappeared but the version history disappeared too. Can you please investigate? I keep having to put the code back in.
Subform code not generating properly
Subform code does not appear to be generating properly when I try and edit the code. Form https://creator.zoho.com/essistmgmt/form/1713/scriptbuilder/# Subform: INITIAL_SERVICES_AGREEMENT Note, the green circle is active for PRODUCT_SERVICE_ID field but when I try and view the code, the code editor is blank. The behaviour is inconsistent since some fields show code and others don't. Other fields that show a green circle but display empty code are MANUFACTURER_ID, SUB_SELL_MRC, SUB_SELL_NRC, etc Although
Disable Zoho form buttons in creator
I want to use multiple ZOHO Forms on ZOHO Page. But I want only one SUBMIT button for whole ZOHO Page. How is it possible?
Unable to create a function using the Builder
I'm not able to create a function using the builder. When I try, I get an error message. See this http://screencast.com/t/PJMeI2e0Zl Thanks Alex
Setting the value of a Lookup field in Deluge
I have imported two spreadsheets into two forms (Organizations and Contacts) to get some data into my application. The Contacts spreadsheet (and form) contains a field with the name of the organization to which the contact belongs. In the Contacts form I also have a lookup field for the organization name, and now I need to go through every contact to look up the organization in the Organizations form in order to populate that field. I've tried to automate this in Deluge but I don't know how to set
Email Subform Sum on Success
I have created a simple application to bulk register youth for an event. The Adult leader fills in their info in the Parent Form, the parent form data is copied into each subform entry where the adult lists each youth that is attending by adding a new row for each. I need to produce a Success email to that adult leader that has a total cost reminder. Basically multiplying the number of rows submitted by $140. I have created a hidden field for each youth that pre-populates with 140 - so I would
issue in inserting the quotes
the xml date is like below $xmlData = '<Quotes> <row no="1"> <FL val="Room Design">http://creatorexport.zoho.com/DownloadFile.do?filepath=/1355684768006_Classroom.jpg&sharedBy=somebody&appLinkName=applinknam-lab&viewLinkName=room_templates_View</FL> here in the value i am getting the following error string '<response><error><code>4600</code><message>Unable to process your request. Please verify if the name and value is appropriate for the "xmlData" parameter.</message></error></response> ' (length=184)
replaceAll empty string
I am using the replaceAll inbuilt function and noticed I was getting errors when I put in empty strings. Should the function return null and accept null values?
Restore a database from yesterday
OK, so I knew not to mess with live data, and I thought I backed it up by copying the form, but that didn't copy the data. So when I editted the name fields in a radio button list, all of the data that was the original name is now blank. Armitage was editted to 2: Armitage, so now all of the records that had Armitage in that field are blank Not sure if it is hidden or lost, but guessing the data is lost. So the question now becomes is my data backed up anywhere. I did not make a proper back up,
Columns missing in Pivot Chart/Table
Hi, I created a pivot chart using my one of my form/table but only few columns are available at the left side. I also tried using different form and it works fine. All columns are available.
Uploaded Images in HTML Views
I would like to display uploaded images on my HTML views. I followed the instructions on the following page to no avail. https://kbase.creator.zoho.com/general/i-have-uploaded-images-to-my-form-using-the-upload-field-type-how-can-i-refer-this-image-in-my-html-view Is this problem possibly due to my application being "Private"? If so is there a way to use a "key" within the url to allow access? Here is the generic html code: rec = Form [Image_Name = input.ImageName]; <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=rec.FileUpload%>&sharedBy=userName&appLinkName=app1&viewLinkName=view1'>
Basic question about using values from Lookup fields
I've managed to get quite a way with Zoho but keep tripping up over some basic functionality - and I can't find any reference to it in the user manual. In a Task form, I create a lookup field (ProjectName) to the Project Name in a Projects form. I discovered that in Deluge script in the Task form, input.ProjectName returns a BIGINT, rather than the actual Project Name. So my question is... how can I convert input.ProjectName into the string of the Project Name that it refers to? Thanks for you
Error Passing Form Objects
Hi, I'm getting an error any time I try and pass a form object. Take a look at this simple example and the errors I am receiving. Report Function void report(Employee employee) { }Test Function void test() { for each emp in Employee { //NO ERROR: thisapp.report(); //ERROR: Error at line number : 8 Number of arguments mismatches thisapp.report(emp); //ERROR: Error at line number : 10 Number of arguments mismatches thisapp.report(emp.ID);
Problem sending automatic emails
HI! in one app i built, i use an auto-send-email function, which sends a message to an address belonging to a person who is assigned a task (i.e., "To: input.assigned_to"). it works perfectly well. in another app i tried to apply the same function, but the Creator seems to add ".toString()" at the end of the code ("To: input.assigned_to.toString"), thus causing the code to fail sending the email. no matter that i delete this addition and save it to the code - when i re-access the app, the change
Script function editor: show full function name
I create custom functions and starting to get annoyed by the function names being cut off, see screenshot below. My suggestion would be to show the full function name. I don't mind if the name wraps around as long as it is not cut off.
field-level view&edit access in creator app?
hi there is about 10 fields in app and 1 manager and 1 supervisor who works with app how make view (access for viewing&editing): only fields 1,2,3,4,5 - for manager all 10 fields - for supervisor ?
One entry per drawing number
Hello, My problem is kind of like a "no duplicate entries" option but it needs to be a bit more complex and I am hoping someone can help me out. I have a form called Operation and there are two look-up fields; 1 is called Customers the other is called Drawing no. The user selects a Customer and then a drawing number [which is filtered by the Customer selected] then the user enters in the operation number which is a number valve. My question is how do I make sure that the user can't duplicate an operation
Collection variables and formula fields...
Thank you for your help. I am trying to use a collection variable to bring field values form one form to another - one them is a formula value. I have been able figure out the collection variable (I think) Some values (publication) will come over but not the formula value (insertion cost). Here is the script written: PropPub1 = LUX_Enrollment [Street_Address == input.Prop1]; if (input.Prop1 == PropPub1.Street_Address) { if (PropPub1.Pub1 == "") { PropPub1.Pub1 = input.PubNameLPC;
Exporting data from reports to a Letter template
Hi, I'm looking for a way to export data from my reports such as <First_name> and <Last_name> in order to create a personal printed letter that I can then post. Thanks
Page boarders using permalink
Is their any code that can be added to the permalink to set margins. I'm working on a form that will be accessed through smartphone 99% of the time and it looks like the left/top margin is around 6 - 8 px. Not only is screen space important it also leaves the form looking of center as the right margin is about half that of the left.
Form security breach
I created a form SITE_ADDRESS and have not shared it yet. I have a SITE form that lets users pick a SITE_ADDRESS with an option to add a new site address if it does not exist. However, users are able to add new site addresses even though I have not shared the SITE_ADDRESS form yet. Why is the form not being restricted? How come users can see the "Add new site address" link even if they do not have privileges. I am hoping to restrict the form to a specific group but it appears anyone who can access
The lookup field type is long() , not String() ?
Please check.
Forms or views embedded within html views are not shown
Hi, I had created some html views with embedded forms and views. They worked fine until i used the old app builder.Now they are not shown when i am using the new app builder. I think it might be bcoz of the new app builder or bcoz of some update or fix. Please update about it this issue. Abhishek
View attachment in subform
Hi, I have encountered a problem when using Subform. I created a Subform that allow user to attach any number of file attachment. For example, if the user want to attach only 1 file, he just need to add 1 row and attach the file; if he want to attach 3 files, he need to add 3 rows etc.. Now the problem is: after the user attached the files in the subform and submit successfully. When the admin is checking the record in a list (or summary) view; the admin can only see the name of the attached files,
Scripting "On user input" for Subforms and a Bug
My subform contains a dropdown field. I want a textbox in the subform's same row to display a value depending on what the user selects in the dropdown. Clearly the "on add row" is not where to put this code. So I selected "configure filed actions" from the form builder: And it loads a page that is totally not editable. If I hit the "free-flow scripting" button, nothing happens. I did note the url for this strange page is: creator.zoho.com/appbuilder/sigroup/lab-audit/form/Audit_Form/Audit_Findings/workflow/edit#OnUserInput
Invalid entries found. Please correct and submit again
I am getting this error on specific entries only Please take a look at the application and let me know what to do! For "Owner to Trade With" when Mitch is selected, Martin Prado causes the error message https://creator.zoho.com/wetalkfs/trade-machine
Code Editor downgrade?
Is it possible to downgrade the latest upgrade in the Code Editor via some user preference? All of this gradient, fading, animation, ghost text is very difficult to work with. I like the color coding and the line numbers. But I think Zoho went way too far with the eye candy animation. Tony.
Catch error thrown by built in functions
Hi, I would like to know if there is any method to catch or find if there is any error thrown during the deluge script execution and handle the same? Basically I am looking for something like a try-catch block. Any alternative will be appreciated. Scenario: Parsing input text into date time format using toTime() function
Regular expression - return expression
I want to extract the street number from a street address. I know that zoho supports using regular expressions to match and replacing strings. Can zoho support extracting strings and returning them?
Code Suggestion to Get Date for Previous Thursday
Greetings all... Any quick code suggestions for calculating the correct date for the previous Thursday from a certain date.... Ex: The date given is Tuesday, August 20, 2013. What is the date of the previous Thursday? I know there has to be some use of the varied date functions here but I can't seem to get my mind around the correct logic. Thanks, Joel
Regex for a Date Time Expression
Hi, Can anyone help me or has anyone in the past worked out an expression that could match the following date time string: dd-MMM-yyyy HH:mm:ss i.e. "12-Mar-2013 13:52:30" Thank you, Guy
Modify radio button field names
I have a DB with 1000 entries. I just tried to modify one of the selectable field names. There was a radio button list of say Apple Banana Grape That I modified to 1 - Apple 2 - Banana 3 - Grape Now the fruit column in my table is blank. Is that data gone, or listed incorrectly or what. Any help would be greatly appreciated! I think I am in trouble.
Next Page