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.
i have records in zoho creator and wordpress....need help to automatically update record in wordpress when changed in zoho creator
hi, i have property listings in my wordpress site. every property is in my zoho creator as well. im looking to see how i can change information within zoho creator and have it automatically change in wordpress. is this possible?
Autofill Lookup Field OnLoad
Hi, I'm trying to set a lookup field (Form B) to autofill with the most recent value from a string field in Form A. I can get the lookup to autofill OnLoad when I link it to a system field (e.g. ID), however, it doesn't appear to do the same when using a user-defined field. For example, the script: "input.Lookup_Field = Form_A[Added_User = zoho.loginuser].ID sort by Added_Time desc;" works perfectly, but "input.Lookup_Field = Form_A[Added_User = zoho.loginuser].String_Field sort by Added_Time
Different form with different from's properties format and workflow script event
I am playing with the point of sales app now and found out one of the form (add stock) not able to add successful added message, i tried to use workflow event to do that but the workflow event "on success" nowhere to be found. others form was fine though..i can only see on load and on user input event. anyone can shed some light? thanks, Jeff
Show/Hide field in subforms
Hello is it possible to hide a field in a subform based on user input in the parent form? Thank you Amanda
How do I assign a value to a drop down field choice?
I am using a drop down field to record the status/outcome of a record and need to assign a value depending on which status is chosen. If the status is Sold, Proposal or Cancelled, I need the value to be 1, or if the status is Assigned or Reset, I need to value to be 0. This value will be input into another field in this form, which will be summed and used in a pivot report.
lookup field ID in custom template report
Hello I have a Master Form, where each records is referenced by a unique "String" data name, let's call it "Record name". This form posseses a "Subform" which I use to report occasionnal errors in the data from the "Master form". I want this Subform, to trigger "send email" workflow, with a dedicated " Custom template" based on this subform datas However, when I reference the "Record Name" (which is a lookup from Master form), the result displayed in the sent mail is containing the underlying record ID,
Security Framework Upgrade Timeframe
I received notice of this Security Framework Upgrade. When will this take effect? By when must we validate all of our apps and make them comply? https://www.zoho.com/creator/newhelp/app-validation/ Thank you,
Pagination. DELUGE. API. No "While" looping functionality
Need to import records from API. Maks records per run is 200, but we have more than 200 records to import, so we need to use pagination. Need to run enought times to get all the records. ZSresponse=getUrl("https://subscriptions.zoho.com/api/v1/subscriptions?page=1&per_page=200&authtoken= x &organization_id= y &filter_by=SubscriptionStatus.LIVE").get("subscriptions").toJSONList(); So, need to iterated the "page" parameter until I have all the records. My API returns the paramter - "has_more_page":
Customised Sequential Number
In one of the forms I need to : 1. Create a unique number which is combination of Employeename+ Sequantial number Eg Lets say there is a task which needs to be done John Hermann. When I allocate the task to John I want this task number to be : Johnhermann1001 and if next time there is atsk and Mary has to do it then that task number become s: Mary1002 Can some one help with a sample code ; simple one please; I have asked ZOHO help a couple times but they seem to be struggling and I have to get
Addresses not found
More than half of my Addresses are not found when I'm adding customers and the ones that are found, there is too much info. I only need street address, city state, zip code, but it is pulling in too much additional info. Is there a way to integrate another map provider such as Google Maps?
Aggregate values from multiple entries in a form
Hi, I am trying to get the aggregate value of a field from multiple forms. My Stock Out form has the following fields: 1. Sale order number 2. Product code 3. Quantity For a single sale order I will have multiple entries in product code and quantity. I have a separate form to print dispatch slip, which needs to have the total quantity for each sale order. How to get this?
Load page data via ID
Hi, I have a button on a report which I want to open the record via the group id I pass to it. I must be missing something as I cannot get it to work and have read as much as I can. It simply loads a single report with the samples that are assigned to that group. When the button is clicked it executes: openUrl("#page:group_summary1?group_id=" + input.group_id,"popup window","height=1000,width=1000"); 1) I have set the page parameter to group_id, Group_ID - you name it, i've tried it. 2) I have assigned
Multiple lookup field
I'm just starting out with Zoho Creator. Presently I just have two forms: 1. Personnel 2. Organisational Units A person can belong to multiple organisational units. I have added a LOOKUP field to the personnel form allowing user to select which unit the person belongs to. But I can't find how to allow multilple organisational units to be selected.
Document management system based on Work Drive
Hello Zoho community, What i want to create is a document management system based on Zoho Work Drive, Zoho CRM powered by a Zoho Creator apps that allow us to customize file attributes, associate them to Zoho Contact/Account with a Creator form/report and finally share that files with customers by a Creator Portal. Anybody did or worked on a similar solution? Thanks everybody for reading! Manu
Lookup field issue
I have a Student education form. In that I have created instituation name as lookup field from institutaion form. While creating the lookup field, selected the "create new entry " choice. If the user wants to add new instituation, he/s she can click new entry. User is able to open the "institution" form. My requirement is when the user select new entry choice in lookup . only instutuation name needs to be shown, other fields needs to hide. Please help me to solve the problem that would be of great
Next Page