Is it possible to move a record from 1 form to another?
Hi guys I have set up a simple form which I want to use for inventory purposes. Each item is stored at the warehouse for a certain amount of time, before it is bought back to the production unit for work to commence on it. I would like the ability to move a record from the form that shows all of the items stored at the warehouse to a seperate archive form of records that shows all of the old items that are no longer stored at the warehouse. Is this possible? Many thanks Tom
Move records from one form to another
Hi Is it possible to move entire records from one form to another? Or is it possible to archive entire records with the ability to look back over them? Many thanks Tom
Re form field for SS NUMBER AND PHONE NUMBER
Sir, I need to have a form field for phone number and ss number please help me mdspine
com.adventnet.persistence.DataAccessException: [Rename_Table_In_Path] Column 'TABLE_NAME' cannot be null
This is the returning error when restoring an app. Does someone know what is it?
On Validate allow either the Added_User or an adminuser to edit
on validate - I want to allow either the Added_User or an adminuser to edit a record. Other users should not be able to edit the record. I've tried a few different statements at "on validate" but cannot get them to work. I am an admin and I attempt to edit another users record as the test. So far, test failed. Any help is welcome. Two examples are below of statements I've tried to use. >> I've tried this if (input.Added_User != zoho.loginuser)||(zoho.loginuser != zoho.adminuser) { alert "You
Look up fields as numeric field?
I have added few look up fields that look up email addresses based on a name selected from another look fields. When I try to set up an email notification on Add, on Success, these email address look up fields show up under numeric fields list. So my email notification errors out. How do I fix that?
Phone validation script
Hello, I am using the following validation script to change some phone numbers that are being sent to one of my forms. if (!input.Phone_Number.matches("[0-9]{10}")) { alert "Enter the numbers only (Example : 1234567890)"; cancel submit; } else { input.Phone_Number = (((("(" + input.Phone_Number.subString(0,3)) + ") ") + input.Phone_Number.subString(3,6)) + "-") + input.Phone_Number.subString(6); } While it works when the phone number comes in as all numbers (i.e., 5557771212), I also
PDF conversion for multi-page dynamic pages
Hi, I have a dynamic page generated from data in a form that fills in a template. This works fine and displays well rendering all HTML as it should. The issue I'm having occurs when I try to use the PDF exporting functionality. Since some pages extend over multiple pages, text at the bottom of the page overflows failing to respect margins and any padding. I have created a print-only style sheet that defines margins for the pages and padding for specific elements but the overflow is constant. Can
How to sum related records?
Hello, I have two tables: one list my works and another one relatated counts worked hours. I would like put a formula in works table that sum all worked hours for selected work. Thank you
Customer Portal quetions
I'm investigating for use by an organization where I volunteer: I'm assuming I can parse data by customer so that multiple customers using the customer portal can't access each other's information. Correct? Can the survey feature be used within the customer portal? Meaning that surveys are presented, responses are captured, results are displayed all within the customer portal. Is the customer portal branded with my company name/logo, or zoho? Can I use my own domain for the customer portal? Thanks
Update Multiple Lookup Fields
Hi. I have fields which are lookup fields which are numerous and need to be updated with the same data. However, the condition fields are also lookup fields. Is there an easy way to do this? the script would be if(lookup field1 == "text1", update all lookup field2 with "text2") Thanks
Creator does not seem to have CRM's workflows?
One of the things I like about Zoho CRM is the "workflow" - Creator says "workflow" but it is programming. It is a shame it could not replicate the CRM "workflow" module. Does anyone else see any utility in it? Thank you Brynley
Criteria from multiple fields for lookup
I know similar situations have been addressed, but I'm having trouble implementing a solution. I am working with 4 forms right now. Crops_form Section_form Planting_form Harvest_form One record in Crops_form is related to many records in Planting_form One record in Section_form is related to many records in Planting_form In the Harvest_form, there is a single-select look-up field "Crops_field" which looks to the Crop_form a multiselect look-up field "Section_field" which looks to the Section_form
Make fields smaller? (lots of fields on a form = lots of scrolling to see the fields)
Hi there Is there any trick to squeeze more fields onto a Form? One of my Tables has about 25 fields and the standard way Zoho lays them out means the user has to scroll down to see them. I don't see this being possible but thought I'd ask anyhow. I have also tried to break the Form up by making some fields looked up in a different table - but this would be a 1 to 1 relationship. Thank you Brynley
Zoho.support.create function call
I submitted a support request last week, but, not unexpectedly, there has been no follow up from Zoho technical support. I am hoping for better response on this forum. I am trying to integrate several Zoho products (Creator, Support, CRM, Projects, etc.) into a workflow. At this point, I need to have Zoho Creator submit at ticket in Zoho Support via integration task/call function zoho.support.create. When the function is executed, the ticket gets created correctly. However, the data contained in
Security of data?
what safeguards does Creator have for the security of the information
On User Input - Submit Form
Is it possible to submit a form on user input? We're incorporating bar code scanning with Creator and having to manually click submit slows down the process. We want scan, then scan, then automatically submit if both values are not null.
eomonth function not working properly
Dear ZOHO , while using Date-Time functions in zoho creator I noticed that the eomonth() function is not working properly. It returns wrong values for dates in February. If February has 29 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.02” / 2 nd of March and if February has 28 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.03” / 3 rd of March. Best Regards Michael
Has anyone elses creator program stopped working?
As of today, Our creator pricing tool has stopped working correctly. In every instance it gives the error below, even though we have made no changes to it since it was working. Anyone else having an issue with this?
How to delete unconfirmed users
I shared my application with another user, but I made a mistake and I inserted the wrong email address so she didn't receive the invitation. So I reinvited her using the right email address and everything worked fine, but now I have the old email address between the unconfirmed users and I would like to delete it. Is it possible and how? Thanks, Michele
Domain validation
Hi I have ".photography" extension domain email ,i try insert the email like as " name@abc.photography " but its not inserted in form Thanks Satya NHM
email field limitations
Is there a limit on the number of characters that can be after the . in an email address? This email produces an error when I try to save the form. name@xyz.consulting A shorter domain does save name@xyz.consult
How to display the first item in a list... as the first item in a drop down box?
I've created a list from items stored in a form, sorted the list and placed it into a drop down box. "Everything works as expected". I would like to display the first element in the sorted list as the default choice in the drop down box. As it is now: As I would like it to display: I'm thinking the syntax should be something like --> input.Service_History = <sorted list> element (1) ; Thank you for any help Alan
How to print message based on radio button selection in html page
i have a problem, when User select "No" in Contact Form, i need to print following message in html page to print pdf. "Please dont contact Customer" How to write code for this condition in html page?
Auto populate crm fields contact and account in creator
I have added a contact and account field from the CRM to Creator. When I access it form the CRM I would like it to auto populate the contact in the CRM I was just viewing. How can it auto populate those fields? Joe
Authorizing Zoho Creator to use Google Calendar
I am trying to add an event to the google calendar using a form in zoho creator. I'm unsure if I will need OAUTH 2.0 working between zoho and google. If this is the case. Is there an example for connecting to google calendar with oauth 2.0 authorization? Here's what I have so far posttest = "https://accounts.google.com/o/oauth2/auth?scope=calendar&redirect_uri=https://creator.zoho.com/oauth2callback&response_type=token&client_id=Client_id_from_google_oauth"; responsy = getUrl(posttest); The error
Google map not showing in add notes field
Hi 1) Google map not showing in add notes filed i use below script input.plain = (("</br><div width = '320px' height = '320px' style='border: 1px solid #A4A4A4;'> <img src='http://maps.googleapis.com/maps/api/staticmap?center=" + input.Address1 + "&zoom=17&markers=size:mid|color:blue|label:S|") + input.Address1) + "&size=320x320&sensor=true'> </div>"; 2) is it possible to insert map in image filed? Thanks Satya NHM
Calculated Field Look Up
I have a table of 120,000 fixed records that are used in a formula based field. The record relevant to the user is filtered through a series of dropdowns on a local database application. Field 1 Choose A and this then gives you Field 2 with Choices of A1, B1, and Choose A1 and Field 3 gives you a choice of A2, B2 etc. When you finally identify your record from the drop downs i.e. record A-A1-A2 the tool then produces a calculation using the number fields attached to the A-A1-A2 record and
how to add file via webhook?
hi how can i add file from any system to creator's app via webhook?
Is it possible to call a function that opens a form record in Edit Mode and then Updates that record?
Reading here it seems I've painted myself into a common corner here at ZC... BACKGROUND INFO: I have a form dense with scripts and formulas, lets call it JOB. Another form called INVOICE is populated with information from JOB. In order for an INVOICE form record to be correct, one has to make sure the JOB form record that will feed data to the INVOICE form record is up-to-date. Currently, to make sure an INVOICE form record is correctly populated with up-to-date JOB data, one has to manually
Pivot Table of records created by users
A pivot tablel showing activity by user is my goal. When creating a pivot table in Zoho Creator, the Added User field is not available. Is there some way to create a pivot table showing each user and how many records with a certain attribute they have created? Thanks for any help. Jim
List - remove element
Hi, I've troubles in filtering a list with a condition : for each item in list(condition ex. var1=>Var2 ) { list.removeelement(item); } Field:ui.add(list); Creator return that is "Not able to find 'list' function" . I ask if possible or I have to achieve the solution in another way. Thanks&Greetings Mike
Problems with Sharing / Google APPS Usage issue
After going through and setting up the sharing in the Creator application on the desired database that I would like to share, I continue to receive a permissions error. I have triple checked the settings and seem to be not having any luck. This is the error I receive. You have logged in as user@xxxxxxxx.org. You are not allowed to access this application. Please click here to login as a different user. Click here to go to your Home Page. Any help would be appreciated. Jon
How do you set the Home or default page for users?
I want users to see a company Dashboard when they log in. How do you make a default landing page in an application. When my app starts I see a form to add some data... I want it to default to a certain view called Dashboard
help
help
Validation -- between Zoho Report Query Table and Zoho Creator Form
Hi, What I am trying to do is to validate the user input comparing the Zoho Report query Table. I have a Stainless form which is used to update the Data inside creator. and I have another query table in Zoho Report also .. now I want to make user input the data correctly based on the Zoho Report Query Table. So I would like to create a script that validate the inputed data inside Zoho Reports Query Table first if it is true then user can enter the data. Zoho Report Table Screenshot : MVPD :
setting a default value where no value from a non-mandatory lookup field has not been supplied
Hi, I have a client name field and and client number field with a dynamic lookup field for client number so that if the client types their name in (accurately) only their client number will appear on the drop down list. However, for situations where the client does not have a number (e.g. new client) or types their name in incorrectly, I would like a default client number (say 1234) to be entered automatically. Ideally I would like clients to be able to select this from the dropdown list, but I can't
Changing owner of a ticket
Hi There, I want to change the owner of an open ticket based on a "On User Input" event on a status field. So if the Status field is changed to "Collection booked" then my "assigned to" field changes the owner. Both the "Status" field and the "assigned to" field are lookup fields. Kind Regards Matt
Getting more than one field from the record.
I have a sales form. On that form there is an item field that selects from a drop down list. I want to get that description and get the price to populate another field on the form. I am very new to this so use third grade language. Thanks.
I have problems fetching data form one form to another
When I tired to fetch data form one form to another de my application did not work. I put the followin script in the look up field and the application dont work if (input.Principal != null) { temp = Principal [Id_de_Voluntario == input.Principal]; input.Estatus1 = temp.Estatus; } Heeeelllpppppp
Next Page