...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
Variable is not defined
Hi everybody, I'm trying to pass a variable by URL to a Page in Zoho Creator with the following code; openUrl("#Page:Trips_Page?Session_ID=" + input.ID,"same window"); In the Trips_Page I try to fetch the variable with the following: <%{ current_session = Current_Login[ID == Session_ID.toNumber()]; %> <p><%=current_session.Employee%></p> <p><%=zoho.currenttime%></p> <% }%> But Zoho returns me "Variable 'Session_ID' is not defined" and I can't save the code. What am I doing wrong? Do I have to do
Design Help Integrating Zoho Books into Creator Application
I am creating an application that interacts with Zoho Books and looking for feedback on the most effective or efficient design strategy to accomplish my goals. I am fetching data from the Bill module in Books that returns all bills due before the date specified on the form. I have no problems with the scripts to accomplish this. What I do have an issue with is how to display certain fields from the results returned so that the user can systematically check one or more of the bills for further processing.
ZoHo deluge time difference subform calculation error
Hello, I am using the below script to calculate the time difference for every entry in a subform row.Time_Sheet.Decimal=((row.Time_Sheet.End_Date_Time_of_task - row.Time_Sheet.Start_Date_Time_of_task)) / (1000 * 3600); however I am getting the "Variable Time_Sheet not defined"Time_Sheet is the name of the subform, how do I correct the error
function to calculate minutes between 2 time fields
Does anyone know of a function to calculate minutes between 2 time fields? I have 2 input fields, one called LKW which is defined ans a Date/Time field and second is called ER_Arrival which is also defined as Date/Time field. I want to calculate minutes between the 2 fields and present that in a third field called LKW-Door. Can't seem to find a function that will work.
Receive SMS messages in Zoho Creator
I have noticed about 6 to 8 months ago zoho support mentioned an update so zoho creator and crm to allow for receiving sms text messages. Did the functionality to receive sms text messages into Zoho Creator or Zoho CRM ever get completed? How close is this update? Will this work will all of the currently supported sms providers? Anything we should be aware of with it? Should we continue to wait for zoho or should we be trying to use a work around? Thank Matthew
Combined Reports / Reporting Across Forms
How does one report across forms? My specific use case is that I have two forms. One captures attendance (hours worked) for employees while the second captures work performed. Both forms have user field and date field, which ought to be sufficient for cross-reporting. There seems to be no way to do this in Creator, and only half-baked ways to do it in Analytics. There is documentation that this feature used to be available in Creator as "Combined Reports" (link), but I see no way to achieve this
New Info/Alert Limitation
The new restriction "For performance reasons, the collective response from the info and alert statements in a function is now restricted to 500 KB. When this limit is exceeded, the response will be truncated and appended with: The info message has been truncated because its size exceeded 500 KB" Is ridiculous. Zoho, you cannot keep making arbitrary changes for "performance" reasons. Sort out your backend! You never consider your customers and their customers. Most end users do not know what 500kb
Uploaded pdf file column in a report: View instead of Download on click
Is there a way where on click the pdf files uploaded can be just viewed in a seperate browser tab? Right now users are forced to download and then open. The pdf links show up in the column. Also, is there a way to conveniently set a filename for display? Some uploaded files have huge names etc and look ugly in the reports. Or are we stuck with whatever filenames are set when the file was uploaded?
Sub Category
Hi guys! How can i make subcategories in zoho? I tried many ways, using the normal options and script. I couldn't select the values for one specific "category", For example the options of Category and Sub Category, How can i restrict the Sub Categories's values using one values of Category? Its exactly the same options bellow this form!
Autopopulating ZC fields with Zoho CRM Data
Hello, I am trying to set up a form in Zoho creator where you input the Unit Number and from that it autopopulates other fields in the creator form (i.e., VIN, Year, License Plate). And it needs to go into CRM and by the unit number entered get the correct values. I cannot seem to figure this out. I have tried getrecordsbyID but I cant understand how to find the Record ID from the Unit Number? Any help would be greatly appreciated.
Scan Barcode metadata and image source
I love the barcode scan feature for mobile devices. Please add the following or if they are available please point me to how I may access the following: Many times it is important to know what type of barcode is being interpreted. Is there a way to determine what type of barcode is being scanned. There are times when the data present in a Code 39 barcode has a different purpose or context than the same data present in a PDF417 barcode. Especially where 2D barcodes are concerned such as Data Matrix
Validation not Running on Create
I would like to validate some data before saving but I'm having trouble getting my apps to execute the validation when creating new records. It works fine for edits. I create a new application with a simple form with the attached workflow but it does not seem to work.
Filter report from button/panel on Page
Hi, I would like to filter contents of a Report based on a function via a button or panel on the page where the report is embedded. This means there is a button or panel with a function, and if for example the panel has Archived, only archived records will show in the report below the panel. Today I am using a Page Open Action on the Panel, which means I create a separate page with the filtered report. I guess this is not most effective? Thank you!
How to add Emoji in "Add notes" field?
Hi Folks, How to add a set of Emojis in Add notes field to provide customer feedback? Your valuable inputs are appreciated. Thanks
FORMAT NUMBER // FORMATO DE NUMERO ZOHO CREATOR
Hola a todos Necesito cambiar el formato que me devuelve zoho creator: Actualmente el formato que me devuelve es : XXX.YY donde YY son los decimales Necesitaria que me lo devolviera : XXX.XXX,YY usando la ", " para separar decimales y el "." para separar millares. Gracias a todos --------------------------------------------------------------------------------------------------------------------------- Hi everyone I need to change the format that zoho creator returns to me: Currently the format that
Zoho Creator - Zoho CRM integration - Sharing Data
We have a custom module in Zoho CRM. We would like to use Zoho Creator customer portal and provide access to the custom module data. Do we need to store the custom module data in Creator also? What is the best way to achieve this?
Zoho Creator Portal - Show records specific to the customer
We have a Creator application for our customer profiles and transactions. We create the profiles and transactions. We would like to use customer portal so that the customers can login and see their profile and transactions in the application. How do we achieve this?
Onboarding of users via Stage
Hi, I read somewhere that it is possible to onboard users through Stage, and they can upgrade into Production. Have I understood correctly? I have a customer which I placed in Stage due to a temporary problem in publish to production, now this is fixed, and would like to just upgrade them direct into production from Stage rather than creating a separate account and migrating the registers manually. I can see that the option to upgrade is there, but just hoping that this will take the customer into
Photos keep disappearing
I add a photo and see it in the creator database. When I go back for any reason it is gone and I must put it in place again. IF I have two photos same record, one will disappear and newest remains. Each has unique name, but similar location.
Next Page