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
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??
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;
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?
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?
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?
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
How to combine information in a grid with 2 fields into a single column?
I need to put both the information from the drop down box and the information from the text box and put it into a single cell on a grid. how can I merge the information from both? Thanks, Fraser
Application
Hi sir, I have created a sales application in zoho trial version, yet 1 day for that version . So i want that application in another user in trial version,Becoz i want to knw abt this application more .please help me to solve this problem
Possible to copy a stateless form?
I know I can create a form using a Form as a template. Can I duplicate or clone or copy a stateless form?
Populate field value based on View/Report
I have 1 form, with 3 reports/views. If the user uses View A, I would like the value of Form1.FieldX to be populated as "Blah" If the user uses View B, I would like the value of Form1.FieldX to be populated as "Blick" If the user uses View C, I would like the value of Form1.FieldX to be populated as "Brack" Can I do that, and how?
Are workflows triggered on customer portal
Is "On Success" script triggered when the record is modified on the customer portal?
Reg retrival of data
Hi all Am new to zoho and actually planning to create a APP for my business and have been working in that for days and have lot of query now.so came here for help q.1 I need to how to populate one look up field with data, which is actually not in this form already for example LET FORM-1 have a field called GC number Let FORM-2 have a Look Up field of FORM-1 with GC number. Here i want form-2 lookup field to display records which is already not entered in form-How do i do that. Q.2 In one form 1 ,
Stateless -> insert into FormA -> Field Actions don't happen?
A stateless form has script that inserts a row into FormA. Very cool. FormA has script in Field Action -> On User Input. But, when the data comes in via the Stateless Form, the Field Actions don't kick in. Should they? Or, do I need to fetch the associated values before I do the insert into FormA???
Zoho Calendar Delete API
Is there a way to delete a calendar event via the API?
Summary View with only 1 label
Is there a way to have the summary view, but only have the field labels appear once, frozen at the left? For example, if I have models of cameras, and I want to select several of them, and view them in Summary View (to compare the many features, side by side) Alternatively, is there a way to script a pivot view of the data, when it has non-numeric values? The Pivot Table doesn't work since the data being compared is not numbers.
zc-footer
How do I edit what is displayed at the bottom of all my creator aps? Live example: Page source: Cheers, John Whitney
Comma-delimited list in Deliuge
Child form has fields for State, City: Example Ohio | Akron Ohio | Toledo Ohio | Youngstown I want parent form to show: State, CityList Ohio | Akron, Toledo, Youngstown Can I script that with deluge and how?
SubForm Limitations
I understand that a sub-form's deluge scripting don't happen when data is posted. I'm finding this problematic, but surely there are work arounds.... 1. Can a script run separately to do the necessary updating (eg, updating fields with related values) 2. Can data in a sub-form be shown in View Only? So that the data is posted by other reports, but I can still see a master form with its related sub-form information? 3. Do you create buttons from the parent form, that open up child forms? It's
Field Setup
I have created a application in sales management.Its a Property Management.So I created a property entry form.I have a apartment name field .My requirement is i entered apartment name, then address filled automatically.
External connection from Tableau
I'm using Tableau software (www.tableausoftware.com) for all my reporting and data analysis. Is there any way I can make an external connection to my Zoho database from this software or is this planned for the future?
Control column width of fields in sub-form
I know how to control the column width for columns in a list I know how to hide columns in a subform How do I control the width of columns in a subform?
Date Expression help - Next_Day(date,weekday)
For any given date, I need to know the next Sunday date - for example, in Oracle the formula would be: NEXT_DAY('18-JUN-2014', 'Sunday') would yield June 22 2014 I could create a lookup table with every date, and the corresponding Sunday, but I prefer to create a formula. Any suggestions?
Emailed data to Form, Captured Attached Images, Need to Update them to Image Field
I have successfully emailed data to my form using it's unique email address. This is a great feature. I have also captured the images attached to the file using the ZC_file field name. What I need to do now is update another forms image field with the above captured image files. I've tried using the update deluge script but the image field is not updated. See below entx = Entries[Entry == input.Entry && TrialID_Entries == input.TrialID_Entries]; entx.Image_1=input.ZC_File0; entx.Image_2=input.ZC_File1;
Phone Number
Hi, I have created a number field for phone number my no format is :943848343812 but in zoho creater phone show like this :9.940057402E9 How to change this format.
Update value in subform before submit
Hi I want to put numeric values in a sub form and total up the values in a separate field before pressing submit. For example i have 3 fields called Size 1, Size 2 and Size 3. a fourth field called Total of size. When i use this as a sub form i want the total to get updated as i enter a number in size 1 and than that total to get updated when i enter another number is size 2 and so on. Thanks
Hide/Show based on values from Checkbox field
Options is a checkbox field, with Option1, Option2, Option3. Based on the selections, I want to show or hide the subform fields (named Option1, Option2, Option3) This is what I tried but doesn't work: if (input.Options contains "Option1") { show Option1; } else { hide Option1; }
@Martryl: Autofill Subform sample
thank you for sharing your Autofill subform sample. I've learned from it and can reproduce it for my application - however, I have a question. If the user selects Vegetables, the sub-form is loaded with the single value of bean. If the user changes the selection to Fruit, the child form RETAINS the value of the Vegetable, and ALSO adds the fruits. That might be nifty in some instances, but I would like the child values to go back to blank if the user changes from Vegetable to Fruit Can you (or anyone
toLowerCase Problems
My application includes several forms which each ask for the users name and email address. The email address is used as the identifier to cross reference records on all forms for fetching data and lookup fields. Everything was working fine until I realized that is a user inputted their email address with different capitalization, the scripts would not be able to match up their records because strings are case sensitive. I looked at these hep articles <string>.toLowerCase() and Built-in-functions
Problem Calling a Function
Hello There, I'm having a problem when calling a function via "custom Calling". I have a grid view where I show the "departments" of a "Company" and from there I want to call a function "GoEmployee" where I have to pass through 2 parameters, (CompanyID and DepartmentID) but I can not pick the CompanyID because of the field type that was assigned to that field at the moment of the creation. I have attached an image that illustrate what my problem is. Any suggestion will be very appreciated.
users cannot access uploaded file from view
I've created a view which includes the column for 'file upload' and everything works fine for me as the developer. The users can see the blue link, but when they click on it to download, they are being required to login. I've opened the entire application as public I've confirmed both the view and the form are published. Is there something I'm missing that will allow 'joe public' not access the uploaded files when I embed the view into a webpage?
Can I add an HTML or Deluge Header or Footer to a List Report?
I want to add a Header and footer to my report. A short introduction to the data present in the report and then a footer explaining action that needs to be taken on the data. I would like to be able to write the header and footer in HTML or in Deluge script. I would like to set a custom schedule to email this report with header and footer on a repeated basis. I have already created an HTML page with the report embedded in the center that looks exactly the way I want it, but I cannot create a custom
Next Page