Attach multiple uploaded files from subform in email
I want to attach multiple files that have been uploaded in a subform to a particular record in my email. The code im using is below, I know this is close but it doesn't seem to work when i put the variable holding the files uploadfilecvar into the attachments :file: part of the email. If I use attachments :file: file.File_upload then only one of one file is attached. How can i get this to email all of the files attached to a single email? If i put sendmail inside the for loop then it will send
how to create a label on the form
Is it possible to create a label on a form, as we could do when creating a form in Access ? For example, I would like to have on the right side of a field the format the user should follow to type the data in. ex: 99.999.999/9999-99 Thanks
Creating custom PDF
Hello guys, I've got a question about creating custom PDF file. I need an application that will print me a PDF file using standard scheme (created by me) and data from my database, created in Zoho Creator. The tricky part of this app is that I need an interface that will allow me to choose the particular records to be printed. How can I do this? Does anybody have any script of such an app? Thank a lot. I'm looking forward for your answers.
how to auto populate rows into subform from another form?
I have the following forms: Main Files (subform) Upload Both forms Main and Upload have a Subform linking to the form Files. The form Files has a bidirectional relationship to form Main. A custom action in the records of the form Main opens the form Uploads which contains the subform Files Both Main and Uploads are none stateless forms. Currently when you click the custom action and submit the form with subform Files the records will appear in the Main form when you edit / view the records. I want
Help to create
Hi I am looking for an expert who can create for me. I am not very great with technology but starting a small business and zoho have advised my requirements can be met but cannot create for me. Anyone who can help, would be great ;) Please do get back. Thanks Adib
Inner Join in Creator
I have not found definitive answers in review of previous topics... I have a set of forms in Creator. They are like the classic teacher / student / class relationships. One form is the teacher and class pair. The other is the student / class pair that I need to write a new report using an inner join. I want to read each teacher record and join to the student record using the common class field. Are inner joins possible in Creator?. Must they be sub-forms? If so what is the script look like
Multiple Paypal Accounts in Same Application
Can I tie to multiple Paypal accounts in the same application? Note: not the same form, just the same application. I'm building an app for member registration for different entities within the same organization. Each entity has its own bank account and thus each wants its own Paypal account. It would be easy for me to build the application so that each entity has its own specific member registration form. I could then put the correct Paypal Email ID in each form. Based on the fact that each
update creator's entry via email/webhook?
hi via workflow customers receive entry data in manner "if this than that" and via email they can reply "accepted" or "rejected" in email subject / message body there is for identification unique zoho creator's entry id how can i via customer's reply update currect entry status? first variant - work with reply email and via entry id update entry second variant - i can make email-to-webhook and via webhook update entry question - is there any possibilities in updating zoho entries via email / webhook?
Issue with gmail and sending form data by email
I have a form that can accept data by email. So I decided to test the Form Alias Email ID. In gmail I set-up the form's email for forwarding. Gmail requires verifcation of this by sending an email with a code. I had assumed it would arrive in the form where I could find the code. It never arrives. Just to make sure, I set-up forwarding to another email account I hold and the verification code arrived instantly. I'm suspecting that ZOHO email servers are misdirecting or blocking this email. The email
Send email based on selection in multi select lookup field
I want an email to be send to based on the selection of a multi select field. I only want the email to be sent to the vendors that are selected in the multi select field that looks up from a vendor table. The code im using is below but i cant get it to quite work. It seems to be sending an email to everyone in the vendor table rather than just to the people selected in the Vendors_in_RFQ multi select field. for each E in Vendor [ID = input.Vendors_in_RFQ] { sendmail (
Able to export out all data with attachements
Hi, We are using creator, but really want a viable method of exporting all our data including attachments for archive purposes, and wondered what was available to do this. Any advice please?? Thanks Dave
how to update a field on add
Hi Everyone, newbie question: How do I update a field on add? I would like to concatenate a field on save/submit. I have looked around and can't seem to find the answer.
Notes fields and line breaks
I have an application which is designed to show a Rich Text Field in a stateless form "On Load", however the line breaks are removed, for example, the following value is entered into a multi-line text field This is a sentence with sub items. The sub items are as follows: i) sub item 1; ii) sub item 2; iii) sub item 3. When I edit the record "On Load", the Multi-line Text Field is hidden and the a Notes Field is set to display the value of the Multi-line Text Field. eg. hide myfield note1 = input.myfield
New to ZOHO Creator
I am trying to make an application for my business and would like to create an app with basic info on the business including photos, info, Facebook, twitter, youtube videos, etc. How do I create this, I am not too familiar with creating my own app from code yet. Is there a way to do this with simple drag and drop GUI or does anyone have any templates that they can share with me?
Sorting on a Linked Field in an HTML View
Hello everyone, I was hoping that someone could help me out with an issue I am having with an HTML script that I wrote for a page. In this script, I use two forms (AVLBeerManager & Beer_Locator) to create an html view that displays a list of beers with relevant information (ABV, Description, etc.). Beer_Locator is where location information resides (i.e. @ which bar has which beer) AVLBeerManager is where beer information resides (i.e. abv, desc, etc) I iterated records on both tables, linking on
Get CRM Leads direct to Creator report List
How can I get all CRM lead records to import/sync directly to Zoho Creator report in list view??
Current date and time in the Date-Time field? If exact data exists how to generate an error?
Auto add the current date and time in the Date-Time field? Also, if exact data exists how do I generate an error?
Using Form definition to create forms
Hi, I would like to know, if there is a facility to create forms using the API. If not can I understand form definition rules and write my own Form Definition programatically and post it after authentication to an URL to create a new form ? Thanks Praveen.M
ALLOWI USERS TO SWITCH BETWEEN GRAPH AND CHART VIEWS IN A REPORT LIKE ADMIN CAN
As ADMIN I can choose to look at the data in a report in various ways, such as charts and tables. This does not change the underlying data records. When I save the view, that becomes the default view for USERS of the app, and the USERS cannot change the view of the data. Is there a way to let users choose to see both graphs and chart views like the ADMIN can switch between? Thanks! Loyd
NO REPORTS IN MOBILE APP?
I have the Android mobile Zoho Creator app. I can see the data entry form, and can view the records, but I do not see how to view any of the several reports I have in the app. I looked for a checkbox to share the reports on the mobile app but could not find one. My assumption is that the Android mobile app is just for entering data and viewing records, and not using reports. Loyd
Add the data of a subform with deluge script
Hello Zoho developers, Finding the answer of this question will help me in many projects. I have 3 forms: MainForm1, MainForm2 and Subform. MainForm1 and MainForm2 both contain a subform of Subform. When creating MainForm1 (in its On Validate or on success), I want to automatically create a record of MainForm2: Form2_ID = insert into MainForm2 [ Added_User = zoho.loginuser ... ];and then to have the same data of the subform Subform in MainForm1 attached to the newly created record of MainForm2. Thank
<Field Name>:ui.add() function does not work in On Add/On Load event?
Folks, I have another questions for this group. First off, I have found the link below on adding data to Dropdown Lookup List type field. https://www.zoho.com/creator/newhelp/fields/add-to-picklist-dynamically.html In my case, I have my first Lookup Field to be Tournament, then the second Lookup Field is Event. Each Tournament can have multiple Events. Currently, without any initial default value to my Tournament field, if the user chooses a Tournament, the Event Lookup Dropdown field will be
Problems with "lookup fields" and variable criteria
I have an application that uses a subform where I need to query a lookup from another database, the previous builder used a criteria with a variable, but I had to capture the "filter" in each row again, It worked very well. Now with the new builder I have the problem that I can not capture variables in the "criteria" field or at least not work well. Has anyone solved a problem like this? Thanks ....
Criteria to display a report with no value entered in a field
I have a form with categories, more than one can be checked at a time but I need a report showing those that have no category selected. I have tried a few things but none seem to give me the response I am looking for. I need to be able to go back and add categories to the ones I was not sure of when adding them initially.
Lookup CRM and return address
Hi, I am trying to lookup my CRM account and then based on customer selected return the address? Thanks
Numbers not displaying properly in HTML
I have an HTML page where I am trying to display a currency field from a particular record. When the number is small I get the number to display 800.0 but if the number is in the millions I get 8.0E+8? I have found that when the currency is less then 8 digits I get something like 8000000.0 but when an additional digit is added it goes to 8.0E+8 How can I fix this to display like $8,000,000? Thanks, Sean The top part of my HTML page htmlpage Opportunity_Details(opportunity_idstr, opportunityID)
Can I call the delete web service using JSON in the request body?
Hiya The API samples show using x-www-form-urlencoded data when calling the webservice to delete records. Can I use json instead? If so, can you give me an example? thanks Paul
how to clear Zoho crm lookup field
How can I clear the value of a Creator Zoho CRM field with out using an API call? I want to be able to clear a value that has been entered. I have used the following but it seems to use an API call and i dont think it actually is clearing the value. input.ZohoCRM_Lookup_Field = null;
Calculation based on lookup
Hi, I have the following I am trying to achieve FormA.Product_ID FormA.Weight_Per_Item FormB.Product_ID is dropdown/lookup from FormA data FormB.Quantity FormB.Total_Weight trying to get this to populate based on FormA.Weight_Per_Item * FormB.Quantity Any help would be appreciated
Adding a field from another form database on success
A visitor fills out the form Landing_Page and enters a Promo Code. On success I need to look up the entered Promo Code and match it to the promo code library form called Promo_Code. After a match I need the associated consultant from that promo code record (in the Promo_Code database) to be added to the record that the visitor just created when they completed the form. Please advise how to do this
how are subform entries related to the parent record?
I want to be able to use a custom action to add a sub form record but don't understand how the sub form record is related to the parent record. My custom action adds a subform record but it doesnt seem to be related properlly. I have a custom action that opens the sub form but seem to be missing the part that will relate the new sub form entry to the parent record that the custom action was executed on. The custom action code im using is: void Payment(int ID) { openUrl("#Form:Payment?Request_ID="
Picklist within subform
Good afternoon, I have a picklist inside a subform wich I dynamically populete base on a lookup field. Is there any way to select one item on the picklist?? I try row.<fieldlist>.select(value); But the system answer: <fieldlist> does not exist in this form Thanks in advance for your answer. Ricardo
Customer Portal Basic Questions
How can a user change his email? Are there plans to customize the sign-up from with more fields? Upon sign-up, there seems to be no way to control where the user lands in the application. True? Since I'm building the app in my own account with an intention to export the ds file to my customer, will my customer have issues with the customer portal aspect upon ds file import? Cheers, John Whitney
zoho.loginuserid not working for customer portal
A few hours ago if I logged in to my customer portal app, a form with Email=zoho.loginuserid; would correctly display the email of the user. Now it's simply blank. However, if I place <%=zoho.loginuserid%> on an html page, the email is displayed to the portal user. Something must be broken with the customer portal? I submitted a support ticket and shared the app with zoho. Cheers, John Whitney
Populate data field
Hi, How can you do that when you select a dropdown and a number is typed into a text field will auto fill other field and the final amount has to be half the user write. Dropdown field name: Tipo_de_Prestamo Data field with the amount : Prima Data field to populate: Comision
custom action to edit record
Is there a way to use a custom action to open the edit record dialogue? I want to avoid passing data back and forth between a stateless form and also do not want users using the standard edit record method. I want a custom action that opens the record for editing. Is this possible? Does the edit record popup have a url i can pass to the OpenUrl() function? Is there another way? thanks
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field.
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field. example,... project db, has the following fields, project number elec design hours mech design hours technician hours assembly hours time entry table has the following fields Project number job function (drop down with selection of elec design, mech design, technician design, assembly) Total hours I would like to update the proper field in
Zoho Creator REST API
I'm trying to extract some data from a Zoho Creator App using perl as follows: #!/usr/bin/perl use HTTP::Request::Common; use LWP::UserAgent; $ua = LWP::UserAgent->new; my $req = GET 'https://creator.zoho.com/api/slowclay/xml/copy-of-slow-clay-registration/view/student_view', [ authtoken=> 'bd73c9ac318d2fab9f8d89fce9509c29', scope=>'creatorapi', submit=>'View Records', ]; $content = $ua->request($req)->as_string; print "Content-type: text/html\n\n"; print $content; But I just get the response
Need help creating a simple search interface PLEASE!
I've created a form that organizes job, job id and location in a form, but I need help creating a simple search interface that makes those three things searchable, and brings up all the information about a particular item searched. (For example, when i search LPN, I want it to show me "LPN", the job id AND the location. How can I do this? Please help!! I've tried for hours to figure out this coding ,but it just isn't working for me! Thank you in advance to anyone who's willing to help!!!!!
Set default value in lookup field after submission
If I have a lookup field (dropdown) with countries, is there any way when I select a country and click submit then automatically set this country as default? . Can you please send me an example of this? I tried (in On Load) to fetch records like value = Country [Name_of_Country = "Germany"].ID; Lookupfield.select(value); With a country like Germany it works but I do not want this.
Next Page