Conditional logic - how can I create an if/then situation for two fields
I need to correlate tree height with tree diameter. For example, if a tree is 5 feet/metres tall, the diameter has to be at above 12 inches/100 centimetres. If the correlation doesn't work, I would like the entry rejected or appear with a warning. Any ideas! Thank you in advance for any help.
Script to upload image files
I need a deluge script that will upload an image files from a local drive into a image fields with minimal user input. Any suggestions? Is this possible?
C5 Page/Dashboard - Configure action when clicking a panel
Is it possible to configure the action when clicking a dashboard panel to open the underlying report but to set the same filters used in the panel configuration? Ex. a dashboard shows the COUNT of events where an action button is not marked. Can I set the Action to open the report with the same filter? Thanks
Sending MMS text to avoid concatenation issues
Greetings, When sending text messages longer than 160 characters you may run into situations where certain carriers (Sprint and Verizon in particular) are not able to receive the text as one message, rather it breaks it up into multiple texts, and often out of order. One solution to get around this issue is to send the message as MMS (Multimedia Messaging Service) instead of SMS (Short Message Service). See link for more details on the concatenate issue and possible work arounds - https://www.smallbusinesstech.net/concatenated-sms/.
Is there a way to determine the context a form is being used?
In other words, in Deluge, can I tell if the form is running natively or is embedded in an iframe?
Zoho Integration
Hi, Is it possible to integrate a Zoho Creator App with a local database? I want Zoho Creator to INSERT/UPDATE/DELETE records into a local database and viceversa. Thank you
Printing In Creator
What can be done in Creator to expand on the few Printing options available by default? Is there a good training resource I can study for this? For example, our DB has over 25 columns but obliviously, they will not print on a single page and some users may only need a certain amount of information printed. Looking for resources on how to expand on this for customized prints.
Accumulative sum in a view
Hi everyone. I want to have a column in a view that shows the accumulative sum of another column in every row. In excel I often do that using a formula, like this: B1= A1 B2=+B1+A2 B3=+B2+A3 and so on I want to have a ledger account like view, actually How can I do that in zc?
How to build business form and other documents in your own format quickly
Hi guys, Let me share a tip to develop original business form and document such as invoice or receipt in Zoho creator. Problem: When you have to write a template of invoice with HTML in Zoho creator / Deluge script, what you would do is to write a function to return HTML strings so that the invoice would be generated dynamically with client name, product and whatever. Here is an example of codes from generateInvoice function of Order Management app provided by Zoho officially. This function will
Error exporting record summary to PDF
Is anyone else experiencing errors when exporting a custom record summry to PDF? I have this problem only in some entries, the PDF file downloaded in 0kb. Anyone that knows if it´s a problem with my script or with the platform? Thanks
When i sent image in gmail from zoho creator using send mail syntax Then automatic create an prefix link thats why my image is broken.
I want to send email from zoho creator. With image. Image host is zoho creator. When i sent mail with image then automatically create a prefix link. Full image link... src="https://ci3.googleusercontent.com/proxy/f86V7f5U9NscSYF1yYVxom8RrynozrJNCS6MkwnIIJo7A1aY1mT43LJQv4Pm_cYnEbJPuiBkvyiSbCQwnE5L49leLepxNAcCv9lF8dMhQr2B16aFDlM69ZR5OvNduWaWJmMkkX3tnWzRCBYO6cptpZmHqtiyuvMn2ED4hP_l7sg6L1fUuIJeh3yVEiq5_frXVCzvNl1W9l41K-EAih34nL-Iie0BZB3Vxt7mV9YDUvYhLyAhkIe5GQx4g_6xLQu-=s0-d-e1-ft#https://creatorexport.zoho.com/ferkosfinejewelry/order-management-by-misba/Add_Product_Report/3498482000000099036/Product_Image/image-download/1513632387666_R11002YW.jpg"
Report using a script to calculate Subform data
Hi Experts, I would have liked to be able to add a button to my form so that we can automatically add multiple entries to a subform but a search of the forum indicates it's not possible. Please tell me if I am wrong :-) (Add a start date & number of weeks to the main form, press button and then it then adds an entry for each week [on a Monday] to the subform) On the strong assumption that it's not possible I have a requirement to create a report showing bookings by week/month but that detail is not
Identify Workers Not Assigned Any Tasks
Hi - I have an application that assigns tasks to workers. Form 1 collects the employee name, and Form 2 assigns tasks with due dates to employees, using a lookup field from Form 1. I would like to create a report or page that identifies any employees who do not have any tasks assigned to them. Please let me know if you have a solution to do this. Thanks.
Trying to set a rule that if a cell is blank, to pull in the number from another cell in the record - help! :)
Hi all, I am currently mapping out daily sales of different products on an hourly basis to start to get a feel of sales velocity. This data is recorded on an hourly basis per product, under ascending fields named stock_remaining_1, stock_remaining_2, stock_remaining_3 etc... I am looking for help with a formula or rule that will state the following: if stock_remaining_3 is blank, then add the number found in stock_remaining_2 Any ideas would be super helpful - I don't mind if this is a rule added
Is it possible to mass export to PDF a pivot table report for all the different values from user filter?
I created a special report using pivot table and have filtered the different clients using a user filter. Is it possible to generate the reports for all registared clients? Either to export to PDF or print all with one command? If not I will have to generate the report for each client and export/print each one. Thanks,
how can i print or export a list of tables and fields
i would like to get a complete list of fields in the database w/o exporting each table. any ideas appreciated. ty
Iframes and Wordpress
I have a Web Site created with Wordpress. I have embedded a User Input form and an Output Report into a page on the website. Essentially the User of my web site enters data for a query and then clicks the "Submit" button. The Zoho Creator does the various calculations and search functions and should then populate the Output Report. The User Input form is in an IFrame and the Output Report is in it's own IFrame and they are both displayed on the same page of my web site. My problem is that the
Emails from my domain
Can I send emails from Creator that appear to come directly from my domain?
How to set the Title on the PAGE View
Hello, How do I set the title of the html page in the PAGE View? It looks like the default is "Zoho Creator - Page Name" Is there a way to change that? Thanks David
Zoho Creator integration with Books
I have created custom applications in Zoho Creator for billing customers, and sending purchase orders to vendors. Some of these orders have more than 1,000 line items each order. I need to reconcile the credits/debits back to Books. So some integration is needed. Has someone done this and/or can I get some directions on where to start? Thanks.
Add signature to different records at the same time or with deluge
Is there a way to add the same signature to different records at the same time on Zoho Creator, or add signatrue with deluge?
Is it possible to embed a pivot table report into a record summary?
Hello, I am trying to build a record summary that includes a report I have already created in the record summary along with other information. Is it possible? Thanks
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Insert into returning lookup ID instead of value
I am creating records on a secondary form on submit and everything works great except the client field, since is a lookup field on the main form, it is inserting the ID into the secondary form record, can you please help me telling me how to convert the ID to value? [ Added_User = zoho.loginuser Cliente = Cliente (this is a lookup field) Codigo = Paquetes_sub.Codigo Telefono = Telefono Paquete = Paquetes_sub.Paquete Fecha_de_vencimiento = Paquetes_sub.Fecha_vencimiento Servicios_disponibles = 2 Saldo
Performing a Look-up within a Function
Hi - I'm having trouble fetching a string value in conjunction with a Function that uses a Form Object Argument. I have a Tasks Form that uses a look-up to Project_Name from another form....once a Task is Completed I would like to be able to press a custom action button to have it marked completed and logged in a separate Project_Notes form. The code below is working but it is giving me a numerical value for the Project_Name in the confirmation email. Normally I'd do a look-up but this doesn't
iframe is blank
tried using an iframe but it does not seem to work, i tried using a simple url but it is also blank, anyone has any ideas? htmlpage Search() content <%{ %> <iframe name="frameSearch" src="http://www.google.com/" width="500" height="250"></iframe> <% }%>
Field Alignment
Hi, I have a 2 column form that contains say 20 fields, 10 on each side. Fields in column 1 relate to the fields opposite in column 2. Field 1a Field 1b Field 2a Field 2b However, at the top of the form I need to insert an additional field called 'Selection' my problem then is this.... Selection Field 1a Field 1a Field 2a Field 2a Is there a way I can insert a hidden field at the top of column 2 to even up the fields? Ive noticed that while Zoho CRM has
Deleting entries in lookup form
If an entry in a form is used in another form as a lookup field, I can still delete the original entry in the original form. This is counter-intuitive or is a bug.... How can something that's used in another form be deleted itself? Then this invalidates the reference. Someone shed some light on this? Thanks.
How do I make a text statement that users must accept before the form can be submitted e.g. a disclaimer for liability?
Hi I'm making a form that can be filled in by my clients to record their information. In my line of work, my industry regulator requires that clients be informed about costs, and the nature and limits of the work that can be undertaken. The text is about 500 words and they must read it and agree to the terms before I can start work for them. How do I create a text statement that is coupled with an accept or decline button.
Simulate "submit"
Hi I need to simulate "submit" for all entries in a form. How can this be done with deluge script? Some fields only populate on "edit success" so it's tedious to do them one by one manually.
Is it possible to display an image (siganature) from another form as an image in a form?
I am building a form where the user will collect information form a registered user in the app. I would like to have the user´s registered siganture shown in the form in order to compare with the signature collected at the time the form is filled.
Script to edit all form names?
I have a collection of applications, each with several form names containing the string "easy": EasyPlus EasyBall etc... I'm wondering if there is some way (using a function or otherwise), to loop through all the form names in an application and replace part of the form name; in this case, each "easy" to "busy." So upon execute, the names of the forms above would change to: BusyPlus BusyBall etc... Thanks,
Using New ZOHO CURL REST APIs in Creator
Hello, this Post will show the way i use to PUSH, GET, UPDATE and so on, Data from the Creator Deluge Script to for example the New Zoho DESK API via PHP-Script. My Deluge code example to add a Ticket in Zoho Desk: urltwo = "http://YourURL.com/phpfile.php?value=60¶m=" + TicketID + "&string="; StringRec = "{ \"secondsSpent\" : \"0\", \"executedTime\" : \"" + thisapp.GetDataFromDesk.TimeStringForTimeEntry() + "\", \"customFields\" : { \"TaskID\" :
Number of rows per page
I found that I need to have more than 200 rows to work with some times in a Zoho Creator Report. Can you guys increase the 200-lines limit? Thanks.
how to add entry to subform (via CSV) and associate this entry with mainform?
hi! there is mainform with subform how to add entry to subform via import (CSV) and automatically associate this entry with mainform's entry ?
What is the fastest way to delete 17,000 records?
Deleting 17,000 records in groups of 200 is not working. Is there a faster way?
Form where users can edit their own records
I have several users - not zoho creator users - who each have individual records. I would like to give them access to edit their own data. What is the proper way to do it, and which resources can I draw on to get insight to this facility. To be more precise - I have signed people up to a conference with workshops, and now I have all my workshops in place, so I would like to send an email to all attendees asking them to choose the workshop they would like to join. I would not want them to go to the
Best data storage / method to use with Zoho Creator
We have a large amount of data currently stored in Excel sheets, we would like to reference this data in Creator and we're looking for the best service/method to do this. Our stored data is fairly large (can be in excess of 100s columns and rows per sheet), split across multiple data-sets (sheets). We believe it is not suitable for storage within Creator because each data-set has a unique number of rows and columns that could not be easily laid out into a SubForm etc So instead, we are thinking
Convert string to number in formula for total sum.
Hey all, thanks for the helpful response for my last question. Hopefully this one will be a just as painless. I'm trying to take the sum of 4 string values in order to calculate a total. I know in order to do this I need to convert those string values to numeric values however I seem to be missing something. Tonumber(Sum1) + Tonumber(Sum2) returns: Tonumber cannot be resolved. I've also tried, Sum1.toLong + Sum2.toLong returns: Variable 'Sum1' is not declared Thanks in advance!
How do I remove time from dates
I have three different date fields in my database and all have a time associated with them. I do not need times included. Is there any easy way to remove the timestamp from each?
Next Page