Reports Embedded in a page, are not applying filters
Hello, I am having an issue when creating pages. When I embed a report into a page, the filters that are set when configuring that report are being ignored when accessing the page. Please see attached pictures. Thanks
How do I download a Sample App?
Hi, I'm trying to get an example of code to bulk update some records and looking through old forum posts I found the exact solution to what I want at this link: https://app.zohocreator.com/sampleapps/bulk-edit-my-form/#View:Custom_View The trouble now is I can't work out how to view or download the workflow/code behind the app so I can adapt if for my needs. Can anyone tell me how I can download the app or access the code and functionality please?
Zoho Creator Sandbox
I am trying to create a sandbox for an app in creator. When I click on create sandbox, the coloured dots just cycle through. I had it running over 20 minutes and nothing. I've also tried different days in case there was a system issue. Any ideas please.
Pivot displays currency as $ when field is GBP
In the Pivot menu Settings>Format Selecting the Format link for my currency field The option for Currency Symbol is greyed out. I cannot change. Also, if I set the decimal places as two - this saves but does not display all values to two places. Any help would be appreciated, Geoff...
Ability To Export To MySQL Schema
This is great, I just wish there was a way to store the data on our own server, instead of on yours. This is a concern for business and security. One solution I thought of is to allow the user to export the database once they are completely done designing the forms. So you dump the entire database schema to a MySQL .sql dump file. Then all you have to do is simply load the dumped .sql file into your own MySQL server. Then in this application you have a place to enter the MySQL server location/ip
Order a list
Hello, does anyone know if there is any way to order a list of n items? For example Original List: {"a", "h", "b", "e", "c1"} To Final List: {"c1", "e", "b", "h", "a"} Please, if someone knows, I would be very grateful. Greetings.
Spell numbers to words with currency (script help)
Hello, I came across the following script that spells out numbers to words (many thanks to whoever wrote it, can't seem to find the source anymore). However, I do need to customize this script a little bit and include several currency denominations such as Euros and US Dollars (Currency will be selected from a Dropdown field). E.g. 1: 15000.50 EUR => Fifteen thousand Euros and fifty cents. E.g. 2: 15000.50 USD => Fifteen thousand US Dollars and fifty cents Can some please show me how can this be
Need to change date format in deluge to interact with an API
Hello, I am working with an API for an external service that I'm integrating into my app but there are a couple of date parameters that need to be sent in a specific format. One is a timestamp like this 2018-06-13T15:00:56.782Z and another is similar but just the date like this 2018-06-13. When I use the built in function 'today' I get "Jun 15,2018" and when I use 'now' I get "Jun 15,2018 09:13:16". I can't find any functions to change the format, how can I do this to match the ISO8601 format required?
GDPR Compliance - how to move to server in Europe
Hi, my client has had a free creator account for many years and now wishes to migrate from us to eu server to ensure GDPR compliance. Is this possible for free accounts and do I contact migration@zoho.com to arrange this?
Gathering data from report in one application and using in another application
Hi, I was wondering if someone could help me with this problem. I have had a look through the forum but no luck with my request. Let me explain what I have. 1 - Timesheet Application 1.1 - Timesheet Form (records hours users have spent on job. Example: 123 Test Job | Jack | 3 Hours 123 Test Job | Tom | 4 Hours 345 Another Job | Jack | 2 Hours 345 Another Job | Tom | 1.5 Hours 1.2 - Timesheet Report (Shows jobs and the total amount of hours spent on this job by different users) Example: 123 Test Job
lost all data
Hi! Today, I can not login because of wrong password (I do not change the password), after recovering the password and login, all data, user account ... are gone. Please help me.
problem with deleting sub-form records in Creator
We've created an application that consists of one master form and two sub-forms that are linked to the master form. Thus, within the master form, there can be multiple records for each sub-form. Any one of these records can be deleted by clicking on the red X next to it, and then it no longer appears in the master form. The problem is that sub-form records deleted from within the master form still show up in the sub-form view. So, they’re clearly not being deleted from the database. Has anyone
Order in sub form
How can I made an order of the subform data in a report ?
Viewing full page edit form mode when clicking on a row in an HTML page view
So I have searched for days on this and I'll try my best to describe this question the best I can (I'm new to Zoho Creator and don't know all the terminology yet). I am creating a police/security computer aided dispatch system, and I am using a page to display "Pending Calls" and "Active Calls." I created a page and added the module that allowed me to view the report with filters (ex: Pending or active calls). When I click on an active "call," it brings up a small box with limited information (I
Relationship between multiple forms
I have three forms: One form is where I submit a new sale (Nueva venta), this form has a subform with the detail of the products sold (Detalle). Those two are linked so my reports can include data from both forms. I also have a separate form with invoice data (Facturacion) and this has a bidirectional relation with 'Nueva venta' so that each sale has a related invoice. For reasons particular to my business I need to have a view displaying everything in form 'Detalle' (all items sold) and in this
Form & Report Access Permissions
I'm pretty new to Creator and need help figuring out how to set permissions on specific app data. Basically, portal users will submit data for their respective companies. I need to restrict form lookups, submits, edits, and associated reports based on what companies the user has access to. The main considerations with the project are: One user should be able to access multiple companies - ex) John is an exec for 2 separate companies and needs to access/submit data for both. Each user is anticipated
reorder lines in a subform
hi, do you have a solution to reorder lines in a subform on a specific field ? thanks you
Returning value of Lookup field gives record ID, not value of lookup
I am having an issue trying to populate single line fields using the user-selected value from a lookup. The user looks up a Company Code from the lookup and this should populate the Sub-Region and Country fields using the On User Input trigger in the Company Code field. A couple of things: 1) When I try and use a script to look up the Sub-Region and Country values from the Company Code table it is returning the Company Code lookup as Long, not the actual user-selected value String, for example "ABC".
Trying to relate a form to the same form (ie: relate one product to
another product)
Any ideas how I can approach this? Scenario: I've 3000 parts & products. If I search for a product X, I want to view all related products or parts to Product X. EG: View a lamp and see the related bulb. If I view the Bulb I can see the related products. It must be a many to many relationship. A Lamp can have many related parts and each part can relate to many different lamps. Thanks in advance?
Invoke a function with multiple arguments
void SKU.generar_stock_Sku(Compras_de_Skus cn) { sr = SKU [Secuencia_Secundaria = cn.SKU_Secundario]; st = Stock1 [Origen == cn.ID.toString()]; x_x = Stock1[Status is not "vendido" && Numero_de_Serie == cn.SKU_Secundario].count( ); sr.Piezas_compradas_historicamente=x_x; } I have a function with an argument (void SKU.generar_stock_Sku(Compras_de_Skus cn)) This function (it is only part of it actually), generates registration within the "Stock1" form. -Now I want to be able to update
Update field when adding row to subform
Hi, I'm having trouble getting a script to work when trying to add rows to a subform. I have a subform called Tasks on a main form called Jobs and when I add a new row I need a field called Task_Unit in the subform to populate when the lookup field SOR_Code is added/updated. I have attached a screenshot of the subform showing how the Task Unit value is duplicating from the initial row (regardless of how many rows I add) , rather than taking the correct value from the lookup relationship (field
Change "null" to something else?
Hi Zoho, When I fetch a record that is empty I get "null". Is it possible to change the default "null" to anything else? (NOT by using a function for each fetched variable.... I mean from you end, or is it possible from the Zoho settings?) Thanks Ravid
Zoho Creator app creating duplicate rows on update function
Hi Team, Problem We integrated vendors app of Zoho creator with CRM. Everything was running fine & since last few days Zoho creator app has started creating a duplicate record on every update. Are we the first one to encounter this or somebody else had the same problem before?
Lookup to the same form?
Here's what I need to do... I have a form with "activities" that needs to allow the user to select a "parent" activity from a dropdown. The parent dropdown should be populated by previous entries from the activites form or null if no other entries have been made. Zoho won't allow me to create a lookup to the same form, so I tried a little code for the form "On Add", but it doesn't seem to work... Any ideas on how to lookup previous entries to the same form?
Sum all numeric fields from subform and show the result in a field in basic form
Hello, i am trying to create an app to follow the payment of my customers. In the basic form (form1) i have the customer details and one numeric field where i write the total money i have agreed with my customer. In the subform (subform1) i have the payments, one record for each time with the fields "Date", "Amount" and "bank name" I want to add all the payments, substract it from the total and return to me the money my customer owes to me.
Problems with dynamic picklist and pull data without using look-up
I have 4 forms: 1)Customer info which has customer info and customerID(customerName + phoneNumber) 2)Customer site - a customer can have more than one site. 3) Consultant info 4) Site info is generated by linking 1+2+3 and it has unique siteId(Customerid+ customerSite) 5) In order form, a) When I input customer name, customer number is inserted using look up and customer id is also generated. b) I want a drop down(dynamic picklist) where related sites for each customerid are listed down when name
Deluge Scripting
Is anyone aware of any books which could help me learn Deluge Scripting. I am not a programmer by profession. Thank you in advance.
How can i filter my records in the sub form based on the main form field selection
Hi, I am trying to filter the data in the sub-form based on the field in the main form. Can i do the same? Thanks, S
Install APP from zoho.com to zoho.eu
Hello, we have account at zoho.eu. With an account created in the EU, can not be login to the marketplace. We created a zoho.COM account and installed app and exported app to .ds We tried an inport .ds file on our EU account. After import the file, the page redirects to the marketplace and returns to the home page of Creator and nothing happens. APP: https://creator.zoho.com/platform/public/showAppInfo?canvasurl=mzxpuwhdg&refererUrl=search%3FappName%3DBasic%2BInventory%2BManagement%26category%3D-1%26limit%3D10%26count%3D1&refererText=Back%20to%20Search%20Results
How do I filter the results on a embedded report using URL parameters?
Hi All, I am trying to create a project dashboard/page that has a few reports that all are filter with the results of that particular project. At the moment I am using a stateless form to change the url parameter of the parameter ProjectID, but the embedded reports do not filter the records to the URL Parameter. At this point I am using the page builder in the new builder. When I embed the report I set the filter to equal the input.ProjectID which auto populates as I have set it as a parameter in
Icon in the top rigth in Creator 5 Portal page
Hi, I have a small icon in the top rigth corner of my app. I'm using portal. See attached. What is this? Thanks!
inconsistency with built in function subString() function
I am trying to generate a part of string which requires subString function. For example If I want to extract between 3rd and 5th index for the word Tamilnadu, I have to do the following x = "Tamilnadu" x.substring(2, 5). a)Since it is based on zero index it should actually be x.substring(2,4) b)in the case of indexing starting with 1 it should be x.substring(3,5) Isn't it a bit confusing?
HTML Views Stop Working
Hi, All the HTML views from all my apps stop working, the Usage Logs do not record anything.
Build excel rater/calculator in Creator
Looking to replicate the attached rater in Creator to then be able to embed into a landing page. Is this possible? Where to start?
Criteria matched value to show up in drop down automatically
Hi guys, Kindly help me for following two things. When I use lookup filed, the value that matched with criteria (only one value) cannot show up in drop down (Look Up Field) automatically and I need to choose again for this value. How can I overcome this ???? Please refer me for sample script. can I pass parent form's field input value (From Look Up field drop down) into sub form and also vice visa. ??? BR, zzw
Import from Excel - Date not working
I am trying to import data from Excel. I exported my data from a ZoHo view to make sure I have the correct headings and columns. When I try to import the same file which I just exported, everything works fine except the Date. My Date field is a Date-Time. It exports to excel as "Apr 07, 2010 23:27:28". The cell is formatted as "mmm dd,yyyy hh:mm:ss" When I try to reimport this same exact file back into Zoho creator, the date time field is blank. I have tried to change the format in excel
STRING and right expression is of type BIGINT and the operator == is not valid
Please Help. This should be so easy? I have a lookup field to select an item by size from another form. Now all I'm trying to do is automatically update the price of the item to a field called total. if (count(iPrices[cabSize == input.cabSelect]) >0) { temp = iPrices [cabSize == input.cabSelect]; input.total = temp.ssPrice; } else { input.total = 0.00; } ...Error -> STRING and right expression is of type BIGINT Thanks for your help.
How can I create a download button on a report that downloads the file but doesn't show the file field?
I have created a document library. I realize that if you add the file field to the report the user can download the associated file by clicking the file name in the file field on the report. I don't want to show the file field on the report. Instead I want to show just a field for each record that shows a download button, that when the user clicks the button, it downloads the associated file in the file field.
Changes in Usage limit for free version in Zoho creator?
Hey, We have an application for internal process, which we have been using for the last one month. We had 6 active users, but all of a sudden today, all except 2 users got deactivated. When we tried to activate the users, there was a pop-up notifying to upgrade a paid version. Not sure if something has changed in the usage limits for the free version. Has anyone else faced the same? Thanks Vikas
Subform Data
I am wondering how the data entered in a subform is stored. Is there a hidden table under the hood with a foreign key to the table for the main form, or is it somehow serialized and stored in the main record. I have looked through the documentation for these details, but I have been unable to find any information.
Next Page