URL links for forms and pages for an application going to the Marketplace
I have a new application (my first to go to the marketplace) and need to know what format should links be so they continue to work when run by someone who buys the application. Are there placeholders for the top URL segments so they always resolve properly. I'm not sure at this point what part of the URL changes once someone is running their version of the application. Thanks. Regards... Rick Davey
count rows in subform
What am I doing wrong? I just want to count the total number of records in the subform that meet a certain criteria and input that count into a field on the main form. input.fieldinmainform = count(Subform[fieldinsubform == "LBR"]);
Sub Items And More users!
Hello, I just signed up for the free account but am very excited about using Soho for all my invoicing needs for my company. There are two huge questions remaining before I would be able to move forward. 1) How close are you to adding sub items? I have hundreds of products and need to be able to break them down into categories to make adding items to an invoice user friendly. 2) Is there the possibility of adding more users? I would like to be able to have 12-16 users. Please let me know.
Best Way to Archive Data?
My team has currently hit a dead end. We are trying to figure out the most efficient way to archive our data. Currently, the only way I know how to do this, is to have two separate forms. One is the “Current Bike Form” and the other is “Archived Bike Form”. On the “Current Bike Form”, once a certain criteria is met and when the submit button is pressed, it will add that record to the “Archived Bike Form”. While this method archives data, the data can get very redundant under the “Archived Bike
Bulk Edit - excludes one of my lookup fields
I have a form with lots of fields, some are lookups and some aren't. When I use the Bulk Edit, one of my lookup fields is not included as a field that I can update. Any idea why that one field is excluded???
How to Add Criteria to a API Request Using Form Method GET
I'm following the API directions to fetch a single record from a view using the form Get Method. I'm not a programmer and the documentation says you can add criteria to your request, but I don't know how to add the criteria. I can successfully access the view. The request returns the entire record set, I just want a single record returned. Can anyone help me with adding criteria to my API Get Request Here is my request with an attempt to add criteria as a parameter. Not working of course. <form
Pull multiple fields from Form A into lookup field in Form B
In Form A I have 3 different fields, Contact, Contact 2, and Contact 3, plus Email, Email 2, and Email 3. In form B, I have a lookup field that currently will only lookup the value of Contact and auto-populate the associated email. In the lookup field of Form B I need to pull the values of Contact 2 and Contact 3 also (if value is present) into the lookup field. Is this possible?
Skip weekends formula
Hello, I am building a database that will allow a user to set a target delivery date and choose a shipping zone. Based off of this information the program will auto populate the "needs to ship on date." My issue is i can not find a formula to add in the extra two days for the weekend if there is a weekend in the middle. This is what I have so far. Thanks in advance for any help. if (input.Shipping_Zone != "-Select-") { days = ((input.Shipping_Zone).subString(0,1)).toLong(); if (days >
Bi-Directional Relationship
FormA has a multi-lookup to FormB, with ability to "add new" FormB has an "existing relationship" lookup to FormA. My expectation is that, from Form A, I can add new values in FormB - the problem I'm having is that: I think FormB should automatically KNOW the value of the linking field, without my having to enter it, and it doesn't. Should FormB be able to automatically know the value of the linking field, because of the bi-directionality? Or is it really necessary to add the value manually????
How can I save a photo to an app with an iPhone or other mobile device?
I have an app that requires photo documentation in the field. I want to be able to enter text data into a form and then take a picture to be attached to the form in a field. I want this to be done with a Blackberry, iPhone and Android phone. Can this be done? Snap a picture and then attach/ upload? If not directly, does anyone have any recommendations on how to do?
HTTP JSON request - return no such view error
Hi I am trying to fetch data in JSON format from one of my views The below fetch call returns There is no such view in Zoho Creator http://creator.zoho.com/api/json/<application_name>/view/PriceSheet_Report/apikey=XXXX I like the above url to return the data in JSON format. Can please help me? Cheers -Jag
Assigning "Numeric Value" to Radio Buttons
This is a two part question (I will take one answer at a time if not one person can answer both LOL) Q1: Is it possible to assign a value to each individual option on a radio button? e.g. Radio Button Field 1: Was the Main Objective completed? Options: Yes = 50 No = 25 Radio Button Field 2: Was the minor Objective completed? Options: Yes = 50
importing apps
Have imported the Apache OpenOffice app for my linux documents, but while it seemed to install properly [even has own icon], when try to access it, all get is message that have lost contact with the page -- again and again and again. Anyone have a solution?
view an image or a file in a stateless form that is fetching data from another form.
Can this be done? I would like to be able to view an image or open a file that resides in another form in a stateless form.
anyone know why this happens?
From the iPhone app, when loading information from a lookup field, it only shows the following, 1 option selected instead of showing the actual info in the field.
Copy form to new form
I have been trying to figure out a way to create a new form based on the completion on a previous form. Im creating a master manufacturing record. Once that form is filled it & saved I need to create a batch production record based on that info from the MMR each time I make a production run. The MMR includes a subform that is built while completing the MMR. For example it includes mfg steps. Some MMRs will have 5 steps while others have 12. This subform is built using the add new option to certain
How to set column formats in table chart view?
Hi there I have a table chart pivot report. I would like to be able to configure the format of data within each column. For instance, I have a date column and I have selected "Month and Year" but instead of showing "Mar 2014" it shows 201403. Similarly, I have a column showing Average. This is an average of currency so I would like to restrict that to showing 2 decimal places instead of default (12?) Thanks for your help
Can I have 2 pop-up windows open at the same time?
I have a report, and I have a custom action that opens up another list, in a pop-up window. While that pop-up is open, can I use a 2nd custom action to open a form in another pop-up window? The only work-around I've come up with is to open a 2nd tab in the browser....
Data in form "A" not saving in form "B" in a nested IF/ ELSE statement
I have a customer service app (Form "A") that needs to save a date back to (customer_Info) form "B". The code is nested in a IF/ ELSE statement. The rest of the function works, but the updated date is not saving back to form "B". It is populated by the ID of form "B". ---> SiteInfo = Customer_Info [ID == input.Site_ID]; This section sends the email ok and with all of the info from form "B". It dose not save the date into form "B". What am I missing? // If the service is marked completed and the
esignatures
is there any way withint the zoho creator (or zoho writer) to add an esignature?
URL link for uploaded file v. download link
Is there a way to link directly to an uploaded file via a standard URL that allows the email/browser app to handle the file accordingly. For example: http://creator.zoho.com/zoho.adminuser/zoho.appname/FILES/uploaded_file.pdf I don't know what path 'FILES' would be? versus: http://creator.zoho.com/DownloadFile.do?filepath=/input.File_Upload_1&sharedBy=zoho.adminuser&appLinkName=zoho.appname&viewLinkName=yourViewName The form scheduler option to send attachments with emails is limited to 100 per
disable field on edit
Hello. Is there a way to disable a field on edit if it has data in it using script? Example: I have a service ticket for my field techs. One guy will add a record, then another will edit and add more data. I'm looking for a way to prevent the second guy from deleting data from the first guy. Each guy opens and edits the record multiple times so just can't disable on edit...only if data is there is what I need. Thanks
How to change message Invalid entries found??
Hello, Changing the message to my language Português Brasil? Invalid entries found. Please correct and submit again. TKS...
Calculation on a page
I need to calc this on a page Table: EntradasRomaneio Sum Field: Valor Grouped by Field: Contas_Banco I want to show the sum of Valor field grouped by Contas_Banco field in EntradasRomaneio Table
Adding record into form with lookup field (by custom action function)
I created a function to load a new record with data from one row of a report. The form I'm trying to add a record into uses a lookup field (integer). The lookup field is mandatory. When I execute the function, I get an error: "Reference field unit_code not having the value 465,202" (the 465202 is the integer I'm trying to enter into this field, but the error is showing it with a comma, could this be the problem?) Must a lookup field always be entered by hand?
replace date field datepicker with Calendar view?
I'm developing a job tracking application. There is a form, Jobs, that tracks each new customer job. Within that form, there is a subform for entering appointments with a client for estimates, jobs, etc. There can be more than one appointment for a job. The subform, events, has the basics for scheduling an event (event name, start datetime, end datetime, etc). I also have a calendar view of the events form. The event form is basically a schedule of all past and upcoming meetings with clients. When
Enforce Lowercase
I have an application set to only allow unique emails. However, I noticed that the same two emails can be registered as long as the upper/lowercase character are not the same. Is there a way to convert a string to all lowercase?
Can I show a related field in a form, without having a field for it?
Can I fetch and display the value of a field from a related form, without actually having to have a field to hold the data? This would be in On Edit, On Load example: fetchPerson[ID == input.person]; show fetchPerson.Email;
How Can I iterate through Radio Buttons
I have a Form with a number of Radio Buttons. I want to create a drop down list in a second Form based on the values of all the Radio Buttons (their names, I guess) whether or not they are selected. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Fetch records
Hello, I need to set a report criteria based on a form from a different application, Is this possible? And also, how can I fetch a lookup field by its ID? Thanks.
HTML View help
Hello all In my application I am trying to create a HTML view that allows me to capture details for my workers. The code is attached below: htmlpage Tankkarte_Details(ID) displayname = "Tankkarte Details" print = true pdf = true content <%{ Mitarbeiter = Personalien [ID == input.ID.toLong()];%> <strong> Mitarbeiter</strong>: <u><%=Mitarbeiter.Name%> <%=Mitarbeiter.Vorname%></u><%if (Mitarbeiter.ID == input.ID.toLong()) {%>
Issue in Script Builder Updating a Long-List
I made a function to clear a long-list field type from my database, but it was reporting this error: The only way I could get it to work was build the code in free-flow script mode: void DELETE_MEMBERSHIP() { for each row in parent_database { row.Schools = List:Int(); } } Clearly a bug! Cheers, John Whitney
Can I import data to CRM field?
I have a form in my application into which I am wanting to import data from a CSV. The form contains a CRM field. I have tried importing using the Lead_ID from CRM as the value for this field, however this does not work. I have tried importing using the Lead_Name from CRM as the value for this field, however this does not work either. Can anybody tell me what value can I use on import to link to the correct record in CRM? Cheers, Bianca.
Import new data plus associated sub-form data
For importing data there is a checkbox - "Do you want to import subform data". It appears that this option does not allow for sub-form records to be imported against a single parent record, instead the import routine imports the sub-form record data against new parents. Can someone confirm this?? If so it is not worth having this subform import checkbox unless there is only one sub-record associated with each parent which really defeats the purpose of having subforms..?
On Load, On Success: Add Record
How do I add multiple records to FormB in one fell swoop? Form A has fields for StartDate and EndDate, and Duration (a calculated field) Let's say July 1, July 6, and 6 I want to insert 6 rows into FormB (one for July 1, July 2, July 3, July 4, July 5 and July 6) thanks
Published App can Add, but can't Edit records. Why?
Hello, I published the below app forms to the public so that a customer can see the forms I created for him. He can add records with the Add Invoice link below, but he can't edit records in the Edit records link below. How can i change the form so that he can edit records? Add Invoice https://creator.zohopublic.com/iramalvarez1/published-qcr/form-perma/Invoicing/A6UKh9uAMga1eg9YCguh3xVN0pgySddyXpkF34UaUzPSsE2dOADC525pKBwBUAODBBCpfrFK0Ka4vNFn6j0DyjnJqabSOMwtxnf1 Edit Records https://creator.zohopublic.com/iramalvarez1/published-qcr/view-perma/All_Invoices/dHH2skxRqbbN6eMjyZDyp7RhbO82h8d9pG22jVeEqA1NxK7aObumW3DSQVP9GyByTqy6Q5q1muEKECMnRvv52UKTHsfFOABMseS7
Can I access a Pivot Table via a Custom Action?
I know how to write a function, so I can access a form or view via a custom action. What is the syntax for opening a pivot table?
Can I extract the link name from Url datatype?
So, is this possible? I have Url datafield; the url goes to a map. The Linkname has the mileage. But I would love to access the mileage for calculations; is there a way to extract that tidbit of info to another field?
Where do we report Creator "Reports" issues?
I am currently beta testing the "Reports" interface in Creator. It has a lot of potential and also a few bugs. Is there a system for bug reporting already set up for those testing this functionality. I have a number of small issues already and can't move forward until they get fixed.
Open Report filtering by multiselect field.
I want to open a report using the following link "<a href='https://creator.zoho.com/" + zoho.appuri + "/#View:Task_Report?Staff=" + input.Staff + "'target='_blank'> View Tasks</a> "; The report opens but shows no data available. I think the problem is that Task_Report.Staff is a multiselect field. The following code is almost identical but uses State which is a single select field. It works as expected. "<a href='https://creator.zoho.com/" + zoho.appuri + "/#View:Task_Report?State=" + input.State
Next Page