Colur tagging
im lost, what i want to be able to do, is if an entry is coming upto the current time, i want the entry to turn red. also if the entry has the required date that matches the current date, then its to turn orange, is this possible, im really struggling here :(
Zoho Creator - extremely slow
Creator works extremely slow for me. Has someone the same problem? Regards, George
Disable Formula Field ?
Hello. I am prototyping/evaluating creator. I would like to know if there is any way to "disable" a formula field and prevent it from executing while in edit mode? I have a formula field that auto calculates a unique quotation ID (I sure wish there was a random number generator) based on date/time when the form is originally submitted. I don't want this field to auto-calculate to a new unique number, every time I edit it. Thank you in advance.
Creator: actions on user input :actions on update
I would like to script a copy of a record when it is opened on the form. Copy of a record when the form is saved Then I would like to compare the two records If no changes create a new record in table that records userid date time filenumber(keyfield) no change If changes are made a new record in table that records userid date time filenumber(keyfield) the beginning and ending vaules and the field name (a change or audit log feature would make this a lot easier) Has anyone done
lookup into another form takes into consideration html formatting
Hi, Am two minded if this is an issue....it is for me but maybe this is so by design: Form A has lookup field (hello) from Form B Form B has the hello field with an entry wrapped in HTML as such <span style=color: red;">[WORLD]</span> (the word WORLD in RED) If fetch Form A and write the same HTML <span style=color: green;">[WORLD]</span> (the word WORLD in GREEN) Result....nothing shows in Form A Conclusion, From A lookup is not displaying anything in the hello field because this exact string does
openurl - embedded view no login
I have a view embedded in my website. I have it configured to allow for no login. Everything works fine. The view has a function assigned to display for each record in the view (shows a button on the righthand column of the view). The function uses OpenURL to call another view that has been configured to open without login. In my function, I have tried calling the view using the methods shown below. I prefer the first method using the #View: syntax because the view pops up inside my website.
Without using for each record how to iterate the loop between two dates
I want to show one html view in 7 times in another html view i.e nested html view (view in view) .And this 7 times data showing date also which is incremented. There is any possibilities to show just like data or any loop (while,for etc)
Can't Get Deluge Script to Save / Run / Work
I've followed the examples in the tutorial. I've read through every single Forum mention the word Deluge. Nothing answers why it's not working. The example don't show either of these two differing lines in the actual script: <return value as map> = zoho.reports.createRow(<Database Name>,<Table Name>,<Data as map>); All the examples at this page show: http://reports.wiki.zoho.com/Creating-Data-Entry-Forms-for-Zoho-Reports-using-Zoho-Creator.html Without including that line with "return value" at
How To Set Address To Google Maps?
How To Set Address To Google Maps?
Multiply the field1 in"FormA" by field1 in "FormB" then the result in"FormC"
Multiply the field1 in"FormA" by field1 in "FormB" then the result in"FormC",is that possible?
Additional row is also added when tried to store seperate rows for each item in Multi -select list
Hi, I am creating an application that includes a form called Form 1 with single line field 1 single line field 2 and one Multiselect Field(Look up). When i tried adding more than one item in the Multi select list for the Form 1, in the Form 1 View this is stored in one single row with the items seperated by comma's in the Multi select column. So i have written the below code on, Script(On Add) -->Actions On Success, that enters the records in different rows for each item selected in multi select,
How is it possible to import data in a form for a user who is not admin ?
Hi everyone, I have created a form with Zoho Creator and, because I am the admin of my application, when I click on "Access My Application", the form appears and also the "More Actions" dropdown with "import data" function. Now, when I share the form with another user, he does not have the "More Actions" dropdown... So I wonder How is it possible to import data in a form for a user who is not admin ? Explicative screen shot in attachment. I hope I was clear.. Thanks Kevin
Submitting File via Email
Hi, Is it possible for a user to submit a file (excel, csv, txt) via email to a form? Thanks! V
Multiple branches control
Hello, I am running a business, which has 2 branches for the moment. This will change in the near future with a third and a fourth branch. I would like that each branch, after logging in, can only see their customers, their employess etc. As also, after logging in, only specific fields on the forms will be active depending of the logged user. But, the admin would be able to centrally see all customers, all employees, all fields etc. Is this possible with Zoho Creator? Thank you
Relating tabs
how can i relate a custam object to a standard object using lookup
create list using toList() then use remove from list questions issue
Hi Still getting my head around this but here are some questions so far 1) toList() enter_string = "X</span>"; enter_string_as_list = enter_string.toList("</span>"); THE String List will contain a trailing , ie X, Q1) Is this meant to be like this by design, lets assume it is for whatever reason 2) remove the element takeout = enter_string_as_list.remove(0); takeout is now X which is correct BUT theemptyaize = enter_string_as_list.size(); returns 1 Q2) Should it now not return 0 ?? as the list
Alert or Pop up in html view
I want to check out the date field in query string is present /null/or invalid for that i want to use alert box
How i create autogenerated date
I want to generate date which is autogenerated and pass through query string andand show in also input field
Limiting subform multi-select based on selection in main form
I am developing a database with forms for corporate data, project data, and employee data. I have created another form to track activities data associated with a client/project by employee. In the activities form I can select a corporation, which updates a multi-select for projects associated with that corporation. I have a sub-form within the activities form that allows me to select an employee and record dates/times/activity for that employee, and associate them with the project selected in the
Subforms
I am new to to Zoho creator and have recently been using the trial version of Microsoft Access to set up a patient database for home visits. I have created a form and have included two subforms within the Master form. 1. I was hoping that they would just provide a link to the forms, by clicking on the images (see attached "overall patients form (editing view)") and not reproduce all the entries, as in the attached "overall patients form (actual view)". 2. I would like it look like the editing
Faster Data Entry... Need help with Lookup data type...
How can my lookup field "remember" their values from previous form submission? I'm trying to improve the speed of data entry by "remembering" the last value that was submitted using the form. I see where I can assign the value to a variable, but how can I then assign that value to the lookup fields when the form is loaded. Or is the right approach at all?
counting months in irregular fiscal year
If anyone out there knows of an elegant way to count the number of months since the beginning of an irregular fiscal year I would really appreciate send that gem my way. I had an app all ready to go for a client that assumed a regular year of Jan1--Dec31 and used the basic .getMonth( ) date function to generate a number count since the beginning of the year for a given date. Then, the client informs me that oops...their fiscal year is May1-Apr31. Now my app formulas must be changed to reflect this
take the percentage from one "form" and calculate it from a dollar amount on another "form"
take the percentage from one "form" and calculate it from a dollar amount on another "form" is it possible??
Combining Views
Hi, How do I combine three different forms to create a view that has all the fields from these forms? All these forms are part of same application. The first form contains a user entered reference field which is also a lookup field in the other two forms. Thanks! V
Creator Embed From not working in IE8 or Safari
Hello, I have an embedded form that works fine in Firefox and Chrome but does not load in IE8 or submit in Safari. Permalink works fine just not the embed code. http://www.sustainableprosperity.ca/RIO+20+Feedback Thanks, SP
Export Back-ups
Hi, I have 7 applications and I will be making more soon. I would like to back-up my data through exporting it all onto a excel speadsheet (each different application). I was wondering if there was a way to get them all to download at once with one click instead of going on all of them and doing it manually and if possibly there is a way to do a scheduled back-up some how? Thanks
Creator Font Change
Hi, I would like to change the font of a renewal deadline to red whenever it is within a month of that renewal deadline. How would I go about doing this in Zoho Creator? Thank you, Jon
issue with email login not in use...
Hi, last year i've played with creator doing a renowal domain system, as a main account i use an email not working now (domain expire). i shared this app with mine domain. can be possible be in contact with support for details? thanks in advance for kind reply Noris D.
I can't use public application on free account???
Hello. I can't find any information on this in the FAQ. Whenever I try to change a form to public the option is grayed out and it suggests upgrading my account. However in the business version faq it says that I should be able to create a public app accessed by unlimited users - inside of the free edition.
Conditionally Call Paypal
Is it possible to conditionally call the PayPal function? For example I'd like to have a radio button options to Pay online Pay at the Door If they choose Pay online it takes them to the PayPal screen otherwise the form saves normally. Herb Wexler
Formula
Hello, i was trying to edit this in free flow, The "username" and "userid" are field name right? and type is "formula" ..But you can't put formula if you don't enter "expression"? in the given example theres a two fields username and userid but their type is "formula" is it possible that you can convert a field to formula in free flow? username ( type = formula value = zoho.loginuser ) userid ( type = formula value = zoho.loginuserid )
ERROR ON AT SUCESS SCRIPT
Dear All, While filling online Form, I am getting Error Message as below : Error on at Sucess Script Note: We are working on giving more meaningful error messages on script failures. What is the solution for this message. I have given request to Zoho Team, but not received any reply. Please reply me at the earliest. Deepak
Can I set up a field that autofills with consecutive unique numbers.
I need each form entry in my database to have a unique consecutive number. So when a form is submitted the first field might be 0234. Then when the next form is submitted that field will automatically show 0235. Is this possible? Thanks in advance.
Need a Database Documentation Report
Any idea when there will be a database documentation report, similar to what you find in MS Access? It would need to report on each form and view, and all of the field properties associated with it.
HTML View Problem
I am evaluating creator for possible use by our company. I am having a problem grasping the concept of the HTML View format. I have my form created, and have created many working view with that. I would like to create an HTML view to report on a single unique record row from my table/form. I understand how to build the HTML portion, but how do i display data from the form in the view specifically. I have passed the variable that I need to set up the criteria to select the correct row, but how do
Zoho Reports Style Data Import Process
Hi, The Zoho Reports method of importing data is so much better than that of Creator. I would like to propose that you try and incorporate this into a future release. Thanks Shaheed
Opening View from list and passing record ID
I am new to custom programming within ZoHo creator and am having difficuties in creating a function that will open a custom view with the lists record ID. I have the custom view called Quote_Review_and_APQP_Tracking and here is the inital Free Flow Script htmlpage Quote_Review_and_APQP_Tracking(potential_idstr) displayname = "Quote Review and APQP Tracking" pdf = true content <%{ curPotential = Potential [ID == input.potential_idstr.toLong()];%> I have created a custom function called
Email Already exist
Hi, i tried to do this in free flow and works fine at first,when i try to submit the email again it shows" One or more fields were dynamically changed. Please resubmit the form. then after i resubmit the form it "Added Data Successfuly"? On User Input { if (count(Register[emailid == input.emailid]) > 0) { input.emailiderror = “This email id already exists”; show emailiderror; } }
Cant find the "count" built in function?
Cant find the "count" built in function?
How I iterate the loop without using form data
There is 'For Each Record' is iteration loop in Zoho creator But I want to iterate one html view in 7 times with incremented date. How I resolve this problem by using Zoho creator? Please Reply
Next Page