Create recurring calendar events
Hi, I had created a database using and I need to create recurring calendar events in the creator calendar. We need this because there are other fields that we use within creator. I someone can tell if this has already been talk about? I have to keep in the Creator. Thank you
Function Problem -Please advise
Hello I have a problem ,whereas my form does not update my other form. Function is below. Please advise . Thanks void display.follow(string id, string projectname, int numoffollowers, list temp1) { openUrl("#Form:Follow?meetingid=" + input.id + "", "popup window", "height=400,width=550"); input.projectname = Post_a_Project[Recruiting_until >= '02-Jan-2010'].Project_Title; sendmail ( To : input.id From : zoho.adminuserid Subject : "Following
Printing Dynamic Forms
I would like to be able to print out a form that has been filled out - these are very dynamic forms, so I would not want to print out the complete record which would have many fields that are not used for that particular record. Any ideas??
How to Calculate Standard Deviation
First, view my test application here: https://creator.zoho.com/niskypto/stdev This calculates standard deviation in the same way Excel does. Specifically using n-1 degrees of freedom, which is preferred. I also added a 95% CI check for any value entered. The function makes use of Creator's new aggregate record commands float calcstdev() { n = DATA_ENTRY.count(); average = DATA_ENTRY.avg(Enter_a_Number); residuals = (0.1 - 0.1); for each x in DATA_ENTRY { residuals =
Form width issue when launching from stateless form in html view
I have a form called Visit. Invoking the form by pressing the built-in Add or Edit buttons results in the Visit form being displayed correctly on screen. However, I have an Add Visit button on a stateless form that is embedded in an html view. When I open the Visit form using the Add Visit button the Form is displayed with a large amount of extra space to the right of the fields. The form is invoked using; openUrl("#Form:Visit?PatientFKID=" + input.PatientFKID + "", "popup window", "height=350,width=550");.
Enter 1 field, then multiple field then auto fill !!! Help !!! Brain melting
I am a newbie to zoho, but I am a quick learner. I have learned about pick list, and auto fill. Example , I pick a state, and then in my city drop down, it will only show me cities in that state. I think its called a pick list, But its only one to one.. I pick a state , then it gives me cities .. i need something that will allow me to input one item,, and have auto fill of multiple fields.. My goal is this. i want to be able to import, records that contain [store id, address, city, state, zip] in separate
Two charts one screen?
I have a chart showing items on the y-axis and counts on the x-axis. The chart is filtered by date range. The user wants to see two charts side by side showing different date ranges (this month, last month, other date ranges). What is the best way to do this? Herb Wexler
Notification when a field has reached it's limit?
How do notify myself when a field limit is met? fetch = Registration [Course == input.Course && Finishing == input.Finishing]; num=fetch.Finishing.getall(). size(); { sendmail [ from:zoho.adminuserid to:zoho.adminuserid subject:"Enter Text Here!!! " message:"Enter Text Here!!!" content type:HTML ] } How do I send myself an email when the 16 limit is met? Thanks for any assistance...
Combining data from two forms into the same view
So I created a form that has exceeded the maximum amount of fields I can create. Therefore, I need to create a second form that is a continuation of the first form. I then somehow need to provide a view that combines the data from the first form with the data from the second form in synchronized way. Example: Customer fills out form A and clicks submit. They then use a link on my web page to bring up form B and begin filling it out. They then click submit. Data from both of these submissions need
How to make multiple fields required based on a Check Box selection
I'm creating a credit application form asking the user to check off customers he wants to open accounts with. I created a list of Check boxes for each customer (30+ check boxes). If the user checks off a certain customers, how do to I make other fields on the form required? Example: Check Boxes for.... (user can check off as many accounts he wants to have opened) - Flooring: ABC Carpet - Office: Office Depot - Paint: Our Paint Co - Flooring: Your Floor etc... If they select a flooring supplier
Importing Date-Time from Excel
Is there any date time format that creator will import? From excel, access, or otherwise? Please, I really don't want to enter 1000 time records by hand with your date picker We have a not for profit and need to upload event days to create a date picker
delete record after specified time ?
Just wondering is it possible to build an action that will automatically delete a record or archive a record after a certain amount of time? tks
Displaying dialog messages in visible area of embedded forms
In Zoho Creator forms, we display success and error dialog messages during data addition. On embedded forms, this error / success dialog message is displayed close to the top of the form only. So, when you scroll to the bottom of the form, this message can be seen only by scrolling all the way to the top. That is, the message is not displayed in the visible area of the form. As a solution, you need to 1. Embed a js file using a script tag as shown in the example below: <script id='zc_external'
data format error
when I hava used import data in the view ,the data format appear alteration. eg:The time is '2011-03-14 22:31:09' ,it display '2011-03-14 10:31:09' how to solve this problem?
Help with 30 limit on view
I need to export my data in one file, and I am unable to do this with the 30 variable dropdown limit. Please help, I can't use zoho if there is no way to access this data in one file. I am attempting to use zoho reports to analyze the data but is seems impossible with the limitations because my data is unable to be read in one table.
data does not update.need HELP pls.
Sir, In this apps, I have 3 form and 3 view. 1.stocklist 2.stock in 3.stock out in "stock in" form I have a field "quantity".each time I submit a value then it should update the value in stocklist view field "quantity stock in".Same goes for "stock out" form into "quantity stock out". Somehow it does not update any value and I've tried it on other record and only certain record is succesfully updated. I dont know which part im wrong but pls guide me to solve this problem.Before this, the previous
New User with a few questions
1. How does one set up subforms/tables in Zoho? I don't see it yet. 2. How does one set up a "template" for the form data. For example, so that phone numbers appear as (###)###-####? 3. How does one get the "height" control for the field attributes on the form activated? At this point I can only adjunct the width.
count record of form A with a criteria from fom B linked with a lookup
Hi let Say I've got a form Account ID USER + other fields I'v got Also a form Submission ID AccountID (Form Account lookup with ID) + other fields Now I want to count Submission that has the current loginuser has user. How can I do that? I tried: Sub = Submission[( AccountID.UW == zoho.loginuser)].count(); but it doesn't work How can I do that? do I need first to create a list of accountID that is assigned to the current user and then count submission that is in this list. if yes how? thanks a lot
Using / Calling a function to create a global variable to collect a list of records
I have a registration application where I collect Account registrations and each registration has a reseller. So there are many accounts per reseller. I am building another application where when I select a Reseller from a multi-select lookup, I want it to automatically select all accounts in another multi-select lookup associated with it. I created a function in the first application string sample.getAccounts(string getaccounts) { if (count(Add_Registration[Reseller == input.getaccounts]) >
Is it possible for a form input field to span two columns?
I'd like to have most of my form use two columns, but have a large text input area that uses the full width of the page. Is this possible?
Any plans on being able to view time as AM PM time format in views?
Any plans on being able to view time as AM PM time format in views? Hi would like to be able to view a 12 hour (example 10 am or 10 pm) clock on our view that has a Date-Time field How can I do this? Script solution is fine too
One of my tables disappeared from "Edit Mode"
Hi I edited a field type in my "Create Invoice" form in my Frozen Foods application and the form has disappeared in editing mode. All I did was add an Initial Value in the field property for the "Country" field, and the form no longer shows up. I can see the view for it though. Can someone fix this? I have given edit access to support. Thanks
Recurring events Creator Calendar
I would like to create recurring events in Zoho creator calendar. I have to schedule nurses to see patients every day and beable to keep notes on the patients. I have created a database already and I need this to work so when the nurses login into Zoho they can see their calendar with all their patients listed for the week, month and maybe yearly. All the help I can get would be great. Thank you
Create recurring calendar events
I would like to create recurring events in Zoho creator calendar. I have to schedule nurses to see patients every day and beable to keep notes on the patients. I have created a database already and I need this to work so when the nurses login into Zoho they can see their calendar with all their patients listed for the week, month and maybe yearly. All the help I can get would be great. Thank you
Uploaded Files in HTML view
Is there a way i can have a link displayed to uploaded files within an HTML view for a certain application.?? Any help would be great.. Thank you.
How to send a reply email to a form-fill email?
How can I get my form to reply to the sender of the email that filled it? I can get email to fill my form, and I can get the form to send an email upon being filled, but I can find no way for the form fill to capture the From/Reply-To address for generating the reply. Thanks.
Does "Error occured please contact application owner." in publicly-used app record any details for the owner to read?
Please? II am aware that details are shows for this error in an admin's session, but I'm asking about the public user's session. Thanks.
How to disable More Actions -> Export Data, please?
I don't want a user who can view a View to therefore be able to download its entire data en masse, as currently. Thanks. PS I found no solution under View Permissions.
How may I remove Form/View icons from the live app display?
Thanks.
Exclude Weekends from Formula
I am trying to calculate total hours that an item is "open" without including weekend hours in the formula. I have been using the following formula field to calculate the total hours from start to end, but I'm not sure how to exclude weekends from being included in the hour total. Here is the formula that I am currently using: ((Date_Approved - Added_Time) / (100000 * 60)) Any help would be much appreciated! Thanks
Input validation according a specific format
Hello, I have a Single Line Text field, where users are supposed to enter numbers separated by semicolons. There is no limit on how many numbers users can enter - the only one constraint is to have numbers delimited by ";", i.e. both entries "12;6;11;64" and "1;2" are equally valid, while "20;6_4" or "20 6" are not. How would you suggest to implement this constraint? How to take into account the fact that the length of an entry is not fixed? Thank you for your assistance.
Public form request
I submitted a request to make a form public last week, and it still has not been fixed. I need it done now.
Remove Lookup Choice without deleting that selection from past database entries.
I have a database the uses "Lookup" to populate employee names for daily transactions. The problem is that when the individual is no longer employed and we remove them from our list of possible lookup choices, their name is also deleted from every past transaction in the database. How do I remove their name from the list of current choices on the lookup field without deleting their name from the every past transaction in the database?
How do I create a subcategory in Zoho creator
Hi I would like to know if anyone can help me and tell me how to create a subcategory using Zoho creator? I have define up to six categories in my database and would truly appreciate if someone could tell me how to add subcategories to it. Thanks in advance.
Images do not appear in the HTML View.
View an html created and put an image (logo) server that is hosted on a third party. The problem is that sometimes the image appears. please someone help me?
Public Access is pending for my application
Hello, I need public access to my form as soon as possible. It has been a couple days already. The form is for a "Festival de Tango" , which needs to get started right away! Thanks for your help! Best Regards !
Link Users to Individual Reports Through One Hyperlink
I need to have one Hyperlink that says "Go To Your Report" that will take each user to their own report. I don't want 25 links that say "Ali's Report" "Bill's Report" etc. How do I create a link to read who is logged in and take them to their report?
Setting email notifications
I'm sure this is very simple, but it will be the first attempt at scripting and I'd appreciate someone pointing me in the right direction. Our application is a product inventory. Each product has a Category, Group and Item Name. There is a Reorder Status field with a dropdown selection of either OK or REORDER. When the user selects REORDER, I want to app to send a reorder email specifying when the record was changed and the item Category, Group and Item Name. Any assistance is appreciated. Thank
How to integrate multiple forms in a single application?
I have following requirements: 1)Create 3 different forms with an owner for each of them. 2)Have 4th user with only viewing rights for all 3 forms 3)Wrap all 3 forms in one application and export. May I know how it could be done? Second problem is as follows: How to read data in one column of a view A in another form B so as to populate list of all values of that column in view A in form B. Please help urgently. Regards ashuzoho
Import data problem. help pls.
Sir, I've got a problem here. I used "create apps using DS file" and it work. but when I tried to import data into it an error occurred. picture as stated below. Need help asap pls =).this is the only apps in my acc.why does it said I've reach record limit even though there is no record is inserted yet.
Next Page