can subform include loginuser and dated posted?
Can either type of subform (the one that is embedded into a field, or the one that connects to a separate form), include columns showing the logged in user and the date?
Combining Multiple Related Data On One View In Creator
I need to combine data from multiple forms on one view, similar to your CRM Accounts view. I need to have a main organization record with sections for contacts, etc. under it. I searched the forums and knowledge base, but cannot find the answer.
Zoho Creator fx formula help
I have values in my forms that are (36" - 914mm) and also (50" - 1270mm) i am trying to create a fx formula that will return the values of these forms so that i get (0.914) and (1.270) if anyone could help it would be much appreciated..
FieldType: Multiselect vs Checkbox
What is the difference between these 2 fieldtypes: 1. Multiselect - and then I can choose dropdown or checkbox 2. Checkbox
Help with some code Please
Hi, Could someone please tell me what is wrong with this code... myUrl1 = ((("https://creatorexport.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/"; rec = input.Job_Number; myUrl3 = "/fame=" + rec.ID; myUrl = myUrl1 + "Invoice" + myUrl3; openUrl(myUrl, "new window"); It is in the app new starlight digital which I have enabled for you if you need it. I have a feeling I have done the rec variable wrong but I am not sure. The code is attached to the action on user input of the print
Set Filters for dependent lookup fields
I have a form that contains two lookup dropdowns from two other forms. I need to populate the second lookup based on two fields shared by the the first lookup. I used the SET FILTERS dialog to generate ((((LGA==input.Ward1.LGA)&&(RA==input.Ward1.UID)))). However, the second lookup does not populate at all and only the first part LGA==input.Ward1.LGA gets persisted. Please assist. Thanks.
Scanner Interface
Is there a way to scan a document directly to ZOHO and add user defined terms?
Help - When trying to change Default Permissions for my forms the screen hangs.
In Enterprise addition I am trying to change the permissions on an form to allow public access. When I go to Settings->Users and Permissions->Advanced Sharing Settings. change a setting and then click 'Save' the screen hangs. Can anyone help me on this - is it a browser problem (although I have tried different browsers) and even tried on my Android tablet with the same results. I also occasionally get this when editing a script - dragging insert a function for instance causes the screen to hang.
Q: How to create Unique Index by combing two or more form field together ?
I know ZC only allows only one field in making unique index. Through deluge script, you can combine two or more fields in submit action to restrict dupplication. I know and did the same, but it worked partially for me. My issue is - as ZC consider lower and upper case separately, it allows duplicate entry when the data entered differently mixing lower and upper case though spelling remains the same. I tried upper function in my deluge script, still it didn't worked properly. It only works when
view only field
I have a parts_Used form that I want to show the current on hand quantity of a part. I only want to show the user the current on hand and not allow any changes to the field. Is this possible? The field I'm currently using is a numeric type.
Q: How to customize ZC form field positions and style as required.
1. I am trying to develop an application whose one of the form would be like: 2. I set the form as Two column wide. Lower section contains the sub-form which may be extended many many lines as more and more product variation is added. 3. Accordingly this form may need to be extended multiple screen down, which means Submit button will be placed in a place which will not be convenient and user friendly. 4. Unlike ZC default CSS settings, to make the application more user friendly I want to customize
How can i put my google calendar insde zoho creator?
Can you help me with this? I really need this done.. please
how to hide admin email address?
hi use workflow rules and send email in manner "if this than that" when i tune email sending systems asks me to send email from admin email or to admin email in all cases systems asks me use admin email how can hide admin email from email body i need use admin email only for system needs on other hand - system do not accept using admin email only in bcc field i need hide admin email in from: and in to:/cc: fields.
Potential Misconfiguration in Maximum Number of deluge sendmail Statements
In my database, I have assigned a numeric "group" number to 259 records to control how many emails get sent using the following function: void NOTIFY(int Group_Number) { for each row in parent_database [Group == Group_Number] { sendmail ( To : row.Parent1_Email From : zoho.adminuserid Subject : "sample" Message : "yadda yadda" + thisapp.printout(row.user_key) + "yadda yadda" ) } } The function thisapp.printout(row.user_key)
How to filter report to exclude sub-form dates
I'm trying to create a list that identifies accounts that have no activity in the last 4 weeks. My main Accounts form has a sub-form for Activities, so what I was hoping would work is: show all rows from Accounts [!Activities.Activity_Date in last 4 weeks] but the use of ! to create a negative doesn't work. If I try to use >, it won't filter Accounts that have activity both before and after the 4 weeks. Is there a !> function, or some other means to say "not after" I've tried using other deluge
String and Date Handling from Multiple Fields into One (newb)
I need to do the following and was wondering if anyone could offer some Deluge pointers. I have a form with the following fields: Date (date) Room (drop down with three choices Room 1, Room 2, Room 3) Class Title (single line text) POS Title (single line string with 30 character limit) The task is to convert the Date, Room and Class Title fields into a string that will be fed into the POS title field in a specific format. Here is an example: Input Date: July 1, 2014 Room: Room 1 Class Title: Underwater
Fetch CRM Field from Another Creator Form
How do I fetch a CRM field from another Creator form? Order form has a drop down "Generator" linked to Generator form. Generator form has an Account CRM field. I have an Account CRM field that I want to update in my Order form based on the Account linked to the "Generator" drop down. (For us Generator is an environmental term for a facility that requires service / Account is the company that will pay the bill.)
Radio button add date
Is there a way to automatically add & display the date, in line, when a radio button is checked. My example is in an application for construction progress. I have a check box radio button for when the rough in wiring is complete. I would like to show the date when the box is checked so I know when the work was completed. thanks
Maximum published components limit - for Professional and Enterprise
I currently on the Standard Edition Problem 1 How do I do this, public sharing on the web? https://www.zoho.com/creator/help/application/application-sharing.html#Make_Public_to_all_visitors_over_the_web I don't see the option in my account. Problem 2 I know the maximum published component is 3 for Standard edition. But what is the limit for Professional and Enterprise? Problem 3 I try upgrading my subscription by selecting Professional edition and upgrade, but all that happen is the page submit,
Making Creator Apps Feel Native In CRM
Hi group. Thanks in advance for any help. I am creating some customer apps and putting them as individual Tabs in CRM. Essentially, I would like to create the next progression of the business cycle after our Potential has closed and become a client. Here is my problem. In Potentials, Clients, Leads and pretty much any native CRM app, the native view provides a hyperlink from the name to the page. For example, in Potentials, the native view lists the Potential Name in a column and you can click
"Usage Limit" records count error
Hi, My records count is given as around 50,000 records, but from my going through my applications, there are only about 12,000 records in use. Can you please reset the count for my account? Thank you.
To view all the records displayed in a published report in a single page
Dear Sir, In our application, we have published a report to our vendors. From the published report, they have to write a script based on the data.In zoho, the maximum records to be displayed is only 200 per page. But our report has more than 250 records. So it traverse to the second page. Pls let us know, is it possible to view the second page of the report, without actually clicking the navigation button. Also, is it possible to include the page number of the report in the report url? Any suggestions
"Super Admin" role versus "Admin role"
I want some users to be able to administer the creation of new other users but not have access to be able to edit the application, is this possible??
Application Context Issue for New Users
The verification email sent to new users (example below) has a link to click to finalize the verification. When this link is clicked you get the "continue to sign in" web page. When that link is clicked, the user is not directed to the application, but to this: This is causing all sorts of issues with users wondering what they are supposed to do. The links should all direct users back to the application where they created the zoho account. Please fix this immediately! Cheers, John Whitney
Can not set Decimal and Currency Fields to 0.00 via Script
I have a Decimal Field and a Currency Field (USD) in a Form ... both defined as having 2 decimal points and initial value of 0.00. They both display 0.00 when the form is initially displayed. I have script that does ... input.Decimal_1 = 0.00; input.Currency_1 = 0.00; However, when invoked, the values in the field boxes are displayed as 0.0 ... i.e. just one decimal point. And when I return to Edit Mode, the commands have been changed to ... input.Decimal_1 = 0.0; input.Currency_1 = 0.0; I believe
Embedding Google map in iframe
I want to open a Url in an iframe, but the url is lifted from a value on the form. What is the syntax? I tried this, in the OnAdd.OnLoad script, but it doesn't work (I get a new window, that's blank). I want an iframe, that shows the info based on a url field on the form OpenUrl(input.Url, "iframe", "height=100,width=100");
How do I make a lookup field display information and not the ID.info
I have a "Contacts" field in a customer follow up form. This field looks up contacts in the contact form. Naturally if displays the ID.info. I've set a filter in the follow_up form to ID==site_ID. This should only display contacts that have the same ID as the ID entered in the Follow_Up form. The contact drop down selection box still displays the record ID.info. I've put this code in the "Contact" field On User Input. FollowUpContact = Contacts [ID == input.Site_ID]; Site_Contact = FollowUpContact.Full_Name;
Help newby question
Help sometime when I log in I can't access my email account it just goes straight to home page and then i'm stuck, I have to log out and wait a few hours then try again and i go straight to my emails why? what happening. thanks for any replies.
how to create public variable
How do I create a public variable to store information in one form and then use it in another? I have three default fields in one form that I need to populate in another form. I've tried creating a variable but they are only valid in the form they are created in. Any thoughts?
Summing the data in specific field in subform and display result to main form.
Sir, I have a sub form named Request_Parts with fields customer_request_id, part number, Part name, retail price and serial number. I have a main form which contains total price. My requirement is that I need to get sum of the retail prices(sub form) in total price(main form). I am using bi-directional relationship with the child and parent table. I have used the following code. but, i am unable to save the code because of the highlighted portion. total1 = 0; for each row in input.Request_Part {
List:Date help
I'm trying to create a list of dates between Start and End The first date should be input.Start The last date should be < = input.End The remaining dates should be 28 days apart fourWeeks = list:Date(input.Start.addDay(28)); gives me an error: Expecting TIMESTAMPLIST expression found TIMESTAMP expression thanks in advance
This record's Datefield = maximum prior date + 7
I have a form with dates.... When I add a new row, I want the Date_field to default to 7 days after the maximum prior date... How do I do that?
Show image in a page
I read all posts and documents related to showing an uploaded image within a page. Ifetched the target record and the link uploaded image link which is https://creator.zoho.com/sharedBy/appLinkName/viewLinkName/fieldName/image/1403695745088_Downgrade.png I replaced all fields manually to try it in a page but never shown the image. Moreover, I could not find any reference to the ViewLinkName field, what should it be replaced with? Any help?
Launching a detail report from a summary
I'm sure this is easy but I haven't found explicit instructions by searching through the help pages or forum. I have one form that contains all the player information for a sports page. On my Web site I want to list a subset of the data (easy enough to do, I created a report and then embedded it in the Web page) with the option of launching a detailed report from the summary. The summary report embedded in the Web page displays Player Name, Team Name, Positions Played, Jersey # What I need to
The effects/code that made in the sub form is not taking effect on the parent form. Why?
The effects/code that made in the sub form is not taking effect on the parent form. I have made a sub form with fields like Part, Part Number etc. Where part is a drop down list and Part Number is a single line. While choosing a part, the corresponding Part number will be displayed in the Part Number Single Line field. While i am inserting the sub form in a parent form, sub form is not working as expected. Similarly, i have increased the width of Part drop down list in sub form. But it is not applying
Complex count
Hi guys, I want to count all availibility for staff member filtered for specific service. I try with: input.Avalaibility = FormA[Day= input.Day && Staff.Availaibility in stafflist].count(); where: Avalaibility - is a field that sum all availibility of staff in the relation STAFF=SERVICES in FORMB. FormA - allow user to choice service for Day and Staff. Staff - filtered field with stafflist and Staff:ui:add(stafflist) stafflist - FormB[Service == input.Service && Status == "Active"].ID).getall();
Recomendation for new App
Hello, Can someone give me a recommendation for a new client I have? The company is a Car Repair Shop (They fix and do maintenance of cars). We need to begin to get all the info of his clients and the info about their cars. I initially think about in Creator: Do an app for Clients and a form with all the info about the client and his cars. For example: Name client, Id Car, Date to change oil, Quantity of miles/kms, Brand of car, Date to change battery... It is just all the info about the car... But
Use Spreadsheet with Form that has Deluge Scripting
I would really love to use spreadsheet view to edit data, but the form I am using has Deluge scripting that disables the spreadsheet functionality. I was thinking of exporting the data I want to edit somehow into a form/view that does not have Deluge scripting and then export the edited data back. Not quite sure how that would work exactly. I would need any data edits to make it back to the original form. Has anyone tried this or have another solution?
Deluge guide
Hi, in https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-list-date.html the text refer to boolean and not date. Thanks Mike
Need a complete copy of a report.
I have gone to some effort to get a report just the way I want it. It displays all the records. Now I want to copy it and designate only those records that are not "Closed" be displayed. None of my column work copies with the report. Is there a way around this? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Next Page