Cannot see my post about ASP.NET
Hi, I added a new post yesterday and I cannot see it... I am very new to Zoho (6hrs old). My problem is I have to add records to zoho through my ASP.NET application. My Questions are: 1. I don't understand about the ticket... it expires every 7 days? meaning I have to generate the ticket every 7 days with in my app 2. Any sample will greatly help Thanks
Fetch records WILL not fetch Rich text and WILL not fetch URL fields?
It records these but WILL not fetch them back? My form fetches everything but these? Anyone? Please?
Limitations on HTTP Post?
I tested my AWS-SES/ZC app this weekend by attempting to send 200 test emails. After about 90 I got an exception violation as the http response from the post. Querying my Amazon account, I did not see any issues. I'm assuming the fault was on ZC's side. So I'm wondering if I've run-up against some limitation with http post? When I post to my PHP api, the deluge statement is AWS_POST={ "FROM" : input.FROM, "SUBJECT" : input.SUBJECT_field, "BODY" : BODY, "SUBSCRIBERS" : SUBSCRIBERS }; From, subject,
Newbie Question: conditional expressions in zoho creator forms
I am trying to build a form in Zoho Creator that firsts asks the user to choose one of three options from a drop-down menu, then assigns a value to that entry based on what the user chose from the drop-down menu. I am currently using a conditional expression that looks like this: if((DropDown == "Option 1"),10,0) The problem is that if the user picks anything but "Option 1" from the drop-down menu, the value assigned to that entry will be 0. I cannot find out how to use the "if, else if, else"
Script reformatted to single line
I've written a script and it looks fine initially when I paste it into the Zoho scripting tool. However, when I save, leave and come back, the script has been reformatted to be on a single line. This makes it impossible to edit in the scripting tool. Is there a way to prevent it from reformatting the script? Thanks!
How do I update a date field within a form when a user modifies another field (example approves the form request)
Totally confused! I'm trying to declare a variable and fetch the most recent record when field is updated. I don't know the fetch arguments in order to update the particular field. (My application has a form to request $ for loans...I need a date stamp when the user approves or rejects it.)
Form validation on edit not working?
I don't think it's me, but knowing me it probably is. The field validation that was working before just stopped, seemingly out of nowhere. When I found it not working I then tried to get just a basic (if this input doesn't equal this number then alert and cancel submit) and still no go. Here's what I am trying to get working: if ((input.Status == "Repair") && ((input.Repair != "Sanding") && (input.Repair != "Lamination"))) { alert "Don't forget to mark who's repairing it above";
Creating a "table" form input
Hi, Is there a way to create a table that a user would fill out? For context, I'm trying to create a table that has "Cost Center", "Cost" and "Tactic ID" as the column headers and would like the user to be able to enter multiple lines (i.e. split the cost of a project across several cost centers. Is there a way to do this? Thanks!
Very Confused Newbie re: Public Forms...
Ok - I have spent far too many hours creating a multi-page form, but everything is essentially working except - I have spent hours trying to figure out how to allow my customer to fill out the form. If I make the application public, then the customer sees all of the application, views, etc., which is not good. If I make the application private, then the customer needs a login, which they won't have. I tried using the permalink code without login, but then I haven't been able to pass the record id
Type mismatch seems bogus
Problem: I built a multi-page stateless form, following the excellent example of the Summer Camp Registration. The pages 1 & 2 both store fields in the master form, as expected. When attempting to follow the same process on page 3, I cannot add the code to the form definition, because I keep getting an error modifying the page, as follows: The field rec.TargetRevenue1 is of type BIGINT. But you are trying to update it with data of type DECIMAL However, the fields TargetRevenue1 and the corresponding
2 Views - Different User Restrictions - Photo shows for one user but not another
Hello, I have a membership application that contains member information. Since there is no way to control access permissions between various users I have done the suggestion of creating 2 different views All_Members and All_Members_Restricted. I share All_Members to users that I want the Edit and Delete links to appear and for the users I don't want to give edit and delete capabilities to I share the All_Members_Restricted. This works fine except for one major problem. I have a photo upload and a
Can ID be used on multiple forms?
Since ID is unique for each record, I guess I can't set the ID of a record in another form, is that correct? Since I have a record that's starting on one form, and transitioning to a separate form, in order to keep a link to the original record, I assume I must create a third id type field for the two records on the separate forms to share - is this correct thinking? Thanks! Kenny
Fetch Records Based on Two Conditions
Hi: I am trying to Fetch Records based on two conditions. This is the general idea of what I am trying to do, and I realize the syntax is not correct: statelist = Grove[Field_Name == input.Field] sort by Grove_Name && statelist = Grove[Scout_Check == "Grove Check"] sort by Grove_Name; Does anyone have a suggestion on how to make this work? I am new to Deluge. Thanks!
Automatically record the site URL which contains my stateless iframe embedded form
Hi not sure if possible but lets see I have 20 Sites each with the same contact form (name, email phone etc ..) I am using a stateless form embedded in an iframe The only difference in the form is that i hard code in a hidden field the url of the website, this is so i can determine which website sent the user submission So at the moment i have 20 forms. Would be nice to cut it down to one form, if only i could write some script that would allow me to determine which site the form is on and have that
Making search results selectable
After creating an html-view for a search form, I want the user to be able to select one of the returned results, which will then be passed as a parameter to the next html-view. But I don't have a clue how to do this. The attached codes is for the currently working html-view. It currently returns an ugly table showing each record matching the search criteria - so user can enter any data he has (phone, zip, name, etc.) and see which records might be the one he's looking for. Now, I need to be able
Unsure How To Structure This Search
I'm trying to make an app that will allow me to input information from a card, then allow me to search the results based on multiple criteria. This is what I have so far: Card_Input Form Name: <value> Type: <value> Cost: <value> Card_Search Form Search By Name: <value> Search By Type: <value> Search By Cost: <value> I've got an HTML view that displays the results. Right now, I have it working for one variable, but I'm unsure how to take it further. I'd like to be able to search for one or all
Need help sorting before output to html view - List()?
I am trying to fetch data from one table based on entries in a second table. The fetched data needs to be sorted after collection and before output to my html view. Here is an example of what I am trying to do: I have a form/table called Enter Genotypes. The table contains 12 fields that each represent a specific gene and each field has a dropdown that displays the genotypes that relate to that gene. The user selects the appropriate genotype from the dropdown. Each gene (field) can have a unique
Update Record error
I have a task form that contains DueDate and also a Priority field. What I'd like to do is to arrange it so that when the DueDate is approaching within X weeks or days, it will automatically update the Priority field to "1-High" Ultimately (which I'm not sure if it can be done) my employer would like the form to auto adjust the priority not only based on the DueDate but also on the EstimatedHours for the project. For example, if it will take an estimated 100 hours to complete a project, the project
Tooltips do not display
None of the tooltips in my applications display. I'm using the following browsers: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.5; en-US; rv:1.9.2.19) Gecko/20110707 Firefox/3.6.19 and Safari Version 5.0.5 (5533.21.1) Any advice? Thanks,
User selects 1 record out of search results view...
I painstakingly built a search form with html view as follows: user enters whatever piece of data they have - such as partial phone number, zip code, business name, etc; view then retrieves a few fields from each matching record and displays them in a table (super ugly at the moment, but functional)Now I want user to be able to select which of the matching results is the desired record - select that result - and go to a new html view or form displaying all of the data for that record.
Cant delete applications....?
I gave shared a zoho applicaiton with another of my creator accounts as a test. Problem is now i cant delete the application from zoho. What happening and why? Well actually i get this long error message. i dont want to go through the application and make all these modifications just to delete the app. What can I do? There are actually 3 apps I want to delete all giving the same type of message. The applications are as follows and they are all installed on this account. Copy of Art Inventory
Converting a payroll workbook in Excel to Creator
I have a payroll spreadsheet that we use for our business, as I have been unable to find a software package that does things how we need them. We pay our people "by the piece" doing electrical work, and we use vlookup, drop down boxes, and various equations to calculate payroll. Love to find a way to do this online with Creator and have it export info in a format acceptable to Quickbooks online. Any recommendations? What should I budget for something like this?
iPhone GPS and Zoho Mobile
Hi: We are using Zoho Creator a like it a lot. However, the one thing that we cannot figure out how to do that we need is to get GPS coordinates on iPhone using Zoho Creator Mobile. Does anyone know if there is a way to do this? Thanks!
Function for returning date after adding x number of business days (no sat, sun)
I have a customer that wanted to let a user schedule 4 BUSINESS DAYS out. I couldn't find a saner way to do this so here's my function. date helper.bizDays(int days) { iterator = helper.iterator(); time = zoho.currentdate; for each n in iterator { if (input.days > 0) { time = time.addDay(1); if (time.getDayOfWeek() == 7) { time = time.addDay(2); } else if (time.getDayOfWeek() == 1)
Can I change My zoho id?
Is there a way to change my zoho id? My business name has changed and my current zoho id must change or I need to somehow move all my applications and records into a new account! Any help on how to make this move without too much pain would be great.
Update Record from Stateless Form
Hello, I have an application (https://creator.zoho.com/jpiajr/compost-tracker) that I woudl like to do the following As it stands now, the first stage of the process is when a user fills out the Phase I form Once that form is submitted it creates a records in the "data_form" (which is the master form that the stateless for feeds feeds into) what i would like to do is have the buttons i created on the "View_Data" view to be able to open the a certain stateless form that is relative to the ID. so that
Email notifications activated...not receiving email notifications
Hi, I created a simple form that I'd like to use to capture data and then email out to a variety of email addresses. I've gone through the instructions and have done the Set Email Notification section. Everything looks fine, but when I go and test the form by submitting some info, I never receive an email. Any thoughts why that is? Thanks
Challenging Task: How to prevent double bookings
Good morning zoho crew! My new task is how to prevent double bookings. Stateless form Guest_Reserve form Test_Reserve holds the table fields date time Zoho date/time start datetime Zoho date/time end number Number_of_Riders number Current_Seats_Available picklist Status (Reserved, Waiting, Available) is there a way for zoho to check for times that are booked ? maybe something like count Zoho date/time start between Zoho date/time end if input.Number_of_Riders is more than Number_of_Riders mark
changing text to other symbols
Hi. I've read some forums around regarding the lack of support for creating password fields in Zoho Creator. I noticed they were dated back around 2009 or so. I was wondering if there are any improvements about that as of today. In addition, what I really want to know at the moment if there is any way in Zoho Creator to change whatever is on the text field into something else, like how a password is like for example. Well, through coding... Like... my password "12345" will instead show up as "*****"
Aggregate Sum function
I am using the aggregate sum function <variable> = <Form_Name>[criteria expression].sum(<Numeric Field Name>); First issue is if there is only one row then I get a null variable. Second issue is when there is more than one row I am getting incorrect results.
Get property of record using only ID
Hi there, We have a Project form, a Job form, and a PO form. The Job form has a lookup field that links to the Project form's ID but displays the Project's Name. The PO form has a lookup field linking to the Job, but I'm not able to have it display the Project Name associated with the Project ID that is referenced in the Job form rather than the ID itself. Any way to do this? One way to do this would be to create a formula where it finds the Project where ID == something and then get another property
newbie question re: lookup fields & form/view
Hello: I have a form with perhaps 50 fields, which describe a new contact and various attributes of their business. Now I want a second form that allows me to look for a record in the first table optionally by various fields, such as 'BizName', 'LastName', 'ZipCode'. So I can find the record by whichever piece of data I have. When I select the correct record, I want to see many of the other fields from the original form displayed on this new form - so I can update them from here if needed, and so
More info and print buttons
I there ! I'm trying to build a simple online database but i'm having some problems dealing with Zoho. I'm stuck in the following problems.... i need to do something exactly like this and i don't have a clue how to do it! I need also to know how to format HTML Views to make nice database lists and be able to print them. Please, point me at the right direction ! Thanks.
Is it possible to set a custom schedule to run only on weekdays?
I have a daily custom schedule that reminds users to return items they have borrowed. Currently, if a user has an item due on Friday, and they don't return it, they get reminders on both Saturday and Sunday. I would like to skip the weekends, so they only start on Monday. This would be a great option to have in the Frequency GUI drop-down menu...
Email a single record
I have a purchasing form and for certain purchases, they will need permission before the purchase can be made. So I would input the information then put it on hold, email the info out, and then once given permission place the order. I know you can email a record upon submitting a new record or changing/updating a record. What I want to do is email a record from the List View by creating a custom function because not every record will need to be emailed, only certain ones will need emailed. Or
share 1 application to another zoho account multiple times?
Here's the scenario: I have created an application in my account. I have shared it with another zoho account so that when i update the application on my first account it will allow the other accounts it has been shared with to update the application. My question is, can I share the same application to the same zoho account multiple times? I would want it to have a different name for each share and each application would have different data. Also, when i update my single application in my first
[t_811321000000024029_PIDX] Exception occured while inserting rows Failed to update data.
Hello Zoho Creator Team: I have the following error while trying to update data [t_811321000000024029_PIDX] Exception occured while inserting rows Failed to update data. :( I'm in the middle of something here and needed fixed as soon as posibble, hope you can help me :) My app is: https://creator.zoho.com/andrea.gmcr/sistema-producto-mango/#Form:Sistema_Producto_Mango_Form I thinks its related to this posts: https://help.zoho.com/portal/en/community/topic/critical-error-t-734872000000029031-pidx-exception-occured-while-inserting-rows-failed-to-update-data
Syntax error: function doaction(recType).....
I receive this error when running an HTML view called Start Here in my application. The error message is: function doaction(recType) { } $(document).ready(function() { doaction(); }); I have shared the application with support. The easiest way to recreate the error is to select the tab Show Preview while Start Here is open. The script will prompt for an email address; enter a dummy email address (xxx@yyy.org will work fine). The script will display the correct form on the screen with the error
Hide certain fields based on what view the user is coming from
I have a fairly large form with a lot of information on it, so quickly filling out a small section is a bit tedious. I am wondering though if I can use "hide" or "show" commands for certain fields based on what view the user is coming from. I know I can do this based on the user's ID, but since all users need access to all the fields this is not an option.
Multiple tabs in forms
Hi, This has been a reoccurring question over time and I'd like to pose it again. I have many fields in my form and there is currently no good way to group them. Are you considering offering multiple tabs in forms? I know you offer stateless forms but this is not suitable for my requirements. It is purely a presentation issue, I need to be able to group information on one form, with easy, quick access to all. Multiple tabs across the top of a form would be the IDEAL fix for this. If this is not on
Next Page