How to calculate a price using a pricing table with multiple variables
I have an input form that allows users to select several criteria regarding the attributes of a product (size, gender, etc) from dropdown lists. I also have a pricing table which lists the combination of these attributes and has a column for price (ive attached a screenshot of the table). I wanted to know what the code would look like in order to have ZOHO return a page that has the price of the options selected (maybe using openURL function?). thank you
Hide Field from main Form on Edit Record
Hi Zoho, i have question about sharing a view with user A. when user A view it and edit it, i only want him to see certain fields on my main form. how can i do that? b/c right now, he can see everything from my main form when he edit the record from the view. i cant hide the fields in the main form either, since i will be the only one sees it. i have some other people work on the main form as well. hope u understand my question. Thanks
Dynamic list within subform again. still need help.
I know there is already a post solved this problem. itis still not clear for me. so please point me to the light. thank you so much. I have 2 forms: Region Entry->Region Name is field City Entry-->City Name is field I need to have these 2 form within a SUbform within my Order Form. input from Region will populate City Name accordingly. Please kindly help out. thank so much for ur time.
Delete a record stuck at loading screen
Hi, this is my second post for this problem. no answer back from Zoho yet. trying to delete a record, stuck at Loading Screen forever. is this a common issue or just me.
Deleting Record stuck at loading
Hi, new database, only first 3 records. i cant delete them. please help. i have share access to application to support. please check your mail. thanks.
Minimum number of digits in number field
Hi, I need help with two questions that i have on the number field in the form. 1. In the number field of a form, we can validate the max. number of digits. Can someone tell me how we can validate that the field contains exactly (say) 5 digits? 2/ Similarly, how do we validate that the field contains both a minimum and maximum number of digits. cheers, KM
Sorting based on a specific record in subform.
Hi Zoho, I am in my trial period atm for Enterprise Edition. i am about to upgrade to regular soon and upgrade even more in couple weeks. this is my water testing period with Zoho database. so, please if you can, provide me with support as fastest if im about to bring my company onto zoho. i am still trying so hard to find a solution to set up criteria/ or sorting for view based on any single record at all in my subform. I have granted edit permission to support. please check it out. thank you kindly,
Express Plans - Users Create Accounts
Hello There are a few old topics on this subject but I can't find an answer. Using Zoho Creator with a Express Plan allows for unlimited users. Is there anyway to allow users to create their own users account either directly into the application, via the API or using a workflow. I'd like to provide a service where the user will provide their email address, password and other details and then be able to sign into my Zoho application. Thanks for your help. Ben
Alert Loses Focus
I use an Alert from the on Actions on User Action. After clicking OK to close the alert the original field does not have focus. In fact none of the fields on the form have focus. This is with Firefox. I have not tested other browsers. Herb Wexler
Zoho Creator (URL Request Structure)
Hello, I know I should really use the API forum area but it doesn't seem to receive as much attention as this one. I'm currently building an application which interfaces with Zoho Creator. I am trying to add records using the REST API. However, it does not seem to be working. My URL takes the form of: My application is definetly called 'Messages' and my Form is definetly called 'MessageForm'. Within this form is a field called 'User' that I wish to populate. https://creator.zoho.com/api/xml/Messages/MessageForm/add/apikey=<api
Help!: Can't view pictures...
Hi! When a user uploads a picture into the form, and you go into the view to download it, the following message appears: ""An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." Why is this? Thanks!
Is this even possible?
is it possible to have subform within another subform? Company A : + Store 1: (Product; Quantity; Shipdates) + Store 2: (Product; Quantity; Shipdates) + Store 3: (Product; Quantity; Shipdates) so, a record of Company A should show 3 stores. for each store, there can be a list of products, quantities for each, dates. can anyone try this out? thx
Attach a created file
Our application creates pdf files based on information in the database. Is there a way to attach this file to the database via script or email after it is created or when it's being created?
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,
Next Page