hide print option
Hi, I am trying to hide print option in the view. I was trying with below code but it seems it is not working <div elname="zc-component" viewlinkname="MVPD_Channel_Form_Report" params="zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true">Loading View...</div>< See below output result: Can anyone please help me Arfater
HTML Close Table Borders
Good day could you please tell me how do I close the borders for this table, (bottom and right border) HTML output = output + "<table class='tableSize' align='center' frame='border'><tr><td style='width:20%;vertical-align: top;'>"; output = output + "<table border='1' align='center' cellspacing='0' style='border-color:#EEE;width:95%;margin:0px 0px 0px 0px' id='billingAdd'>"; output = output + "<td class='rowHead'>Consecutivo</td><td class='rowVal'>" + AvanceDiario.Auto_IDStr + "</td></tr>"; output
REST API Response
Hi I got the following response from REST API call. var zohochandrasekhar.kview54 = {"Welcome":[{"ID":"1205836000000077129","Image_Url":"https://pbs.twimg.com/profile_images/459764305567576064/ILQOFcfh.png"}]}; Can you please let me know why the string "var zohochandrasekhar.kview54" is added before the JSON response. Thank you
Zoho.userloginid to variable
I have an application that gives our clients access to complete questionnaires. Since I want them to have access only to their records, I setup views that display records according to the zoho.loginuserid. The views work fine, however the html pages typically display an error on the first attempt, then after refreshing the browser, it works. The same happens when trying to print the page...first attempt gives an error, then second attempt works. The only thing that may make a difference is that
Open Form with Lookup Value as a Parameter
Hello - I'm working on solution that will send email notifications on a scheduled basis to customers to fill out a survey via a link to a Zoho creator form. The survey form data needs to be related back to the customer form, so I've placed a lookup field on the survey form to accomplish this. I need a way to include the customer ID (the value of the lookup field) in the link so that the survey form can be related to the customer without prompting for that information. Using the standard "?customer_lookup=000000000"
Deluge script to new entry to a sub form
I want my subform to auto-populate with data when a option from a dropdown in the mainform has been selected. For instance, if "Jack" is selected from the dropdown and he has 3 kids, I want the subform to replace all the existing entries in the subform with 3 entries for his children. If "Mary" is selected from the dropdown and she has 5 kids, I want the subform to remove the existing entries in the subform and add 5 that are populated with info about her kids. I found many similar posts, but I couldn't
When will normal creator apps be able to carry over to Mobile Creator?
I'm excited to see syncing between normal creator and mcreator. Any idea when this will happen?
zoho.loginuserid in criteria
list Team_Events { displayname = "Team Events" show all rows from events [team == members[email == zoho.loginuserid].team] ( ... ) } team == members[email == zoho.loginuserid].team returns the correct BIGINT. If I set team to that number statically, it filters the correct data. Why then does this not work?
overriding report permissions
If I set the permissions for a report to allow add, edit & delete the following code in an openurl will cancel these options. "/view-perma/Board_Minutes?zc_EditRec=false&zc_AddRec=false&zc_DelRec=false" However if I set the permissions to NOT allow add, edit & delete the following does not allow these features. "/view-perma/Board_Minutes?zc_EditRec=true&zc_AddRec=true&zc_DelRec=true" Is this the way it should work or do I have a problem with my syntax. Note this is for a Customer Portal user.
Indicate that a field is different than a previous record
I have a flat database and associated form where, among other data, the user fills out his address. I also have a question as to whether the person's address changed since their last entry. Frustratingly, my users can't figure out how to fill out the "has your address changed" question accurately. I would like to add a hidden admin field that I can include in a report view that looks at the address the person enters, compares it to all the previous records, to see if the address was there previously.
Pictures
Hi there Is there a possibility to download several pictures uploaded by our countries at one or do I need to download every single picture of every clipping? Thanks for info! Samira
Digit Grouping for Zoho number fields
we'd like to see digit grouping feature for Zoho fields like Numbers, Decimals and currency. We have an application that generates bills and printed on invoice, but ZOho currency fields are not able to display digit grouping for the values. eg: we'd like a feature that would make USD 8346073.66 appear like: USD 8,346,073.66 Any help will be appreciated
Using checkbox as workflow automation
Hi, I am using a checkbox as a means to automate the process. As of now, I have 7 different selections in the checkbox. Each will have its own email sent out after it has been marked as checked. As of now, I am using IF statements to attempt this but i get an improper statement error. For example, the 7 checkbox choices are: (1) Awaiting Approval (2) Approved/Denied (3) PO placed (4) PO confirmed (5) Receipt received (6) Shipment received (7) Payment issued If I want to send an email after "(1)
Is't possible to move Form to another app
It will be very useful to have ability to move form and all assosiated views to another app. Now I have 4 app, which are full of different data, and they are using all, but sometimes it's nessesary to change architectury of whole application and I need to move some forms from one app to another. By hand it's very difficult to do. I understand that there may be some problems with openUrl function, which are using "#Form:.." or "#View:" navigation, but may be you can do something. I think it's possible
Area greyed out after selection
Do you have any suggestions on a form, that a area is greyed out after selection? The greyed area cannot be selected again.
How to NOT display "null" in empty fields
I have a form called "New Request" and a stateless form called "Update Request Status". In Update Request Status, I have a field called "Task Pending Notes" - here, the user will fill in the notes and upon submission, this will save the notes into "Task Pending Notes" in New Request, along with a timestamp. This happens every time new notes are submitted, and they are saved, collectively with each note and timestamp in "Task Pending Notes" in New Request. This is also auto-populated into Update Request
Sendmail - Email sent to multiple persons
Hi, I have used similar code on a related form and it worked, but it doesn't seem to be working here. So, what I want to do is say, there are two email address fields - one is called Email Address, the 2nd is Email to CC. I want the form to send out a certain email and cc the 2nd email address IF IT IS NOT NULL. This is what I have: if (((input.Task_Completed.toString() == "Completed") && (input.Request_Type == "Create new SKU")) && (input.Email_to_CC == "")) { sendmail (
Data validation check
In my creator database, I have two fields, one is today's date and the other is a delivery date. Many times people are entering the wrong date into the delivery date. I need to have some sort of date verification check to make sure at the very least the delivery date is later that today's date. Must be possible but how? Many thanks!
Feature Request: fetch record and select field to display within formula field
Hello, I have a table containing cities, one per line (e.g. 'Chennai'). This table has a column refering the country that the city belongs to (e.g. 'India'). I would like to create a formula field that displays 'Chennai, India', to be used in dropdown list. The reason I want to display the country along the city is because it exists two cities having same name but in different countries. Unfortunately, referring the 'country' column in the formula field will not give 'India' but the ID of 'India'
Embed web form
What are the steps to embed the web form on my website? Thanks
Error message <There is no such form in Zoho Creator>
have embed the form to blog, but it returns with error : <There is no such form in Zoho Creator> webpage (where the form is embed) : vezejubankas.blogspot.com Form's direct link : https://creator.zoho.com/vezejubankas/u-klausa/form-perma/U_klausa/ What I already checked: 1. code is correctly embed 2. direct link works fine Please, any advice? Thank you
Cannot share forms or reports
I am trying to share an application with one other user. I've shared several sections and forms with the user. The user sees the application on the home page, but when clicked on it says the user doesn't have access to the application. Please help, Joe
Left Expression is of type string in lookup
After reading a number of posts, I understand the issue that my lookup is returning an integer and my initial data is a string. I've tried following the advice in the one of the forums and creating a variable to convert my lookup iD to the correct field. But I get an error message now on the variable. If the two elements were strings my code would look like: Email == input.Employee meaning that the field from form Ticket_Entry would perform a look on the field employee in form Employee. Of course
user denied
I just today started my paid service with ZOHO creator, but already had my application and user access set up and working correctly. After my first monthly payment went through my 6 other users were unable to access the application I created. While they are able to log into their created Zoho accounts, they can no longer view the application I have shared with them. They get a access denied screen that asks them to try to log in using another account or go back to their home page. I have tried calling
Using Deluge variables in data stored inside zoho creator forms
Hi I am building an error handling mechanism for an application. i want to store the error codes, error names and error messages in a creator table and send back the data requested according to the error code called for. in some errors, for example when a variable sent has an illegal content - Example: Document type can be: 10,11,12 user sent the value 13 for a Document type. In addition to the hard coded message stored in the table, i want to include some dynamic value, in this case the value the
Image map in form?
Hi - noob here, is it possible to insert a clickable image map in a form?
Creator Background Image
How can i change the background like this?
Ordering Sections in Android App
The Sections (Tabs) are ordered alphabetically in the Android App, while the Sections are ordered as defined in Settings -> Sections. Seems to me the Android App should also order Sections as defined. Can we either change the Android App to respect the defined order or have the option to go either way? Thanks, Joe
change of workspace
Hi, Please can you change my workspace from motorinspections to intelligentautomotive please Also.... I want to put a picture in the notes field when a user accesses my workspace, but can only find the ability for text? Can you please advise asap. Kind regards
Sort rows in a subform with display numbers
Dear All, Lets say that I have a subform with two fields like Description and Display Number. I would like when I click submit to sort the list with the Display numbers which I gave. example The first will be Guide Excursion... The second Bus transfer...Land People The third Bus Transfer...Thessaloniki Each time when I give the display Number then to sort them. How can i do that?
Printing on View Record page not working properly
I have embedded a published report table on my website and created a template for "View Record." On the "View Record" page when I click the print button it redirects me to a zoho login page for my app. This is unacceptable for my workflow. Please let me know if there is something I can do.
UK Data - location of servers and data protection legislation
Hi there. I need to understand where the servers for Zoho Creator are located. I'm in the UK, and would like to use Creator for a series of databases. The UK's data protection legislation puts limits on the 'export' of personal data to countries outside the European Economic Area. If for example data is hosted in the USA, then I need to be able to demonstrate that I have explored the data security and privacy protection protocols that apply, and that they will not contravene the UK's legislation.
Can't delete field
I created two lookup fields (Introducing_Player and Introducing_Scout) in my form 'Search Profile'. Right afterwards I realized that I had done this in the wrong form and wanted to delete them. But the tools will not let me delete them as they are supposedly referred in script, which they are not. You have edit access to my app (I only have one). Regards, Filip
Email Notification Multi-Step
I have a multiple step form, that requires email notifications at different steps in the process. How do I do this? Example: In my Human Resources Time Off Request form, the employee must first fill out a time off request. After the employee completes his section, the form should notify the employee's manager via email (with the record). The manager goes in and approves or rejects the request. The form should then notify the office manager via email (with the record), that a request for time
Can I populate one form with data from the database?
Can I prepopulate one form with data that has been previously entered? I understand the 'lookup' field and to use it to connect one form to another. I'm wondering if I can create a script action that looks up data based on a user-provided selection from 'lookup'? dono2081
Dynamic Picklist
I was wondering what I have to do to my dynamic picklist so that if value "a" is present multiple times for it to only show in the pick list once script: Product = Add_Product [ID != input.ID]sort by product_type; select_product:ui.add(Product.product_type.getall());
adding form data via sms
is it yet possible to add form data via sms?
Value Total taken from SubForms
I have a question about getting a Total Value for the order based on grabbing data from sub Forms. We have a large input file which contains a new Report for each Activity within a Job creating a large disjointed data base. From that large IMPORT file we are then pushing certain information from that Import file into separate more specific forms. I have one form right now that is called Work Order. In Work Order there is the SubForm Jobs. A Work Order can contain 1-infinite amounts of Jobs that
Change current workspace
Hi Can you please change my current workspaces http://creator.zoho.com/workspace/educared.ec to http://creator.zoho.com/workspace/fundaciontelefec Thanks
How to setup multiple options, each with unique cost?
I am looking to create a form where a customer can select one of more options from a list of services. Each time they select the option, I would like the cost of that option to added to the total. Each option has a unique cost. I would like to create an option, give it a name, description and a cost. Is this possible in Zoho Forms? Possible to have someone create a custom form to start with, that we can add to? Thanks in advance for your expertise. I am not a software developer, just a casual forms
Next Page