How add new values in subform multiselect/checkbox ?
Hello! I have easy question, how i can add new values in subform multiselect or checkbox. I'm created script, but he doesn't working. values = {"option","option 2", "option 4"}; subform.checkbox:ui.add(values); And i tried this values = List:String(); values.addAll({"option","option 2", "option 4"}); subform.checkbox:ui.add(values); And i tried this values = List:String(); values.addAll({"option","option 2", "option 4"}); for each val in values { subform.checkbox:ui.add(val); } What i do wrong?
Calculate field value based on subform entires
So I was wondering if someone could help with this. if we have a form, lets call it orders, and it tracks an oirder for X number of hours work then we have a subform which records the hours e.g. an order for 5 hours comes through and it gets broken up into say a 2 hour block, a 2.5 hour block and a 0.5 hour block, these hours are recorded on the subfoirm. Can I have the subform update the number of hours on the main form, possibly even stop entry of the subform record if it exceeds the value in the
Set value of lookupfield from a url Get variable
I have a form 'project_form1' that has a unique product_number1. on save it opens a second form 'project_form2_stateless' with openUrl("#Form:project_form2_stateless?project_number2=" + input.project_number1, "same window"); I try now to assign the value in variable project_number2 to a lookup field 'project_number2' connected to project_form1, but is is not working , if I send the variable to a number field it works find? How do I select a certain value in a lookupfield with deluge script on form
Error:The server cannot service the request because the media type is unsupported
Good afternoon everybody, I have the following error which it returns for a soap method: Error:The server cannot service the request because the media type is unsupported I use the function postUrl to execute the method soap I sent the following XML: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:bat="http://fslso.com/BatchFiling"> <soapenv:Header> <bat:AuthenticationHeader> <bat:UserName><username></bat:UserName> <bat:APIKey><password></bat:APIKey>
Two Unrelated Forms in one Chart? (to compare revenue with expenses)
Any suggestions for creating a chart that compares data from two unrelated forms? In this case, I have a form for entering individual expense items and a form for entering individual revenue items, and I'd like to be able to compare total expenses vs. total revenue, month over month. Thanks!:)
Disabled but not Grayed?
Is it possible to have a text field disabled but not grayed-out?
How to update already existing data via import.
HI all Kindly help with below I have a set of data in creator app. for example Name | Email | expiry date. The expiry date changes based sales activity offline, which is reported as CSV with Email and expiry dates. how do i import the offline sales activity report so that it updates the expiry dates for the email address already available in APP.
Count the Value within a Anniversary Period
Hi, I have a table contains the attendance records of all customers, I want to count the no. of times a Customer_ID attended the class (Date) within each Anniversary Period (based on the Join_In_Date), and return the value to another report like below format, is there any way I can do so? Thanks a lot! Customer ID Range Count ================================================================ 8888 Year 1-
REST API link is broken
Hi, When using the REST API link :https://creator.zoho.com/api/<user id>/json/<application>/form/<form name>/record/add the web server returns an HTTP error 301 and redirects to https://www.zoho.com/creator. Seems like the REST API link is broken ? Regards Malcolm
HTML page doesn't show new line on textarea on content coming from multline fields
I get this code on a HTML page: <textarea readonly="readonly" rows="10" cols="100"><%=form.multiline%></textarea>But it doesn't show line breaks from multiline field content. I already tried to do a replaceAll("\\n", "<br>"), replaceAll("\\n", "\r\n") or replaceAll("\\n", " "), none of them work.
Wordpress Integration for Current User
Hello We are a small company of 3 managers and 10 technicians. I wanted the ability to automate some of our work and create an app that we can use to organize jobs and vacations. Only one user is actually accessing the Zoho creator system (me), the rest would be using the app only (mebedded in a Wordpress site). Can I embed the app in Wordpress and then use REST API or something to send the WP current user ID so we can track who enters orders etc? Is this possible? Or against the rules? I've been
Fetch Value from dropdown within Subform
Hi, I am new to zoho creator and not sure about how to do the following with deluge script . In the Point of Sale application and I want to auto calculate the "Expiry Date" of each item added within the subform based on the invoice date. Expiry Date = Invoice Date + X months In Add_Product Form, i have added a field called Validity Product Name Validity(Months) 4 Lessons 3 5 Lessons 4 8 Lessons 5 Thank you for your suggestion!
Publishing a Creator Page with an included Form
Hello, i have a published Creator Page with an Included Form like this: htmlpage Anlageverzeichnis(CRMID) content <%{%> <div style="clear:both;" elName='zc-component' formLinkName='FORM_NAME' params='zc_Header=false&zc_SuccMsg=Data Added Successfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&CRM_ID=<%=CRMID%>'>Loading...</div> <%}%> but if i include this via iFrame in an Website i become the error: Can everyone help me with that? Kind Regards Klaus Brandt
Update two forms with same Data
Hie , In Subform i use this code (Code1 pic below) to show every category list depending on Lookup field option and this working well but i want these to update in Two different Forms of Same Application . so what code i have to use there ?
Date Field in Zoho Creator
Hi, I have been using zoho creator for creating many application. I always feel that it is nice to have a field for Time. I dont know why you guys are not allowing the "Time field" alone. It will be helpful you do so. Or provide any options for setting the time format criteria for single line fields.,
Download a CSV file but with semicolon as separator
Zoho offers a built-in CSV Download, but unfortunately it uses only "commas" as separator. Some systems requires a "semicolon ;" as row separator. Does anyone knows a solution for that ? e.g. programming the download based on a list from deluge ? Or does it Zoho has any plans to offer the "semicolon" version of the CSV Download as well? Thanks Alex
bug: matches function is not work in fetch record.
matchedRecords = formName [Single_Line.matches("abc.{4}d")]; matches function is not work in fetch record. abc.{4}d is regular expression can anyone help?
How to calculate business days between two dates ?
Team, I need to calculate working days between two dates for Task management . Two dates : ticketAssignedDate , ticketClosedDate . Need to achieve this without loop and recursive
keep the active session
I have a question, Could you help me or tell me the best way to connect to a REST API which requires to keep the active session? It means, First I have to call a login method to access other methods in the API. My code is: //CREATE THE HEADER PARAMETERS THE REST METHOD NEEDS mapHeaderParameters = Map(); mapHeaderParameters.put("Content-Type","application/json"); mapHeaderParameters.putAll(mapParametersRestMethod); // //CALL TO METHOD REST // // LOGIN
ID Field Required for Showing One Record In Report?
I use a link in an email to notify users that a new record has been added. The link is to the Report and I only want the new record to show. As far as I can tell, this only works if the ID is shown in the Report. Is this so?
Best Way to Filter Records by Field that Corresponds to Users?
So, I am trying to figure out how to filter records in reports based on the current user. I also have a field in these reports that corresponds to the user, but it's the initials and not the Zoho username Basically, I want to be able to filter the records so that only ones where the initials field is the one that corresponds to the current username. I had a bit of difficulty with syntax when I tried to create a formula to do this, so I am not sure how to go about this.
Configure Menu Item
When I click on a menu item, I would like to go to a Form or Page based on where I was when I clicked it. Is that possible? Is it possible to tell the target Page where I came from?
Eliminating duplicates on import
Hi, I need to regularly import data from a supplier into Zoho to keep my records up to date. The supplier data contains a unique reference. The data will be sent to me weekly and may contain records already sent the previous week. I need to import all the new records, but discard the duplicates. My question is therefore how do I do this? My assumption is that I need to create a new table to hold the imported data, then to run a function to compare it to the "master" table, adding new records before
If statement to send email
I created the following if statement to send an email based on the input of a selection field. I keep getting an error on line one missing a ";" The code is as follows; if (input.Location_field == "Day Support") { sendmail ( To : XXX@xx.com From : xxx@xxx.com Subject : "Test" Message : "Test" ) }
Zoho Docs Integration
I would like to create a document from a Zoho Writer template and then populate some fields in the document with Zoho Creator data. Is this possible? So far, I am only able to create a blank document. If some documentation exists, please point me to it! Thanks in advance.
Calculate a currency field based on current manufacturer
I have an Inventory form where I store all my part info. I need to adjust a field to automatically calculate when a certain Manufacturer is selected from the drop down field. I was thinking about a Fetch Records to do this. example; Inventory Form Manufacturer Drop-down field three pricing fields (A, B, C) If Manufacturer(Big Int field) ="Apple" Calculate Price in "A" times.3 and place amount in Currency field "C" aep=(Inventory[ID=Input.manufacturer].count()>0) if Input.Manufacturer.toString()=="Apple"
Converting date-time to date on a report display where date-time is the side effect of a formula subtracting days from a date
In some of my reports there are columns that look like this: "30-Oct-2017 12:30:00". I think the source of the time element is that I started out with a pure date on a form and performed some date-arithmatic on it (subtracted 30 days etc.) using a formula in the form. So the base column displays as a pure date but the derived columns display as date-time. Is there a way to fix this? To display (or fundamentally do the arithmetic) on dates instead of date-times?
To display contents of lookup form with a subform
I have a Form A with a lookup field from Form B. In Form B there is a subform C. I want to display contents from Subform C when entering data in Form A, sometime with one entry in Form A corresponding to like 5 to 10 rows from Subform C. How can this be implemented? I was looking for a field type like "Array" to display all records found in Subform, but the "on validate" action can't pull up Array values to populate such a field.
Please support reverse alpha sort on lookup dropdowns
Built a time logging app for technicians out in the field with dropdowns to log their time against a fault or job reference. Since the list of things to select from just keeps growing.. and reference numbers with them, the current implementation of dropdown lookup field with a fixed ASCENDING sort order puts the most recent at the very bottom of the dropdown. Pain in the a**** Please please add an option for descending sort order!!
zoho creator and google map
I have a form where I can insert information about my customers like name, telephone number and address. Is there a way to verify if the addres exists? Can I use google Maps API (how)?
autofill subform
how to autofill subform using details from another form. Help me with code.
Foreign key relationship - how to lookup records based on foreign key (parent key)?
Hi all, I'm modifying the Order Management application that comes with Zoho Creator. In the New Product form, I added an Add Items subform that captures individual serial #s along with a status field that captures the location of the the item. That all works well. Each time I go in to view or edit the product, it lists the associated items in the subform. Next, I modified the Product Subform that's included as part of the New Order form because I want it to pull all the related Items records for
SAML Authentication - Is this only available for ZohoMail ?
I read that SAML authentication can be implemented for ZohoMail, but no mention of it's implementation for other Zoho Apps, namely Creator ? Why is this feature not across the range of Zoho Apps ? I have a customer who insists on using a Microsoft Enterprise Sign-On, which is not available on Creator, which has forced me to start investigating Knack.com which does offer it. Any updates or a definitive answer would be appreciated. Neil The diagram online, indicates it is across Zoho Applications,
getting { "message": "Invalid Portal" } in response.
Hi, I have been hitting the below API GET method url = https://desk.zoho.com/api/v1/tickets?include=contacts with authtoken and orgid as headers like mentioned in the API documentation. But I am getting { "message": "Invalid Portal" } in response. I am sure my request format is correct. What would be the problem? when do I receive this response. Please revert back ASAP.
Linking two forms imported from Excel
OK, new to creator but have some database experience. I have imported three sheets from Excel that are related, i.e they have the same unique column index in each sheet. Had to split my data into three since I had too many columns for Creator. On importing into Creator I want to link / join the forms together so that I can create a report that has all the information in one view. (From reading the help sheets I need to create a relationship to do this. Lookup or Subform.) So, on the Members form,
Email link to record
I'm trying to create an onSuccess email. I want the email to include a link to the record that was just created. How do I go about getting that url?
Subform row heights - anything to do about it?
I would like to change appearances of subform rows in Creator Forms. There is a lot of space around the subform fields, which may look good on simple forms. However on large forms this is not practical. My client is looking to move the spreadsheet below to zoho forms. Additional options for columns would also be a blessing! Are there other means to achieve my goal?
Web Site embedded Dynamic Reports
I have an APP that takes User Input data and does a calculation & queries a database table. When it finds a Record in the database that matches the Query criteria, it generates an Output Report. I have embedded the links for the "User Input" form and the "Output Report" into my Web Site and they appear on that web page. The User Input form works properly accepting data entry from a user, and performs the calculation & query when I click the Submit button. My problem is that the "Output Report"
How to zoho creator create, update o manage variables of XML? Could you give a example?
Good afternoon everybodye, How to manage the XML response of a webservice? For example: <response><result><application_list><applications></applications></application_list><application_owner>Public</application_owner></result></response>
Ideas for Script Editor
I am not a big fan of the script editor adding parentheses. It often makes the code hard to read later. I would like to change the color coding of the text. Thanks,
Next Page