How to reload a stateless form with updated data
I have a stateless form with 2 fields. One is a key of a form. The user enters that field and clicks a button on the stateless form. This button retrieves the form using the key, and copies a data-filed from the retrieved form into the second field on the stateless form. What do I need to do to show this second field to the user? The <reload> function basically refreshes everything. Any suggestions? thanks Henk
REST API criteria in update request
Hello, I've tried to update my Zoho Creator View by using Email as criteria. $criteria = "Email=$user_info->user_email";The response is a failure, with the following response : update: {"formname":["User",{"operation":["update",{"newvalues":[{"WP_ID":"135","WP_login":"f","Origine":"wordpress"}],"criteria":"Email = f@mail.com","status":"Failure, No Records Found With Specified Criteria."}]}]} f@mail.com obviously exists in my zoho creator view, and a test based on another criteria ( WP_login ) works.
Customer portal and pictures
Dear team, For a project I am working on for a customer, I am having some questions related to the announcement on the blog about customer portal. My application will be used by operators in the field. They will therefore use Zoho Creator on their Android device. We would like to be able to add pictures as attachments to a form. This is because they want to have proof of delivery and install done with customer. Is that currently possible? My customer would like to show these pictures to his end customers.
Send Todays Tasks by Email
I have a built a tasks app, I would like to make it so that on the due date tasks are emailed to the relevant person. I am trying to add a schedule using "Workflow" and the "Schedules" and the "form schedule". I have done it all ok but if I click execute to test I get a message asking which task ID. In the "What to do" page I have it set to filter tasks that fit the criteria. Below is what I have in the "message" of the "When to do" page but when I click execute it asks for a task ID. That would
Users unable to view HTML page
I have spent some hours (and had a LOT of help from Herb Wexler) building an HTML page which displays a compiled view of information held on 15 tables within my database. The html page is run through an action button in one of the views. I have shared the page out to all domain users. Until now, myself and the developer have been running the html page and printing off the records, but we are ready to train users and hand this application over to business as usual. Unfortunately, when a user selects
IF statement -- Date == NULL Error.,
HI, I am facing null error on the below 1st line (IF statement). All 4 fields are of type Date. if((((input.From_date == null) || (input.To_Date == null)) || (input.From_mon == null)) || (input.Date_monto == null)) { Execute; } Else { Execute this; } Let me know the solution.,
Conditional if statement in scripting
What's wrong whit this script? Or what else can be wrong? I always get back the FALSE value, 200.0, regardless the input. input.Painting = if((input.BWS < 40.0),2.0,200.0); I have the sensation that the input.BWS < 40.0 has not be considered at all. Do you have some experience like this? (the input.BWS in the <boolean-expression> is Look-up field, with an applied filter, so it is dynamic) can it be a problem?
View Image without login
With Zoho Creator API, image fields are returned as HTML tags with src being the image URL. However, loading of images uploaded to Zoho database requires the user to have a valid session. I am building an application which requires public access of the uploaded images. Is there a solution to this problem without making public my view? Any help will be much appreciated.
Mail Suite Contact Data Entry through Web Form (NOT CRM Contacts)
Hi, I am trying to find out if I can make a web form that can be used to enter contacts into the zoho contacts that are part of the zoho mail suite (also accessible at contacts.zoho.com). VERY IMPORTANT - this is in reference to the contacts in zoho mail suite - NOT in CRM. I did see the webform for CRM contact entry, but we are planning on using zoho primarily for email and possibly campaign purposes, and while CRM's functionalities are impressive, they are not applicable for our purposes. While
Passing value through open URL not working for me.
Im using the following function on each record in a view. This function opens the edit mode for the record and I want it to set the field "edit_design" equal to "Yes". trouble is when i use the function the edit_design field is not set to Yes. What is wrong with this function? The field "edit_design" is in the form Purchase_Request_Form and is a drop down menu with values "Yes" and "No". Im sure this is something simple but i cant seem to find it. Please help! void editDesign_upload(int ID, string
Report for loop Syntax
I'm trying to construct a report that's to the value start date between the first and the last date of the current month. I know that I can do this through a filter but I'd like it to be coded so that I can ahve it be emailed list Report_Example { displayname = "Report Example" #show (for each TimeSheet in Time_Sheet [Start_Time > zoho.currentdate]) ( Employee_Details as "Employee" New_Company as "Client" New_Project as "Project" Start_Time as "Start
Open source fonts
Is it possible to use open source fonts (e.g. google fonts or icon fonts) on html pages? Thanks.
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;
Next Page