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
KPI Indicator in Creator Page Panel - red/yellow/green
Hi did anyone ever try to realise a KPI indicator in a Panel or HTML snippet on a ZOHO Creator Page (would also be useful in Forms) What i would like to do define three different target ranges of values and the Panel should show a red / yellow / green indicator (traffic light style) based on the value would be a great feature, if it was part of the product :-) kind regards, Lambert PS: if you implement this, please also think of a 4-range indicator (this is getting more and more popular)
Generate new number (+1) on duplicate record
Hi, I have a form and when a record is created for that client it checks how many records exist and adds 1 to give a new report number as below: if(group_client != null) { ClientNo = client[ID == input.group_client].client_id; Counter = group[group_client.client_id == ClientNo].count() + 1; input.group_report_no = Counter; } It works a treat, however, when you duplicate the record the script obviously doesn't run and it just takes the number from the cloned record. I thought perhaps triggering on
Can a formula app be created by adding, dividing and multiplying entered category data
I would like a very simple math app that could be placed on my website that a visitor could enter their data and get an instant result. ie a +b+c divided by d multiplied by e = The answer. the user enters their known data for each specifically named category abcd, so the only unknown is the answer. 4 + 7 + 9 / 8 x 6 = ? ( 15 ) would be seen as the result.
Eval Function in Deluge
Does Deluge has eval function similar to the eval function of Java script to execute the Math expression on the fly ?
Hide employee in drop down if on holiday
Hi, I have a booking schedule which has an employee dropdown to assign the job to an employee. I also have a date required (date) field on the booking form. The drop-down Lookup fetches from Employees. The Employees form has an Employee Holiday subform within. I'm looking to perform the following, however, I'm stumped! 1) Look at the date required 2) Look at the employee holiday dates 3) If the employee has a holiday date booked off on the same day as date required, do not show the employee in the
Adding Data Value to legent
Hi I want to view the data legend on a chart permanently not only when I hover over the chart with the mouse. I'm sure it is something very simple but I am unable to find a solution. I'm using both pie chart and Funnel chart Thanks Amanda
Next Page