Auto-populate Lookup field to link back to 'parent' form?
I have a long, complex form that I want to split into multiple Child forms, linked back to the Parent form using a hidden Lookup field that automatically gets populated via a URL from the Parent form. I would need to populate a Notes field in the Parent form that can pop open the Child form including the Parent form ID. Is this possible? Any tips?
Open Url Editing Records via Record-ID With Variable
Hey guys, I need to be able to open a form URL for editing with Deluge Scripting. So far I have come up with this. openUrl("https://app.zohocreator.com/genesisportablebuildings/ledger-record#Form:Main_Database?recLinkID=3060960000001163199&viewLinkName=Sales","same window") My question is this. How I swap the recLinkID "3060960000001163199" with a variable. I have not been able to get the syntax right. Thanks for your help Chris
Password protected form
Is it possible? I'd like to invite outsiders to get survey/poll.
How to report on subform variables
Hi! I have an "order" form which includes an "order details" subform. The fields in the "order" form include Order_Number (num) Customer_Name (name) Order_Date (date) The fields in the "order details" subform include: product_name (integration - lookup from CRM products) product_category (text) quantity (num) customer_price (num) earnings (num) I want to create a stacked bar report that shows the sum total earnings from the subform, stacked (grouped) by product_category also on the subform,
Import Data With Spanish Characters
Good day, When I use the Import Data tool to feed a Data Base I got some problems when it contains spanish characters like the ñ or á é í ó ú (for accent mark), there are replaced with � , so when I upload the file there is a lot of errors because of course the Lookup fields will not match, Its possible to fix that? Best Regards,
Problem trying to duplicate an existing app in C5
Hi, I´m trying to duplicate an app I currently have in my account. For some reason after the process is completed the copy does not appear. Is there any limitation for making duplicates? Thanks
To enter students Marks
I have student database and course details ,i need to enter the marks for the students based on course .Please suggest any idea regarding this
Barcode Inventory Organization
Is there a way to link product barcode generating to the inventory management system? I would like to be able to create a barcode, enter that item automatically into inventory with the barcode information and when a sale is generated, scan the barcode for packing to remove the item from the inventory management system. If this is already a capability, please send me in the right direction. Thanks.
Execution of a script in opposite order
Hi, I'm starting to write some Deluge script and I'm really surprise about a behaviour of the system. I've just insert to simple line in a script while one field is being updated: Alert "step 1" Alert "step 2" and with my great surprise I've checked that the system show me the alerts in opposite order so before step 2 and then step 1 I cannot really believe that. Could you please tell my what's matter? Thanks. Luca.
Subform in form column
In the ZC3 version we are currently using we can have subforms in the form columns, however now I am working on migration to ZC5 and seems we are no longer able to have the subforms in colums, but rather have to span across the entire form. Am I missing something, or is this a new limitation?
No Report Summary in C5
Can't see how to create a Report Summary in C5 all instructions apply to older version and there doesn't appear to be that option when you create a report in C5.
Weird Anomoly
Im new to Zoho so apologies in advance if this is a dumb question. I have a weird problem while using the Order Management application. Data is loaded into the database without issue, however the price / currency information does not appear in the subform (New Order) correctly. For example: The price of a product is £2.18 but in the Load New Order form / product subform the lookup finds the record but displays the price as £2.00. In fact all of the prices appear to have no decimal places. I've tried
Lookup CRM
Hello is it possible to have a lookup to ZOHO CRM and that this show me filtered data? For example, have a potential lookup that only shows me the potentials that are in stage closed won? Thank you, bye and regard.
SubForm - entering data through subform
I have a "Family" form and "Children" form. They are parent-child relationship. "Children" has a look up filed ("Family ID" field) to connect the parent form. My idea is to display children's information when we open a family record, but I found unexpected behavior. Is it expected? When I open one family record, I see a subform underneath. I can enter children's information. First question is do I have to choose Family ID (look up field) for each child manually? Other online database recognize what
Auto number combination
Hi, I like to have a record ID automatically generated based on the current year and a sequential number. Eg. A record with date 2009-14-07 will have a ID number 2009-1. Is it possible? Thanks.
Is the 2-3 columns section working in ZC 5?
Dear All, I am trying in my free (personal) zoho creator 5 account to create a form with 3 columns section (like the below tutorial) but it is impossible to create these columns. I tried all the possible drag and drop actions but I cannot do it. It still remains 1 column https://www.zoho.com/creator/newhelp/forms/fields/rearrange-fields.html Do you have same issues with me? Is it because I am trying to do it from my free plan account??
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?
Next Page