How to set a field to a value contained in another form On Input, etc. while referencing a selected key value
I know this is doable, but the tool (Script Builder) and my still weak expertise in Deluge is preventing me from joy on this simple task. In a form I have a lookup drop down which gets populated with a list of names from another form. No problem, works fine. What I want to do is when a user selects one of the names in the lookup drop down list, another single line field in the form gets populated with a piece of information from the other form related to the selected record in the lookup drop down.
Reference previous record on formula (please assist)
I am attempting to do a calculation inside of a Zoho Creator application. I need do math on the following formula: (Todays_Inventory) - (Todays_Shipment) - (Yesterdays_Inventory). However I do not want the person to have to manually type in yesterday's inventory, because it is already in the system under a different record (in the Todays_Inventory section on the previous record). How can i tell the formula to look back 1 record to obtain this information?
Hierarchy
I am interested in learning or paying someone on how to create a hierarchy within my application. The app will be used in an organization and will allow management to see the employees. There are 5 levels within the organization: Sales Representative, Asst. Manager, Dealer, Distributor and Master Distributor. I would need the app to allow a manager to add employees and pick who their direct report is. Then I would need a view to show the chain For example: If I am a Distributor I want to
Number Format in Email Notifications
I am trying to create an email notification for a vacation rental application. When the "booker" updates the records status to "Reserved" the email notification is getting generated; however even thought the number fields are set to currency (2 decimals), the email output only shows 1 decimal place and no commas (see below) Can this be adjusted in the deluge code or HTML? Rate: 1200.0 Deposit: 300.0 Cleaning Fee: 150.0 Pet Fee: 0.0 Tax: 126.0 Total: 1776.0 Should be Rate: $1,200.0 Deposit: $300.0
Filter on a field created by a Picklist
Ok, I'm confused about how this works . . . . I'm trying to filter data like this - if ((count(Workshop_Job[Assignee == input.Owner]) > 0) || (input.Owner == "-Select-")) But I want to also filter by a field from Workshop_Job that is derived from a Picklist - a 'Status' field. But the field 'Status' supposedly doesn't exist in Workshop_Job. This is evidently because it is derived from a Picklist. I don't get it. So how can I filter the Workshop_Job records by 'Assignee' AND 'Status' like -
Formula Help Needed
Hey all i need help with the formula section of this program. So i have a few dropdown menu's all containing text and numbers but what i want to do is when the user selects one of the drop down menu's it add's the price of that item to the total cost and display's it. So i need to somehow get every little part of each dropdown menu and declare a different value to it and then make it at the end add them all together and then display. I would like it if it updated this total after every change the
Envoking functions besides in a form or in Custom Actions
I haven't yet experimented with getting this to work. However, before I "commit" to building a full html view of a view I want to know if there ways of envoking funtions through an html form button or a html link... VS the normal way of having custom actions in your view. Any thoughts? Thank you for your help.
Linking two applications without the API or cross application functions
Just an fYI Came across a pretty useful method of using other application's forms..... copy a forms iframe snippet (the one with out signing in!). Drop it into an html view. add parameters to the URL like <iframe height='500px' width='100%' name='zoho-Daily_Stats' frameborder='0' scrolling='auto' src='https://www.creator.zoho.com/testy/testapp/form-embed/Daily_Stats/QhqYTxfe0bqCFUVAZqvh3Mufp2txpSXFCJFUMnfn3pEWawSUgUP9DKDZbJuEM03NfynXU0Sb6EgMXSMfudp4fXUaw4Namd2MnUGh/&my_field_value_in_framed_form=<%=input.parameter%>'></iframe>
Update Global Variable on record delete
Hi, Is it possible to run a script when a record is deleted from a view using the built in 'Delete' link? As far as I can see there isn't but I would be happy if somebody told me I was wrong. When users add a new record to a Event attendance form they have to state how many people will be attending (input.No_attending). The number attending is added to 'Global variable' AttendeesTotal (function) to give me a running total of how many people will be attending. If an attendee confirmed they couldn't
Help needed with form
I am trying to create a feedback form for third grade students. I have created a webpage with 24 different activities from which they can choose. I have made a checklist of the activities, but I want them to tell me how difficult each of the activities was (I have a radio button setup for this) and whether they liked it (also radio button setup) What I need help with is making the difficulty and satisfaction come up for each checked activity. If I need to create the difficulty and activity fields
HTML View - How to email the page?
I have created an HTML view, but want to take the code and email it as a rich-text email. Is there a way? PS: You cannot email i-frames, so that's out.
Shrink-The-Web Thumbnails?
Does anyone know how to leverage the power of Shrink-The-Web to display thumbnails based on a URL field stored in a database?
Secure page
Hello, Is there anyway to create a secure page that clients can go to to fill out a form including their credit card info? I would love to be able to do this vs asking for the info over the phone which is what I do now. I think they would feel safer doing that. Thanks, Eli
Why Can't I Change Milestone To Which Task List Is Assigned?
hi in Project Manager Plus, i want to assign a tasklist to a different milestone, but i cannot. the milestone field is disabled, when i 'edit' the tasklist. why? i should be able to do this. ...ok, i'm starting to see that i must implement a custom control on the new_tasklist form, which let's me pick the milestone, and somehow links it to the milestone ID field. i tried this manually, by unhiding the milestone ID field on the new_tasklist form, and it half worked. on changing the milestone ID field,
User input variable
Hi This could be a very stupid question, but I just can't figure it out or find any info in the help docs... I have created a Custom action. When I activate this action I want a window to pop up and ask for two values that will then be used in calculations for modifying the database values. But I have no idea how to create two user input variables ... Please help!
Asynchronous loading in HTML View
Does anyone have any suggestions on how to "emulate" asynchronous loading of information in a view? I have created many css accordian boxes right in a comment field on a form. (works great by the way for data you don't want edited and want to take up less room). Just hide the fields you don't want people to edit. Example of box here.... Code Example: // style for statbox stat_stylevar = "<head><style type='text/css'>.holder {width:260px; margin:0px; padding-left:1em; padding-top:0em; padding-bottom:0em;
Keyboard Shortcuts
Ok . . . hope I'm not monopolising the forum! Are there any shortcuts? For example, if you're running your app (to check it does what you thought it should), is there a shortcut to go straight to Freeflow Scripting? It's just a bit tedious stepping through . . . . . Thanks - Graeme
Giving a label to a grouped total in View?
I have a grid view of time entries, grouped by the Date field. When I tick the "Sum" option for the "Hours" field, i get a handy sum at the bottom of each date grouping. The only problem is that there is no way to label that total, so i get the number with no context. Is there any way for me to add a label to the total row? Thanks!
Can't figure out lookup
Hi, Lets say for example I have an Employee form. Most employees have a boss (who is also an employee). How can I have a lookup field (a dropdown box) that lookups from Employee.Name ? Lookup fields appear to only be able to reference other forms, not the form they are in. This is pretty common stuff in Access or any other SQL database, but I cannot figure it out on Zoho. Please help!!! Thanks
css background
So I'm trying to add a background to an HTML view using the css background code and it won't let me display the background in a #View. Only as an html/view URL. I have tried both a style script in the <head> tag. Is the <head> tag supported? I have also tried an inline style as well! I can't seam to figure out what is going on!
Time Tracker
Ok so im trying to take a list of people and give them hours, it should be simple to do you just check the box's of the people that you want and then it should total that persons hours for the week. the only 2 things i dont understand is how to make each check box create a diffrent record vs. putting them all in one since its a list of check box or total them from the list of multiples -TechIsCool
Add Images
How to add (attach) images and use them in html code?
Error On Deluge Autonumber Script
the validate script below is giving me the following error: "Invalid entries found. Please correct and submit again." this is an autonumber script, copied from the Deluge manual. here's the explanation. x = MaxIDs [ID != 0]; input.TaskID = (x.TaskID_Max + 1); x.TaskID_Max = (x.TaskID_Max + 1); why am i getting this error? i'm using it in the Project Manager Plus app, from Marketplace. THANKS
Dynamic fields
I am building a survey, and I need to display some fields for one survey and another set of fields for another surveys. The surveys are for each country. There are 200 countries and each country will have its own set of fields. How can I do this based on URL parameter? Ramin
How to use ZC API METHODS
I am new in the ZC API METHODS. I tried to use the REST API METHODS LIST (url: http://api.wiki.zoho.com/REST-API-Methods.html). For test purpose I have a JAVA program that use the view Record - Get Method (url: http://api.wiki.zoho.com/ZC---View-Record.html). Find bellow the program. Due to security reason I do not include my apikey. When I run the program I do not get nothing ! can some one help me ? Antonio -------------JAVA-------------- public static void main4 () throws Exception {
Compare Two Lists
I know how to do this in Excel using VB, but cannot get anything working in creator. Basically, I have two lists in ZC, call them A and B. These are separate single column databases: List A is a vary long series of numbers while List B is very short. What I want to do is tag List A with any entries that match in List B. I'd add a new column (text field) to List A for the tags "matched". I'm just about ready to pull these into Excel and do it with VB, but wanted the Zoho community to take a look first.
How do I import data from a spreadsheet / csv file with carriage returns in the data?
I am trying to import data into a creator database from a spreadsheet, and one of the columns has carriage returns. Do I need to conver the carriage returns to another character to load the data, or am I just totally missing something in the load? Thanks.
Can I use HTML view to control Forms fields?
So that I could style and locate fields the way I want? and use this form as a page to collect data? Ramin
Client side API
I am trying build a custom look and feel for the form and tried out Client Side API. I can see the fields, but I cannot make the functionality that I built in ZC work. For instance, I could add ?id=xxx to URL and it would prepopulate fields for me, but with Client Side API, I cannot pass the parameters. Any thoughts. Ramin
'Nex' instead of submit?
All- I'm developing a lengthy form and would like to break it up into multiple pages... What's the easiest way to achieve this?
How to check if there was a date input?
Hi, at add|success I tried to check if there was date input in the form, if not ---- the record in the database has to be filled up with the current date. if (input.date == "") { input.date = zoho.currentdate; } ... is not working because: The Left expression is of type TIMESTAMP and the right expression is of type STRING and the operator == is not valid here Anybody know a solution? I have got no time today to check by myself ;-) Thanks in advance, Paul.
Logic for Checkbox On Load
This is not working.... If (input.My_status.select("Enrolled")) { alert "You are enrolled" } else { alert "You are not enrolled" } How do I perform logic On Load for a checkbox?
Integration of Contacts
Hello - I am creating an application with ZC. In many forms/tables, I need to access basic information about Individuals and/or Companies ie, name, address, birthdate, etc) Information that could happily live in Zoho Business: Contacts Is there a way for my AC application fields to lookup the data from Contacts? Or, do I need to create it from scratch within my application? Thank you - Marion
Adding Records By email With Empty Fields
I have a form with many fields I use for people to submit stories that we might cover. It includes dates and many other fields that we use to assign the story to some one and track its progress towards completion. Most organizations do not have the time to fill out the form and just send us an email announcing their event. Until now, we've cut and pasted those emails into the form to create a new record. That's a labor intensive process and I'm looking for a short cut. I would like to forward
Stateless Form > Redirect Upon Submission
I will be using Zoho Wiki pages to display my forms. The forms are pasted in as ZC i-frames. The issue I have is that after a user submits one of my stateless forms, only the i-frame is updated. Here's the end of my script... alert("Thank You! You will be notified by email after the PTO moderates your suggestion. This page will now reload."); openUrl("http://mywiki.net/Suggestion.html", "same window"); Is there some other way to notify the user of his success in submitting a stateless form, and then
EMAIL DROP DOWN BUTTOM
Hi, i need some advise, i got a form set up, but in my form i have a drop down box with 50 peoples names, i want to make my form in scuh a way when the visitor complete my form they select the relevant person from the drop down box, when they click the send button it must email a notification of the form to the selected persons email adress, I obviously need to add all the relevant email adresses somewhere, but when they send it must only send the form to the selected persons email adress, Can someone
Creating a Form Picklist using criteria based on common ID from different Form records
I am trying to create a Picklist that has a criteria based on a common ID stored in different Form records. Here is the scenario: ACCOUNT Form - creates records for Companies - unique record ID is created (Account.ID) CONTACT Form - creates contacts with reference to Account.ID (Contact.Account_Name) - has field Full_Name for Person's Name (Contact.Full_Name) NOTES Form - has picklist that imports Contact.Full_Name (Notes.Contact) - has the parameter Account.ID fed into it and stored (Notes.Account_ID)
Edit link on view record openning up in New Windows??
Is it possible to chose how the "edit" link on a View record opens up the input form for editing? At the moment, the input form opens up inline to the page being viewed, which is fine inside the application, but unfortunately it becomes a problem when the View is being embedded into another website using the <iframe> approach as it creates a very small scrollable region for the input form. The <iframe> height is set to auto as I have more than one View being displayed on the external website page.
Embedding Deluge Script View not correctly using "no prompt for login"
I have a deluge script view that I have used the "Embed in your Website" without require login feature, however the login prompt still comes up when I view the page with the embedded iframe in it. What is wierd about this situation is that some of the embedded page does work and some does not. The iframe code is very straight forward: <iframe src="https://creator.zoho.com/XXXXX/crm/view-embed/Detailed_Account_View/9sneBBK3zXr9NNOEezxttKGfaO5U0MAVZ6RuD3YQgAR9KNmedYH0TmerJuHWGX7AwnOsrrgVh0K8KGkqJxQjwRQw0FmZSRJ1TQWf/account_idstr=310076000000041991"
Advanced CRM
I would be willing to pay someone to develop a Zoho Creator solution to this and it would require some phone time to explain and detail the problem. Problem: I have a dataset (in excel) of about 300 records that needs to be tamed into a workable solution Issue: Two lists - Some overlapping memebers We have a mailing list that includes members that have contact information including addresses and emails. Some members are unique to each list, and others exist within both lists. There are members
Next Page