Advanced Record Security
I'm just passing along an advanced tip I recently implemented on an application. I had the need for more than the just the zoho.loginuserid to view and edit a record, but not everybody. I created a text box field to hold a list of emails: And populated it using another form. Viewing the record it looks like this: For the view (now called report in the new builder) I added criteria that enables the record creator OR anyone on the "admin_list" to view and edit. All others see nothing. Hope you like
Update a FORM field via URL
Hello, Is there an easy way to update/modify a field in a FORM just by URL? I have looked through the forms and help areas and I cannot find anything on the topic. Basically I just want to change status field (a drop down) in my FORM from "New" to "Active" with once click. I do not want to have to to into the form, change the pulldown and hit save every time (that is already in place). I was trying to create an action button in the report list view that when clicked just changed that value - and
Size of file
I have an application where it is critical that I know the size of the file uploaded. Does not matter if it is before the upload or after the upload. I just need to know the size at some point. (I understand there is a 5mb limit this has nothing to do with my question) Is there a way to find out what the size of the file is? Any workaround or ideas will be appreciated. Thanks David
Formula with no time
Hi I am still new to using Creator. I have made a formula to add a number of days to a date field. Expression I've used: Start_Date.addDay(364) In the formula field it showing the correct date (364 days later than Start_Date) but it is also inserting the time. For example it is inserting like this: 11-12-14 08:00:00 Does anyone know or can help me to just get the date and not the time as well? Thanks
Developing on the IPAD - is it possible
Hello, I have tried to work on Zoho Creator apps on my IPAD and it does not seem to work. I cannot update the form properties. I am using the new interface. Is there something I am missing? Is this a known problem? Any help or some direction will be appreciated Thanks David
Hide/Disable Submit Buttons
Hi Think its critical to have the option to incorporatre the submit/reset/custom buttons into the deluge script so programmers can hide/dissable etc those buttons like any other fields. Rgds,
Iterate all Records and check a checkbox if match
Hi , I have tired to get this working for a while and have also tried various methods but I just can get it to work. Max has offered a solution involving a report but I would like to try to get it working like this. I would like a view in a room booking application that would show me the Rooms/units that have same day arrival and departure, so that I can put some sort of priority on the units that will arrive and depart on the same day. This is the solution I am working on: for each Record
Forms for customers to fill inn.
Hi all :-) I'm currently using , CRM, Support and Creator. I'm searching for the best way to get information from my customers. Ideally I would like to send a link on email to my client, directing them to a form online they will fill inn and attach documents. The data they fill into the form should ideally be editable into the future, hence a login function is desirable. Also important, the forms filled in, should be linked to their CRM Contact, for us to easily access it. Our business sell travels.
The Image field seems to be broken
Hello, The image fields does not seem to be working: I create the image field in the form add a new record - I put a link to a graphic in the image field - save - it shows the fine in the default report view telling me the link was saved okay - if I use IMAGE FIELD it displays fine in a PAGE view. (so far so good) However if I UPLOAD a graphic from my hard drive (instead of using a link) - it shows the graphic fine in the default report view - but it shows as a broken link in the PAGE view
Dropdown
Hi I have a dropdown box where the user must select a certain period (three , six , twelve months) When the user select the option the formula needs to calculate the correct amount of days to add onto the input date. Ex . - if user selects three then the amount of days must be 91 that are added onto the date entered. How would the formula look ? any ideas ?
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
Multiple Criteria
If I want to set a view criteria can I use multiple fields to set the criteria? For example: DATE1_Drop == something; DATE2_Drop == something
InBuilt functions for Oauth parameters?
Hi Are there any inbuilt functions/ supported libraries for creating the oauth (hmac-sha1) signature and other oauth parameters like nonce, timestamp in deluge script?
Record Level Access Control by Group - any better approach?
Record level access control by group is not supported by default, and I am looking for any way to achieve it by combining various features of ZC. When "userA" add a record, it is accessible only by him by adding a criteria like this. Added User equals to zoho.loginuser The same thing applies to "userB", "userC" and "userD". Now, "userX" is a supervisor of "userA", "userB", "userC" and "userD". I want to allow userX to access 4 users' records. My idea is to create one field, called "Permission" field.
if condition other form
Hi, I use a script condition in which if the Email of student it's founded in other form request and was authotirzed for a staff member (information in the same form) I show plain field (showing alert) and I hide a field (that suggest password, because was already comunicate in the other request). The script give no result expected. if (Count(Comunicazione_pagamento [(Email == input.Email) && (Staff_Tecnico != "")]) >= 1) { show plain2; hide Password; } Any help? THanks Mic
Hide A Formula Filed
When I try to hide a formula field the following error message is displayed. hide/show/enable/disable fields is not applicable for formula field Is there a way around this yet Thanks
hiding fields in views
I have a view that has something like 60 fields/columns. For each of my records, however, only 10-20 of those 60 fields may be filled in. The other 40-50 fields are empty. When I am viewing, I would only like to see the fields/columns that are actually filled in with data. If there is no data in a field, I would like to hide that field/column. Any idea how to do this?
New Zoho user - rookie question
Just attempting to enter "contacts" for the first time. Within that template is a space for "Account Name". Based on Zoho definition, an account is "companies or department within a company, with which you make busines dealings." I'm not at that point yet having just made cold calls to potential customers. QUESTION: If I put the company name in that slot, is it going to confuse future reports when I ACTUALLY do business with a company? How would I know the difference if I'm wanting to look
Tips on how to embed a mp3 player for a uploaded file
Hi, I'd want to embed a mp3 player in a HTML view based on a Upload file. I've tried couple things (simple and complicated) without success. Anyone has a tip on that ? Thanks, Pascal
Adding Custom Button to View
I need to add a button to a view. I know that I can do this by writing a function and then calling that function via custom action. My problem is that I want it to work like a static button. I doesn't have anything to do with the below records and the custom action forces me to attach the button to a record or set of records to iterate over. I want to add a simple button to a view that calls a function (function that does not reference a record) but I do not want to have to build and entire html
Back Botton Script Not Working - Dialog Box
I have a page that has an openurl(#) pop up script in it. This allows me to open a form without navigating away from the current page. the problem I am now having is that when I hit the back button it loads the dialog pop up box instead of taking me to the previous page. Is there any way to fix this? I have tried the following: #Script:page.back #Script:page.parent.back But both of them reload the dialog box instead of loading the previous page. Again, if i have opened any dialog boxes it will
OnLoad Get Url Variable
I have a view that is filtered using a url variable. Example: https://creator.zoho.com/app/app#View:Contacts?Contact_ID=1159827000001018003 When I click the "add" button from the view header I want the add record form to pop up but also call an "onload" script that uses the Contact_ID that is in the parent window url. Is this possible? All i am trying to do is grab the url variable before the new form loads and pass it to the new form.
Change text
Hi, I have a field in a form called job_ref. I cut and paste the job_ref from an email. the ref would be say HYG287/1/101 When I paste it into my form I want the / to be replaced with a - can anyone please help. Thanks Nigel
Create windows folder
Hi, When I create a record, there is a field called job_code. lets use the job code "axg101" For each record I create a folder within windows and call the folder the job code which in this case is "axg101" Is there a script that will automatically create the folder for me and name it whatever is in the job code for that file? Thanks Nigel
view criteria help
I can't figure out the logic to create a view that would show me records that have an ArrivalDate and a DepartureDate that occur on the same date. I need to be able to show Units that where the Guest will depart and another guest will arrive on the same date to the same unit so I can mark them with priority. Example Fieldnames: | ArrivalDate | DepartureDate | UnitNumber| | GuestName Thank very much.
Deluge Console
Please, Very ofthen you need to make some queries to calculate, fix or check something in application, make some relinks and so on It will be very useful to have Deluge console - you enter some deluge code (only one line) and get result or make some changes in Application. It's not very comfortable to create every time a new function in script section, run it once and then delete it.
Login and/or Sign up to access forms and views
Hi, Within our application users will be required to sign in / create an account. This is for privacy purposes, as well as creating view filters based on the logged in user. When I set a form or view to require a login there is no option to sign up. Also I want the user to be able to log in and end up exactly on the form or view I want them to land on. In other words, if User A is trying to access form A - after he creates his account I dont want him to have to find his way to the form on his own.
global todo list
Hey, Is it possible to do the following..... So I have a record for every job, some records require me to do an additional task but later on. What I want to do is pass the information from some fields in a record into a global todo list. e.g. Fields to pass to Global todo list. Date: 25/7/2013 Task: Phone Mr. Jones and ask when he is free for the meeting. o Click here to add to global todo list ---------------------------------------------------------------------------------------------- Global
Parse data uploaded from File Upload field
Say I put a file upload field in my form where my users upload an excel file. How do I parse the file data? I would like the data to be uploaded on Zoho Reports but I can't directly upload the file because I have to process the data first like separating a text, replacing a specific text inside the excel file, format the texts inside excel and so on, before uploading it to Zoho Reports. Just in case you were wondering why can't we just format the excel file before uploading, we want it automated
Need simple sub form.
I have a form that tracks landscaping issues. I want to add a button to each line in the view that opens another view of "comments" that people have made about the issue. I want the second (sub?) view to have the add/edit capabilities and when a person clicks add, the issue text from the first view is there. Thanks in advance for any help.
Stateless form problems
My application: I have a form where data is stored, including several radio fields with yes/no/others options. There is an employee name and a date field. I then have a stateless form that fetches data and populates the stateless form based on the contents of the primary form. This is where the 2 issues come in: 1) It populates the yes/no, but will not populate the others option - it doesn't select radio the circle or put the right data in. 2) If the fetch returns no data (which is to be expected,
Print a dashboard
I have a dashboard, based on HTML view, that contains a pivot table and two pivot charts. I am able to print each table/chart independently, but I would like to print to a pdf the entire dashboard. How can I set it up to do so? Thanks, Antoine
How can I filter the form view to show only the sum totals in my groupings
I have a form view that shows several groupings by city and all of the city's records. How can I filter the view to show only the city grouping name and it's sum totals on the last row?
Formulas
How can I make a formula into dollar signs? The two fields that are included in the formula are dollar amounts but the formula isn't. Any suggestions?
Criteria Help!
Hi- I am looking to restrict the number of entries in a lookup field in my form and need to specify the deluge criteria. I'm stuck! I currently have two fields I want to restrict with the return of records: "status" field and "discharge_date" field. I want the criteria to return only records that are either "active" status or have a discharge date within seven days of the current date. Can someone help me with the correct criteria to use? Thanks, Troy
How to restrict users to access a record in the table
I am making family/individual management application. I want all users to login to add/edit their family/individual records, but they should not see others' information. Adminstrator group, on the other hand, should have a full access to those people's information. I am new to Zoho creator. Is it technically possible to do with Zoho Creator?
form layout in html view
Is there anyway to drastically change the layout of a form in an HTML view? I'd love to be able to use my own styling and put the fields where i want them to go - I have a rather lengthy list of data, and I would much rather be able to arrange it as I see fit across the page, instead of a long list down the page. Any ideas?
Upload proble; Exportto different field names problem
Hi Zoho people In my new event app form some things dont work: ( I used new builder) (generally great by the way!) 1 Sub form > I have "name" field and "instrument" field. This data arrives on export as a long row of digits instead of words e.g. LINE UP : 1112234000000026029, 1112234000000026033 2 Uploads of images, PR docs: not appearing in exported file (images was small < 500k) In the sent email the FIELD NAMES for those do not appear either. 3 A problem using drop down font selection in
Change row color in View when field is not null
Hi, I already found a post where it's shown how to color a particular entry. I actually need to change the color of each row in a view, when a particular field of that row is not null. Plz help! Thanks...
Trying to add the resuts of formula fields - Help
I'm trying to make formula field, where I'd like to use variables from another formulas in this form. In result there is warning message, that "variable is not declared". I would like to add the sum of the formula fields to get a total cost. Thanks Ed
Next Page