Backup of uploaded files ?
Hi -- How do I backup uploaded files ? I've got pictures uploaded, and when I download backups, they're not included. What would be the way? What would happen is something went wrong and I do a restore, would there still be pictures attached to my records? TIA.
My app is non-responsive to edits
I'm trying to edit one of my forms, and I can't add or delete some of the field types. When I try to add a field it hangs at "Please wait" and doesn't do anything. If I try to delete a field, it vanishes, but if I reload the form it is still there. This is the case with several of the field types. I also cannot add views for the form, or change the columns that are viewable in any of the views connected to the form. It seems that something is "stuck" with that particular form in my app. I've
Need Verification Does not Work
Greetings, I need to use the Verification turned on for my forms. I check the Verification Needed feature, hit save and it does not turn the feature on. Is there a problem with that feature? Bartley
New Records not Created in Issue Manager
New records cannot be created with "Add Issue" in the Issue Manager. The email addresses are valid, however when the issue is submitted, the log reports: Error details: Error occured while on Success script. Unable to send email Invalid Email Address found
Images - desappearing from view
Hi, I see not more images in my view... any problem in zoho server? Or it's my application? Thanks Mic
Send mail - autoincrement problem?
Hi I've a form https://www.creator.zoho.com/misca/form/459/edit/ with send mail function. When I set up autoincrement funciont stop running. There is some mistake in the script? x = MaxValueHolder [ID != 0]; autoincrmentval = ((input.Universit + ((input.Data.getYear() * 100))) + (x.maxval)) + 1; input.Codice_Lezione = autoincrmentval; x.maxval = (x.maxval + 1); Thanks Mic
Reports- User Filter by Weekday
I am trying to create a report to show Usage trends. The Form I have allows the User to input the Date and Shift, and then the Quantity for each Product. (There is also a field on the form that calculates the day of the week on Date_Field.getday()) The User needs to be able to select the Day of the Week and select how many weeks to return, and then the report needs to output the usage for each day, with the averages. Example: User could Input Weekday = 1 (for Monday) User could request the last
with "Helpdesk" what URL to enter a ticket?
I signed up for the helpdesk trial. I see the admin dashboard, and the technician dashboard, but not the the dashboard - or whatever - for helpdesk users. Where do users go t enter tickets?
zoho application
Hi friends, I dont know how to access the shared applications from my project.Please help me. Thanks, Raja
How can I create a View displaying data from Two or more Forms?
Hi there I don't get this solution How can I create a View displaying data from Two or more Forms? What exactly is "the child form"?
Contact Form
How can we configure the 'Send Email Notification" in Zoho Creator to send a notification to another Zoho user other than zoho.adminuserid? Thanks, Mark
Can a public app use another app's records for lookup fields?
If I sell an app in the Marketplace, is it a good design to have it use another database app to manage the lookup fields that is not purchased? Can this be done? For instance, I have an app with lookup fields. The user cannot add to or access these records directly- only through the lookup field. I would like to add to these records without needing to republish the app for a user to upgrade. Can I have the lookups get their lookup data from another separate database that I maintain in Creator?
Functions fired on client side or server side
Hi: As we know, for a database driven online application, usually we write code and the code will run back on the server, but sometime we use script (such as: javascript) which can run on client side. I am a little bit fuzzy on Deluge, I noticed from Deluge help: 'alert' can be used only in 'validate', 'on load', 'on user input' and on click actions (so I suppose it runs on client side). How can we choose or tell if we want to run the code on client side or server side? (for example, some validation
Multiline appointment in calendar view?
Hi there, I was wondering how I would be able to have a multi-line item show up in the calendar view? Right now in the Calendar view, it only shows one line item per appointment. For example, if I create a new item in the calendar view, it'll show my name on a single line. I want to concat my name with other important info such as 'venue', 'time', and I want those to show on lines below my name. How would I be able to do this? I've tried using the formula field and adding <br> to the script, but
Signature/scribble field
is there a way to insert a Signature field ? Should be useful when we need to authenticate some data with the customer's signature. It could be an image field with an ole export capability. Thanks
Best way to include record edit popup in HTML view?
Hi folks, I have a query about using record edit functionality in the HTML view type. I have read this interesting post in the forum: http://help.zoho.com/portal/en/community/topic/edit-link-in-html-view-dialog-problems but unfortunately I have not got as far as the original poster. I think this is because I am building the link in a different way. Background: I have a list of tunes (musical pieces) and would like to be able to edit these directly from the HTML view. At the moment, my view is extremely
Display field from other form based on other field in form
Sorry; cryptic thread title, didn't know how to call this... I think I saw threads relevant to this in the Forums in the past, but I can't find these back. Sorry. Hi -- Let's say I have four forms : - Projects - Dates - Tasks - Users Basically, When I enter a new task, there are mandatory date field + project field. Then when I assign a task to a user, I would like to be able to retreive the corresponding date and project for this task in a user view, for filtering/sorting, without having to manually
PDF's are broken AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN
PDF's are broken AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAINAGAIN AGAIN AGAIN AGAIN AGAINAGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN How many times? Please fix.
Allowing edit of a record without login?
Is there a way to allow someone to edit a record without logging into ZOHO Creator? I have a form that emails users in a list when a record is added. Once they get the email, there is a link where they can respond Yes or No. If they choose Yes, then a hidden field is supposed to change to Yes as well. If they choose No, then nothing happens and the record remains unchanged. If I am logged in, this works fine and there are no issues. If I am not logged in, it takes me to the form from the
Public Access vs Private Access
If I begin my form with public access and my visitors do not create an account, can I go back after the fact and make the form private and force my visitors to create an account to have access to the information? If I make them create an account, can they access information that they have entered previously when the form was public? Thank you.
Limit the # of Formulas in a Form?
Is there a limit to the number of Formulas that can be included on a Form? I have a form that has 13 formulas, and I have tried to add another one, but no matter what formula I put in there (I have even tried to copy other formulas already on the Form that are working) it keeps disappearing. I will put in the formula, and click "Done" and it will save and appear in the screen. But when I go to View to try to add it to the View, it has disappeared, and when I go back to the Form, it is no longer
How to add Data from a record in a form to HTML view
I want to add data of a record in my forum to a HTML view. I am using following scripts htmlpage HTML_Test1(Ref_No) displayname = "HTML Test" content <%{ rc = Shipment_Details [Ref_No == input.Ref_No]; }%> when I test this script in the preview it works fine. But when I access this view I don't get any result. Can anyone help me with adding data of a record in a forum to HTML view. Ashish
Passing params to ZOHO
It would be extremely useful if it would be possible to pass data to a ZOHO application. I work with a content mgt. system and I would like to pass some variables from there to ZOHO creator when it starts a form. Example. I would like to be able to pass first-name, last-name, personal-id and sex to an application so that the form is already pre-filled with the information I already know about that user. Would that be possible??? Could It be made possible?? And of course - this would be my next question
When specifiying parameters in the URL for a view, can you filter for results based on param1=value1 OR param1=value2?
Hi, I would like to be able to display a view with results based on a parameter, but would like the results to be shown for records where a parameter equals one of two possible values. Is this possible when passing the parameters via the URL? ie it would be something like urlToView?param1=value1¶m1=value2¶m1_op=xxx where xxx is an operator for OR. Anyone have any ideas on how to solve this? I might be missing something basis regarding parameters, I am not an expert. I can't find an
Newbie Question - Group Sort by related field
I would like to be able to group items in a view in an order that is not alphabetical. Is there any way to do this? I was looking at the map functionality. is this the correct method? Also, is there an app that uses map so that I can try to understand it better? Thanks in advance
Sort Values in Lookup Box
I've created script that populates a lookup box. Despite setting the field's property to sort alphabetically, the values are not sorted. Any ideas? Martyn martynhale
Form definition unavailable
Form definition is currently unavailable for me using FF3.6 and Chrome. In FF I get dumped to a search page when a page is unavailable, but in Chrome i get this error: The web page athttps://form/733/edit/script/&action_show=false&defleft=true might be temporarily down or it may have moved permanently to a new web address. More information on this error Below is the original error message Error 105 (net::ERR_NAME_NOT_RESOLVED): The server could not be found. Unsure if related or not but am also unable
Else statement is not working in HTML view
I cannot seem to get the else statement to work in this view. The if statement works fine, just not the else. Thanks for the help. htmlpage Approval_Form(pAccountKey, pOrderKey) displayname = "Approval Form" content <%{ account = Accounts [ID == (input.pAccountKey).toLong()]; order = Orders [ID == input.pOrderKey.toLong()]; services = Order_Service_Charges [Order_Key == order.ID]; billing = Billing_To [Order_Key == order.ID]; shipments = Shipments [Order_Key ==
Add multiple records on one screen
I have built a simple time sheet app. One each input page, we have the following: Date Employee Name Client Hours In this way, the employee needs to enter a few times per day. It would be better if the app can be designed in the following way: Date Employee Name Client 1 Hours Client 2 Hours (2) Client 3 Hours (3) etc. Can the input page hand one page entry to multiple records (same date and same employee name) Thanks, Sam
Custom HTML Forms?
Hi there, I was wondering how would I be able to create custom HTML forms rather than use the form builder? I'm a web developer and find the form builder extremely limiting. I would like to do simple stuff like this: <div> <label>Firstname</label> <input id="firstName" type="text"> <label>Lastname</label> <input id="lastName" type="text"> </div> Is there a way I can do that? I find the default forms layout (table based) very limiting as it doesn't allow for better use screen space.
Time picker?
On the forms page, there is a drag and drop element for Date-Time. However, if I only need and want the user to be able to select a time, how would I be able to do this? The Date-Time picker seems to have such a large focus on the date controls and doesn't have large enough controls for the time picker. In terms of UI, it makes it more difficult for users to simply just select the time. Thanks in advance,
Changing Location Of Filters
Hi - Is there a way to move the location and layout of the search filters on a View? For example, can I have them appear on the left-hand navigation rather than at the top of the grid? Thanks for the help. JL Scott
Defects/Deficiencies relating to Share Functionality
I have discovered defects/deficiencies relating to the Share Functionality within ZOHO Creator ... I did not want to hi-jack this topic ... http://help.zoho.com/portal/en/community/topic/an-issue-with-unshare ... so I started a new topic here. A couple of months ago I was asked to evaluate an Application (running since January/2010) for a Customer ... their previous Developer had gone AWOL. This Application had never been backed up ... and the first attempt to do so failed ... the ZOHO Support Team
An Issue with Unshare
Share/Unshare is confusing me (ref http://help.creator.zoho.com/Sharing.html) I have added a public HTML "start page" in a private application with multiple views and forms. The start page has logic to share certain views and forms based on the ZOHO account email of a signed-in user (the logic criteria references emails in a "roll list"). I have verified that the share operation not only places a user on the application's share context (for views/forms/etc) but also places the user into the "Account
how to check if it is a number in a field
Hi: What is the function that check if user input is a number, something like: If (isNumber(Input.NumberOfItems) == true) Thanks.
Generation of more than one records in a single form entry
We are trying to generate e-commerce application for bill collection. Table-1 contains customer detail in 06 fields. Table-2 contains bill detail in fields. Now we want to generate one form having all these fields. It is simple. But we want that customer data will remain as header data i.e. should be entered once and bill detail data can be entered more than once on a same form with total amount showing in the form at the bottom. i.e. if one customer wants to enter his three phone bill detail at
Adding a record count
Hello, How can I add a record count on this application (I've put it on our website)? Thank you, Lisa
Render image formula field requires upload field
I used instructions on this page to render uploaded images in views, and it works, but why do we have to display the upload field in the view for the formula field to work? Or am I missing something? To me this is just bloating/breaking views' tables with useless loooooooong file names. Is there a workaround for this besides an HTML view? TIA.
Corrupt Script Hanging - Will Not Load
In my "Admin System" application, my form "Task_Attachments" on-edit:on-success script has become corrupt and will not load. I am unable to load the script builder OR the free-flow script in order to correct the issue. 1) can you please go into my application and delete the "on-edit:on-success" action script for the "Task_Attachments" form. I have a backup of the script and will place this back once I can get back in. 2) Zoho needs to implement a feature where we can edit scripts in a "safe mode"
"for each" loop exits when sendmail fails
I am sending email to a subset of records satisfying a condition. The problem is that occasionally a record has an invalid email addresses and the "for each" loop exits in this case. This is a problem because everyone in my records needs to get that message. How do I make "for each" continue to the next record without exiting? for each X in Registrar [SEND_EMAIL == 2] { sendmail ( To : X.Email_Address From : zoho.adminuserid Subject : "Estás invitado
Next Page