Subforms : Clearing and only showing matching results in drop downs (pick lists)
I have a script that creates rows in an attendance subform when a training course is selected. So that I can add an employee to multiple courses. It works great, however there is a drop down for each course containing a list of modules - this currently shows every module for every course. I have been able to use deluge to only show modules that are related to the selected course - but this does not work in a subform for me. My Code : for each subRecord in input.attendee_subform { ModuleIDs =
Upcoming updates - July 2019
Hello App Creators, We’re here with another set of updates. During Jul-2019, the Zoho Creator team will be rolling out the following feature updates: subform.insert() and subform.clear() Zia-powered smart data import during form creation Ability to control rendering of HTML content in Formula field Lookup data from Radio and Drop down fields Setting background images for panels Here are the links to the recent posts in this series: Apr-2019 updates, May-June updates. Refer to our changelog for the
generate pdf of customized HTML contents using zoho creator deluge script
Hi Team, I am creating a request to send a set of HTML contents using SendMail function of zoho creator. I can send the HTML contents succesfully in email but along with that I want to do is to create a PDF file of that HTML contents & send it as an attachment from zoho creator's SendMail fucntion. Firstly is it possible.? If yes, how do I achieve this scenario.? Thanks & Regards Amit Thakkar
Can a embedded Form be passed different values depending on the Webpage that it is accessed from?
For instance, I have a website that allows the customer to select their sales agent and proceed to a page with an embedded Zoho Creator Form. Is there a way to prefill the sales agent information on the load of the embedded form? I know I can use redirect
Zoho still sending us spam mails
Lee Joseph from Zoho Creator (Lee Joseph <lee@zohocorp.com>) still keeps sending us spam mails, though we were told some weeks ago he would stop doing so. Can somebody please tell him to stop his spam mails? Thanks Juergen
Upcoming updates - August, 2020
Hello App Creators, We'll be rolling out the following updates this month: About upgrading to Creator 5 File preview in reports Displaying published components inside published pages External hosting for widgets, and more Supporting record templates in
Quotation marks in a string
I see this same question multiple times in the forum, but no answers. How do you set a string variable with a " embedded in it. I need the resulting string to be ... "text"... It cannot be a ' Help please, thanks!
I'm new and don't know where to start
I currently have a few applications built on Caspio and I am looking to migrate those applications to zoho. I have a large database of addresses that I want to build a custom search for, and I can't figure out where to start. I have imported my addresses
Creator and Zobot
My company has the whole umbrella of Zoho apps and are looking to fully integrate across the platform. We have used Zoho Creator to create our webspace and want to use a chatbot to interact with out clients using the power of deluge and zia... I really
Fetch records from Books especially the General Ledger accounts?
Hi there, I'm trying my hand at creating an app and I need some help in fetching records from Books but especially the general ledger accounts and cashbooks. I havent been able to find a reference to this. I would appreciate some help... Much thanks, Shawn
Can't access Creator Form from Edge or Chrome or Monzilla but can via IExplorer
I have a form created and has been running for years by another person. This morning they can no access it. Only the title comes up in the top left corner. I said to try other browsers to try and narrow the issues. Chrome - fail Edge - Fail Internet
Clicking on link in detail view brings me to blank page
I have my detail view for a report set up for clicking on a related item and going to that related item view. When that view shows up, I see it on the right side and on the left and background is the report view but it shows no records. I close the detail view of the related item and the page still shows the report with no records. I have to refresh the page for any records to show up. It should be showing records for me to click on after loading the related item detail view on the right. Also,
Updates - January, 2020
Hello App Creators, A very happy new year to all of you! The interactions we had with you last year made Creator's 2019 journey remarkable. And we'll be working hard to make sure Creator gets even better in 2020. We'd like to welcome you into the new year with some updates: Support for reading NFC tags Accessing apps as PWA - - - - - - - - - - Support for reading NFC tags Zoho Creator's native mobile apps can now read data stored in NDEF tags and input them in form fields. Learn more NDEF - NFC
Internet facing
Is it possible to have a Zoho Creator app internet facing with no login? If yes is there an add-on or cost to make that happen?
API V2 Issue for HTML Form Submit to Zoho Creator
Hi There We have multiple Html Form that use API V1 to submit into our Zoho Creator. It seems the new API V2 requires user to login to zoho before can generate the token and submission. is there a easier way for us to continue submit our form to Zoho
Take time to load & unexpected error.
Hi, Team form today morning Zoho creator is not working well. it takes time to load. sometimes doesn't show data. I have tested with diff accounts on the EU domain but the same issue. after checking the console it gives a lot of error. Anyone when it
Integrating biometric device with ZOHO Creator
Integrating biometric device with ZOHO Creator for tracking Attendance with in ZOHO creator. I am new to ZOHO Creator i am creating an application. In that application i have to manage data or attendance from a biometric device So how to integrate
Ignore empty criteria when fetching?
Is it possible to ignore empty criteria when fetching? Color = "blue"; (Food is missing / empty) Animal = "cat"; fet = Form [FavoriteColor = Color && FavoriteFood = Food && FavoriteAnimal = Animal]; @Damien?
Form Structure for Multi-Level Manufacturing BOM
Hello Zoho Creator community! I'm looking to use Creator to help me with our inventory management, ordering, etc. for our manufacturing business. I'll be hiring a developer to help eventually, but I'd like to get some core parts of the structure in place.
...you can't embed an image (not an upload image widget)?
I mean...this is basic functionality for any web interface. Of any kind. I have an app. it works...mostly. The form, when submitted, will need to call out to a database that, based on Workflow, will help generate a "score". The score should then drive other logic that (and this is where I don't see it possible) it will display a simple page with the outcome, represented as one of three sections that hide or display images based on that number. I figured out how to do everything except get the
Upcoming platform updates
Hello App Creators, We'll be introducing the following updates to our platform in the coming weeks. Some of these introduce improvements and changes, and some may also require you to update your applications. Please note that all release timeframes below are tentative. We'll update this post as we progress. - - - - - - - - - - - - Upgrade to the framework for exporting a record as PDF Applicable to: All Release timeframe: June, 2020 We'll be upgrading our framework that's used when a record in your
How to pad a string with leading zeros
I have created an auto increment reference number but I like to display it with leading/padding zeros. So it looks like: 0001 0002 ... 0256 0257 and so on. This is the equivalent to the following printf function: printf(" d", variable) How can I do the same in a deluge script?
Creator : Lookup Firstname and Surname of app user when selecting from a list
I have creator app that internal staff use to record training, I need to be able to pull a first name and surname from their ZohoOne profile when selecting them via a dropdown. The only fields I seem to be able to fetch are : username, email address and
Cannot get posted variable and fetch row
Hello everyone, I really need your help to get this sorted. I already spent hours on this.] So I am sending an email with an URL that looks like this: https://app.zohocreator.com/xxxxxxxxx/xxxxxxxx/#Form:Opportunity_Poll?ID=4083783000000024015 On my onload event, I have the following: currentBrand = New_opportunity[ID == getUrl("ID").tolong()]; alert currentBrand; When I load the page, I get this: Can anyone help me solve this. Thank you in advance.
report quick view custom layout records per row problem
i have a report with custom layout. when i enter to the layout properties X records per row i ican see the changes on the report but i cannot see it on a page with this embedded report.
Limit the length of a field in a list view
I have some multi-line fields in my application with a large amount of text in them. I need to include these fields in a view, but I don't want to display the entire contents because it causes each row in the table to be excessively tall. I'd like to limit rows to a certain height and have fields truncated with elipses (...) letting me know there is more content that I cannot see in the table.
Widget showing up as javascript on Page
Hi, I need help again :) I have created my first Widget and inserted onto a Page. The widget built successfully, but it is showing up as javascript on the Page, which is not the intention ;) Widget on page You can assume that I know nothing, e.g. I needed
How to access a records in a function called with a button
Hi, apologies for what I'm sure is a ridiculously basic question. I'm also not exactly sure what terminology to use to ask this, so I hope this makes sense. I want to write a function to look at all the records in a form and update them if they meet certain
Introducing the improved Form Workflows
Hello App Creators, Greetings from Zoho Creator! We are glad to introduce the new form workflows that bring with it a revamped UI and a whole lot of enhancements that put a new spin on how you create and manage your workflows. We always look to improve and enhance our product to provide a seamless and smooth app-building process. We identified that workflows had a scope for improvement in the following areas: Creating workflows used Created, Edited, Created or Edited, and Deleted as the events at
embed record view in page
Hi, Is it possible to embed a detail-view of a record (or record-summary) in a page and load the record using id from the url parameters? i'm trying to improve the user experience in my app when dealing with Forms that include subforms with many fields.
Cannot seem to get CRM Data (Many-to-many module associated fields) into Zoho Creator List Reports
Hello, I was wondering if you might be able to help me with an issue. We have multi-linked modules in our CRM (to support many-to-many module associations), specifically on the Deals module. One field is "LR_Client_POC" I am trying to build a customer portal using Zoho Creator. The standard integration for Zoho Creator to Zoho CRM, does not include our custom fields in the results. That is, when I use the CRM Integration options, the data does not include our multi-linked field, i.e. "LR_Client_POC"
Possibility of creating parent record and related subform record via one/same stateless form.
Is it possible to have a stateless form, via workflows or other means, create a parent record and add a row to its related subform? I know how to have a stateless form add a record to a form via workflows. I know how to add records to a subform via parent
URL construction
Hello, I have a function that creates a new record and then after that opens the record for editing. This is the tail of my function //fetch newly created record newRecord = Register[ID != 0] sort by Added_Time desc; //open record for editing openUrl("#Form:Register?recLinkID=" + newRecord.ID + "&viewLinkName=Beneficiaries","popup window"); This sort of works, however it's derived from the original app in the older Creator version and I have no idea where the &viewLinkName=Beneficiaries refers to.
HTML Word-Wrap in Richtext Field
Hello All, I am having problem with html, i am saving subforms data in richtext field and then printing in the record template. While the data in subforms field may have large amount of data and it need word wraping in those fields data which apparently i am failing to do so. Following is the code i have used: if(Outward_Type == "Fabric") { table_String = ""; table_String = table_String + "<html><head><style>table {font-size: 12px;vertical-align: top;font-family: arial, sans-serif;border-collapse:
Javascript from ZohoDesk not showing up on Page
Hi, I want to insert a javascript snippet created by Zoho Desk onto a Page in Zoho Creator (Developer). I added an HTML Snippet to a Page in Creator. The code is accepted, but on viewing nothing shows. I do have Javascript enabled on my browser (Chrome). Any help on why this is not working appreciated.
Filter Lookup Dropdown Based On Logged In User
I have a field in the Application "Contractors" that is a dropdown called "Region" within the "Contractor Info" Form I'm using another Application "Scheduling" that uses the "Contractor Info Form" as a lookup field to input "Contractor Name" What I need to do is to make another form (not sure if it should be in the Scheduling Application or in the Contractors Application) where I attach "Region" to a specific manager (either as their login email or User ID). Thinking this would tie "Region"
Query Parameters in Open Report action
Hi, I need to pass a query parameter in an Open Report action on a dashboard page I'm building but I can only get the "=" operator to work: fdClosedState=No. I need to have more complex queries passed to a few reports using the same layout but I can't seem to get any others to work with any other operators except for =. I know I can duplicate the reports and apply individual filter sets to each, or add fields to my database that when calculated will give me a value I can use in an 'equals' sense
Running summary of selected rows in a report
Hi, We have a fairly mature application we wrote in Zoho Creator. We have a big report showing rows of data with several numeric fields. The client wants to have a running summary of some fields for rows that they have selected. For example: Row 1 = Price - Volume - Other data Row 2 = Price - Volume - Other data Row 3 = Price - Volume - Other data Row 4 = Price - Volume - Other data If Row 1 and Row 2 were selected (using the checkboxes) they want to display the sum of price and volume for those
How to stop Zoho Creator sending us spam mails?
We keep getting spam mails every few days from a Lee Joseph (lee@zohocorp.com) who won't take No for an answer, instead he keeps sending out spam mails several times a week. Having already gone through a poor customer service experience with Zoho Books, can someone please stop Lee from sending spam mails please, we don't use Zoho Creator, nor will we use Zoho in future projects! Thanks. Juergen
Rental Equipment Management
I'm working on creating a Creator App that tracks our Rental Inventory, but I'm running into some issues. When we create a new rental, I need to be able to generate a packing slip. What would be the best way to execute a printable PDF form. When we have a rental returned, we inspect it and note any damage on the item record. I've got the page that generates a return to only show products that are marked as Checked Out. However I need to write a script or workflow that will change the Checked Out
Next Page