Force a Save in Script for Grid View
Is there a way to force the save action for the grid view from a script? I have an html view that has 2 grid views and form embedded in it. When someone clicks submit in the form? I would like to force a save action for all changes made in the other 2 grids.
Link Directly To Edit Entry
I have a schedule that executes every day, if an entry has not been modified in 7 days it sends an e-mail per a table requesting that the entry be updated. The e-mail contains pertinent information about the entry, but what I would like is for it to include a direct link to the entry for easy editing. Ideally this would bring up the same window as if someone went into the view then clicked 'edit' next to the row. Does anyone know if this can be done?
Hide options in Database View
HI In a database table view ,Is there any option to hide Add , Bulk Edit ,Delete options .. Thank You
Help Urgent
My Entry Form dont show up on user UI anymore. Need help urgent. everything else still there. I see it on my admin view. is this hacking issue?
order form and order details
I have built and order form and placed a sub form with order items. What I need to do is when the user selects an item to add to the order, it needs to look up the cheapest vendor of that item from another table and populate the vendor, price and item description to the order item record. Any suggestions on how to tackle this? I am new to Creator and Deluge script but not new to programming so technical speak is fine :) Thanks
Is it possible to validate e-mail field against my valid domain e-mails?
We would like to ensure people enter only a valid e-mail in our domain. Is it possible to validate this?
Is it possible to export a filtered report to PDF?
Hello, I have a report in my application to which I have added two user filters. When I select one of the values in the filter, I can see that the report gets updated to display only those values associated to the filter. However, when I select 'More Actions > Export to PDF' I get the full report (including those items which I purposely filtered out). Is it possible to export the filtered report to PDF? For example. I have a report which adds the total number of employees per department. In my report,
Submitting Files via Email
Is it possible to create a new record including an attached file via email?
Notes and Terms and Conditions in Invoice tasks
Are "Notes" and "Terms and Conditions" supported in invoice tasks such as zoho.invoice.createinvoice and zoho.invoice.createdraft ? I read help page but it's not clearly said. We use these 2 fields for writing some information for customers. It seems that other fields including custom fields are supported. So, if it's not supported, could you support these 2 fields as well ?
Multiselect - Returning all selected fields
I have two forms. The first form has a lot of information on different contacts. The second form has a multiselect lookup field where a person can select multiple of the contacts from a list. I am trying to write a script where it will them return all of the selected entries and add 1 to one of the fields. Here is the script I wrote for the same thing except a dropdown box instead of a multiselect: dat = Add_New_Contact [First_Name == input.Find_Person]; dat.of_Appointments = (dat.of_Appointments
Subform disaster
Hi, My goodness someone has really messed up the subform feature that you offer. Can I suggest you change it back until you have a chance to test it properly. Nigel
opeurl record-edit and form-perma
I have a stateless form embedded in my website that calls the following statement openUrl("https://creator.zoho.com/abc/xyz/form-perma/Customer_Info/record-edit/Customer_View/" + Customer_Record.ID, "same window"); The Customer_Info form appears but all the fields are blank. If I take out the form-perma then I am asked for my Zoho Username & password. After signing in the Customer_Info form appears with all the information for the Customer_Record.ID. Both the form and the view are public. Is there
Help building a function to filter data?
I have a form that contains a record for each branch (of which there are 5). Each branch has different territories (states) that they are allowed to access, but some of them may overlap (i.e. Branch 1 may be able to see records for IL and WI, whereas Branch 2 should only be able to see records in WI). The Branch records have a field which contains the emailaddress for the user in question. What I would like to do is create a function which will return the states that the logged in user has access
Too many decimals in Currency field?
In my app, sportspenguin, if Asking_Price>0, then months * Rate (USD) = Total (USD), where Rate = 1.2 (USD). So why, if Months = 3, does Total = 3.5999999999999996???? USD currency fields are 2 decimal points.
view add records permissions
Hi, I'm embedding in my website a view for our users to see the database and I'm creating another view for the admins with add,delete,edit permissions). It is possible to only have one view for all and if you are loged in as a Zoho user and I'm sharing this database with that user, they can edit,add,delete records? What I'm trying to avoid is having to create 2 different views for each database. (one for the user to see the records and another one for the users with permission to add records.) Thanks,
Unclear about form schedule frequency- please advise
Users post records that will be displayed in a view until they expire in 3 months. At 7 days before the expiration date, I want the user to get an email letting them know that their post is expiring in 7 days. I created a form schedule to do this, but I am not sure if it should run once or daily. Can you help? I only want them to get 1 email at 7 days before, so I assume that once is the frequency, but then I am confused, because the schedule needs to run everyday to email those whose posts
¿Spam Filters?
Does email data has spam filters, I am still testing it, sorry.
SSL in creator free version
I have a site using ZOHO Creator (free version) and need to find out more about network security. On your security.html page, you say to check the product pages for details on which applications support SSL but I can't find that in the Creator pages. In the forum, it sounds like you were working on it but is it in production? I also think it said all pages are now https but ours is still http and still works. Can you give me more information on network security using the free version of Creator?
Multiple Select List and Advanced display options
I'm using a Lookup field in FormA with Field Type: "Import Data" from FormB and Display Type: "Multiple Select List" (one-to-many relationship), also using the Advanced display options (displayformat showing 3 fields from FormB) 1. In the FromA EDIT mode, I want to display the records in the Multiple Select List that are only the related to FormA. Is there a way to do this? currently it display all the records in FormB with selected iteams related to FormA. 2. As a work around, I tried to clear the
Updating lookup picklist with "Advanced display options"
Hi! In a form ("SampleForm") I set lookup field "Client": [Appname] - ClientsBase [Form name] - ID [Field name] with Display as: (Advanced display options) "ClientName" In the same "SampleForm" I also set another picklist field "ClientType". My target is: When I pick "ClientType" I'd like to see in "Client" piclist Names of those clients only of choosen Type. I've tried: "ClientType" - on user input: clear Client; client_var = ClientsBase [Type == input.ClientType]; Client:ui.add(client_var.ClientName.getAll());
Devoloping a function
hii... Here is my requirement To develop a function to populate list of items . To develop a function to close the window . is this possible in zoho creator ? Thanks You
Display table with only (Edit or Delete) option
Hi, I have an application i.e view form ->having this field fist name : svenu last name :gopal email : venu@zoho.com etc fields With Edit and Delete options . once we click Edit or Delete -> that will go to the database table view . If Edit -> in database table only Edit has to show ... all options has to disable. If Delete -> in database table only Delete has to show ... all options has to disable. Is There any option to do like this or else Any other way functionality that will work on
How would you set this up?
I have tried doing this myself but am getting confused on how to structure an application. If someone(s) experienced could help me, I'd appreciate it. The application is for keeping track of hundreds of websites, their promotion campaigns, their rankings in the search engines, development and maintenance. The websites need to be able to be dealt with both individually and as bulk groups. The websites have a front page, and then 20 or more sub-pages. Each page on a website has 3+ keywords that each
Help in performing calculations in Zoho Creator fields
I have a particular problem, and I've been struggling with it. I thought I'd just go ahead and ask here. I'm a book review editor, and I want to use Creator to track books I've assigned, review due dates, how many days a book has been out, etc. Specifically, I have a field titled "Date Review Due." I want to look at another field, "Date Book Received," check to see if the reviewer has received the book, then look at another field, "Date Review Received," verify that the review has not been received,
NEED HEPLP: structuring application for a SEO company
I have tried doing this myself but am getting confused on how to structure an application for this project. If someone(s) experienced could help me, I'd appreciate it. The application is for keeping track of hundreds of websites, their promotion campaigns, their rankings in the search engines, development and maintenance. The websites need to be able to be dealt with both individually and as bulk groups. The websites have a front page, and then 20 or more sub-pages. Each page on a website has 3+
Sendmail script on edit
I am trying to create a script that sends an email if my Assigned_To field is changed. So the conditions would be as follows. If the Assigned_To field is changed then send an email to the user specified in the Assigned_To field. I can get it to send an email on edit if the the Assigned_To field is equal to a certain user, but I only want the email sent if the Assigned_To was changed during the edit. Otherwise every time a record is edited an email will be sent to the Assigned_To user even if it
how to publish the same 3 application at one user from one application
Dear Sirs, We plan to publish our application to other user. In that case, is it possible to make the same three application at one user from one our application ? If possible, how do we do? Best regards,
Searching in View
Hi! Is there anyway of adding a search bar in the view, or adding a filter that will search anything a user enters rather than setting up a filter option (There is no option for Equals to Anything) ? There is current an Equals to in there, but that means I'd have to enter every word in the dictionary to have a specific result! Thank you,
Limit number of records displayed in a subform
How can I limit the number of records displayed in a subform, both when it is displayed in a view and when the detail is opened to edit. We gather monthly statics on clubs in Africa. Years of data is collected, and I only want the user to see the current year at a time. Our main form has club info with a subform for attendance records. In a test (which didn't work) I tried to just limit to the Month of November. Below is a snipit from the parent form code: Weekly_Statistics ( displayname
XML RPC API Issue
hi, I am using XML RPC API "http://www.zoho.com/creator/help/api/xml-rpc-api/xml-rpc-api-add-records.html" for adding 20 records to my form. I have prepared the required XML request as per the your documentation and made a request. But in the response I am only getting the last record with 'Success' status. Also, the form reflects only that last record. Kindly look into this. Also, let me know if you need anything from me. Thanks Gurpreet
Query regarding the send email
HI I have question regarding send email functionality in zoho creator. To : r.EmailId From : zoho.adminuserid Subject : "Regarding subscription to our newsletter" Message : "Your subscription is approved" If i want to address to be dyanmic then in that case do i need to have paid account because it is not allowing us this in free account Regards Rana Ammar
Feature Request: Merge records
Hi, I've recently started developing an application for our organisation. The data that has been imported has some duplicates, and this is causing problems with our records. It would be great if in one of the views, I could select two records and click on "Merge" (which would display any conflicts, as well), and fix up any record relations. Is this on the cards?
Sum of field on related table
Good Afternoon, I am trying to find a solution to the following and haven't been able to find any help articles on it. In a table called Client I have a field called Total. I have a table called OpenItems with a field called Value I would like the Total field to be the sum of the Value field when the ClientID field matches. Any help on completing this would be appreciated. Many thanks. Best regards John MacPherson www.saffuze.com
Document date in age ?
Good Afternoon, Could someone please direct me on how to create a field that generates the 'age' of a document in days (not years). I can find the help file on calculating date of birth but I don't really understand the formula and which section to remove to convert back to days. ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2) I am confused why (zoho.currentdate - documentdate) doesn't appear to work. Also will this field only update on creation and if so how do I get the field to
Subform: How can show a field value existing in the main form?
Hello Zoho; I have a main form and a subform in order to track availability of consultant skills, idea is to add into main form all the information regarding an Technology open position. Then in a second instancy HR will add on the subform all the candidates matching that open position (Name, available date, CV file, etc). In order to easy track that I need that the open seat # field which is a field generated on the on add of the main form can be automatically passed to other field in the
How do you change the value of a List() element?
The help documentation is clear about how to add and delete (remove) an element from a List(). But, unless I'm missing something, there's no explanation on how to change the value of an element in a List() using an index. Example: myList = List({"Larry", "Mo", "Curly"}); myList(2) = "Shemp"; <-- this is what I want to do, change the element with index=2 (the third element) to "Shemp" ...now the list should contain "Larry", "Mo", and "Shemp" or, something like: myList(2).set("Shemp"); <--
picklist criteria
hi folks, i am trying to add a date criteria to my picklist however i am not quite sure how can it be done. the scenario is i only want the list on form B to show result that match the current input date on form A, so i put something like this in the criteria Date_field == input.Date_field but obviously this was not allowed, hope you guys can help. thanks!
Currency symbol (€ - Euro) not showing properly in HTML view
I have to put some € - Euro symbol in HTML view. It was working pretty well but now it shows as : € What can I do to solve that ? Thanks Pascal Veilleux
Very much looking forward to it possible to convert the Deluge to android and ios code...
Hi ZC team Very much looking forward to it possible to convert the Deluge to android and ios code services for mobile devices, if possible, will greatly enhance the developer's participation and bring to ZC broaderrange of applications.. Thanks Stanley guo 2011-11-24
Display uploaded image in exported pdf
I'm trying to export a pdf that displays an image that was uploaded. When I view the html view online, I can see the images. BUT, when I export the view to the pdf, the image disappears. Do I need to reference the image differently when export it in a pdf? Here is my reference to it: <img src="http://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=rec.Image%>&sharedBy=<%=zoho.adminuser%>&appLinkName=skypro&viewLinkName=Employees_View">
Next Page