How do I add Formula values to calculate sum?
how to create a form that inputs data to another forms database table
Hi, I have a form that inputs data to a database table. One of the aspects it inputs is "team", because there are more than one development team. I have created a second form exactly like the first, but with the "team" field preset that I will give access to one of the teams. When they input data, they don't have a choice to select the team. However, the data does not seem to go into the same table as the original form, because it never shows in the view I created for the first form. Does each
Calculating Time Difference
I am trying to calculate the difference between 2 date/time fields and have it show up as 0 Hrs 42 mins or 1 Hr 15 mins I have input the following based on a prior post, but it is not working: ((((((Date_Time2 - Date_Time1) / (1000 * 3600))).toLong())) + " Hours ") + (((((((Date_Time2 - Date_Time1) / (1000 * 3600))).toDecimal() - (((Date_Time2 - Date_Time1) / (1000 * 3600))).toLong()) * 60)).toLong()) The formula gets saved OK with any error, but no data is populating in the field,
How to prevent users from editing the application once shared
Hi, I've created a simple app and shared it with myself. I can see and use it, but I can also edit it. Is there a way to turn that off, or is that jus because I am the creator of the app?
how to get the submitted form directly to my personal email?
Hi Harshavardhan, i already created a "Contact Us" form on my blog which it enables my customers to send their enquiries directly to me. how can i check their comments n enquiries directly to my personal email? Regards, Jaja
related forms: indicator to show if there are related records in the other table
I have two forms with a one to many relationship. How can I set up an indicator to show if a "one" side record has related records in the other form? Thanks.....
Inserting hyperlinks in a multiline text field?
How does one place a hyperlink in a multiline text field? I Have tried "<a href='" + Link + "'>" + Link + "</a>" but that does now seem to work.
Dynamic lookup criteria - not possible?
In the form 'TestForm' I have two fields: 'Player_Name' and 'Player_Entity'. Each Player can have multiple Entities. They are entered in another form. The field on the 'frmPlayer_Entity' form containing the name of the Player is also called 'Player_Name'. Now in TestForm I tried to make Player_Entity a lookup field with the criteria 'Player_Name == input.Player_Name' (to get only the Entities of the entered Player in the dropdown) and I get the error message 'Variable 'this' is not declared'. Is
Create new event in google calendar from a new form event.
Hi!!! I've been reading a lot of discussions about gcal sync from the last months...and I don't have a clear idea. My point is that i need to create a new event in my google calendar from a new form created in my zoho app.It's posible??? Thanks a lot. Sergio.
email notification
I have a form imbedded on my web site. When it is filled in, I get the content emailed to be as well as the database. I can't remember how i set this notification up or is it automatic? Can someone help. Also is it possible to set it up so that others are notified? I would like the person filling out the form to also receive a copy of what was submitted. Can you point me in the right direction. Thanks, tom
Unable to update Multi-Select field in another form
Hello I have the following code in the "Edit - On Success" event of my frmCountry_Market form: for each recP in frmPlayer [Market.contains(input.Market_WithCCode_before_edit)] { newList = {"item1", "item2", "item3"}; info newList; recP.Market = newList; } One recP record is found (the list newList is displayed in a log message). 'recP.Market' can not be set. This is what the log says: "Unable to update data on the form variable null" I tried updating another field in the same form (recP.Name
Cycle 2: Voting Phase
The Voting Phase for the Second Cycle of the Community Driven Feature (to be developed by the ZOHO Creator Team) can now begin. John Whitney (user niskypto) has developed a ZOHO Creator Application to enable users to cast their votes. It can be accessed here http://creator.zoho.com/niskypto/comdriven/# The Voting Phase will remain open until midnight on Satuday, August/15 2009. Here is a recap of the 6 submissions you can vote on. deepa7476 - HTML view to PDF http://help.zoho.com/portal/en/community/?ftid=2266000000361648
More complicated scripting based on Time and Graphs?
Hello, I just discovered the Creator section and I find it really magnificient. I am considering creating an app that is unlike any that I have seen developed so far. I would like to make use of the graphs. I work with groups that I want to support with data that is taken from the forms they fill in. For instance: - So far today your average is 10 (on a ranking from 1 - 10) - Here is your perforance today. - You are less than your average for the past week. - This is your progress over the past two
Reference Fields
I need some help. Zoho is great at editing literal records but I am having a hard time making a useful application that does not mirror a DB record. 1) given --- form PERSON known by ID has Last Name has first Name --- form COUPLE lookup PERSON.ID for man lookup PERSON.ID for woman Now when I build the COUPLE form I want to use a reference of ID back to PERSON twice, but I can only fill a drop down list with abstract IDs. I want the drop down to shown the names (First, Last) but then once I select
Multiple Forms associated with One Table?
I'm building a form that I will embed on a site, for clients to submit a work order. Its a long form, tedious to build in Creator and such a long form can test our clients' span of attention. So, I'd like to break it out into 2 or 3 steps (2 or 3 forms), but I don't want 2 or 3 tables. I'd like the 3-step form process to submit data to just one table. Is this possible? Thanks. - Matthew
dfgfd
Application sharing not working
I have entered the correct email as a user to my account. I have shared 3 views to this email. Still the application does not appear under 'Shared Apps' (Home). If the user tries to access it directly (by clicking the link in the email that was sent to him when I shared the views) it says that he is not authorized. What to do?
'Save as script' function
Under "more actions" one of the choices is save as script. What does that do ? How does it differ from 'save changes' which appears occasionally ? Zoho newbie
Escape key
The 'escape key' which normally reverses choices made (drop-down menu, etc) apparently does not work in Creator. Plz advise. Thanx. Zoho newbie
Export Issue
I have been unable to export any of my app views to any output formats. I get the attached error. Could it be a problem with my pc or is it a setting I have missed in my application? Thanks for any help you can offer. I look forward to getting this resolved. Kevin
Complete documentation Avail ??
Is there Creator documentation avail for a Zoho newbie that is better than 'quick start guide' ? The guide leaves out a l-o-t of good stuff. If published doct avail either from Zoho or other professional organization it would help. Thanx. Newbie
user_email == zoho.loginuserid
I just discovered in horror that all the views I created with a filter: user_email == zoho.loginuserid does not work any more.... "user_email" is one of the fields in a form.... The intention is to control user access to a set of records in a table; when the user_email is equal to zoho.loginuserid, the user can see a set of records assigned to her. please help...
Help With Email Notification Please
I need an email notification to be sent if a specific date variable in my form is set to today or tomorrow AND the zoho.currenttime is after 2PM. I can't figure this out and I've tried every workaround I can think of. Can anyone help please? Thanks!!!
Email Notification Based On Separate Date & Time Values
I have a delivery scheduler application and I need an email notification when the requested delivery date is tomorrow and the added time is after 2PM today. I've been trying everything I can and have been unsuccessful. Help please!!!
Column Width
I understand existing bug which prevents width changes will be fixed around Sept 2. What do choices 'pixels' & '%' mean : (a) how many pixels = 1" ? (b) % of WHAT ? Thanx. Zoho newbie
Dates/Time fields will not update with 00:00:00 specified for time
I have a form with a date/time field and it generates an error with the time of 00:00:00. Why?
Change default label on Calendar
I created a calendar of events in Creator. When viewing the results, the label (the link you click to get more info about the event) on the calendar day for the event is showing the person's first name. How can I change this label to show instead the Event Name?
Suddenly I cannot submit my form
Hi When I try to submit a form this morgning the system comes with an error saying: "On User Input action is being executed for one of the field in this form. Please wait till it gets over and submit again." The problem is that nothing happens! This is a fatal error to us. We cannot create any request in the system!!! My application is AFB System 2.0, and the form is called Request to MDMT. You should have the access! Regards Skouboe
STATUS VERIFICATION
Hello guys: I have a form named CONTROL_DIARIO, it keeps records on individual house construction development on a project. It pulls the houses' status info from another form, STATUS_VIVIENDAS. The house's lot number in the CONTROL_DIARIO form is chosen by the user in a pullout list fed from STATUS_VIVIENDA 's info. There is a field in STATUS_VIVIENDAS named STATUS, wich describes if the house is being constructed or sold. If a house in STATUS_VIVIENDAS has the STATUS == constructed or sold,
Help with multiple field lookup and returning a SUM total
Hi all, We are recent ZC converts and we’re trying to build a Job Management application for a creative agency. The application will manage: - Job workflow (Jobs contain different Tasks and Status’) - Track Hours per Task - Track total Hours per Job - Calculate Invoice amounts - Track Expenses - Generate Profit + Loss per Job The Jobs Form/View has these fields: Client, Job Name, Status, Hourly Rate, Actual Hours. The Logged Time Form/View has
PDF functionality like PHP (FPDI)
Hello We have a few government PDFs. We would like to show a simple online form to the end user. And the form, autogenerates the completed government PDF. This can be done in PHP using FPDI libraries. Can this be done in Deluge? Thanks
Record summary doesn't show hidden columns
Hi, I still can't believe how powerfull and easy Zoho Creator is. However, I have a problem: when I click on the 'record summary' button, the summary that pops up doesn't show the data of the hidden columns. How can this be fixed? I can think of some workarounds, but I thought the 'record summary' function was designed just to show these hidden records easily. Thanks, Maarten maartenzam
Scheduled Report on Creator
Hello: Can a scheduled report based on a View be escheduled to be sent, let's say, to the Directors' email once a week? Thanks Alberto
Print support
Hi You write in your "Working on" list, that you have completed the print support. How is this to be seen in ZC? Br Dennis
Send mail based on submission data from another form?
I maintain 2 forms in order to match buyers and sellers. 1 form contains data from the buyer, and the other contains data from the seller. When a buyer submits their info into the form, I would like a form automatically sent to the sellers based on certain matching info from the buyer. For example, if a buyer is from California, I would like an email automatically sent to all sellers who are also from California. Is this possible? If so, can someone please help me with the script? Thank you!
Unable to Fetch Data/Renaming APP or URL/permalink
Hello.... A problem and a question. I was about to deploy my app (on a deadline) when these issues arose. The Problem: My app form appears to work fine, but I get the "unable to fetch data" error when I try to look at the associated table. I've enabled edit access to support for the app "EVAL." The Question: Because I copied/backed up my app several times, the URL now reads something along the lines of: "copy of copy of copy of..." Is there a way to rename the URL/permalink to something a little
Often need to refresh
Hi, I wonder why my application often need to be refreshed with either a "F5" or I simply need to logout when I slect a value in my picking lists?. This is a generel question and not a specific. Do I do something wrong in my programming? or is our IE the problem? Is ZC the problem? Br Skouboe
Calculating formulas within a form
Hi All I am running a form where values are imported from look up fields which are then categorised into a specific group that is represented by a number. I am wondering if by inputting the number, and not commiting the data to the database at this stage, that I can perform a script or function that would enable me to generate a look up list (checkbox) within the form that then displays specific data relevant to the number input so that I have the ability select choices from a list. appreciate
Calculate Average from Picklists?
Hello.... My form contains a series of picklists, all with responses 1 through 5. I'd like to have a calculated field visible on the form that will display the average of the choices in the pick lists. For example, assume two picklists. One has the value 3 and the other has the value 4. The average, of course would be (3+4)/2 and equal 3.5. I'd like the filed to display 3.5. Alas, I don't have the programming skills to even begin to figure out how to do this. Can you help? Thanks in advance.
URL data type does not persist custom 'target' after edit.
OK, here is another Elephant sized bug that got by the Creator Quality Assurance test team. Create a From with a URL type data field. Populate the URL field via deluge script, including a custom 'target' attribute. Such as:. <a href="http://creator.zoho.com/ensobase/home/form-embed/Task_Manager/DealPreLoadHidden=RECORD_ID#" title="4th - MacKenzie" target="tm">4th - MacKenzie</a> Click the link in Form View mode and watch in amazement as it actually works and loads the target frame. :) Edit the record
Next Page