Fetch Records + Update
HI All, I'm trying to fetch records from "Inkoop" to "Verkoop" , but it doesn't work. Can someon help me please. Note: I want to fetch the records into a subform "Brillen_Toevoegen" + Can i update the "x.Aantal field" with input.aantal? 1+1 for example. if(Inkoop_link[ID == input.Brillen_Toevoegen.Model].count() > 0) { x = Inkoop_link[ID == input.Brillen_Toevoegen.Model]; input.Brillen_Toevoegen.Merk_inkoop = x.Merk_inkoop; input.Brillen_Toevoegen.Kleur = x.Kleur; input.Brillen_Toevoegen.Aantal =
Custom Order ID
Hi All, Can i have my own costum order ID? Example: ABC12345 and when i add 2 new records , it will update ABC1236 and ABC1237
How to paste google ad code
How to paste google ad code on my website . Do i need to add any tags or anything like that
Lookup field not pulling lookup field of secondary form
I am creating a lookup field in a form. The lookup goes to the second form to find values; for display purposes, the lookup field on the main form won't display the lookup fields of the second form. Is there a way to overcome this? Thanks.
Auto delete records based on amount of records and age
Hi there, in our Creator dashboard we have hundreds of apps, each app has a form and a report. Most reports now have several hundred records each - managing and clearing these out when we start to run out of space is becoming a monstrous job therefore I'm looking to create a couple of clever little delete functions to help me out. For a bit of background, we use creator in order to take and send messages to clients, the form uses a sendmail function to email the client, the report is used as a history
Chat Bar in Zoho Creator
Apologies for this probably very basic question. Is there any way to permanently disable the chat bar from taking space at the bottom of the browser window? You can collapse the bar to the left by clicking << but it comes back every time our users return to Zoho Creator. Many thanks in advance.
EPSON Printer
Hi, Is it possible to print a record on a epson printer? FOr a receipt? Thanks!
Push CRM Attachments to Creator
Is it possible to push all Zoho CRM products attachments to Zoho Creator? For ex: I want the attachments in 'Zoho CRM Products' to be uploaded in Zoho Creator Form file upload field.
Easy CSS Styles for your forms
Hi ZC users, Just whipped up a little ZC function that makes it super easy to customize the look of ALL your forms in all your applications. I got tired of having to make markup changes in many, many html views and links when using the customization parameters. Here's the code.. Also, this is up on the marketplace as well. string style.getFormStyle() { /* Author : -Stephen Rhyne -Owner -Rhyne Design -stephen@stephenrhyne.com -http://stephenrhyne.com Created : 11-25-09 Version : 1 Copyrights :
if a total amount over the past 31 days is ..
Hello, is there any guru to help me out with that How could i script the following : if a total amount over the past 31 days is then.. I totaly lost at it thank you in advance
if and period of time
Hello there, Does anyone to give a hand with the "if" and a certain period of time and a quantity fetch if over the last 10 days the quantity is > than 10" { } in fact i want to condition my if to a period of time && to a quantity thank you many time in advance buddies
Workflow Automation Task
Hi I would like to ask for some help or idea on how to maximize the use of Workflow Automation, I've created some workflow process and has instant action for the tasks, but I have more than 5 tasks which limits me to add more tasks on each workflow process. Any recommendation on how to add more tasks? Also how to create Pipeline stages like on Insightly? Is it possible here in Zoho? Thank you in advance. Regards, Arvin
Dashboard
Hi All, Can someone help me with the code to a simple but beautiful dashboard? I need to display 6 reports and 2 charts. Thanks in advance
Fields
Hi all, Is it possible to have 3 fields: Price: Discount: Total: (Price - discount) If yes how do i do it? is it with a function? Thanks!
How to autofill a single line with a record from subform based on latest added time?
Hi all, so I have a main form call PO_Update. in the main form, i have a Subform called Update_Detail. Subform Update_Detail has Update_Detail_DateTime, Update_Status, Update_Note. on PO_Update form, I want to show Latest_Status that is a latest record from Update_Status sort by Update_Detail_DateTime. please help me what to do to autofill this Latest_Status automatically? Thank you in advance
Summary Report PopUp Width Setting?
Hi. I am using a summary report in conjunction with a normal list report. When you click on a row in the list, it popup displays the associated summary report (invoice). Is there a way to control the width of the popped up summary report. It seems to fixed at 50% width of screen. Has anyone found a workaround to display larger widths? Thanks in advance.
Custom actions
Hi all, Can someone help me with the code for transfering "pendig orders" to "ready to deliver orders" ? With a custom action button "ready", and is it possible for the app to automatically add the date i pressed the "ready" button? Ex: I pressed "ready" today, the app automatically adds the date to a "ready date" field? Thanks all, i really need this!
update a field in subform
HI Does any one knows how could i update a field in a subform ? The system refuses it it s very frustrating have a good week end
Merging Unique ID to mail document
Here is the situation: I have a lot of members and I will ask them to update their records: name telephone etc. I can export all data to a spreadsheet. I want to merge the unique ID so they individually can correct the data. When I try to merge in MS Word I simply get the message: cannot open website. Here is an example of a URL I want a member to access: https://app.zohocreator.com/fluiddanmark/favrskovgym60plus/#Form:Kontakter?recLinkID=3069380000000373191&viewLinkName=Medlemmer What would be easy
iframe size dynamically?
Hello. I already see on the forum many similar questions but may be u fixed that. I would like to have the form's height change dynamically, as the content within the frame's height changes without scrolling iframe. Thanks!
Restricting View For Calendar
Hello, I have created a calendar report that is based upon a CUSTOMER form that contains information such as... Assessment Date Assessment Time Support 1 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Support 2 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Rep 1 (once confirmed, ADMIN then assigns the lead to a representative) Rep 2 (once confirmed, ADMIN then assigns the lead to a second representative
Limit data displayed in field in report
Hi - I have a report with a comments field that sometimes gets quite lengthy. I don't want to limit the input on that field, but when I display it in a report, that field can make the row for the record take up most of the page. Is there anyway to truncate the amount of information displayed for a given field in a report? Basically want to keep my reports crisp looking without limiting the underlying data in the form. Thanks.
Fields
Hi all, Can i create a field with block in it? more like separating the filed in lets say 5 blocks for the user to put data in the blocks Thanks.
Cash register
Hi all, Is there a possibility to have a cash register with zoho creator? Where simply i can get a record and print out a receipt with a epson printer? Thanks!!
Upload File to Google Drive
Hello, Is there any way to have the "Upload File" button in Zoho Creator push the uploaded file to a Google Drive folder directly? Thanks.
Mobile app Zoho creator
Hi, Can the mobile app be customized like the web app? for example the layout or icons?
Record Summary to Display Collected Data
The Record Summary is a GREAT feature, and I was wondering if, after we've designed a Record Summary, if it was possible to use this Record Summary as a way to view data, such as List, Summary, or Calendar views? The major issue is I have multiple fields of data and I would like to view all of the fields at the same time, as opposed to having to scroll horizontally (as in List and Spreadsheet view) or vertically (as in Summary view). The Summary view is the one that comes close, as the List and
Customize Text
Hi all, Can i customize the text you see when you update and/or delete a record? When you add a record you can customize the text "Data successfully added". Is it the same for update,delete,modify? Thanks!
report on creator
hello india ! I have created several reports based on different part of a same form Is it possible when i edit (update) a report to show only the corresponding part of the form without showing the entirer form? thank you in advance
break one field into many
I want to split one field into two.How Can I do that : for example I have a field name Company Name: Kader rahman tonmoy I want to split first word under FIrst Name and rest of the string under Last Name Like below : First Name :Kader Last Name: rahman tonmoy How can I solve my problem or Which string function I need to use?
Webhooks - Update Creator Record from ZOHO People
Hi All, I have a CREATOR application that gets populated whenever a new Employee Record is added in ZOHO People. I have used Webhooks and Creator ADD API for this. It works fine. Now, I want to UPDATE the Creator Record whenever the Employee Record is Updated in ZOHO People. I have used Creator UPDATE API. It does not seem to be working fine. I am getting the below Error, that says no CRITERIA is specified. <response><result><form name="E"><update><criteria>null</criteria><newvalues><field name="Email"><value>krithika@langoor.com</value></field><field
the latest date
hello there :) I have got a little problem, something i can't find out I would like to code in terms of deluge the following : " Find the latest data submitted for this field" in order words, my criteria must based on the date of submission. ( fetch) thank you in advance
Beautifying Zoho Creator forms
Hi I've been working with Zoho for a while now and one thing I always find is that the forms are just FUGLY. But I was really impressed by this one: https://www.zoho.com/creator/help/getting-started/register-with-zoho.html Can anybody share the code for this, or something similar, so I can see how it was done? Also very glad to receive links to any other beautiful Zoho Creator forms others might have produced.
Adjust Quantity in lookup record based on quantity selected in parent record
I would like to adjust the inventory quantity of a product based on the quantity selected in the parent Order form. is this possible? If so please explain with example code or concept. Thank you!
Is there any way to insert arbitrary number of rows in a custom module in one click via custom function(s)?
Hi, I have a custom module called Vouchers which holds number of unique alphanumeric voucher codes for an account. The problem for me is sometimes I might have to create more than 100 number of unique vouchers on one click. Now, when I go to add vouchers from Voucher module and choose the account and enter number for vouchers to be created then entered number of unique vouchers should be automatically created. I am not handy in building custom functions at the moment. However, lets say I grab number
COMPOSITE PRIMARY KEY
My form has three fields A,B,C forming a composite key. How do I enforce an "on add" script so mass-loading of data will be filtered: only lines with composite key A+B+C that are unique and not duplicating existing records will be inserted? Thanks! I have researched this before but there seems to be no answer to this questions.
Mail Merge with Zoho Creator
If you are looking for an easy method to create a Mail merge of the Form data you have, please use send mail task. Check out https://help.creator.zoho.com/Send-mail.html Creating Advanced Mail merge process (to generate PDF of Form data) involves the following components in Zoho Creator. It becomes mandatory to have some basic ideas about them. Data View HTML View/Page Fetching records from the Form Functions Custom Actions 1. Create a Data View: Data Views in Zoho Creator are used to display the
"Where used " for a field
For any field in a Zoho Creator Form, I wanted to find out where it is used: in functions, workflows, custom actions etc... how can this be achieved from the developer side ? can you add this function for us developers if this does not exist today?
appearing on filter name
Hi - I have a Customer form that collects First_Name and Last_Name of customers. I have a separate form for Orders, that uses a look-up field from the Customer form that combines First_Name and Last_Name, called Customer_Name. On the Order report, I have a filter for Customer_Name. The Customer_Name appears just fine on the filter, but once I select it, the Customer_Name appears as "LastName, FirstName" --- any idea why it would be adding the in there? It should read Last_Name, First_Name,
Custom-action button at beginning of line
I designed some "custom action" buttons to use for lines in a form. The button for each line/record is always placed at the end of each record display. How can I move it to the end of the line display in a report? Thanks.
Next Page