How to load a form in edit mode?
Hi I'm looking information about how to load a form in edit mode. I found this forum post https://help.zoho.com/portal/en/community/topic/load-form-in-edit-mode#2266000004613049 Sadly the resources linked there doesn't exists anymore. Can anyone explain me or redirect me to a resource where explain how to do this on the current Zoho Creator? Thanks,
File Size workaround - open question to the community?
Hello, So Zoho creator does a poor job with file uploads in general. That much is clear. But I have seen the community come up with pretty innovative solutions for all sorts of roadblocks that Zoho cannot or chooses not to handle. So this is an open question to everyone. I have hit a wall and really need your help. What workarounds (third party scripts, third party online solutions, zoho api integration, anything) have you used or seen or think might work to do the following: When a customer
link "#Form:formTest" in a view perma
Hello all, I have a page with a link like this <a href='#Form:formDummy?zc_LoadIn=dialog'>Test link</a> This works when the url page is normal (https://creator.zoho.com/xxxx/yyyy/#View:pageDummy), but when i try to use this link in a view-perma (https://creator.zoho.com/xxxx/yyyy/view-perma/pageDummy) doesn't works. Why? Any idea?
Generate permalink for not logged users via an Script
Hi I want to know what it is the algorithm for create the not logged in permalink for a form. In my application I need to notify to the users (not zoho creator users) with the link to a form with some pre-populated data. I found some guides but them only say: Go to your form and get the permalink from there. Those links doesn't change? It is reliably form me insert those links on my email template? Thanks,
Add a record and immediately get its id?
Hello, I am building a stateless form that allows the user to enter a Contact and a Payment for that contact, each of which is its own form. I create a Contact record first, then need to get the ID of the newly created record to use in the Payment record. I could always do a find using enough fields from the input that I can be confident I will always get the record I just created, e.g. name, address1, address2, email. However this seems a bit kludgy, and I'm used to working with APIs that automatically
Get data by column number
I would like to retrieve data from a table/form by column number i.e. the nth field. Does anyone know how to do this?
Uploaded resume from Creator form to Recruit
Hi, I'm running into an issue where when a candidate submits a form made in Creator, with their resume attached, the data does not get added to our candidates database in Recruit. But when the same form is submitted without the resume, the deluge task we're using works fine and the record is added. What can I do about this?
Load form in edit mode
Hi , How to reload the form in edit mode.At the time of accessing the application ,i need to load the form in edit mode.(not in on add--on load )
Search form for stage
Good morning, I need to make a loockup in Zoho CRM Zoho Creator to seek a potential with a certain stage. Is it possible?
Create a List from a String
I am building a search form to search CRM and manipulate the returned rows. I want to be able to search the CRM on one or more Account Names. I am working on the basis the user will enter a string such as "account1, account2, account3" into a field on a form and the system will return the Account Rows where the name Contains account1, account2 or account3. My plan was to use the searchrecords function but as this only allows one search criteria I have to run round it several times to cover all the
Script not adding fields, will not hold () in script.
Below is a script I am trying to use. The purpose of this script is to update an "Inventory" form's "Quantity" field. It will not give me the total of the two stated fields "currentinventory + Inventory_to_Add". When I enter the script via the GUI or free scripting method, Zoho always removes the () from the script. I am no scriptwriter by far, but isn't it supposed to keep the ()? So when i use my "Re-Stock" form, the script adds what I enter to the "Inventory" report but does not ADD them, it
SubDay Question
Greetings all... I am using the following to determine a date in a script: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(churchinfo.reminder_email_days); Where churchinfo.reminder_email_days is a collection pulled from a table where reminder_email_days is of field type numeric. When I put in specific number: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(4); It works fine, but when I use the code referencing the variable for the subDay it throws an error message.
'ADDTOPICKLIST' can be used only in on load actions - error message
Would like to be able to populate a drop down list based on value of another field. Works fine on load action, but on update get error above. if (input.Title == "Mr") { Singing_Voice:ui.add("Tenor"); Singing_Voice:ui.add("Base"); } else { Singing_Voice:ui.add("Soprano"); Singing_Voice:ui.add("Mezo-Soprano"); Singing_Voice:ui.add("Alto"); } Thanks Tim
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
Next Page