Send Email Function
In the old Creator (4), it was much easier to script and email. It seems more difficult now. I was trying to find a flaw in my email routine and it is much harder in C5. If I point to the line number next to the Send Email (Edit), it does nothing on click. I tried to re-create the same making another email script, but found no "Insert Fields" like the old. When I go to </> icon, it does bring up fields, but it is still difficult to enter something on the subject line like "Project: input.Project_Name".
Accessing a specific row's data in a subform
In my sub form i have several rows and I wish to access the last row inputted in order to send some of the info in it via email when the form is submitted (On Add -> On Success in the main form). I have tried using the script from this forum: https://help.zoho.com/portal/en/community/topic/subform-get-value-from-the-row-above My rows in the sub form ( AKA Actions_Taken) before the script is executed: Date ROW ID 4/21 1 4/22 2 4/23 3 4/24 4 My Script (I tried it both on the 'On Edit' -> 'On Success'
differrent "subform default entries" ON ADD and ON EDIT ?
does anybody know how to workaround this ?
Deleting data from forms
Hello, I am working in Zoho Creator and am a bit stuck. My app is for Production Inventory. The offered apps don't really fit my requirements. I have created 3 Forms to capture incoming goods that have unique serial numbers for each item: GNSS board, Camera and Antenna. I have also created a Form called Build Orders. This form allows me to gather the items needed for a production build. When I fill out the info in Build Orders, I have look up fields for GNSS boards, Camera and Antenna. This allows
Embed form translation
Hello, i have published a creator form, and i have included the embed code on the italian version of my website, and it works fine. Now i need to translate this form into other languages, is it possible do create embed code in different languages using the Creator app translation feature?
Accessing Subform Fields
I have added a subform to Zoho CRM. How do I access the fields that are in the subform both in Zoho CRM Workflows and Zoho Campaigns? I want to access them so I can use them in these apps.
Zoho Creator - Special field 'Integration' with CRM Potentials - How to get record ID and use to update other fields
Hi, I have used the Zoho Creator - built in special field 'Integration' to lookup CRM Potentials in a Form. Field name: 'Potential' Field link name: 'Potential' Im trying to get a deluge workflow right that will find the Record Id (Potential ID) from the Potential field as integrated already in the form. This would then allow updating other fields in the Zoho Creator form by populating the data from CRM record. So, this deluge scrip works in a workflow if specifying the potential ID: crmResp =
How to do a Mass Search on all reports?
Hello, I have several forms that ask for the same field. Example my License Holder form, Mail Box form and Subscriber form all ask for a "Name". I created a page so I can have all of my reports together but how can I do a mass search where everyone with the same name will pop up in EVERY report I have instead of individually looking through all of them?
Unusable Section
Hey Guys, I have an issue with a section under Settings> Sections. It is named Hidden_Application_Page _Section. It is greyed out and does not have the usual Edit, Show/Hide and Delete buttons. I can move Forms or Reports into the box but cannot take anything out of the box. I searched the Web for awhile but couldn't find anything to help. Thanks, Kevin
Auto populating 2 rows in subform
Hello everyone. I have subform with 'Product' lookup field (products are in Products form). I need to auto populate 2 of those products (e.g. packaging, shipping) on add on load - those 2 are everytime there. Any ideas how do the code should look like ? Thanks in advance...
Get a Integration Dropdown Field
Hello, I'm trying to do a simple thing, get the name or id from a integration field (integrated with my potential on my crm), the field works fine, gets all the names of my potentials. But im testing a way to get the id or name of the selected potentential on the selected name on the drop field and it says always that its null. I really need help in this. Check the prints: print 1 print 2 print 3
New Zoho Creator broke functionality in apps?
I haven't made any changes to my app in days but errors started popping up today. I see that the new Zoho Creator is being rolled out and I wonder if it has anything to do with it. My app has become essential to my sales process and now I'm stuck with this please help.
Filtering or Selecting a record from a ZOHO Pages view
Hi, I have a custom ZOHO Creator Page view. I would like to filter on this page based on a ID number. Either with the option to select the ID from the list of all records, or to input this number. Any help would be appreciated. thanks
Sub Form
I am enjoying the new Creator 5. I have one question. Is there anyway to move a subform to a single column. When I try it stubbornly insist on occupying all three. Thanks for your time....
Relationship Diagram between apps
Hi, I've divided the business process into a few different applications which depend on each other (lookups between them). The relationship diagram view is only showing relationships within one app. Will this be changed in the future?
How do I restrict access on a sharable report?
I want to share a set of reports. How do I make those accessible to view only and not edit?
Add record API to trigger Zapier
I'd like to add a record via API. I'm fairly competent with deluge but have no experience with API. So I copied and pasted/edited the info (from zoho API wiki) on "On Success" of a form <form method="POST" action="https://creator.zoho.com/api/sampleapps/xml/sample/form/Employee/record/add"> <input type="hidden" name ="authtoken" value="***************"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="Name" value="Gary"> <input type="text" name="DOB" value="12-Jun-1980">
View/Add comments in Desk
Hello, How can I actually view the comments from Zoho Desk in Zoho creator? htmlpage Show_Tickets() displayname = "Show Tickets" content <%{ lo = zoho.support.getrecords("Requests","MyApp","Maintenances"); for each single in lo { // I need to somehow fetch the comments here <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< } }%> And how to add a comment to a ticket via Zoho creator?
Tree view in C5
Hi, Is it possible to have a tree view, like in windows explorer?
Can I create a function to select a record summary for a report?
I have several record summary templates, which are invoice formats that depend on the customer. The basic information is the same for all, but for example, some need the invoices to have the PO numbers, others need the weight information, and so on. So whenever I have to print an invoice, I have to edit the application and choose manually which of the record summaries I want to activate. Is there a way to develop a function to display at the report header that would allow me to select (and change)
Custom Portal connected users
Hello, I use custom portal. Is there a way to know when users connect to my app? I want to have a report that show when users are connected in realtime. Thanks guys!
How to include original email after parsing required info from body
I need one quick email filter from Zoho Mail, can you assist? I want to trigger the filter on a new email coming into Zoho Mail. I will filter (I am able to do this so that only "Hapag Loyd" emails come through. This is what I need help with: I need to parse the incoming email body for a Bill of Lading number using regular expression search. I need to assign that extracted value (In this case "HLCUNG11803BPXY6", see * Below) to match against a sheet in Zoho Docs. (Attached) When the matching value
Localization ignores some values
Hi, we use a localized version of an internal creator app. C5 seems to ignore translated fields on sections, forms and reports. If we write the translations it'll just revert into the "auto" created translation. Fields on forms and reports seems to keep their translations so these works. Can anyone also reproduce this ? - is there a solution on the way ?
Filling data in a subform with a FIELD URL
I can not fill in the data of a subform (URL box) from its input. On add row row.Link_compra = input.Link_of_Mercadolibre1.tostring (); Both fields are URL Do you know what the error is? Thank you!
Update Current Account
My present version of Zoho Creator is so old. How can I update it to the current Version?
Context storage to store variables and modify a Page according to ths context
I have included a Stateless Form and a Report inside a zoho creator Page. I want to filter the records shown at the Report with the data introduced by the user at the Stateless Form. To do so ideally I would like to have a context API mechanism that allows to store variables, reload the page and fetch the variables from the context and filter then the Report so to show only certain records. is there such a context API in zoho Creator? Thanks in advance
Client login possible in zogo?
Hi, I have the following process: 1. Customer gets mail with question to login the system through a hyperlink 2. Customer logs into the system and is asked a question. Based on the answer (‘yes’) he is asked to add data (new employee data). When don, he is asked for another employee (yes, then add more data, no, then exit) 3. Confirmation mail to customer about data wntered 4. Mail to new employees with hyperlink to login system 5. Employee of customer logs in and answers a few questions 6. Data
"status": "Failure, Error occurred please contact application owner." when add a record via an API to Zoho Creator.
I tried to add record via an api to zoho creator form, using this link from postman : https://creator.zoho.com/api/info_kedubai/json/booking-form/form/Online_Reservation_QA/record/add?authtoken=*******************&scope=creatorapi I entered the value of each field with form-data in postman. The response status is 200 OK. But the status in the response is "Failure, Error occurred please contact application owner.". But when I checked the database the value is entered to the database. I already tried
Using field name and display field name is code
I have several form fields that require the same user validation in the On User Input sections. I have written a function to perform the validation and alert the user with a message. I want to give the display field name as a parameter to the function to use in the message. Is there some way to know what the display field name of a given field is in script? Otherwise, I will have to hard code the display field name in the code, which is pretty clunky.
Two-way linked view
I am in the process of migrating our old ZC applications to ZC5, and in order to clean up old design mistakes we are building the app again from scratch so as to have one "backend" app that contains all our global data, and then various frontend apps that will refer to the backend data. So far so good - my problem now is however, that when I in a frontend app refer to data in the backend that is again pointing to the front end, I can not create a linked view between two frontend reports within the
Inserting Images in to Zoho Creator Pages
I've been reading several articles and videos on how to add an image from a record to be displayed on a page when the record is requested. There seems to be three different ways to insert the image however no one has followed up if the suggested code changes worked. I'd like to know the simplest way to insert the image in to the Zoho Creator Page that will pull the users image and display it on the page with the rest of my content. Right now I'm testing this in the CRM Demo is Zoho Creator. SC
Fetch Books Contact ID by searching with form data
I am trying to retrieve the contact id for a customer selected in creator by searching contacts in books using form data as a search parameter. I do not know if it is a syntax error or what else i could be doing wrong. here is the code i am trying to use. newresp = zoho.books.getrecords("Contacts","12345678","contact_name=input.InvName"); detail = newresp.get("contacts").toJSONList().get(0).toMap(); customer_id = detail.get("contact_id"); info newresp; Any help would be appreciated.
Transitioning from Filemaker to Creator 5, basic questions
Hello. I was excited to see the mobile functionality of C5 and decided to rebuild my Filemaker app in Creator. I have so many questions, but the main ones I have right now are: 1) How can I test the app as a customer (not administrator)? Do I need a separate Creator account? Do I have to go so far as buying customer portal functionality? 2) I have a test score input form that my clients will use to update their latest scores (they can take the test repeatedly). Occasionally, I will update their scores
Showing/Hiding Labels
I have created an embedable widget in my zoho creator app for use on my website. When I use it, the title of the form and the label of the fields appear. I know how to style most of the items, but can't figure out how to style the button border, fields label and widget title. Help?
sum across fields
Hi i have these 2 forms to manage time spent with customers one is customer details and the other is time spent with each one the first form has a name field and a amount of hours pre-purchased the second form has a start date field(timestamp), a end date field(also a timestamp) , a lookup to customer field on the other form and a formula field that gives me the total time per record in second form form1 - customer details field NAME field TIME PURCHASED field HOURS REMAINING form2 - appointements
Access to application: Users&Permissions vs. Share
Giving access to user through Users&Permissions is preferable for me. I also understand that rules set in Users&Permissions override Share permissions, if used simultaneously. Question: After I added a user into Users list and assigned role and profile to him, why this user still don't see my application in his account? even with link to application, he doesn't have access.
Edit button for each row on a subform?
Is there any way to get/build an "Edit" button on each row of a subform so that clicking it would open that record in its own edit form window rather than having to inline edit the record? This must be pretty common, but I can't seem to find any good examples of how to accomplish it. I'm open to scripting, pages, whatever. I just need a way to do it. Thanks!
Pay for customers to use my site?
I'm a bit confused... What am I missing here? With most every online store, when making a purchase you have the option to create an account, or place order without account. If you create an account, you can then login and view your past and present orders. This is common practice and as a Store Owner, I do not have to pay anyone, anything, for customers who purchase from my store. Well, I've created a form in Zoho Creator that customers use to order Real Estate Signs. I have embedded this form on
iPad App Bug Opening Forms
There is a bug in the iPad Creator App that Zoho has been slow to fix so I'm hoping someone might have a suggestion or work-around. I have a Creator app developed to run on an iPad. We have training events and at the end of an event I want each participant acknowledge by signing on the iPad. The app opens a form for the first participants who signs, then it opens a form for the next participant, and on and on until all have signed. It opens each form with an openUrl call. This sequence of events
Display image in header
Hi, Is it possible to display an image in the top instead of the name of the app?
Next Page