house rental app
my project is HOUSE RENTAL APP i need to display images in the BHK form i soon as i select proceed based on particular id of the house present in the report of house details form.
Image in report in C5
Hi, With the C5 update, I want to use the report type where there is an image for each record. The image is not displayed on the web app but it is displayed on the mobile app. Thanks
Share appilcation
1. If i share my application with a user who has not zoho creator account can he access the application? 2. By deafult can a user add/delete/modify application?
Formula field doesn't work anymore
When I change the expression in a Formula field, the value in Report doesn't update to the new value. Even if I delete the expression, it still shows an old value. Thanks, Martin
How to add commas to number
I want to know how to add commas to numbers. For example, when the number is “12345”, I am displayed as “12,345”.
Auto Select/Fill an Entry the Look-Up Field
I've been playing around with the CRM Template and I created a Stateless Template to allow customers to sign up online. I've run in to an issue of the forms being submitted and the lead owner field being empty. I want to have the Look Up Field auto Populate with the "WEB" Username Load, Validate or Click... pretty much at any part. (Screen Cap) Any help would be appreciated. SC
Sharing Solution Information
We have a need to email/share our solutions module (internal FAQs) externally. We want to build a simple creator app that allows us to choose our solution and input an email address to send all defined information within the Solution. I am VERY new to DELUGE. I am able to create my form and have it send me an email upon success with the solution name that the user chose (CRM variable in the form). I need a line of code to be able to put other date within the Solution record and not just the name.
Return text I do not code.
Hello, I'm starting with the creator of zoho, I have a problem. When assigning an entry in a "conditional format" field, it returns the code, and I hope it returns the selected text in another field. I have put in a field the following expression: if (input.Cannal_de_entrada_1 = "Client", input.Cliente_crm, input.Agencia_de_transporte) The problem is that the order runs fine, however when it returns the entry, it returns it in code format and I would like it to return text. For example, in the case
Deluge Sequence
I just encountered something that baffles me trying to use Alerts to inspect the values of variables. The order of my Alerts appear exactly in reverse order. Does anyone know why this would be? To verify, I created a simple one-button stateless form and added this code to the button click: alert "this should happen first"; x = 1; for each myRec in Customers[ID > 0] { alert x; x = x + 1; } With 3 records in my Customers form, the first Alert said "3", the second Alert said "2", the third Alert said
Problem in Importing Data
Hi. When importing data from CSV sheet, after finishing the import I found my Date Time value is blank This is my application link - https://creator.zoho.com/appbuilder/zoho_dov16/a-kaioum/form/Seller_Cloud_VC
Create application to display description field for a CRM account record on lookup via a search box
I want to have a search box where my team and I can enter an account number and then if that account number exists, the app will display the description field contents for that particular account. Any ideas?
How to get logged user role in using deluge scripts.?
hi, i am creating application in zoho creator . In this i have created different roles(admin/manager/employee) and assigned to users . i want to logged used role (admin/manager/employee) using deluge script . to show logged user role on dashboard. waiting for your quick reply. Thanks Suresh Kareti
Records error
Hi, I have a quata of 45000 records and i have in use the 12000 of them. The problem after i delete i still see that i have 40000 in use. Can you refresh please the record count? Mike!
how to get values in multi select lookup field for each selected record?
row.Mat_Purchase_Req is the multi select lookup field, for each rec in row.Mat_Purchase_Req { if(row.Mat_Purchase_Req.size() = 1) { i = Material_Purchase_Requisition[ID == rec].Items_Required_for_Purchase1.ID; i0 = Mat_Pur_Req_item_lookup[ID == i].Request_Qty_for_P_O; } if(row.Mat_Purchase_Req.size() = 2) { i1 = Material_Purchase_Requisition[ID == rec ].Items_Required_for_Purchase1.ID; i11 = Mat_Pur_Req_item_lookup[ID == i1].Request_Qty_for_P_O; } if(row.Mat_Purchase_Req.size() = 3) { i2 = Material_Purchase_Requisition[ID
Getting Form Fields in HTML
Hi everyone, Any help with this would be much appreciated. For my new page, i decided not to embed an iframe with a report, but to use HTML to get a nicer look and feel. The issue that I am having its writing a script to generate these records and then splitting form fields. I have attached an image of my current iframe and then the HTML that I would like to have. Any help would be much appreciated. Cheers, David
Is there a way to determine the context a form is being used?
In other words, in Deluge, can I tell if the form is running natively or is embedded in an iframe?
Section Icons Are Not Updating
I changed the section icons and they were working perfectly. But suddenly they changed to the default section icon. When I try to update them, it saves but they don't change. I've tried to reset and select new ones, but still the same result.
Deluge multiple option if Field change
Need assistance. Need deluge when in a form, if field "A" is updated, on "success" change muliple field "B" from option "1" (by default) to field option "2" Thanks
Autocreate records in a form based on records entered in a different form
Hello, I currently have a form that captures attendance information based on user data entry. However, the data format for that record (record A) needs to be transformed for it to be used in a report, so I need to autocreate a series of records based on the information in record A. For example: 1. Record A has the following fields: - Date (3/25/18) - Event type (Event A) - # of Adults (50) - # of children (10) I need to make a separate record for each permutation of event
How to create an internal use CRM data lookup application
I am trying to create an application which I and my team can access, put in an account number into a field and it will (if the account number exists) display the description field contents of that account. It seemed straight forward when the idea came to me, but it's proving difficult for me to execute. Has anyone done anything similar or have ideas how I could?
Multi-Language Apps
Hello, How can I detect the current user selected language in deluge?
Getting error in function
Hi, When I am going to execute a function it shows me this error - Limit Error Number of statement execution limit exceed Line:(3) Why am I getting this? This is application link - https://app.zohocreator.com/zoho_dov16/a-kaioum/
How to count the number of times a name has been selected in a field ?
Hi, Hope someone can help me out in Zoho Creator. I have a simple Invitation_Form with a Name Field as drop down that refers to another Name Field in Names_Form. The question is : How can I generate a List with the total of times people came to my events. (The events are all generated into the same report...) Thank you for your help !! Arnaud
How can i add criteria in a report?
I got this line in the following documentation Link - "For example, you can make sure that certain reports can be accessed only by the admin user (application owner) by adding the following criteria to your report: show all rows from <form_name> [<email_field_name>l == zoho.adminuserid]" How can I add criteria in a report, by specifying who can see this report?
The page is no longer automatically updating after adding data to the embed report
I have a page with 2 embed reports and html-button which call the form for adding data to embed report. For example. Page Invoice with Embed Report "Payments" filtered by invoice ID. Button "<a href='#Form:Payments?" + formParams + "&Invoice=" + NewRecID + "'><input type='button' class='addNew zc-formbutton' value='New Payment'>", formParams = "zc_LoadIn=dialog&zc_BdrClr=transparent&zc_Header=false" When I closed the form "Payments", the page "Invoice" was updated automatically. About 10 days it
Criteria Setting Via Deluge
I have a form that has a radio button named 'Filter'. There are two choices namely '2 years' and 'Custom Filter'. If 2 years is selected a table filled with number of students in each department. If Custom Filter is selected, two Date fields namely 'Start Date' and 'End Date' appear. When a user enters a date for each date field, the table should contain the number of students in each department within those dates. Problem: If I select 2 years, nothing happens to the table, it only displays all of
How getFieldValue() work?
I want to know how getFieldValue() work. I did not find any example in the documentation. Can someone please explain it to me?
Bulk Add Functions
Hello, I think it will be great if we can use the attached form to add multi-functions instead of one at a time
Deluge Add Record Script Not Triggering Zapier
When I add a record to a form using the deluge add record script, I receive no trigger action in Zapier, even though the new record is successfully being added to the correct form. I know that form data can be emailed to a form, and from what I have read, this will cause Zapier to trigger, but I have been unable to setup automated emailing at this time. Is this a bug in Creator or a bug in Zapier? Are there any other workarounds available? Thanks for any input!!!!
SORT RECORDS WITHIN RECORD SUMMARY
Hello...how do I sort the the records that appear listed within a record summary? I've got the records sorted in the corresponding report, but they do not sort the same when embedded within the record summary. Any ideas?
Offline Mobile App Works Differently in Each Phone
I've signed for offline mobile app account (2 users). In my phone, I can access all my forms. However, the user's phone can't. And when I tried to log into my account using the user's phone, it didn't show my app offline. Both phones run Android. Why does the app behave differently in each device?
Date Only on Formula Field
I have a form with a date field, not a date-time field, and a formula field that references that date field. The formula uses date_field.addDay(7) to add 7 days to it. That formula works, however it is formatted as a date-time filed in reports. I need the field to only show the date in reports, without the time. The 00:00:00 time stamp is not only unnecessary, but it takes up too much space on the report and is inconsistent with the rest of the date only fields in the report.
Publishing for an Intranet
Hi, I'm reviewing the use of Zoho Creator for my organisation. I only have the trial version so can't play with publishing at the moment but can anyone help answer the following .... Is it possible to publish a report in a way that it's available to our intranet site (Google Sites) but not fully public - ie outside the company. I don't want to create a user account in Zoho for every employee as the cost would be too high. Is there a google site add-on that I provide some credentials to login to Zoho.
Filling multiple lines of subform on add/ on load ?
Hello everybody. Is there any way to pre-fill three (or more) rows in subform ? I have Form lets call it "order" and there is "subform" with lookup "product". I need to have there three lines with products (which are very frequently used almost in every order) pre-filled. I did not find any solution in formums. I dont have any idea how the code should look like.
Hide certain checkboxes based on if statement
Hi, I have a piece of code that reads whether or not a certain value is inputted in another field. If that field is a certain value, I would like it to hide specific checkboxes within a checkbox field. Is that possible?
newbie question
Hi i'm new to Zoho but i like it a lot. i want to build an app that allows me to manage computer repairs i've managed to build the forms and a few reports but now i want to add parts management i have a few suppliers, thats easy to put on a form. also the invoices from those suppliers are easy to register my problem is with different serial numbers something like: -supplier form with name, address and VAT number -invoice form with a lookup field to the supplier form and also a invoice date field
Mobile App and Data Relationships
Hi There, I'm new to Zoho Forms on my android mobile and am still trying to understand how to link records as in a relation ship. I dont seem to see any way to create a relationship between two pages. My first form allows me to enter garden centre addresses and add an image. my second form should allow me to add a date and notes each time i visit the garden centre. Then when I view the reports I would like to see the garden centres address and the dates that it was visited. My other question is it
Schedule Push Notifications
How can I create a form schedule that sends push notifications to my phone?
Criteria as substring?
Hi, I have a list of names (first + last as a string), and I would like to fetch entries from a form based on that name. problem is the form has separated fields for first and last name. I'm looking for something like EntriesListPerName= (Form[ First_Name in NamesList && Last_Name in NamesList].ID).getall() ; but currently the "in" criteria is looking for the full string, and not if it contains as sub string (if in the form First_Name is "John" and Last_Name is "Doe" it will not match an element
Adding columns to a report from a related report
Zoho creator allows me to add columns to a report from a related report. But sometimes the columns I want to show are uploaded files in the remote report. Is there a way to do this? It does not seem to show file upload fields. e.g. Report A has Purchase Orders. I can show the address of the associated company from a related Report-B but it won't let me show (say) the company Tax certificate which is an uploaded doc in Report-B Any workarounds? Otherwise, can the zoho team treat this as a feature
Next Page