Delete multiple records
Hello all, Please be patient with me as my experience with databases is very limited,and I am hoping there is a simple solution. In my application I have a form named "Controllers" in this form there are three fields "Serial Number", "Max Temp", and "Hours" I am trying to create a lookup function for the form named "Controllers" I want the function to lookup the "Serial Numbers" of all of the "Controllers" in the form and display them as selectable check boxes. (This Part I know how to do) I then
OpenURL - filter by date
I have a form called 'expenses' with two date fields - startdate & enddate. I want to open the view 'expense_list' but restrict transactions between the startdate & enddate. Can you help with the syntax for this requirement? Thanks, Martyn
Sorting values in a lookup field
I've created a job db which uses job numbers. I have a number of forms that link to the job using the job number. I have set the look-up to sort, but in some forms it's not sorting as would expect - see example below: Job Numbers: J016 J007 J026 J019 J030 J998 J999 J040 and so on... Some forms do sort the job numbers correctly - any ideas? Martyn
error while duplicating application or importing application from a script
Hi, I was trying to make a copy of my application. It says "duplicating...please wait" and then nothing happens. So I tried to export the application as a script and then importing it again via create a new application. Initially it gave me the following errors: 1. If I had anything in quotes in the Notes field of the forms. Eg. Please type your name in "CAPS" It gave me an error on the quotes -- " So I removed the quotes from the Notes field 2. In one of the views I have added a sendmail function
Edit Multiple Records
Well the support team at ZOHO answered my last question quickly, and in a way I could understand so here is a thank you before we get started. I have an application named PRT Collar Tracking, in this application I have a single form also named PRT Collar Tracking. In the form I have several fields for user input. The fields I am concerned with are Collar_Serial_Number, Trip_Hours, Circulating_off_Bottom_Hours, Sliding_Hours, Rotating_Hours, and Total_Hours. I need to be able to edit all of the [Trip_Hours,
Add Record via REST API
I'm trying to add a new record to a form via the REST API. I am posting this: <input type="text" name="Title" value="test"> <input type="text" name="Aspect_Ratio" value="99"> to: http://creator.zoho.com/api/xml/copy-of-encode-details/Encode_2_Form/add/apikey=*****&ticket=**** I *'ed out the apikey and the ticket for obvious reasons. The only thing I ever get back is: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused.
Data relation of Lookup field broken
I have a Lookup field ('Import Data') called 'Player_Entity' (on form A), for which I limit the choices available in the 'On Load' event with the following code: //Limiting Entity field choices to player tempValue = input.Player_Entity; clear Player_Entity; Player_Entity:ui.add("Himself"); for each recPE in frmPlayer_Entity [Player_Name == input.Player] { Player_Entity:ui.add(recPE.Name); } Player_Entity.select(tempValue);As you can see in the code, there is a field called 'Player_Name' on the
Can't find "On Success" FORM ACTIONS help________________________
I created a stateless form and want to "SendEmail" on success but I am not able to include "On Success" action on the right side of the Script Builder screen. I only see "On Load" "Add_this" and "On Click". How are "Form Actions" like On Success added so that I can then "SendEmail" "On Success"? Also, the form that created the table has at the bottom "on Add" and "on Edit". My stateless form doesn't have that. George www.yourbizzwizz.com
simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
What about adding simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
Having trouble with Radio Button functions/expression
The 1st two choices of the Radio Button works correctly. But the 3rd Choice is not working. Once Choice Three is chosen it will not allow to be updated should the client decide to correct his choice. If you start with any of the 2 top choices one you can toggle between the two and you will successfully update. If you choose any of the formulas for the 3rd choice they will also update successfully. But if you choose any of the formulas from the 3rd Choice and then change your choice to any of the
CREATOR - How to CLEAR stateless form data after Submitting??_________________
Please see script for stateless form below. I finally figured out how to update table with stateless form but am not programer and need help. How do I remove the data from the form once it has been submitted AND display a confirmation message like "Your Data Has Been Submitted".... See from at: http://azrealestate101.wiki.zoho.com/GUESTBOOK.html I am keeping it simple so I haven't learn how to do the data field validation. Where is there "beginners" documentation how to build more complex stateless
Hide fields/views based on User Group?
Hi all, I have seen that it is possible to hide fields if a user isn't an adminuser. I am migrating from Dabble and need to set up a database for two groups of users -- editorial and production. In Dabble, I created a "Pages" view for the editorial users and made a few views possible through that. I want to hide the fields/views that editorial doesn't have to think about to make their job easier to do. The production team needs to see more fields, will need more views. From my initial understanding,
Make my app public
It seems the "click here to request for public access" link is permanently not working (Error on page) How can I do to make my app public then? Cheers
Functionality based URL's - print - in Functions
Having now spent a few hours on this challenge I ask for some advice. I have succesfully created a function as below that allows me to view more information from a specific record. this idea was taken from a sample and modified for our needs. void print.MoreInfo(int LoadNumber) { openUrl("#View:InboundLoadSummary?LoadNumber=" + input.LoadNumber + "&hideprint=true", "same window"); } The concatenation works fine and I noted from the sample that the ZOHO domain, username and appname were
Linking Zoho Creator Apps with CRM
Hi, I'm using the deluge code given on the below link to populate a drop down select field with the vendor details in my Zoho CRM. http://zohocrm.wiki.zoho.com/Linking-Zoho-Creator-Apps-with-CRM.html I have adapted the code slightly, but it will not save and the error message I receive is not much help - "null". The field to be populated is called "Seller1" The code below is the same except I have replaced MYLOGINID, MYPASSWORD, MYAPIKEY and MYCVNAME Can anyone help? Many thanks. responseStr = getUrl(("http://accounts.zoho.com/login?servicename=ZohoCRM&FROM_AGENT=true&LOGIN_ID=MYLOGINID&PASSWORD=MYPASSWORD"));
May I Customize My Form?
I would like to customize a user form like the one attached. The form must be interactive and be able to update my data. Thank you for your quick response.
Can't Delete Function (again)
I encountered another case where I cannot delete a function. When I try to delete the function, it says: Function cannot be deleted. This function is referred in the following places. Please remove the reference,then try deleting the function. In action script--> Notice, there is no name after: "In action script-->" The name of the function is: GetPledgePayment The name of my application is: MyDB I have given support access to the application. Please access my application and delete the function
Need Help Formatting Printout of Student Directory
Hi: I have a seres of Zoho tables for a small school. I need to printout a Student Directory in which the student's name is listed once on the left and the parents are each listed (one per row) underneath. The look needs to somewhat resemble an Excel pivot table where the student names are grouped. Can this be done when setting up a view? Thanks- Charlie Epes
Does Zoho Creator support Soundex (phonetic) algorithms that will display similar sounding values?
E.g., when adding a new company into a database, if the company name is similar, though not exact, to a company already in the database it would be recognized as a potential match and permit a notification message (such as "Did you mean this company?").
Problem importing data into Zoho Creator database
I have a very simple form and am trying to import data into it. I have successfully done this in the past, but this time it silently fails every single time and gives no feedback about what is causing it to fail. I have tested all the obvious things, like data types and field names, and have found no issues. Any ideas for how to test further or how to get explicit feedback about what is killing it? Thanks!
Another Update ... Another case of breaking existing functionality !!!!
Looks like the ZOHO Creator Team decided to update the platform ... ... right in the middle of the day (Eastern Time) ... without any advance notice ... and in keeping with past practices, broke existing functionality !!! When trying to Edit an Application ... free-flow mode ... when you right click on a Form field and then ask to Edit Actions on user Input ... the resulting display goes into a never ending "loading" state. However, when you click on the Share Tab and then choose the event from the
Zoho applicaiton will not Import CSV, XLS in any browser
I've spent hours trying to bulk import 7600 entries into the application. 5900 were successfully added. The application never accepted the full list but did accept ~1000 at a time until 5,900. Now, it will only accept 2 per addition. What's going on with this?
Editing Import Data Feature
Hi, I'm using the Donor app from the market place and the Import Data feature won't let me import records with duplicate emails. Is this a data constraint or code in the Import feature? And how do I change it? Thanks, Michael
Schedules - am I doing something wrong here??
I have made a schedule which is to run daily at 4pm and email everyone the schedule for tomorrows events. It is not working for me. Not getting a single email. Also, it would be nice if the schedule section had a little button to test script to make sure it works - rather than setting the time and waiting a half hour each time to run. Here is my code: WHEN TO DO? Send Schedule { execute event on '2010-04-21' at '16:00' daily } WHAT TO DO? for each Staff_Members in Add_Delete_Staff { sendmail
Get google calendar into Zoho creator database
In my company Google calendar is used, and we would like to import the appointments made in Google calendar into an Zoho creator application. When the data for the appointments is in Zoho creator, then one should be apple to attach extra information. Is this somehow possible? Or one would be able to see our google calendar in a zoho creator form, and then update google calendar from zoho creator by filling out a zoho creator form that sends a .ical file to google calendar. Then one could add recipients
How to add custom action to views without records
I have a Contacts View with a Notes button on each record in the view. When I press the Notes button for "John", it shows the Notes View filtered for the Contact John. However, when I press Add in the Notes View for John's Contact, it does not populate the John's Contact Form ID on the new note. Thus, there is no connection between the Contact John and that new Note that was just created. How can I ensure the Contact Form ID for John is passed to the new Note, to maintain the connection?
Email Data
Ref to http://help.creator.zoho.com/Email-Data.html I think the concept of emailing data would be more usable if Creator would accept email from anyone, if the form is public, and have the option to parse-out the sender, subject and body without having to resort to keyed form fields in the email.
Doodle functionality
Hi there. i am looking for a form in a kind of a 'doodle' for planing meeetings. Has anyone an idea? Thanks
Reports in creator
I am trying to make some graphs in Creator reports and have hit a road block. I have a bunch of events scheduled at differnet times of the day, every day. I have made a graph which shows the count # of the different positions of people involved with each event and also the number of delays starting on time. On the X axis, I have the time from 0-24. Is it possible to give the user options of clicking on certain days or ranges and making it more configurable for the user to get the data they
Form Scheduler
I am setting up a from scheduler and was wondering if there was anyway that when the email goes out it can send the corresponding row to the date. For example I have a row that looks like sales associate job number mail date quantity I have setup the scheduler to email out when that mail date comes, but I want the fields put into the email so they know what job it is. Also is there anyway to make the person it emails out to be the person who is in the sales associate column?
Relationship with relationship entities
Hi, I have the following problem. Forms A, B, C, D, E, F, G, H all collect simple data entities Form I creates a unique entity by lookup to forms A - H Forms J, K collect simple data entities Form L is intended to create an entity by lookup to Forms I, J, K The problem is that all the lookup to form I presents is the ID, which is not very meaningful to the user Can anyone help achieve my intention Barry
LABEL_FORMAT=P not working for the API to sheet for graphing
I tried, based on the documentation in http://help.creator.zoho.com/Creating-charts-using-Zoho-Sheet-API.html, to create labels on the PIE chart, but no variation of upper or lower case on it works. The format should be what? Here's the URL I was generating (replace the $ in front of 0A with a percent sign, as it gets stripped out in this editor): http://sheet.zoho.com/zohochart.do?&title=Excludes Not answered&charttype=PIE&LABEL_FORMAT=P&width=600&height=300&chartdata=Complexity,Count$0ALarge,1$0AModerate,5$0ASmall,5
Prevent user data from being recreated
Hello, I created a patient database witch uses several forms, patient evaluation, contacts, appointments and so on, each form link with each other through the patient name with a Lookup field displayed as "Dropdown (single select)". What happens is that when using the application and selecting one of the patients, that were already registered, from the dropdown: - The fields that i have already filled wont show up, pre-filled like in the form view. - If I write something on those fields they will
View by date
Can I create a view that displays things based on the whether or not the date == today. I have a column with dates in it called date1. I want a dynamic view that will display rows that the date is == today. Is this possible?
Creating multiple forms?______________________
I am at a loss and not able to create a 2nd form without creating a separate table that stores it in a separate Creator Form. I know how to associate many Views to a Form but each Form I create in "Edit Application" creates different table. I've read all the comments but need someone to walk me through the process. Willing to pay and do via Desktop Sharing. I am not very technical but typically can figure things out. This has been a problem. Will Zoho CREATOR come out with a WIZARD to associate
Message to User
I have a Custom Action that should only be used by the Administrator for debugging purposes. I've written the script for this so it only executes the important part of the logged in user is the Administrator. The problem is that the system gives any user the message that it was succesful, even though nothing in the data changed. Is it possible to give the user a specific message like this? if (zoho.adminuser == zoho.loginuser) { do_the_thing; } else { message "Sorry, only the Administrator
How to localize ZOHO login screens
I have noticed the various discussions about non-ZOHO branded login screens, and I am happy to see that ZOHO has come up with a solution that should address most of the concerns. Unfortunately, it seems that while almost any message in the form can be customized (and hence localized), this is not the case with the login screen, and as a result a show-stopper for many international end-users. Is there a way to have the login and sign-up screen localized, and if so, how? And if not, what is the ETA
set input field to content of notes field?
I've created a user agreement form, which has a note field that has the user agreement text. I would like a hidden field that gets assigned the contents of the note field that has the user agreement text upon submit (or load). If the agreement language changes, I need to have a copy of the exact text that was in place when each person "signed" the agreement. When I try to do this on validate, I get this error when trying to save: Field plain does not exist in the form User_Agreement When I try to
Date Time - very simple question.
I have a very simple question which is boggling me. I have a Date-Time field in my form. I have the following function: if ((input.Date_Time == zoho.currentdate)) { Send email... } I want emails sent out only if the date scheduled in the record is todays date. I know my field is a Date-Time field, but for this function, I only care about being the same date. I don't know why I can't figure this out, but its not working for me. Thanks
1 to many tables
I have an application in Access that has many tables, some are one to many, and with look-up tables. Is it possible to import the tables as is? Is it possible to have 1-to-many tables in Zoho? I'm a newbie here.... Thx Rob
Next Page