Formula Program Assistance (If>Then)
I am currently using the formula listed below to lookup the previous record and pull data. Altering the formula listed below, how can I write the formula so any number that returns as negative, will be altered to zero? if (count(Main[ID != 0]) > 0)
{
rec = Main [(ID is not null)] sort by ID desc range from 0 to 1;
//fetching the last added record
input.Usage_P1_SQUD7442N4 = ((input.OnHand_P1_SQUD7442N4 - input.Shipped_P1_SQUD7442N4 - rec.OnHand_P1_SQUD7442N4) * -1);
}
else
{
On Submit Mail Question
I am having difficulty with the simple email notification feature once a Creator form is sucessfully submitted. It seems I can only have 1 email address in the "TO" field, and 1 email address in the "CC" field, and 1 email address in the "BCC" field. How can I set it up to send the email notification to 2 users in the "TO" field and 4 in the "CC" field. See code below: sendmail
(
To : "who@who.com"
From : zoho.adminuserid
CC : "who2@who.com"
Reply to : "who3@who.com"
Upload file - Client Side API
Hi all, I'm trying to add a Upload field in a html page using the Client Side API, but it doesn't show up. All other fields from the same form are no probleem. Maybe I am forgetting some special settings, like with a picture field ? code: <td><script type="text/javascript">Zoho.writeLabel("ImageUpload");</script></td> <td><script type="text/javascript">Zoho.writeInput("ImageUpload");</script></td> The label shows, but the input field not. I also couldn't find that
Fetch and display multiple records from stringlist on user input
Hi, I'm a newbie developer. I'm trying to figure out how to write a script, but my brain is hurting. In a form called Add_to_Assignments I have a lookup field called COMPETENCY_A_A that's displayed as multi-select checkboxes. The data is from a form called Add_to_Competencies that has two fields: COMPETENCY and AREA_OF_KNOWLEDGE_C. In the Add_to_Competencies form, the AREA_OF_KNOWLEDGE_C field is a single-select dropdown lookup from a form called Add_to_Areas_of_Knowledge. What I'd like to do is
Deluge: can a field reference itself (instead of specifically referencing itself by name)?
Is Deluge capable of allowing fields to reference themselves, instead of specifically referencing itself by specific name? I.e. User checks a decision box called "iwantblue". The following script would run "On Update": if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose another color."); self = false; } meaning the box would become unchecked after an alert box, instead of: if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose
Newbie question: if statement in a Formula field?
Hi everyone, I'm new to Zoho and am building my first app. I'm pretty excited by what I've seen so far and look forward to learning more. I've got what is probably a simple question. I would like to generate a Formula field called Name Line that displays either the individual's name or the business name depending on the value of the field contact_type. I tried the following but got an error saying it didn't expect an "if": if (contact_type == 'Individual') { name } else if (contact_type == 'Business')
Reference Formula Assistance
I need some newbie help on a formula in Zoho Creator I have 2 fields I need to do the formula on Field 1: Todays_Inventory Field 2: Todays_Shipment I need to do the following formula (Todays_Inventory - Todays_Shipment) - [The entry for Todays_Inventory in the previous record] How can this be written to look into the last record entry and pull the data number for the Todays_Inventory field? Thanks in advance.
Problems viewing X-Axis Labels in a Chart View
I am having a small difficulty with a Chart View of a Line Chart in my Zoho Creator application. If you reference the attached sample image, you will see that on the X-Axis, you can not see the axis labels. The X-Axis is set to match the "Date" field, however, You can not see the dates on the image. One 1 chart, I the labels were drawn at a 45 degree angle automatically, but I can not seem to find how to do tell this chart to do it. Also, how can I set the chart to in chronological order to where
How to get the correct record ID from a selection in a picklist where there are multiple records with the same criteria?
This is a tricky one that doesn't seem to be addressed directly in the Deluge documentation, unless I've missed it. A lookup-picklist displays a list of names to choose from. In that list there happens to be more than one listing with the same value, e.g. "John Doe" and "John Doe". When a user selects one of the "John Doe"s, I want to know the record ID# of the selected "John Doe". But... if I use the method seen below, how do I know that the ID grabbed is to the *correct* John Doe that was
Send email on date
I have a view that contains dates and email addresses where multiple emails addresses are related to a given date. I can, of course, login to Creator, select a date, and have that action send an email to all the corresponding email addresses. My question is can I have the system itself do that automatically? What I'd like is for the system to once a day, see if the current date matches an entry in my view and if so, send an template email to all the matching email addresses.
Confused by lookup field
I have a status field that I use to track the reservation record. I have a couple of statuses that I write via script that I do not want to be set by a user. So in my lookup table I only included the statuses I want the user to set. If I create a new record or edit a record I also see the statuses that I have written via script in the lookup field choices it is not just the values from the lookup table. Why is it showing these extra values. That does not make sense to me. Is there a simple way to
Lead Owner Tab
How do I edit the lead application in Zoho Creator so each user/lead owner can view only his/her leads not all the leads for all lead owners in the CRM? I can't seem to find the instructions neither any functions that disables users from viewing everyone's leads. Your helps is very much appreciated. Thank you.
"Item" checkboxes and Total Amount on an Order Form
I have an Order Form of sorts with a Total Amount field. I have a checkbox field for different items on my form with associated hidden price fields. When a user checks an item's box, the Total Amount field is updated to include the associated price. However, the SAME action happens when a user unchecks a box, i.e. the price gets added again to the Total Amount field. Granted, I'm just playing around right now, so my code looks like this: if (input.items.contains("Fruit Loops")) { input.total
HTML View styles
Is there a reference list of the styles that can be used in an HTML view? I would like to format an HTML view to look like the standard creator views but am unsure how to do this.
How to pass a For Each record parameter (r) to a different HTML view and access the record passed in the parameter
I'm trying to pass a record index number as a parameter to a second HTML view and use it there to access that same record... and I'm failing after much effort. I have an HTML dashboard view that successfully lists records from a form using a 'for each r in <formName>' loop. I've put a link w/ each output record that links to another HTML view that will (when this works correctly) elaborate on details of the individual record being clicked on. I've setup the second HTML view w/ a parameter called
Can I transfer ownership of an app to an alternate user account that I use?
I created my first Zoho account and started app development. But then I created a second Zoho user account that I wish to use as my main account, but I also want to transfer complete ownership of the app created under the first account to my new main user account and continue development from there. Can I do that? Or do I have to start over again w/ the app in the new user? Greg datazen1@gmail.com Santa Fe, New Mexico US
Confusion about sharing after changes
I'm getting confused about how best to share my application with my colleagues. I'm building an internal system that a great deal of my co-workers (50+) will be accessing. We're currently in the testing phase, so i'm still adding new views and forms to the app. I find that even though I add these users in the "sharing" tab, the new views/forms don't automatically show up in their view of the app, but instead a second listing of the same application shows up in their Shared Applications tab and
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
Next Page