Auto Submit of record based on data
Hi, I am trying to create an app which will allow the user to scan bar code data from a bar code scanner connected to the mobile and submit it. The use case is the user will scan barcodes of each product using the barcode scanner and when the user reads a particular bar code say "A0000" which indicates an end of customer I want to submit the form and reload it to read the bar codes of next set of products. The users of the App are Visually impaired people and it is hard for them to either
Disable Subform Row based on condition.
Is it possible that we disable a subform's row based on condition? if one of the cell is not empty then disable the field? i've tried to use disable subform.price , when i add new row ,the new row got disabled as well. anyone can shed some light? thanks Jeff
Sales Order Deluge
I need to create a Sales Order in CRM from Creator and I need to know the fields to populate and how to structure the Product information when there ware multiple product lines for a Sales Order. I know the basic is: response = zoho.crm.create("Sales_Orders", mapped_fields); It's those mapped_fields that I need the structure for to correctly populate and create the record in CRM Sales Orders.
Hide related field in Add New popup form
I have two forms: Client and Pet. Clients can be related to multiple Pets; each Pet has one related Client. On the Client form, I have a Pets multiple lookup field with the ability to Add New pets. On the Pet form there exists the bi-directional single lookup back to Client. This is good in case I decide to add a Pet through the Pet form and not through the Client form. However, when I choose to add a pet using the Add New function on the lookup field in the Client form, the popup shows the bidirectional
2 levels of subform in one form
Hello, I want to have 2 levels of subform in one form. In the form Client, 1 to n Contract. In each Contract, 1 to n Records. So I want to see all that in the form of the client. Is it possible?
1 to 1 help
Hi, I've started using Zoho creator and i have followed and understood the basic walk through. I have basic coding skills in VB previously. I'm looking to use this platform to create many apps for work so i would like to progress my knowledge quickly. I was wondering if there was anyone on the forums etc. who has a decent knowledge of using Zoho creator who could help me build particular apps to speed up my knowledge uptake time. Happy to pay $20-$30 per hour or discuss rates. I'm not sure if this
Send E-mail with Attachment
Hi! I want to find a way to download multiple files in an easier way. I have a form that allows the user to input 13 files. Today, we have to download one file at a time. I thought about creating a custom action to download all the files at once OR sending an email with all of the files attached to it. I'm having trouble with both option. With the custom action, I could not find any routine to download / export a file. With the email, I could not make the expression "Attachments :file:input.NAME_of_my_File"
Deluge - list & iterate through all form fields for an audit log
Hi, I'm trying to build an audit log (I'll call it AuditLog) that will update every time I make a change to my primary form (which I'll call Form1). The form AuditLog contains 4 fields: Entry_Date_Time (date time) User_Name (single line) Description1 (single line) Description2 (multiline) In onSuccess state for On Add, On Edit and On Delete form actions in Form1, I call this code: insert into AuditLog [ Added_User = zoho.loginuser Description1 = "added record " + input.ID Description2 = "input.ID="
Error message: We failed to retrieve this report
One of the users in my organization is seeing the following when trying to view a report:
zoho creator
how to do checkbox deluge scripting like i have two checkbox options on which when i select one other should be disabled or other should not be able to selected...
HTML popup
HI, I would like to add a link to my Rich_text field, that opens up a popup window. So far I have this: RichText = "<a href='https://app.zohocreator.com/ccimailzoho/interhof-travel-calendar/#Form:Passenger_Form?recLinkID="+OutPax.ID+"&viewLinkName=All_Passenger_Forms&zc_LoadIn=dialog'>"+PaxPasteName+"</a>"; unfortunately that does not open in a popup window. Does anyone have any advice?
How to upload files directly google drive using zoho creator application?
Hi Team, I have to store my attachments in google drive and also i need to open my word attachements in onlyoffice. Please provide the process. Regards, Ramesh.
Logic help with Variable not defined please
Can you please tell me why this code comes back with variable not defined. Thanks if (count(Agents[Name == input.Name]) > 0) { rec = Agents [Name == input.Name]; input.Name = rec.Name; openurl("#Form:Agents?Lookup_Agents=" + input.Name, "same window"); } Error at line number : 1 Variable 'Name' is not defined
REPORT result does not match the live/actual data
Hi, I have a simple CHART report that show the breakdown of data based on a status column (drop down list) but somehow it does not pick up all data. For example in total we have 78 entries but the report only shows 75 entries. Also when we change the status of the entry and run the report, the status change is not reflected in the report (I have confirmed this by checking the underlying data) Shouldn't REPORT looking at live/actual data? Or is this problem only happened to our account? Can someone
Zoho Creator - Download as Mobile app not working in Zoho creator 5
Hi All , Download as Mobile app option is failing on code signer for andriod. Raised the support question and they accepted it is an issue - they working on with HIGH priority it has been months - i find very difficult to get follow up from them .. for me it is show stopper issue in the product when they claim custom mobile apps as sales pitch for zoho creator looks like Zoho is not taking this as serious issue In general Zoho creator Support is below average for me Do any of you here face
Taking a printout of the Relationship diagram on one page
Right now I can scroll around and see the relationship diagram but it would be easier to take a printout on a large paper, eg A0 or A1 where I can see all the tables at once. I tried the print button and setting the Save As Pdf with landscape format and Size of Paper A0 and A1 etc. But it seems to only export whatever is in the current view. Is there a way to export the whole schema?
Creating map reports from database addresses or longitude&latitude
I need to be able to create a visual map based on addresses or long/lat of given records. Does anyone know if this possible and how to do it? Also I'm wondering if it could create a route between the addresses. Basically I use it to store bus routes and need to be able to show the data as a map. Another option is if I upload a map to my app is there a way it can break that map down into records?
Serial data in processing window
hi all Lets say i vant to show the value that i can see via my terminal program sent from arduino, and show that in a box in the processing window... In other words, how do i transport serial data in to the processing vindow?? Regards from Denmark.
How to hide HTML buttons from a pdf
Dear All, If I add in a HTML page two buttons like <button type="button" id="B2" onclick="alert('Hello world!')">Accept</button> <button type="button" id="B3" onclick="alert('Hello world!')">Reject</button> Furthermore, the Print - PDF buttons have enabled.. I know that with the @media print { #B3,#B2 { display: none; } } I can hide the two buttons. But how can I hide them in the PDF button?
On button click in report record send that record's summary as pdf attachment to an email
I have the following use case in Zoho Creator. Is there a way to accomplish this? (a) I have a Report with various rows. (b) I have made a record template as a pdf and saved it as a non default template (i.e.I don't want to disturb the default view of a record that gets generated on clicking on a record) (c) On each row I can display a button labelled "Email me pdf summary" the on click action of which I can get it to send out an email to the logged in user. But I need to have a pdf attachment
Send Mail Workflows & reports
Hello The "Forms Workflows" permits to send an automated email, "on add" or "on edit" of a record. In the email settings, it is possible to send the record, as html formatted data, according to "custom print templates". However, in the "Functions" configuration for email noticfications, the checkbox "include user submitted data", which allows me to choose the record "template", isn't available. I can only add "fields", to the body of the email. Please see the 2 attached screenshots. I'm trying to
Fingerprint
Hi, How can i insert fingerprint function on my zoho application on creator?
billing app - add product via search or barcode
hello, We have created a billing app. On invoices, we wish to add products in 2 ways: - by search (drop-down list) on the field "Product_name" - by scanning a barcode on the "reference" field. (smartphone camera) We would like: - if we enter the field "Product_name", the field "reference" must fill automatically - if we scan a barcode for the "reference" field, the "product_name" field must fill automatically The 2 fields must be both in "input" mode and "get data" mode. Finally, the "price" column
Forms Data to Excel spreadsheets
Hello, I try to to implement Creator to get rid of excel spreadsheets in our everyday business workflows. However, we still need to deliver some documents in Excel format to some customers. I used another "low-code forms application" (DoForms) which allowed me to populate a "preformated" excel file, with forms data. This by upoading an xls template with the "data name", (or "link_name" in zoho) prepopulated to certain cells. This would give me in return an xls corresponding to the record, with data
"Invalid or null criteria specified" error message
As of today 2 separate apps showed the message "Invalid or null criteria specified" when submitting and entry using the mobile app. The two apps had been working properly and no changes have been made. Has there been any changes on Zoho´s side that might be the cause? Can anyone find an explanation or possible cause for this? Thanks in advance Constantino
Can't get code pasted from zoho doc to work for creating a search page - improper statement
I paste in the code under "Create HTML page with Search parameter" from this page https://www.zoho.com/creator/help/tutorials/advanced-app-building.html#create-app-using-subforms into my editor and I get "Error at line 5: improper statement" error. I followed this whole page 'tutorial' and this was the only thing I couldn't get working (I'm in creator 5). I found a typo in other code earlier in the page to solve one set of code that wasn't working, so hopefully someone else can help resolve why
combining pdf uploads to create a compilation that can be downloaded
I have a form where users upload several scanned documents corresponding to orders e.g. Courier Reciepts, Bill of Lading etc. For printing, emailing etc. there is a use case where a combined pdf would help that is made from each of the uploaded pdf's concatenated as one multipage pdf. Is there a way to do this in Creator? Ideally I woild have a new column in the Report labelled "Compilation of docs p
"multi select lookup" is not selectable using sheet2app.zoho.com excel import
I am testing out the new (for me at least) sheet2app.zoho.com excel import which looks quite nice. I have some demo data and can set a lookup relationship between my sheets of data in excel, but "multi select lookup" isn't an option for the relationship. I'm not sure I have my data structured correctly for what the import is expecting, but if anyone can layout what the generic format is that import tool needs for one to many relationships (and/or confirm that the multi select lookup should be usable
"Account is inactive"
Hi, My business account (username arsharpe2 and email robert.sharpe@evergreen-consulting.co.uk) 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. Regards, Rob
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I'm trying to use the Creator data migration tool and get the error "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" when I attempt to open any files. I found info telling me to install various Access Database Engine components which I've done, both 2007 and 2010. This had no effect on the problem. I have Office 2010 32-bit installed and Access works fine by itself. What can I do to get this thing working??
Is it possible to disable reset button?
I don't want my users to accident hit the reset button (on a mobile phone that can be easy to do) and then have an incorrect submission. How can I effectively disable the reset button on all forms in my application? I deleted the mention of the reset button in my form definition, but that didn't make the button or it's function disappear from my form (I hope I didn't damage the form).
Send multiple attachments by selecting checkboxes
Hey all, We send test reports to our clients on a one by one basis using a custom sendmail function. Sometimes, the client asks for 10 + reports to be re-sent to them as they have lost them and we have to click send 10 + times. Ideally, it would be far better to select multiple by using the checkbox and having a custom function in the header to send. Am I right in saying that each would still be sent as singles? Is this possible? Any advice on this would be greatly appreciated.
EMAIL
I have set up a email notification to be triggered on one of the conditions being fulfilled in a form; This is being done on edit option. This is working fine; but if for some reason if we happen to edit some thing else in the form and update ; it again generates the same email as the condition that triggered the email is stiil true; Can I stop the email being sent again;
Count seconds between 2 Date Time fields
Hi, We have always worked out the time between 2 x date time fields and output them as 'Hours and Minutes' as below: string CalculateDuration(Date Start, Date End) { Duration = (((End - Start)) / (1000 * 3600)).toLong() + " Hour " + (((((End - Start)) / (1000 * 3600)).toDecimal() - (((End - Start)) / (1000 * 3600)).toLong()) * 60).toLong() + " Min"; return Duration; } The need has now arisen to calculate the Minutes and Seconds. I have tried many equations to no joy. How would I do this please? Regards
Select fields to copy
There may be similar fields in a form. Instead of having to retype each field, it would be helpful to be able to select fields to copy and then rename the new fields.
Field no more required
I had created a field when I initailly created the form and now I realise that I do not need that field; There are several records which have that field but we do not visualise using it any more. How can I delete it or inactivate it
Proper case with one small modification I'm trying to find a workaround for
I'm trying to clean up my customer database and prevent new entries to be all caps or weird random capitalization (sometimes employees can do that when adding data). The built in proper() function works fine for the most part, except that when the string has a period in it, I want to make the next character to be capitalized. For example: JOSE VILCHES is converted correctly to Jose Vilches. But a company name like BRONDBY S.A. would be converted to Brondby S.a. instead of Brondby S.A. I would like
Understanding field level permissions
Can someone explain to me the difference between field level permission "visibility" and "Read Only" (image attached)? I have a user who can't edit a field even though her "Profile" allows editing and the field permission is checked for 'visibility and uncheched for "read only" for the form in question. Which is the correct choice for a field to be editable? The knowledge base articles do not explain this well. Thank you
Passing info from stateless form into htmlview
Hi, I need to replicate the sample below (from an older post). How can I get the script to replicate? Thank you Please refer the sample application: https://creator.zoho.com/sampleapps/employees/#View:Complete_Employee_details. This html page has the same feature. Max Technical Consultant | Zoho Cares
Zoho Books Chart of Accounts in Creator
Dear support, I've been trying to import Accounts from Zoho Books Chart of Accounts into a new Zoho Creator app, as the main base data for this new app. I know I could export accounts (from Chart of Acounts) from Zoho Books, import in Zoho Creator for the new app ... but this solution needs human action to sync Books/Creator data ... Is it possible to import Zoho Books Chart of Accounts to Zoho Creator?? Thanks in advance. Regards.
Next Page