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?
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
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
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
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.
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
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
Delete / add rows to subform based on user input
Hi Zoho, I have a form with a subform. In case the user is changing (on edit mode) the input for one of the fields in the main form, I need the subform to be cleared - to have all the rows deleted, and to add just one row with specific values. in other cases I need to add a (changing) number of rows based on the user input. Scripting Clear Subform_Name does not seem to do the work. Help please? Thank you Ravod
Approval Workflow -- completed tasks not showing for Approver.
When using the Approval Workflow, as the Approver, i can see the Pending Tasks, and can Approve or Reject them. But then I cannot see them in the Completed Tasks. The user that submitted the task is able to see them in the Completed Tasks, however. I thought when I first tested this, i could see them as the Approver, but I have no idea what changed. Anyone have any ideas what could cause this? Thanks!
Zoho Creator -> Custom Function Update Multiple Fields
Hi is it possible to create a custom function to update muiltiple fields on : - main form - within subform main form example:- - main form has A,B,X,Y,Z fields - any changes to the X or Y would automaticlly update Z,A & B - right now i use "on edit" on both X and Y - was wondering whether there is a better way for both X and Y to call a cusom function. similar example can be used to refered to a subform row. a simple example would be appreciated. thanks
Removing some data from a QR Code Field and entering it into other fields
Hi I am scanning a QR code into a field that consists of the test data "01/2347/011 02 242" I would like to extract the "01/2347/011" part of the QR Code field test data and have it entered into a field in the same QR Code table named part number i would like to extract the "02" part of the QR code field test data and have it entered into a field on the same QR Code table called operation number I would like to extract the "242" part of the QR code test data and put it into a field in the same
How do I assign a numeric value to drop down field choice?
{EDIT] i meant to post this in the Zoho Creator forum.... 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.
subform entries
is set default entries in subform using only script?
Attaching records to each subform record
I have an app where I am storing a specific activity. Attached to that activity (using a subform) is any hazard that is found while doing the activity (1:n). So it's a one to many relationship between activity and hazard. Once those are stored, later we are doing some evaluation of each hazard. I need to store multiple evaluations against a hazard (1:n). So, it looks like: Activity 1 - (using a FORM) Hazard A - (using a SUBFORM) Evaluation x - (using ????) Evaluation y Hazard
Importing main/subform and get "Value '1,2,3,4,5' is not an option in the field 'SubForm'". What am I doing wrong?
Followed all the subform help pages and forum discussions I could find and still struggling to get a simple main form with linked subform data import to work. Been working on this for a few weeks now. The zoho help page here should be useful https://www.zoho.com/creator/help/forms/creating-subforms.html#Import_Subform_Data I find it flawed in a few ways.(1) It doesn't show you what to select during import. (2) It says ""items" column" when I believe it should say ""subform" column". (3) It doesn't
Next Page