Record Summary Alignment/Paragraph
Hello All: I have not used record summaries much to this point and am running into two issues with a proposal form I am setting up. When I set up an image or paragraph to be centered, it is not centered on the page when printed. I selected letter size for the record summary but it is still off. Also, I have a paragraph that is cutting of the last couple of words on each line on the right side of the paragraph. It doesn't seem like it is wrapping the text correctly. Any insight would be greatly
Zoho Creator on an Iphone crashes when entering a Date-Time field in a subform
Hi there, I have a form which has a subform that captures two Date-Time fields on each subform record. It works fine on Android phones and a desktop, but on an Iphone the minute I enter the first Date_Time field, the app crashes. Any thoughts?
Only getting one record returned in my Page script
Hello, I am having a hard time figuring out this script for a page I am creating. As far as I can tell, it should be returning several values, but I only get one record returned. I am trying to get all the expenses for owner Kathi and show the payee and amount. When I write my script and access the page, I only get the last record to appear in the table. I do not understand. Can you look at my script and tell me what I might be doing wrong? htmlpage expense_test() displayname = "expense test"
Old records
Lets say that we are May 1st. I want to see records that are before April 15th. So I want to see the records before the last 15 days. Is it possible? Thank you
Auto-populate Sub-form Value
Hie , Have Three Forms A, B, C In Form C have 2 Single Line Fields In Form B have 2 Lookup Fields , a1 and b1(Based On Form C) In Form A have Sub-form (Based on Form B) whenever any customer fills Form A with Sub-form ,when value of a1 entered, automatically b1 value will auto-populate How we can achieve this? Thank you in Advance !!
How to fetch records from a separate application
Hello, I would like to fetch records from a separate application. Here is an example: ApplicationA: "Form1" has fields: Name1, Email1, Department1 ApplicationB: "Form2" has fields: Name2 and Email2 --> Name2 is my lookup field. --> When I lookup a name, I want Email2 to automatically populate from Application A field Email1. How do I do this? Please give me an example. Thank you.
adding an image in a scheduled email dynamically
Project overview: How do i add an image that is stored in a form using the scheduled email workflow. The image is stored in the "offer" form and when entering the customer info we use a lookup field to connect the image that will be embedded. We enter order information into a form "Customer" so that we can send out a specific email XX days after the order shipped. My struggles 1 How do i add the embedded image in the email dynamically? Do i add the code in the email notice 2 when i rough tested
Typical Responses of Zoho Creator support Folks - #FRUSTRATION
Zoho Creator Team, Here are few typical problems I frequently run into - 1. Un-promptness - Support folks usually don't respond quickly - Reason: They are working on multiple chat sessions Evidence - are you there Vinod? 5:46 PM Hey... are you there!!!!!???? Vinod Chandrasekaran Yes,I'm here Please give me a moment. saurabh570 u already ate your time ... Story repeats.. saurabh570 it is 1 record at a time I will be able to show properly with screen sharing 5:52 PM are you good for that?
Graphs on Record Summary/Template
Hi all, Is it possible to insert graphs on a Record/Summary Template? I need to create a record summary to display some medical results on the first page, and a graph with potential risks according to the results on the second page. I'm using Creator 5.
Subform Lookup Field - no search option on mobile device
We have a Creator form which has a Subform. The Subform has a Lookup field linked to another module. That other module has over 800 records. When selecting the Lookup field value on the Web/Desktop interface, user can start typing text and selections will filter based on contains text. But on Mobile device/Creator App, this is not possible? User must scroll and find only using very big list. Please advise if there exist a workaround.
iPhone app does not work
Hello everybody, I use Zoho Creator (great app) and I wanted to also use it from my iPhone. I installed the last version, logged in and ... nothing. The app seems to reset to the initial state (little button to login at the bottom of the screen). Can you help me out? iPhone 7, iOS 11.3.1, Zoho Creator 5.9.4
Send Confirmation Email from Email Address other than zoho.adminuserid
Can anyone recommend a deluge approach (or 3rd party plugin approach) to allow for sending from any outside email address (smtp, etc...) other than from deluge defaults of zoho.adminuserid and zoho.loginuserid ??? Surely there is a method to call email functionality from outside zoho?
Dynamic Function Calls
Is there any intention to support dynamic function calling in deluge scripting. Example: x = "functionName"; r = callFunction(x, parm1, parm2); I think this feature is very important especially used to pass callback functions.
Search interface for dummies?... Please?....
I need a simple search interface to allow users to search one field at a time. I've found the "search function" template, I've created a stateless form, I just can't get it to work. I know the field I want to search. I just want the button click script to return records containing a matching term in the field. Maddeningly simple but I can't navigate the HTML and scripting needed. I know it is possible to use the search function in the list view. It's a lovely function. However I need the simple search
Add time on the x axis of the page's graph
Hello, I use Creator 5, and I would like to be able to insert the time's fields on the x axis of the graphs on the pages. Actually I see only other field's type (number, text, ecc.). Thanks Best regards
How can i restrict visibility in a page?
I want to restrict the visibility of a page from some users, but in the page builder dont appear "Restrict Visibility" as in a Report.
Don't share data with other users
Hi guys, I'm evaluating Zoho Creator and trying to understand if it fits my use case. Let's assume that I have my Entity: Customer (id, name, address) And this application users: Steve Jobs (Role: user) Bill Gates (Role: user) Elon Musk (Role: admin) I want that Jobs and Gates only see customers added by themselves while Musk can see all customers (with the detail of who added the customer). Is this possible with Zoho Creator? With the free trial I can't add any role so I can't understand if it is
SMS Reply
I can send SMS text messages, but is it possible to get simple SMS replies? Like to confirm a phone number? Or reply Yes, No, Cancel, or Stop?
Ask the Experts 2: Live Q&A: Find out all about the new Page Builder in Creator 5.
Hi everyone, As you all know, we recently released the latest version of Zoho Creator 5. The update includes features and enhancements that reduced the complexity involved in app building. One of our favorite enhancements is the new page builder. With the new Page Builder, creating interactive dashboards is extremely easy. It eliminates the need of coding in HTML or CSS — users can just drag and drop the elements they want onto the builder. Also, they can customize them by using a range of pre-built
Report with old record
Hi! I want to build a report that shows only the records that the "Last modified date" is greater than 15 days ago. Is it possible? Thnaks
link to live event?
How do I log in to here this live event?
Converting Month Numeric Value to Month Name
Is there a way to convert the number returned by getmonth() from the numeric value to the month name? I would think something like a built-in function or CASE OF statement but I don't see either of those as available. I could do it with a really long series of if/then statements but there has to be an easier way. Thanks! Parker Byron Network Administrator Kansas City Regional Homes, Inc.
How to display numbers as 6,000,000 in fields?
Hey, In excel I have a bunch of numbers written as 6,000,000 is it possible to have this same formatting in Zoho Creator? I can't find an option for it. Thanks, Dan
bigint * bigint gives "mismatch of data type expressions found"
Here is my script - ---------------------------------------------------- lineItemsCostWithTax = 0.0; lineItemsCostWithoutTax = 0.0; lineItemDiscount = 0; discountOnAllLineItems = 0; //Get details of the customer in current order detailsOfCustomerInCurrentOrder = Customers[ID == input.Customer]; selectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Select_Product.New_Product_Name; discForSelectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Discount_in_Rs; info
Subform field delimiter in reports
Hello. In the previous version of Creator, when I was designing a report with fields from a subform, I was able to specify a different delimiter for each field (with exception of the first one). Now in C5 I cannot find that functionality (it allows me to specify only one general delimiter, not one for each field). Is there a way to accomplish this in C5? And if the answer is "no", is there a way to go back to the previous Creator version? Thanks in advance.
Zoho Creator -- a product catalogue -- image links from Dropbox broken
I'd really like to use images from Dropbox in my product catalogue on Zoho ... so I only need to have one copy of a file for almost every application I use. I've tried adding ?raw=1 to my links from Dropbox to make the image embeddable, but I get broken image links displayed in my report. Dropbox image links are formulated like this https://www.dropbox.com/s/000000000000/test.jpg?raw=1 Is there a way I might be able to get Zoho Creator to display images from my Dropbox in a report? I could host all
subscriptions
i cant find a subscription window to upgrade my account because i am blocked because of over use! i want to upgrace but it is impossible!! very fustrating
Import old version application to Creator 5
I have a working application in old version. I want to install this application in new Creator 5. Is this possible?
How do you auto fill a lookup field based on input of previous lookup field?
I'm getting the following error when I try to auto-fill a second lookup field based on the information I entered into the first lookup field: Error at line number: 2 In Criteria left expression is of type STRING and right expression is of type BIGINTLIST and the operator == is not valid The data I'm trying to fetch is in the Commodity Codes form. The form I'm trying to input the data into is the Contract Summary form. Commodity Codes (form fields) Commodity_Codes1 (Number) Goods_Services_Category1
Printing Custom Reports - Headers and margins
Hi there, I'm developing an app and have a report with a custom printing template to automate the drawing up of agreements for clients. When I save or print the report, the margins and header are not set for any page apart from page 1. Is there a way to correct this? The idea is to generate a PDF in A4 which covers multiple pages. Any suggestions?
Customer Portal
I have created a customer portal with multiple forms & reports and two html pages - one containing an embedded form & report, and the other an invoice template. I have set all the Module-Level permissions to access for the report. The forms and reports can be accessed fine by the customer portal user, but when the portal user hits the html pages - they are prompted for another log-in? One thing of note - If I am logged in as a zoho user in another browser, they portal users can access the HTML
How can I print report from other forms with together
Dear, How can i print report format from other forms with together. eg. I have Fuel, Maintenance together as one report format in Transition -> all Expense Thanks
Fetching data from lookup field third level
How can i fetch third level field when is using lookup field (bigint) I have only use for String format for that field, not bigint. Field to fetch =========== Transaction -> WO_Customer Name Form ==== Customer - Customer Name Work Order -> WO_Customer Name Transaction
Is there a workaround for the date field language limitation on user level?
Hi, I have a client that uses Creator in Mexico. He has the basic user access and multilanguage option for the date field is not available. He needs to show dates in spanish. Is there a way to work around this limitation using code? Thanks
Military Time to Regular Time
Is there way to change the Time for Date-Time from Military Time to Regular Time?
New creator trying to do formulas and reports.
I'm working on a project for a client that is currently using Excel to generate numbers for charity donations based on a percentage on income linked to each client. I'm not sure where to begin to create a system in Zoho Creator. But here's what I have so far. I have a set of forms like charities, customers, payments, payment reports. When I enter a payment into the payments form, I need to push those numbers into another form, do some math based on linked entries. The end result needs to be a
Maximum number of components allowed
I received this error message. What are the limits? How do I see a list of the published components. I'm sure in this application there are some that do not need to be published. Maximum number of components allowed to publish for your account has been exceeded.
Zoho Inventory and zoho creator
Hi I need help in integrating zoho creator with zoho inventory. Kindly let me know.
Populate multi select with filtered concatenated values from other form
Is it possible to populate a multi select (list) field with concatenated values retrieved from a 2nd form? Fact pattern: 1. Form A (Master) includes fields for field number, lot, grower, crop (collectively referred to as a Planting). 2. Form B (Timecard) includes fields for field number and a multi select which I would like to populate with Planting. Example: 1. Master includes records as follows: Field Number Lot Grower Crop Ranch A 123 A Taylor Iceberg Ranch A
What, if any, differences/limitations are there in having a lookup between apps as opposed to form to form inside a single app?
Curious what differences there are for some planning we are doing. Thanks, Brady
Next Page