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
Options in Embedded Report (Export, Print)
Hi all, I am embedding a report of type list in an HTML page and I would like to have the option to export data (same feature than the one in the standard report not embedded). But I can't find how to display it. Also, I would like to remove the Print option next to each record but again, I can't find how to disable it. Any idea ? Many thanks! Guillaume
Tutorial: How to count booleans
Ok, I have rows of data, and each row has multiple decision booleans, which are progress criteria for a job completion. My goal is to total the "true" booleans, and use this total to represent "amount done". I struggled for three hours trying to figure out the correct syntax for this, searched the forum, nothing. I hit upon the solution quite by accident. So here is how you do it: Say my project names are in string column "Project Names", and I have columns for "step 1", "step 2", and "step 3",
Customer portal vs. Share in Creator
I've just updated my account to Enterprise, believing that the customer portal gives the flexibility to manage the users. I have an app where I have more and more users, so far I had to create an email address for the user in Zoho Mail, then creat the same user in Creator, and then do the programming (scripting) to get the login name from them. (I have some scripts where I need the individual user, since some data based on them) The Customer portal is something else, but how can I make this long
Show links from subform in main form's report via script
Hello, I have a form by which I upload files. Each record of the parent form needs to be associated with 1 or more uploaded files or URL links. The only way I know to associate a variable number of uploaded files or linked sites is to use a sub form. This part is OK. However: I want the end user to be able to click on a link to download the stored file or access a web-URL directly from the parent form's report without having to open a separate window corresponding to each of the sub-form entries.
Zoho Creator
Hi, I am trying to create a new app using zoho creator. I am trying to create an app called "compressors", I want to mimic the "products" app that is already available but with minor adjustments. Do you have any ideas on doing this? Thanks
Is it possible to have a conditional Payment form?
Hi there, my client has a requirement to allow direct deposit as well as PayPal payment. Is it possible to make the payment form conditional so that if the user chooses "Direct Deposit", they won't be directed through the PayPal gateway? cheers, Jeremy
Page
What is the use of Create page? I Saw that user guide but i dnt understand pls explain me
Does anyone know how to import Cognos reports into Zoho creator?
I'm new here and can't even get started. My excel files from Cognos don't integrate well into the Zoho. Is there a developer out there that would like to work on a project that could help change the performance management process for a category in the CPG industry? Would love to collaborate on this project to get it moving along.
Report Only see my records
Hello, I have a report and in this report I have a field called "Assigned To" which has an email address of the of the person that equipment is assigned to. When anyone accesses this report I want them to only see records where "Assigned To" equals the email address of the person logged into Zoho Creator. How can I do this?
View/Report help
Form1 has a look-up to a Team Team is connected to Teammembers How do I get a report that connects Form1 with all of the Teammembers? ie, if a record in Form1 is connected to TeamA, and TeamA has 5 teammembers, my report (unfiltered) would have 5 rows (ie, 1 row for each teammember) in MS-SQL, the view would be: select T1.* ,TM.* from Form1 as T1 inner join Team as T2 on T1.teamid = T2.teamid inner join Teammembers as TM on TM.teamID = T2.teamid
Iteration on Zoho Creator (not related to forms or fields)
Hello, I want to iterate character by character in an string. Which iteration structure (not related to fields or forms) could I use? Kind regards, Mari Plaza.
RTL in pages
Hi, I am trying to tweak CSS or Table tags in a page so as to render a table as RTL. I am using the Dashboard template for the page. Unfortunately, all my trials failed, any suggestions? Regards
Next Page