Zoho Creator: Recipe Builder
I am trying to develop a recipe builder which incorporates a function for the app to reflect the quantity of ingredients used according to the serving size of a recipe. May I inquire if there is a way to enter the serving size of the recipe and the quantity of the ingredients will update automatically for me to print it out as a recipe? Thank You
Fetching data for a form
I am new to zoho, I have imported data and made a form from that data. I am unable to get the field boxes on my form to formulate anything example: (fetch info for other fields if name is equal) and if I use the form, then it does not update the spreadsheet that I imported. Could someone help me understand please. If I have to make "another" form to use the database (which works) then it is not useful. Yes I have watched all the videos and nothing deals with this. the written guides make no sense
Problem in customer portal invitation template
Hi Team, I was not able to add image in the invitation template of the customer portal. It just says "Uploading Image" and not responding after that. Kindly assist me. Please find the screenshot of that problem in the attachments. Thanks Satya NHM
Edit field and make operations between 2 fields of different Table.
Could you help me? I want to add the "Number_Day_Requested" on request to "VACATIONS_YEAR" at Employee_Information after to sendmail. if(input.Status == "Approved") { sendmail [ from :zoho.adminuserid to :Employee_Information[ID == input.Employee].EMAIL subject :"Your request has been approved" message :"Congratulations!<div><br></div><div>Your request for time off from " + input.Begging_on + " to " + input.Ending_on + " has been approved.</div>" content type :HTML ] /* I want to add this
Dynamic Record Summaries
I would like to propose an improvement to the Record Summary templates used to generate PDFs and print. I propose to add functionality that allows a user to either flex which template is used based on a value in the record OR hide/show fields based on a value in the record Example: We have a master form and a master database that is used by multiple clients. Each client has a unique identifier that we pass into a text field. Based on this identifier we show/hide certain fields. We would like to be
Restrict record visibility in Report based on login id and a field.
Is it possible to restrict record visibility in Report based on login id and a field? e.g. To one set of users whole login ids I know (I can create a group from these specific users) I need to only display those records in a table where a CompanyField is set to "XXX" I can do it by making a separate Report for each such set & then restricting visibility for that full report. But that's cumbersome. Every time a new company happens I need to create a new report & manually copy all my conditional
Zoho creator api - search view returns var variable instead of json
I am trying to search a view the following api call. https://creator.zoho.com/api/json/app-name/view/Books_Invoice_Report?authtoken=xxxxxxxx&scope=creatorapi&zc_ownername=xxxx&criteria=(Invoice_ID="127624000019543065") The return value should be json. But the result is like a java code like this. var zohomarkozivkoview70 = {"Books_Invoice":[{"Status":"sent","Due_Date":"12.12.2017","Customer_Name":"Radica Goran dr.med.dent.","Salesperson_Name":"Josipa Guzanović","Sub_Total":"kn 85.50","Invoice_Number":"2017-1-5088","Invoice_ID":127624000019543065,"Salesperson_ID":127624000013211099,"Invoice_Date":"12.12.2017","Customer_ID2":127624000000145967,"Customer_ID":127624000000145967,"Invoice_Amount":"kn
Need help in passing data from one form to another
I have two forms: New_Interns and Intern_Updates. Both forms have the field "Questionnaire_Complete" with values of Yes or No. I wanted to have my interns access the form, "Intern Updates" and complete that question "Questionnaire_Complete" with a Yes value when they have completed that exercise and then pass that value into the report generated from the New_Intern Form. Not sure how to get that done...Any help would be greatly appreciated :)
Pull data from a currency field on previous record
Hello. I've been off Zoho for a couple years and can't recall a few things. I'm trying to create a simple checkbook registry. On the form I have a "Beginning balance" currency field and an "Ending balance" currency field. I would like to pull the number from the "Ending balance" currency field from the previous record and input that in the "Beginning balance" currency field for the new record on the "On load" work flow line. Any help is appreciated. 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"
Missing fields in report builder for pivot table
Trying to create a pivot table based on an existing report - but many of the fields are missing in the report builder. I see the issue raised in the forum a year ago, but no solution.
Difference between view-perma & view-embed
What is the difference between view-perma & view-embed ? Also, What is the difference between form-perma & form-embed ?
Create multiple records with function add record
Hello, I would like to know if it is possible to do a function that allows me to create 10, 20,50 or 100 records at the same time. The records will be exactly the same. I would like to do it with this function: void funcion_comodin.Crear_comodin(Ficha_de_productos cn) { insert into Stock1 [ Added_User = zoho.loginuser Comprador = "Isaias" Condicion = "Nuevo" Destino = "MercadoLibre" Fecha = zoho.currentdate Imagen = cn.Imagen_del_producto
Record summary page header
Hi! I have a record summary based on an orders form wich also displays the order details. The order details is a subform of order form. It works great, but if i have many order details another page is generated. How should i have the order details header at the second page? Open the attachment to see what i mean. Thanks!
copy data from previous record
Hello. I would like to copy data from a field from the previous record to a field on a new record. Please help with coding. Thanks
1 week ago it worked perfectly. I open form from the page, when I close it, the sustem bounce me out to previouse page.
You can see it in your standard application "sales management". Click "All Accounts". click the button "View" (custom action). On the page click "New Contact" or "New Task".
Select multiple developers
I have 3 users set as developers. When I go the my application settings and choose developers, I am only allowed to choose 1 user. How can I have multiple developers?
Prefill form field based on last known (the form has a date field) value of that field
I want a way to seed a numeric field on a form with the last known value of that field. Is this possible? How can I achieve this? I suppose it is some sort of OnLoad deluge script? Any snippets?
Can I share an app while in my free trial period?
I set up an account today and am attempting to share an app with a colleague to discuss zoho creator as a potential solution but when I follow the directions here: https://www.zoho.com/creator/help/application/application-sharing.html#Share_with_individual_users/groups I receive the following message: errorMsg:Sharing failed! I'm trying to determine if this is a limitation of the, currently, free account or if I have failed to do something properly.
Removing Items from Lookup Fields as they are selected
Hi all, I'd love some guidance on the following: I have a form [Dependants] and there can be multiple records in the [Dependants] form that link to a master form [Main Member] through a unique value that I've created "Member Number"; so a many to one relationship. I have another form where I want to have the user see and select (one by one) all the Dependants linked to the one Main Member, however as they select one (easy to show them via lookup field), I want it to disappear from the next lookup
Referring to fields within "Add notes" field
I can get zoho to send emails with the body having references to fields e.g. <%=input.Customer_Name%> Now, for a certain workflow I need to display a body of text to the person filling the form (either dynamically as he fills in fields or on success) where the body of formatted text contains references to other fields within the form. i.e. not an email but directly displayed under the form page. "Add notes" lets me compose the text beautifully, but I haven't figured out how to include references
Compare two tables to verify the information of the first table and change the status
Hello I am new with creator and I have to decide if it works for my necessities. I have two tables: - Orders from Client - Product list (a list of a product I sell) Step 1 I receive from my clients orders with the following fields Client name Client Order number Date Product code (mine) Photo Step2 I need to compare the photo (and other info) on the order with the photo+ info inside my Product database. So I need list (grid to see more than one order at the time) that on one side shows me the order
Deluge Scripting - find rows with duplicate values
The FAQ on Deluge Scripting (copied below) indicates that there will be a code snippet, but the code snippet doesn't appear. Can anyone here provide the code? 9. Sometimes, my requirement is such that combination of a field has to be unique. For example, Name and DOB combination has to be unique. Is it possible to set that in GUI or script? It is possible to do it in script mode by writing an on submit script for the form. The "on submit" script gets executed before the data is persisted. In the
I need to know the code of the sample application.
Hello, Recently I use Zoho Creator to create an app for specimen management in my laboratory. I want to add a feature to create a label for each specimen that I checked in, and I find this sample application similar to my need (https://creator.zoho.com/sampleapps/preview-and-print ) However, I can't download or add this application to my application. I want to edit the application so I can see the deluge code. Please help
Add Record - API - PHP / Curl Script
Hi, I've been trying to figure this out for ages and have eventually resorted to asking for assistance. A really simple request: Does anyone have a sample of a php script which shows how to make a post to a Zoho Creator form using the Zoho Creator API interface? I can clearly see this exists for Zoho CRM and can easily get this to work. The same process does not work for Zoho Creator. I can also see that this question has been asked before without any real follow up, so hence my question now. Any
Users marked as inactive
Why does Zoho Creator randomly have errors with users? How do they get marked as inactive?
Schedules are not working, can not fetch more than 200 records from Zoho CRM to perform tasks.
I have got two issues. 1. Schedules are not working while I have got 500 limit available in my account. 2. I am trying to fetch records from potential module where the closing date is more than 30 days from today and update the stage according. It works for few records while few records are not changed even if they are matching the criteria given. I found that the issue is the index limit, you can only call 200 records at a time. However, I would like to perform this task on each record available
Error in executing zoho.books.getRecords
Hi - I have been using the following code for few months aWhere = "invoice_number=" + input.invoice; // Obtenemos el registro de la factura booksResults = zoho.books.getRecords("Invoices", "999999999", aWhere); Note: 999999999 is replaced for real value of my organization. // Obtenemos los datos propios de la factura invoiceMap = (booksResults.get("invoices")).toMap(); Today, i am now getting the following error; Error details: Error in executing On User Input script of Factura. Error. Error
Use Record Summary in a Page
Is it possible to have a record summary in a page? The record ID is a parameter for the page. What I want is to display the summary without the report eliminating the need for the user to click the record to see the summary.
Contacts Filter
I am building a Contacts app that contains; Postal Code, State,County,City. My requirement is to filter down with updating all the forms as I input or lookup. I am structuring as; Postal Code (form) >State (List Field)(Form) >Zone(form) >County(form) >City(formI have tried many ways to Bi Directional with Filters, but find doing double work at times. I am trying to determine the best way to handle 4 forms and filters at once. Postal Code (input field) State (Lookup Filter) County (input field) Zone(Lookup
Change Status of person with order
I need to change the status of a person based on an order. Eg labours field i have five labours ( 1 2 3 4 5)that have status "free" in radio section. While booking an order for a labour if i choose 3 inlook up field i would like his status to automatically change to "occupied" Would really appreciate if anyone could help me with this. Rachit Agarwal
Add entry into another form for each record in one form
Hello all, New to zoho creator and built one app for my company. Although I could get basics to work but stuck with one situation for now. Any assistance would be of great help. Here is the overview of my forms Users - (firstname, lastname, status, email, etc..etc..) System - (systemname, category, etc. etc.) Access - ( Users.email, System.systemname, access_status, access_date) There is one default system (Google apps) that every user will have access by default, so I want to create a script
How to import data from CRM to Creator Order Management
We have/use ZOHO CRM for a while now and have many customers. We are now just starting to think about order management. How do I get CRM Customer data to feed automatically from CRM to Order management? Thanks
formula that refers to a lookup field appears garbled as numbers
I have a lookup field that I want to access in another form as a lookup field. Directly this is not supported. So in the original form I added a Formula field that refers to the lookup field from the same form. Now I can indeed refer to it in the second form. But there seem to be numbers appearing instead of the names that are visible. i,e, A lookup field simply referred to by a formula appears as some internal number. Thoughts?
Daily backups not possible in zoho creator?
Can I not take daily scheduled backups in Zoho? I only see options for weekly monthly & yearly. Are these backups saving the App structure or the data? Or both?
Printing/Uploading PDFs with Deluge
My applications stores notices (letters, not emails) that are sent to various recipients. I can create the letter with code, but is it possible to print it and store it in a upload field with code?
Referring to fields of a record within function for Custom Actions for each record of a Report
I have created a custom action which displays a button next to each record, say, "Email record to user". I have successfully written a function & I'm getting the email. But how do I get it to email the record field details? Best I can do is this: In the function builder if I try to add an expression in the body I get variables under a "Collections" tab but I don't get how to use them. I have included the entire form as an input argument to the function as a "Form Object" I seem to only get an ID
Urgent Issue: Creator Forms have suddenly started throwing On Load Error. No response from support.
Hi, We are having an issue where a few forms in our application have started throwing the following error: Error Details Error occurred while executing on load script. This also affects forms on a separate application that was a prior instance of the current application and hasn't received any development updates for a few months. I've removed all On Load scripts and still receive the error. I've sent support an email and added edit access, but have not gotten a response. This is an urgent issue
Estimate Creation Form?
I came across a post from 5 years ago at https://help.zoho.com/portal/en/community/topic/submit-form-to-create-estimate and would like to know if there is a new and easy way to create a Zoho Form that will create a Zoho Estimate that can then be accepted and turned into an invoice. Most importantly I need the invoice to take the items from Zoho Inventory for the purchasing process. Is this possible and how? Steve
Back Orders
Hie , All items that don't ship should automatically transfer to the next order, based on back-order rules for each customer. How can i Imply that ??
Next Page