Relationship
Hi, I have created 2 forms 1 is Property Details another one is requirement details so i want to show property name in requirement details form
What does this mean and why am I getting this error?
Any help would be appreciated. I don't even know where to begin with this error on an Add Record script. See the screenshot please.
Data Type in Reports Incorrect
I have some formula fields in my table that when I try to use them in report show up as text so I only get the option to count them rather than sum, count, avg, etc. The formulas work fine and show up properly in the views, but not in the report of the view. I have made http://creator.zoho.com/kavery327/powered-parachute-log-book available to support. In the Report the field Total_Hours is numeric (or should be since it is a formula calculated from numeric data), but shows as text. Any insight would
Formula field result format not consistent
I have 3 formula fields. The formula is basically this:(((Date1 - Date2) / 86400000)).toLong() I had one field like that in my application for months. In report it is shown as number. Today I wanted to add now formula field: (((Date3 - Date2) / 86400000)).toLong() That shows up now in the report as text (the values are calculated correctly) What is misterious is that if I make another formula field (3rd) and copy the formula from the first one (((Date1 - Date2) / 86400000)).toLong() That too
Aggregate Records
I cant see the result of "Aggregate Records" on html page view I already see this link https://www.zoho.com/creator/help/script/aggregate-records.html#Sum_Function I folow the steps of the link I have a form SaidasRomaneio that have a field Valor Here is my code: htmlpage Flow_Page() displayname = "Flow Page" content <%{%> Fluxo de Caixa<%Valor = SaidasRomaneio.sum(Valor); }%> Do not show de result of "sum" on page What is wrong?
Hide fields if not equal to
Hello, The fields below are on a form and I only want three zoho IDs to see them, all other zoho IDs hide these fields. I want to hard code these zoho IDs into the script. How would I do this? Payroll Amount Deduction Total Iram
Using system variables in pivot charts
It would be useful to be able to report by system variables - like records' Added Time in pivot charts. For example, to graph how many new records are placed over time. How can I do this?
Viewing records in the parent form even if records in the sub form gets deleted
Hi, In our application, we have a parent form NewOrder, and a sub form in that parent form, order item. If i select 4 values in the order item, these 4 values are viewed as 1 field in the parent form. but if i delete the records in the sub form, the field values get deleted in the parent form. Pls advice on how to proceed with, even if i delete the records in the sub form, it should be visible in a field in the parent form. Detailed step on how to proceed is very much appreciated. Thanks, Anitha.
Sharing Data between Creator databases
Is there a way to dynamically reference data from another database within the same account?
Add Formula to Amount
Hello, this is my first post...so excuse me if I don't explain my problem good enough. I have a page where one can input an amount in a given field to a specific user. So I would type in a specific user and enter an amount that user has paid and the date the amount was paid. But on the report page, I would like to have a field that shows how much the user has paid in a specific amount of time (week, month, or year). Is this something that can be done?
help href in html Page
Hello, on one page, I should open another page passing a parameter which is not a value but is a variable, how can I do? So I'm not trying to pass as the value of zoho.loginuserid. <tr class="zc-viewrow zc-row-1"> <td><a class="zc-edit-a" href="#Form:NewAction?Account="+zoho.loginuserid> - New Action</a></td> </tr> Is it possible to do a refresh only a part of the page? Thank you in advance David
Return to Previous Form Code for Stateless Form button with mandatory fields.
Hi Zoho! I created a form and whenever I press the cancel button, it prompts me to enter the details. Please see image below: Note: I just put openUrl() in my DELUGE Script for the close button. Any help will be much appreciated! Thanks!! Joy :)
Why does this deluge script not work?
The script below hangs, and doesn't work. How do I fix this? I think the script is saying: show all rows from Groups where Group_Members.UserRecrodD contains (zoho.loginuserid) I want it to say: show all rows from Groups where Group_Members.UserRecordID contains (User.RecordID) list Copy_of_Groups_Report { displayname = "Groups I belong to" show all rows from Groups [Group_Members.User.contains(zoho.loginuserid)] ( Company CompanyViaFetch Group_Name as
Auto populate a form with data fetched from same form
I was working on this feature some time ago, never figured it out and moved on. Now I'm revisiting this idea of auto populating my form of customer information that has been previously entered. Additionally only pulling address that have been entered by the current logged in user. Using Auto populate a form with data fetched from another form I have tried to get this to work, however with no success. Any direction or examples anyone can offer? Thank you
How to automatically add another upload doc field after one has been uploaded
Within a form I am creating, I want to know how do I let the system automatically create another File upload field after a document has been uploaded. In addition, if the second doc also uploaded, system will create a third blank field for further uploading. Thanks for your assist.
Rest API delete not supported?
When calling an external API, Zoho Creator lets me do a Post and Get call. But for some reason Delete is not allowed. Is there any way to do a Delete call? (this is NOT RE: the Zoho Creator API - Delete is supported there, but RE calling an external service.)
data from form to pages
how to access data from form in pages?
user permission
i maintain a client database. i want to allow uers to edit thier data alone. not others. how to do it/
Input masking
Hi Zoho, I am trying to create an input mask for numbers. Currently, if I input a number like 12,583,720 Zoho displays it like this 12583720 This is not very reading friendly for humans. Is there a way of masking the number so that Zoho inserts commas and dots in the appropriate places. Not all numbers will have 8 digits. I still need to be able to perform numeric actions on the field. Thank you, Anne
Show checkbox in view, versus true/false
How do I change the view to show a checkbox instead of true/false for a decision box field? I have a test view that it will work with. But my main form view will only show true/ false.
Issues with Button in stateless Form
After recent changes in creator user interface & modification in application, I am finding that I am unable to pass any value to stateless form field through deluge code written under an action button. Example : I add a field named Message in a stateless form , I also add a button called say " Show message " and under this button i write code Message=" This is test message" When I press the action button, the field does not get the value and does not show on the screen. It use to work well in the
shared options
i want to see sharing details based on user
password field
i want to allow password field in my form. how to do it?
Back Ups
Is there a problem with back ups except for the first one I did they have all failed.
D.O.B and Age
Does anybody know a way to create an age field that automatically updates based on a date of birth field?
location search
I am looking for an app that will allow me to search my database for customers that are located within a 100 mile radius of a zip code that I enter. Please respond if you know of a way to do this using ZOHO.
Attach a document stored on ZOHO Creator to an email
I have a form to upload PDF files to ZOHO Creator I have another form with client name, address and email address I have a 3rd form that does a lookup on the client name to get their email address, and capture further information about that client Is it possile to be able to select a document (from a browse or drop down list) previously uploaded and stored in ZOHO Creator and attach that document to an email to the clients email (from the lookup field) when the SUBMIT button is clicked on the form?
duplicated report has incorrect name in url
How do I change the name in the url address for a duplicated report example current https://creator.zoho.com/appbuilder/dbob/nameofapp/report/Copy_Of_report1_Progress_Overview2/ this is the incorrect name as the report name in dashboard is baggage so should read https://creator.zoho.com/appbuilder/dbob/nameofapp/report/baggage/ How or where do I change /update this thanks DC
If record exists bring up edit records with openurl in same window not working?
In the date field's(named TYDate)-> "On User input" event I am checking to see if their is a record with the same as input.TYDate if so use openUrl with "/record-edit/", the result is not nearly as useful as going to the report and selecting edit on given record? It will open the correct record in a "new window or pop-up' and no header labels such as "Edit Record", but not in "Same window" as expected when I use the "edit " link from the report for the same record. if (Fat_Daddy_s_Destin[TYDate
How can I add fields in "search" for a report?
I am not sure if I am using the proper lingo here, so I think a screenshot would be best to illustrate my question. See, what I need to do is add multiple "Software" and "Title" search fields, because we often will be searching within our spreadsheet for a freelancer that may fit multiple titles and is proficient in multiple software applications, so we have to be able to search for more than one term within each of those columns. We might even like a few more non-specific search fields added so
Force Edit in Report?
Hi, I think this has been answered, but I could not find it. I have a field in "FormA" that uses data from "FormB". When I create a new record or edit a current record in FormB, script executes that updates the field in FormA, but it does not show up in the report unless I do a manual edit in the report. Is there a way I can force an edit or otherwise update the report? Bruce "Speedy G" Peaslee The World's Fastest Programmer
HTML in Formula Field
Today I found that my lists which include values with hyperlinks (such as quick reply) are being displayed incorrectly. I have been working on other modules today, but found this specific behaviour to be happening - as of today - to all of my lists displaying formula-based fields. After reading the forum I found that - for security matters - deluge scripts should be used instead of HTML. I have tried to restore a backup from 13 hours ago, but that process threw an error. Could someone please help
Working with multiple applications
If I'm understanding correctly, I can have multiple applications which share and use the same forms (where form is equivalent to a table, or object). This is great, as it helps me organize my thoughts and keep 'modules' of my leggy master application separate and distinct. Is there a way to create a page/screen that links the applications together into a menu? Or is that the generic zoho.creator/home page?
New price
Hi! Whether old customers ZOHO Creator upgraded to the new price or for them to remain the old conditions.
IF Statement in Conditional Formula Expression
I have looked at all the forums and support docs and still am having trouble with this. Currently I have several formula fields that calculate a discount based on the input of the general price. Here is an example of the current working formula expression: ((General_Ticket_Price * 0.1 - General_Ticket_Price) * -1) But now I have a request to have different discounts based on the type of event. For instance IF input.event_type == "workshop" there would a different formula expression than IF input.event_type
ical feed
I cannot get the ical feed to work in any of my calendars (goole, yahoo, iphone) - Also the export in CSV doesn't seem to work either - I also can't make it public, I want to see the info on my phone without being logged in, it says to upgrade but i'm already on a paid subscription and it does not tell me what plan I need to be on - all very confusing, this was supposed to make things easier! please advise?
Finding all locations that call a function
I think I must be missing something, but I cannot find a way to get a list of all the locations from where a function is called. I used to get this list of locations by changing the name of a function and then saving it - and Zoho would tell me all the places I needed to make the change. But now it automatically changes all the calls to the function - which is good - but I've lost that useful feature. Is there another way to get the information? Thanks Alex
Phone questionnaire linked to record
We have a form that has questions we ask leads to qualify them. I have successfully created the form but what I would like to have happen is to have my salesperson simply have to click "Add" within the lead details area and automatically associated to the form similar to when you record a call or add a task from the lead detail area. Right now I can search for the Lead name and associate it manually, but I don't want that to be part of the process. I want it as seamless as possible just like your
Hide/Show Fields in Stateless Forms
Hello All, Is it possible to hide/show fields on a stateless form based on conditional criteria (user checking a decision box) just as you can on a regular form? Thanks, Adam
Can a form have mutliple related sub-forms?
As the question says - if I have a parent form, such as CITY, and there are related forms (such as Restaurants and Hotels), can the City form have two sub-forms? One for restaurants and one for hotels?
Next Page