from subform entry - link to mainform
hi! there is mainform (contacts) and subform (purchases) one contact has many purchases - in one mainform's entry there are many entries inside subform after adding entry to subform - we can view such entries in subform's report how from subform entry can view to which contact they correspond? example 1) open subform entry 2) click on link inside this entry 3) opens corresponding mainform's entry
how to add entry to subform (via CSV) and associate this entry with mainform?
hi! there is mainform with subform how to add entry to subform via import (CSV) and automatically associate this entry with mainform's entry ?
Auto-increment
Hi, I would like to assign a unique Alpha numerical value to each record. The "Alpha" would be the first letter of a field in the form. The Numerical will be increment + 1 Thanks for helping me out! Brian
Lookup with multiple fields
Is it possible to create a lookup that displays more than one field of information, For example if I had a table of jobs with a lookup to select a client, could the lookup display more than one field from the client table such as client_no, name, postcode. Thanks.
What is the fastest way to delete 17,000 records?
Deleting 17,000 records in groups of 200 is not working. Is there a faster way?
About Rebranding Again
Good afternoon. My question is: Is there any way to hide alerts, marketing messages , invitations to seminars etc. on applications made with ZOHO creator . I am a freelance programmer I'm starting to work with ZOHO seriously , I upgraded my account to enterprise , and I would like to offer my work without customers know what my methodology and what my economic gains , since it could easily deduce at your price list. Is there an alternative to further consider ZOHO creator as my work tool ? I have
Powershell REST API
Hi! I'm using Powershell to do REST operations with various online services, such as Dropbox etc and it works fine. Now I'm trying Zoho Creator but with no success. Does anybody have a general Powershell script that would for listing applications and return the result in json format? Preferably I would simply replace the token-code with mine to get the concept. Any input would be appreciated. I have looked at all the examples available and tested for several hours but I've run into a dead end...
Function to create multiple tests
Can I create multiple choice tests by using Zoho Creator or any Zoho utility? If yes, what modules can I use? Can you please give me detailed instructions? Thank you very much!
Confirm before deletion in subform
I just clicked the "X" in a subform row by mistake. Is it possible to ask "Really?" before it vanishes forever?
Sum of formulas (within subform)
Hi, I have a timesheet subform, with an "Hours worked" field, an "Overtime" field and a "Total" formula field that combines the two values. In the main form, I want to include a grand total field that would be the sum of the "Total" formula for each row. I've achieved this with "Hours worked" only, but not the sum of "Hours worked" and "Overtime". input.Total_Amount = input.Total_Amount + row.Hours_Worked; That works. (in Main Form>Subform>Hours_Worked>On User Input) input.Total_Amount = input.Total_Amount
Updating a lookup field issue
Hi All, I have a subform that has a single select lookup that needs to be replaced with a multiple select lookup. Both lookups exist now in the form and access the same source "Add_Labels > Labels_Description". Before deleting the single select lookup field, I need to copy the single select data to the multi-select lookup field so I've created a temporay form and script to process make this change - and this is where I'm stuck. I appreciate that the mult-select lookup requires the record ID so I've
Update Subform with field from Parent Form
I am looking for deluge script to update multiple subform entries with the date of the parent form. The purpose of this is to allow me to run more detailed pivot reports with the subform data.
Schedule export of data
Hello - Is there a way to schedule the export of the data from a Zoho Creator application to an external server? Thanks Anil
How do you get the value of a lookup field instead of the record number
I using the value of a lookup field on a form in another formula on the same form and instead of the value being placed in the formula, the record number is placed there. The formula ---- input.Competitor + " - " + input.Media_Channel + " - " + input.Offer Competitor is a look up field on this form from another form/table. When this formula runs, I get the following result 3444267000000037515 - House File - 20% Off All Men's Wear I get the record #, not the value in the field. How do i fix this?
custom PDF name from Record Summary
Hello everyone, following this forum i tried to use a custom action in order to download pdf from a record summary with a customized name (for example the number of an invoice or something else) i've found this function and i've adapted it to my needs void scaricaPdf.scaricaPdf(Nuova_Fattura Numero_Fattura) { openUrl("https://creatorexport.zoho.com" + zoho.appuri + "record-pdf/Elenco_Fatture_Estero/" + Numero_Fattura.ID+ "/customName", "new window"); } everything was compiled correctly but when i
Invalid entries found Please correct and submit again.
Hi, Trying to add the first record to my first form...and got this "Invalid entries found Please correct and submit again." error. All mandatory fields are filled. Don't understand whats going on. Any help would be greatly appreciated. Thanks Cyrille
enter text on summary report with images
I would like to develop your classic shopping cart experience... on the right side of the screen an iframe with report of all available inventory with pictures, an input for the qty and a custom action to "add to cart" on the right of the screen an iframe with the contents of your shopping cart. But Zoho does not allow me to have the user enter a number in the qty field on the left report. How do I work around this.... any ideas?
Emailed link to record in report now broken as of last week
I have been using a scheduled script to email me a link to a report that will show one record. Example the script looks like this: linkToReport = ((((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/html/reportName/") + reportSearchTerms) + "&showHTMLOnly=false"; it creates a link that looks like this: https://creator.zoho.com/zoho_user/zoho_appname/html/reportName/&ID=1986294000004712003&showHTMLOnly=false As of last week the link now pulls up "https://www.zoho.com/creator/"
use one lookup to reduce the records in another lookup
I have created a function and form to copy a few fields from one record and paste in another record. I select the record to be copied using a button on the report which also calls a form where the record to past to can be selected. The problem is the list of records to select from when choosing where to paste is 4000 records long. This makes it difficult to find the record to paste to. I want to reduce the selection by using another field that is linked to the selection or in other words I want
Getting extra Blank page on printing customised record summary
i am getting this problem on all browsers ,so its likely to be an issue with zoho creator itself. Whenever i make a new record summary in a report, It prints with one extra page (even if the data remains on a single page, the extra page just remains blank ). i have tried to create a blank summary still it prints 2 pages. My default paper size set in the printer is A6. If however I Keep the default template for the record summary the printout is limited to just one page. I am stuck on this.
Center a form
Hi, That's maybe a silly question but is there a way to center a form (without embedding it in a Page) ? Thanks!
On a form, value of a field depends on the selection of a data in a drop down list
In a form "Session Location" I have a single line field "Location Name" and a multi line field "Location Address". Each location has a unique address. This form allows me to record an address for any specific location. In another form "Sessions" I have a drop down list to select the location name and a multi line field to display the corresponding address. When I select a location in the drop down list, I want the muli line field to display the corresponding address. How can I do it? Thank you for
Can you show/hide edit record fields based on which report calls the edit record?
Is there a way to detect which report the Edit record command came from, and use it in the Form Actions - On Edit - On Load to show/hide specific fields?
Populate Multi selection Look up field
Hi, Is it possible to populate a multi select lookup field in a form? Main form: has a date field and a Orders multi select lookup field Here is the behavior i want: 1) User selects a date. 2) On User Input, the script populates the Orders multi select lookup field based on the date selected. input.Orders.add(orderID) doesn't seem to do anything.
splitting records in report equally to no. of users
Hi, I want to assign the no. of records in a report to the number users after the equal division of the records. say, I have 500 records in a report i want to assign it to the 4 users. so I will do the division of 500/4. When the no. of records divisible by no. of users (i.e.) when remainder is 0, then the code is working for me. But when it is not divisible (i.e.) remainder > 0 then my code not working. the remainder no. of records is missing for me during assignment to the users. Please help me
Error when trying to get CRM records using deluge script
Hi, Pardon me if this is naive but I'm new to zoho. I'm trying to get all accounts from the crm records. When trying to call: zoho.crm.getRecords("Accounts"); The Object returned is: {"4813":"Inactive user"} I added another account to the app and logged in with it to try, but the same object is returned. Can someone explain why this happens? Thank you.
Currency Field
How to add a currency which is not listed out in the Currency Field (LAK for instancen which is the Lao currency)? Thank you for your help.
How to show records from Zoho Reports in a paging table/grid?
I am trying to use Zoho Creator (ZC) to allow a user to select a range of criteria and return a list of records. These records, however, are not stored in my app but in Zoho Reports (ZR). There could be a million or more rows in the ZR view. I want to show the selected records in a grid so the user can select one of them and show the record in a read-only form. I have already written the read-only form as a Page. I can already read the data using the ZR API but I'm struggling how to show the records
My Account is inactive
Hi Support team, My business account (email phuongnam@vpppn.com) returns "Account is inactive" when I try to log in to Creator. Unfortunately, the locked account also means that I cant access my previous business emails and business CRM data having a major impact on my business. Could someone please activate the account as soon as possible. Thanks a lot for your support, Loi
Change "This report is not accessible." page
Hi all, I have a public form that, on edit, will send an email notification. This all works fine. When I click submit, though, I get sent to the "This report is not accessible" page. I don't want the user to see the reports, but I also don't want them to see this page. How can I direct them to a page that just says "Data Entry Successful"? Thanks in advance! Levi
Form where users can edit their own records
I have several users - not zoho creator users - who each have individual records. I would like to give them access to edit their own data. What is the proper way to do it, and which resources can I draw on to get insight to this facility. To be more precise - I have signed people up to a conference with workshops, and now I have all my workshops in place, so I would like to send an email to all attendees asking them to choose the workshop they would like to join. I would not want them to go to the
Fetch SubForm data from another Creator app
I'm looking to pull data into one Creator app from another, I have successful pulled in individual fields from the Parent form using a Function. But I also need to pull in data from it's SubForm and I'm having trouble getting it working The Function code I am using for the Parent form fields is: string arAccess(int Ar_Lu) { fetchAr = Area [ID == input.Ar_Lu; return fetchAr.Ar_Name; } Any help much appreciated. Thanks
Retaining variables after form submission
Is there a way to retain variable values after a form has been submitted? I have an evaluation form where a supervisor evaluates various people. I need them to be able to select a subordinate from a drop down, complete the evaluation, submit it, and then select another subordinate. The subordinate list is a lookup that is filtered, and is dependent on a previous field for the filtering. It works ow, but you need to re-authenticate each time to see the list of subordinates. Thanks!
Are Note (plaintext) fields supported in subForms?
I do not see the Notes field as an option for a subForm field. I was able to add it to the form field definition in code without error but it ignores the new field of type plaintext. I could not find this listed in the subForm known issues and limitations paper, is this documented? Also here is a forum entry from support saying there is no restriction on subForm fields. So there is some confusion. thanks, tt
Embed a stateless form more than once in the same in a page, is it possible?
Hi, is it possible to embed the same stateless form more than once in a page like the example below? when I try, only the first one loads, and the other two never load... thanks Luis htmlpage Page() <%{%> <table border=1><tr> <td> <div elName='zc-component' formLinkName='MyForm' params='zc_Header=true&field=1'></div> </td> <td> <div elName='zc-component' formLinkName='MyForm' params='zc_Header=true&field=2'></div> </td> <td> <div elName='zc-component' formLinkName='MyForm' params='zc_Header=true&field=3'></div>
Formula referencing date entered on form.
Hello, I am needing some help understanding how to write a formula that references a date entered into my form so that a report can be generated. Please see the attached snipit for a better reference. Thanks in advance for the help. Ryan
updating from background Paypal subform
There's limited access to the paypal subform, it doesn't appear I can pull any of those fields into the reports, so I'm trying to update a form field, this seems simple/easy but isn't working, any thoughts? On Edit - On Success if (ZC_Payment.payment_status == "Completed") { input.Payment = "paid"; }
Inventory Item to Unit relationship (many to many)
I'm creating an application in which I have- 1. a list of inventory items 2. a list of units of measure Now want to create a Sub-form in the Items Form, where I can define one Base Unit of Measure, and as many Alternate units of measure For example I want to define 1 LITRE of Oil = 0.8 KG = 1 CAN. Here LITRE will be BASE UNIT Can anybody help me do this? The units should not be repeated, and once BASE UNIT is defined, it cannot be changed
Logic problem
I have three fields: Login - which uses a single line field that will take a value and evaluate it using the if condition; Association Selected - which will be populated, based on the Login field if statement; and Candidate - that will filter a database list from another form and only show those records that meet the value of Association Selected. The first half works (using a login value to set the value of Association Selected), and the second half works if I type in the Association name in Association
Can't Delete a Field from a Form
I'm trying to delete a couple of fields from a form, but when I try to delete the field, then I get a message saying that "This field is referred in the following places. Please remove them and then delete this field." and it gives a list of Views. However, the field is not included in any of the Views listed. The only connection I can see is that the Views are all based on the Form that contains the field I would like to delete. Can anyone suggest how I can get these fields deleted from the form?
Next Page