Custome creator app developing
How can I share my app with a developer if he'll be granted all access and data? is there a way to share the app without the data?
Genrated Image in Record Summary
I have a field with an URL to an image. Would like to display this image in a Record Summary, is that possible? The URL is dynamically generated so i cannot add it as a normal image field. Tried to wrap the field value in some html img tags, such as: <img src="${Value element}"> but that is not accepted.
Customize form style with CSS (not for published forms)
I am using Zoho Creator to run a Word Order database application and would like to know if it's possible to customize the layout of the form. I keep reading that you can customize a published from but that's not what I am looking for. I know you can go to Settings > Customize but this only allows me to choose from pre-built layouts. The other thing I discovered is the option to set the form to single or double column in the screen where you can edit the form but this also is limited. I would like
Interative DELUGE Tutorial link doesn't work - how can I learn DELUGE?
Just watched this video Introduction to DELGUE-Preethi / Nandini https://www.youtube.com/watch?v=e-Y23JefgLs at the end of it the instructor states you can go to an Interactive DELUGE Tutorial and promotes this website: https://creator.zoho.com/learndeluge The page appears to be broken in Firefox and IE. I found the video difficult to understand and I was hopeful the Interactive DELUGE Tutorial would help me to understand Deluge and how to use it. Grateful for any assistance with this, Lisa
Bi-Directional Multi-Select lookup to Sub-form bug!
Hi, I was trying to set-up a multi-select bi-directional lookup field for a sub-form, everything worked as expected until I tried to access the main form. I got the error "Form not available, please contact support". I had placed some script in the multi-select "On User Input". I have since reverted to using a drop-down instead... Thanks, Damien Cregan Hire an Expert
Slight issue with Dynamic Picklists
Hi, I've only recently been put to work on our company Zoho project, but I have some background with code. A colleague of mine asked if I could do some clean up with his forms and make them a little more user friendly. Currently, what I'm trying to achieve is a simple (or I thought...) dynamic picklist. I've worked through the example you have put forward within the Creator Help pages, but there must be something I'm missing. It's a shame that I can't start at the beginning, but also trying to figure
Navigational URL examples
Hello :) Could someone show me some example script using these navigational URLs. This is my best guess. Not working. openUrl("#Script:page.back ", "same window"); https://www.zoho.com/creator/help/url-pattern/navigational-urls.html tx,tt
Restrict records in reports based on user - Zoho creator
I have created an application. In general an admin has access to view all the records. I have shared the application in customer portal. Users who access the customer portal should see only the records created by them in report. But admin should all the records created by the portal users. How can I achieve this in zoho creator? Any script needs to be written? I am new to zoho. Please help me.
Hidden fields
I "hid" some columns in my report and now don't see how to get them back ?
Error while adding item to picklist. it Appeared today and worked perfectly before
Construction (ui.add) does not work since today. Errors: "Invalid client task found" if(Invoice != Null) { for each ServiceOrderRow in Service_Order[Invoice == input.Invoice] { input.Customer:ui.add(ServiceOrderRow.Customers); } input.Customer = ServiceOrderRow.Customers; }
How to set report criteria to show records that have a field value that is in a list
In this past post: https://help.zoho.com/portal/en/community/topic/how-can-i-control-the-display-permission-of-report-with-deluge-script-zoho-creator An example was given for report criteria where-in only records with the department field matching the single department the user was associated with in the user form: Department.ID == User[Email == zoho.loginuser.id].Department but that only works if User[Email == zoho.loginuser.id].Department only returns one single department ID, but what if this
Passing a form to a function
ZC team: I saw that now it's possible to pass a certain form as an argument in a function. I suppose that this means that half of the job Passing form in the function argument and related improvement in custom action posted at http://help.creator.zoho.com/Working-on.html is done ( still no change in the custom actions - so if you pass a form parameter to a function, you can't use it in a custom action ). Regarding the use of this feature, I saw that if you have for example the form sampleform with
Filter embed report in pages
Hello, I have a custom action that send a value to a Page by url. This is working. I have sent me the value to an email and the value is correct. I want to use this value in an embed report to filter the values. This doesn't work. When I hard code a value, it works. Here is the script in my Page: *****this does not work ------------------------------------------- htmlpage Resume_de_site(numsiteselected) displayname = "Résumé de site" content <%{ siteresume = numsiteselected; %> <%=siteresume%> <%
Filter openURL for all IDs in a list
I have a multi-select lookup field. My ultimate goal is to be able to add IDs from the picklist and then be able to edit them without having to submit the main form. The only idea i have is to have a checkbox under the lookup field that when checked, would open a report/view of ONLY the records inside the multi-select lookup field. This way I'll be able to edit the records. My question is, how do I go passing parameters thru openURL so that I see only the IDs inside the current lookup field? If
Marketplace There is no such application in Zoho Creator
Hi all, I go to marketplace in zoho creator but non of them allow me to install. When I click Install app it pop up message There is "no such application in Zoho Creator". What is the problem?
Embedded Reports in page
I have an embedded report in a page. However, I do not want all the information in the report to be included? For example, I am keeping data for 10 properties. However, On this particular page I only want the data from one particular property. Can I filter the others out? Thanks
Is there a way to add custom fields to the user objecty/form?
Is there a way to add custom fields to the user objecty/form? If not what is the best way to extend the table?
DOMAIN CHANGE
please I need to beg this admin of the site that the domain am using is expired and I want to change to temporary one but the site did not accept it, please help me out
Hidden field keeps adding value
I have created a form that builds an Estimate for Books. I have a field hidden depending on a previous field selection, the problem is the SKU for the hidden field keeps getting listed along with the SKU of the shown field. Can anyone help with a solution to this? Here is the code for the 2 fields, only one of those fields is shown on the form at any one time.... if(input.Container_Pref6 != "None") { sku = "6MB"; } else { sku = "6MT"; } getitemsd = zoho.invoice.getRecords("Items",orgid,"Status.All",sku);
Pivot Table - Filter DOB field by Month not Year
Form "Employee" includes a DOB field, and a "Manager" field. I need a pivot table to show, for each unique Manager, a list of all their employees with birthdays in each month. I want to apply a User Filter for This Month, and Next Three Months. How do I get the DOB to filter by the month only, and not the year??
Display picture in header of report
Hello, Is there a way to add a picture in the header of a report? If its possible also to change the picture depending on the zoho.loginuser? Thanks
Dynamically updating subform content within a parentform
I have a very simple CMR form where users can chose from a pull down list of users on the parent form. The idea is to have the embedded childform (containing 4 to 5 fields) dynamically update after a selection was made on the parent form. I am unable to find a code snippet or a clear example on how to do this.I'm a little confused as to why when a subform is added it does not prompt you for a parent or a one-to-many-relational key to the parent form. In any event here is what I'm trying to associate
Multiple person logged in with the same user on custom portal
I have a app with the customer portal. Is there a problem with many person logging to the portal using the same user and password? I have tried it and it seems to be working. thanks
sign up error
I can't sign up as I want to created hosting email address. My domain is tumblrwp20170608.wordpress.com. I am getting error occurred
Move data from one form to another
Hello. I have 10 different forms with 5 same fields (Name, Data, Number of.., etc) And i want to merge all this data to one view. So how i can add data from 10 different forms after submitting them to another form. Or how i can merge 10 different forms to one view. Best Regards, George.
To send a filtered Excel Report by mail
Hi everyone, In order to mantain a clean Database and an optimal number of records, I would like to do a procedure when an action is executed (for example when an employee leaves the company). The procedure that I'm thinking is as following: 1. To send an email with an Excel Report attached containing the employee associated records from different forms (for example vacations, expenses, etc) 2. To delete the employee associated records Which one is the best way to do that? Thank you, David
Google Map dynamic selection
Hi, I have a report with a list of gps coordinates. I want to display on a map those points when I select them. It has to be dynamic. I know Zoho is working on something for many years and was supposed to release something in 2017 fall.
Map Tutorial Intermediate
This is a follow up post to map tutorial (Beginners) Hello ZC fans, I in the last post I discussed some of the basics about the map() function/feature. The last thing I discussed in the post was how to pull in map values from a map function (in functions tab) to a local script (form, view). But what if you wanted to do the opposite? What if you wanted to transfer a map from a form or view to a function. Pass a local map variable from form or view to a function First let's make our map myMap = map();
email notification
hi, as you can see on this form (inkedCAttura2_LI.jpg) there is a user and an email field (that automatically is set on user email you can see on user field) now, i made a email notification (as you can see on "cattura.PNG" and "cattura1.PNG") but email are not sent. why?
Fetching data for a form
I am new to zoho, I have imported data and made a form from that data. I am unable to get the field boxes on my form to formulate anything example: (fetch info for other fields if name is equal) and if I use the form, then it does not update the spreadsheet that I imported. Could someone help me understand please. If I have to make "another" form to use the database (which works) then it is not useful. Yes I have watched all the videos and nothing deals with this. the written guides make no sense
Problem in customer portal invitation template
Hi Team, I was not able to add image in the invitation template of the customer portal. It just says "Uploading Image" and not responding after that. Kindly assist me. Please find the screenshot of that problem in the attachments. Thanks Satya NHM
Edit field and make operations between 2 fields of different Table.
Could you help me? I want to add the "Number_Day_Requested" on request to "VACATIONS_YEAR" at Employee_Information after to sendmail. if(input.Status == "Approved") { sendmail [ from :zoho.adminuserid to :Employee_Information[ID == input.Employee].EMAIL subject :"Your request has been approved" message :"Congratulations!<div><br></div><div>Your request for time off from " + input.Begging_on + " to " + input.Ending_on + " has been approved.</div>" content type :HTML ] /* I want to add this
Restrict record visibility in Report based on login id and a field.
Is it possible to restrict record visibility in Report based on login id and a field? e.g. To one set of users whole login ids I know (I can create a group from these specific users) I need to only display those records in a table where a CompanyField is set to "XXX" I can do it by making a separate Report for each such set & then restricting visibility for that full report. But that's cumbersome. Every time a new company happens I need to create a new report & manually copy all my conditional
Need help in passing data from one form to another
I have two forms: New_Interns and Intern_Updates. Both forms have the field "Questionnaire_Complete" with values of Yes or No. I wanted to have my interns access the form, "Intern Updates" and complete that question "Questionnaire_Complete" with a Yes value when they have completed that exercise and then pass that value into the report generated from the New_Intern Form. Not sure how to get that done...Any help would be greatly appreciated :)
Missing fields in report builder for pivot table
Trying to create a pivot table based on an existing report - but many of the fields are missing in the report builder. I see the issue raised in the forum a year ago, but no solution.
Create multiple records with function add record
Hello, I would like to know if it is possible to do a function that allows me to create 10, 20,50 or 100 records at the same time. The records will be exactly the same. I would like to do it with this function: void funcion_comodin.Crear_comodin(Ficha_de_productos cn) { insert into Stock1 [ Added_User = zoho.loginuser Comprador = "Isaias" Condicion = "Nuevo" Destino = "MercadoLibre" Fecha = zoho.currentdate Imagen = cn.Imagen_del_producto
copy data from previous record
Hello. I would like to copy data from a field from the previous record to a field on a new record. Please help with coding. Thanks
1 week ago it worked perfectly. I open form from the page, when I close it, the sustem bounce me out to previouse page.
You can see it in your standard application "sales management". Click "All Accounts". click the button "View" (custom action). On the page click "New Contact" or "New Task".
Prefill form field based on last known (the form has a date field) value of that field
I want a way to seed a numeric field on a form with the last known value of that field. Is this possible? How can I achieve this? I suppose it is some sort of OnLoad deluge script? Any snippets?
Can I share an app while in my free trial period?
I set up an account today and am attempting to share an app with a colleague to discuss zoho creator as a potential solution but when I follow the directions here: https://www.zoho.com/creator/help/application/application-sharing.html#Share_with_individual_users/groups I receive the following message: errorMsg:Sharing failed! I'm trying to determine if this is a limitation of the, currently, free account or if I have failed to do something properly.
Next Page