removing edit ability on public share
New to Creator but have created an online data submission and using the public share so I can have the data be viewable online. Awesome tool! However, I do not want general viewers to be able to edit/ delete data and cannot find function which allows a public view w/o public edit rights? Any ideas/ help? Thanks, Eric eric.c.seto
How to establish a relationship between a custom module and a contact record through deluge
Hi all, I've got a custom module built in zoho CRM that has a relation to the contacts module, so contacts can have 1 or more of this custom modules related to it. What I'm trying to do now is have a form in zoho creator create one of these custom module records, and link it to a contact. I've tried using .put("CONTACTID", xyz); and .put("Contacts ID", xyz) and other variations thereof, but nothing I do seems to work. Any ideas?
How can i fetch the products in the qoutes modules?
Is that possible? if yes? can you give me some idea since products in quotes is not a field? im no sure Please help me:(
Report Summary field and label colours
In a report summary how can I quickly set all the labels / field, borders and backgrounds to white?
Help with some code please
I have written some code to send to a web site to include in an embed statement on the web site. The code is if x = 1 { input.rep = "<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.signedfast.mymomentis.co.uk/products-residential-uk.asp?CO_LA=UK_EN">"; } Trouble is because the line has more than one " in the statement it returns an error. How do I enter this statement into a field on creator. Thanks in advance
changing font color
I want to add a check box field which when checked will change the font color for the record. Is that possible to implement?
How to I autofill a field?
Hello I am creating a form and there is a section called SKU that is a search bar so i have to search for a part number and select one. Below I have a section to add the urls of the listing I created for that Item. How can I auto fill on the opposite side the urls that I have already submit to avoid doing double work. Example Sku: W10130913 URLS Amazon _________________ Amazon __________________________________
Permissions, Groups, and Customer Portal
I'm operating an events system. I have a system of teams which consist of managers and employees. If I assign an event to a team, I would like that team's managers and employees to be able to read and update that event, in addition to creating, reading, updating, and deleting their own events between one another. As I create and dispatch the majority of events, I should be able to see all events (administrator). I would care to only maintain one list of events, I do not care to create a report for
Accessing upload field from external website
I'm looking to post image upload field to an external site. I need to export images and signature fields via script to web-merge or another external software. I need to access the URLs without login or using an authentication token. So I need the actual link to where the image and signature fields are stored in the db. Any suggestions?
iCal feed throwing syntax errors with newline character
Hi I am trying to share my calender report with google calender using ical(using two fields Address and Datebooked), the Address is a multiline field, when this is added to the ical URL, google calender comes back with syntax error. I put ical URL through an online validator, and its is pointing to an error when there is an newline from my address field. When this is removed the ical feed works. Is it possible you can fix this by encoding the newline character so its readable in the ical format
Remove box-shadow on Embedded Form
Hello, I just attempted to use the code found here (https://help.zoho.com/portal/en/community/topic/is-there-a-way-to-get-rid-of-box-shadow-on-embedded-form#2266000006342219) to hide the box-shadow on my client's form and while most of the code was accepted and used, I am still finding that the specific box-shadow value is staying the same as it was originally (box-shadow : 0 1px 2px #cdcdcd ;) and will not be overwritten, no matter what I code. The specific page is here: http://www.sharespace.co/practice/
how - move old entries from creator to zoho reports database?
hi need to move entries older than 30 days to zoho reports database there is synchronization in place i need exactly move functionality as scheduler in zoho creator oк zoho reports
Auto fill in fields on base from a lookup field
Hi, I'm new to Zoho. i'll build a form where the first field (name) is a lookup field (from the table Customers). When my users select a client. So far so good that's not a problem to build. The 2 (adress), 3 (zipcode) & 4 (City) fields must be auto fill with the data witch is also on the table Customers. And i don't know how to build that or how to construct that Can someone please help me with this. Kind regards Maarten
Sort by date in a form
Hello, I have a Customer_Info form and an Inspection form. I have looked up the customer form where the assigned technician is assigned to that customer. The customer has an annual inspection which is due through out various times through the year. I have found all of the sites where the loginuser is the assigned technician for the site. then looked up all of the inspections that correspond to the customers account. I would like to sort the list by the inspection date, then put it into my drop down
Failure in mass-data-update using the migration tool
I am using the migration tool provided my Zoho Creator to do mass data updates, so I don't need to write functions to do it. But during the update process I got "data already exists" errors... of course "data already exists" because I am using the ID as the unique identifier to update existing records with data from my spreadsheet... any clue? ID field1 status seriqla 21677000010333591 dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b 120 100001 21677000010333595 dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b
Embed Form Field Params
Good day, I have an Embed Form in myCurrentApp, I want to prefill a lookup field in the Embed Form called Projecto according myCurrentApp projectname, I have this code but it doesn´t works. htmlpage Reporte_Horometros_Combustible() displayname = "Reporte Horometros/Combustible" content <%{ projectname = Project[projectcod = 1].projectname;%> <div elname="zc-component" applinkname="mantenimientoytaller" sharedby="czambrano1" formlinkname="HoursFuel" params="zc_Header=false&zc_SuccMsg=Project
Pivot table/chart system user data
Hi all. Is it possible to use system user data such as "Added User" and "Added Time" as fields within a pivot table or chart. Currently they do not show as usable field options. Thanks.
Pulling data from CRM into Creator using searchRecords
I'm trying to build a Creator application that will update CRM data using zoho.crm.updateRecord method. For this method I need the ID, and I am having trouble finding a good way of getting the ID of an existing record. I have tried using zoho.crm.searchRecords with the Email as a criteria, but I do not know how to then extract a specific segment of the response. Here's what the code looks like. I just don't know what to set CRM_ID to to get only a part of Record. Record = zoho.crm.searchRecords("Leads",
already defined of datatype 'BIGINT' but trying to update 'DECIMAL' datatype
I am trying to add in a simple piece of code but I keep getting this error Variable 'a14_current' is already defined of datatype 'BIGINT' but trying to update 'DECIMAL' datatype a14_current is a decimal field a12_allotted is a decimal field if (input.template08 == "01-Preflight") { a14_current = input.a12_allotted * 0.6; }
Passing Parameters in mobile form
Hi, I realize that the "#" URL notation is disabled in mobile form. I need to pass parameters to certain forms. Is there a function that will let me check the users browser? Otherwise, can you please do the auto-reconfigure of the URLs (changing #Form: to mobile-form) to include the parameters. Right now, it just crashes and burns (i.e. redirects to the app home) if there are parameters passed.
Built-in Functions Broken
Really!
Inserting Notes Under Reports within a Page
I'm having trouble finding a way to add a note under embedded reports within a page. I'm familiar with adding notes within a form, but there is no form builder that I can see for pages. Any tips would helpful. Thank you
date flied multiple selection of days
hi i cannot figure out how to set the date field in order to allow multiple days selection and then sum the days selected into another number field any help or guide
Group Creation is Still Broken
I have reported this a couple times and it's still not working. Maybe because we have the old enterprise account? So I want to make a new security group Next I click "Choose from contacts" Note that there are no contacts. However I do have many users This makes it very difficult to manage security. As we have paid you $1000's over the years I think this bug should be fixed right away. Thanks, John M Whitney aka buzzap
Enable Email Notification missing?
I was able to tick this option for my previous forms. However, I do not see this option anymore. Please help Zoho / Zoho experts :) Many thanks.
Changing drop down lists
I changed a drop down list item, added a word and now it does not display on any of my views. When I edit a record the old text appears. What did I do? I thought I was globally changing the field display.
ZOHO CRITERIA in Zoho Creator
Hi, Is there any ZOHO CRITERIA function in zoho creator like zoho reports? I want to filter the records dynamically in pivot chart based on some conditions. Kindly assist me. Thanks Satya NHM
add date as a criteria in pulling records
Hi, How do you include a field in a form that is part of a "for each x in AssignedSites.sort()" - AssignedSites is a result of a list created by another "for each statement". I want to add a date reference in the for each statement to pull put dates within a range. Here is the code for each x in AssignedSites.sort() { xx=AssignedSites.size(); ThisSite = Customer_Info[ID == x]; ThisInspection = Inspections[(ID == AssignedSites && (Next_Inspection_Due <= Next_Inspection_Due.addDay(input.Fire_Inspection_Range)))
Combining single line text fields and autonumber field
I'm in need of combining 2 single line text fields and 1 autonumber field into a new field. The single line text fields just need to combine the first letter from each field together with the full auto number field. Example: Text field 1: Ext Text field 2: New Autonumber: 1234 Combined output into new field: EN1234 I found this example on How Combine 2 fields into One. But is is only part of the solution, I'm stuck on pulling the first letter only from the single line text fields. https://help.zoho.com/portal/en/community/topic/combine-2-fields-into-1
Report using 2 times the same form
Hi, I would like to build a report which uses 2 times the same form with different criteria. I have Form A with a one to many relationship with Form B. I need a report which extracts rows from Form B with certain conditions, that are linked to Form B (via Form A) with other conditions. Not sure if I am clear enough. Basically, in the report builder, I would like to see 2 times the same Form. I can't find a way to do that. Any idea ? Many thanks !
How to change admin ID
We want to create a specific new ID for managing all software stuff including zoho apps. I have made a Typo error in the email id while creating Zoho creator account. Now i want to get my receipts and change the ID too. Fortunately i have created other users so usage may not be the problem. However I need to change the admin ID for communication needs. Even if i choose forget pwd option, a mail will be triggered to non-existing email which is of no use. How to do it? regards Mukunth
Summary of courses per individual
Hello I have multiple entries for individuals showing courses they have completed. I want to show a summary of this using the learners detail and then a list of the multiple entries on the same summary page. I would like the details of the learner and then a list of all the course entries to show on the same page in the summary.I can only get a summary with one entry per page. thanks P
wmsbar.js script stopped
I get the following message when trying to work in Workflow>forms>deluge tasks. Tried the obvious restart etc. Using Firefox.
Is there a way to get rid of box-shadow on embedded form
I'm using the professional theme and the embedded forms come with box-shadow around them. Is there any way to remove this ? Been playing around with css but no luck.
how - move old entries from creator to zoho reports database?
hi need to move entries older than 30 days to zoho reports database there is synchronization in place i need exactly move functionality as scheduler in zoho creator oк zoho reports
Dynamic Lookup
Hello All, I am attempting to build an estimating application. Within this application I need to have a 4 level lookup filter. For example, the user selects the material dropdown which filters the type lookup which in turn filters the description lookup which in turn filters the size lookup. How I am attempting to achieve this: The Material field is a dropdown list. I have a form (L2 Descriptions) which stores both the Material information and the Type information. I have a lookup field called
Creating a lookup field
My organization is comprised of divisions, corporate branches and an entity called TELF. Divisions contain portfolios, which in turn contain programs. Branches contain business units which contain groups: Divisions Name of division Name of portfolio Name of portfolio Name of division Name of portfolio Name of portfolio Name of program Name of program Name of portfolio Name of program Name of division Name of portfolio Name of portfolio Corporate branches Name of branch Name of branch Name of business
Fetch Record using Auto Number Field
Hi there I am new to Zoho and have successfully used the 'fetch record' to get fields from one form into another using Set Variable BUT, I am trying to populate a form using the AUTO Number field in the Fetch Record script., but it won't work,. I have made it work by using the ZohoID, but this is a big number, and would rather use the auto number which starts at 2014 here is the script that doesn't work (where incident ID is the auto number field ) IncID = Report_Incident_or_Serious_Harm[Incident_ID
Showing image in a form
Hello I have image field. I want to see my image in form. i did what you written before for this issue in the form but link is broken I am really bored help me out. My Code is "Resim" is image field in "Product" table Plain is Addnote field in my Form Urun is lookup field from Product I fetch data Image = Product[ID == input.Urun]; Picted=Image.Resim; imageUrl=((("http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Picted + "&sharedBy=" + zoho.adminuser) + "&appLinkName=") + zoho.appname)
API Criteria &&
I am trying to view & update through the API. It states that I may use criteria. I can get it working fine provided there is only a single criteria required, however I am trying to do this with 2 & 3 crtieria that must be met prior to the activity being undertaken. Specifically the API documentation states for multiple criteria - Example : (Name == "Jean" && DOB == "20-Jul-1981") So I have built this into the JSON array I send. It appears to be reading it and trying to act upon it but is returning
Next Page