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
App DNA, the Zoho Creator 5 Youtube Channel for newbies...
Hi guys, Once again, I will never understand Zoho and its communication especially regarding Creator. Zoho created a new Youtube channel but won't promote it anywhere, unless I miss it. I discover that channel trying to find infos from people using Zoho Creator 5. The videos have a good approach but some portion of them are too fast or too titghly edited. Some improvements are expected but the idea is very good. So I invite all newbies to subscribe to this channel so they can go on providing tutos
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!
Discover Zoho Creator 5 at Zoholics 2018
Hello all! Zoho Creator's annual user conference, Zoholics Developers is all set to unfold on May 30-31 at our headquarters in Pleasanton, CA. The two day event will host keynote presentations by Zoho's top management, hands-on training on Creator 5, and one-on-one sessions with Zoho Creator experts! Who should come: If you're a new user, you should come to learn app building on Zoho Creator, meet with the product team and discuss solutions for your business. For existing users, this is an opportunity
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?
Subform
Good afternoon, I am trying to get the list of e-mail addresses from a subform Contact. Form : g_commande (= means order) Lookup field : Fournisseur (= means Supplier) Subform : Contact I submit the g_commande form for each new order. In this form, I have a lookup field to get the supplier name from a list. In the Suppliers form, I have a subform with all the contacts of the suppliers. When I submit the order, it must get all the e-mail of the suppliers that have the checkbox checked. I am doing
Creator 5 migration
We're new to Zoho Creator. Seems very good for our needs. We've done a great deal of work and were surprised to see we're already being moved to a new platform. Of course, things change and we do understand. Reading the support information about migrating to the new version, it mostly looks like front end changes, all fine. Would you please tell us the significant changes in the new version that might be challenging for migration of existing applications? What areas should we look at most closely?
The Lookup Field in Form is not there anymore
Hi, The Lookup Field in Form Builder is not there anymore, Can't create a join table... Thanks, Martin
Need help creating a quote form
I need to be able to look up a price based on the breed of dog and the service level(bath or groom). Ideally I would like to be able to select the breed from the dropdown, then select either bath or groom and the price would then populate. I have tried this several different ways. I created a table where the record name is "breed - service) and includes a price field. Created another table of just breeds and another of service levels. I then created a form that has a Breed lookup and a Service lookup,
Change language
Hello, I'm with C5. Before my creator GUI was in english. Now in C5, it is in french. I guess it has automatically detect my region and adjusted to it. I want to change to english.
Fields on CRM Integration
Hello, I'm trying to make a new form that integrates with my zoho crm (Potentials module) but i only get on creater a few fields from it, like potential name, stage, amount etc. How can i get all the fields? including the ones that i've created on my CRM? Thanks
Scatter chart rearranging
Hello, I have created a scatter chart with values on x-axis 70,80,90,100 which zoho creator automatically arranges in different order - 100, 70, 80, 90. Is there a way to rearrange it correctly and if not how should I adjust my data? I'm sure 99 instead of 100 would work for example but it is imperative that the last value reads "100". Thank you
ZC5 Functions Search
Hey Creator Team, The new search functionality in the functions view is really great only if it is working!
Form Data as Annual Calendar
I have a Multi_Select Field "Holidays" and I'm trying to find a way to present all the checked (true) items as a Year Calendar with the all the picked holidays probably as a filled cell on a grid. Any ideas how to accomplish this?
FreeFlow mode and change language with the new Creator 5 ?
Hi folks , first i've take a look to the new C5 but I would like to switch back what i've done but the problem now i got this message "Actions modified with the new builder cannot be edited here." btw i dind't any modifications. And did they have the freeflow mode in the new C5 because i'm a bit confuse how to use the new one and i have an app to finish soon.
How to get All field of user inputs of Zoho Creator App in Capital letters?
Hi All, I can get particular file input as capital using below script. (For example to get a Customer Name in Capital) mName=input.Customer_Name.toUpperCase(); if(mName != input.Customer_Name) { input.Customer_Name=mName; } I would like to know how to get all fields in Capital letters during user inputs & update ? Anybody tried common function that we can use in across all forms and pages of an Zoho creater app? Regards, Easwaran
Dates in panels in Creator 5
Panels don't allow fetching of date fields. Would like to show maximum and minimum dates.
Form Fields that dynamically change based on an input
I've a quality control form but depending on what product is selected the parameters to be entered change. e.g. If it's a screw it may be "Weight" and "Shiny Yes / No" but if its a bolt it may be "length" and "Number of imperfections". The parameters to be measured for each item are pre-known but may be of different types (number, select etc.) What's the best way to impliment this in Zoho Creator? I could just do many forms one for each item but that seems not elegant. Ideally I want one place
Is there a way to construct a file the user can download?
I have a fairly simple app I'd like to use with Zoho Creator if possible. Imagine you are putting names on the back of uniforms for a sports team. The names will all be in vinyl which is cut from a machine that can derive cut lines from a pretty simple SVG file. Creating a form to capture the list of names is easy and I know what the SVG syntax is to produce the file. What I can't figure out is 1) how do I create a file with a .SVG extension on it; and 2) how do I give the user an option to download
Report Criteria Uses Functions
Hello, It seems that filtering reports using a function in the filtering criteria returns back to work. I remember that this feature was discontinued but now, I see that it is again support. Are you intending to continue supporting this feature or shall we find other way to do the trick?
Cannot create a lookup relationship from a dropdown on another form?
Here's the simplest test I've tried and it won't work. I have a test form with a single dropdown box on it with 3 choices in it. I create a new form and insert a lookup field. On the Create Lookup Relation dialog, I choose the test app, the test form, but the dropdown from the first form is not available as a choice in the field column. Is this not possible or am I doing it wrong? In my live app, I need to be able to select some data on the second form from previously selected data on the first
Printing / PDFing a Notes Field
Hi folks, I'm recreating a simple signed client agreement within our app. I was hoping to pull in the client details, use the notes field type for the agreement text, and then use a signature box. The client needs a copy of the signed agreement, so a PDF of that record in the report seemed the way to go. However - the notes field isn't stored in the report, so it doesn't display in the record summary. Has anyone done this before? There must be a way of templating this so that we can PDF a copy of
Attachments not added to scheduled reports
Hi - we have a number of reports that are sent automatically as attachments to emails using Workflow>Schedules. They have worked fine for a long time but now the emails go out without the report being attached. The reports are attached when we do an "execute now" command, but not under the scheduled system. Any thoughts on how to correct this? Thanks.
How to fetch data from other application?
How can i fetch data from other Zoho Creator's application(same account) ?
Next Page